Graphics stopped all at the same timee

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
Deamen
Posts: 4
Joined: Sun Jul 11, 2004 5:29 pm

Graphics stopped all at the same timee

Post by Deamen »

Hi there,

We've got a working Cacti for a long time now, since yesterday my graphs are not holding any vallues anymore. SNMP is read successfully, see cacti.log snap below. But the values are not drawn in the graphics anymore. It happened after the drive did not had any space left (Which is fixed).

I've run a repair on the Cacti SQL database + reboot of the server, but that didn't fix anything.

Can you please help out? This will be appreciated:D

We are running Version 0.8.6h of Cacti


12/04/2007 09:23:09 PM - CMDPHP: Poller[0] Host[28] DS[408] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, output: 3075814072
12/04/2007 09:23:09 PM - CMDPHP: Poller[0] Host[28] DS[408] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, output: 4062468822
12/04/2007 09:23:09 PM - CMDPHP: Poller[0] Host[28] DS[407] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, output: 1710331465
12/04/2007 09:23:08 PM - CMDPHP: Poller[0] Host[28] DS[407] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, output: 1541566401
12/04/2007 09:23:08 PM - CMDPHP: Poller[0] Host[28] DS[406] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, output: 2962173717
12/04/2007 09:23:08 PM - CMDPHP: Poller[0] Host[28] DS[406] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, output: 520571028
12/04/2007 09:23:08 PM - CMDPHP: Poller[0] Host[28] DS[405] SNMP: v2: x.x.x.x, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, output: 2177212239
12/04/2007 09:23:08 PM - CMDPHP: Poller[0] Host[28] DS[405] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, output: 2024906487
Top
User avatar
fmangeant
Cacti Guru User
Posts: 2345
Joined: Fri Sep 19, 2003 8:36 am
Location: Sophia-Antipolis, France
Contact:
Contact fmangeant

Post by fmangeant »

Hi

can you :
  • rebuild the poller cache
  • run the poller once in DEBUG mode ?
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
Top
Deamen
Posts: 4
Joined: Sun Jul 11, 2004 5:29 pm

Post by Deamen »

I've cleared the poller cache and cleared the cacti log file, after that I've set the poller logginglevel to DEBUG but this did not resolve the issue.
Here's a part of the result, I hope it tells something that can cause this issue. I hope it does :)

12/05/2007 11:38:39 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1196807919 --end=1196894319 --title="ams-sw3 - Traffic - Fa0/3 - Dare Productions - www" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2007/12/04 23\:38\:39 To 2007/12/05 23\:38\:39\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode DEF:a="/var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_431.rrd":traffic_in:AVERAGE DEF:b="/var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_431.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf%s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" LINE1:cdefe#002A97:"Outbound" GPRINT:cdefe:LAST:"Current\:%8.2lf%s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf%s\n" COMMENT:"\n" HRULE:0#FF0000:"95th Percentile" COMMENT:"(0 mbit in+out)"
12/05/2007 11:38:39 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool fetch /var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_431.rrd AVERAGE -s 1196807919 -e 1196894319

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=431"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1196807919 --end=1196894319 --title="ams-sw3 - Traffic - Fa0/2 - Dare Productions - Gallery" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2007/12/04 23\:38\:39 To 2007/12/05 23\:38\:39\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode DEF:a="/var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_430.rrd":traffic_in:AVERAGE DEF:b="/var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_430.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf%s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" LINE1:cdefe#002A97:"Outbound" GPRINT:cdefe:LAST:"Current\:%8.2lf%s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf%s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf%s\n" COMMENT:"\n" HRULE:0#FF0000:"95th Percentile" COMMENT:"(0 mbit in+out)"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=431"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool fetch /var/www/html/monitor.website.nl/public_html/rra/amssw3_traffic_in_430.rrd AVERAGE -s 1196807919 -e 1196894319

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=430"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=431"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='title_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=430"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=323 order by graph_templates_item.sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=323"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from (graph_templates_item,data_template_data_rra,data_template_rrd,data_template_data,rra) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_data.id=data_template_data_rra.data_template_data_id and data_template_data_rra.rra_id=rra.id and graph_templates_item.local_graph_id=323 group by rra.id order by rra.timespan"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=323 limit 0,1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=323 group by graph_templates_graph.local_graph_id"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=430"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='title_font' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

12/05/2007 11:38:39 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

The debug stems from graphing only. That's no use. Please follow second link of my signature for more help
Reinhard
Top
Deamen
Posts: 4
Joined: Sun Jul 11, 2004 5:29 pm

Post by Deamen »

I've just resolved the problem:D
I've found some error messages regarding memory size problem.
The php.ini memory limit was set to 8Mb, I had to raise it to 256mb before the Cacti could process all results which it didn't proces since the full harddisk.

Thanks!
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 0 guests