Cacti stop graphing

[crash_override]

Hi everybody!

I've this strange problem:
my cacti stop graphing my hosts 9 days ago, but I've no erorrs in logs and the poller is running.

what's wrong about you?


thanks for help.

Crash_Override

[omen]

I have the same issue too. How do I fix the down host? without creating new host again. Thanks in advance.

[rcaston]

I have the same issue too. How do I fix the down host? without creating new host again. Thanks in advance.

Please post your debug log output for one of the affected hosts

-rodney

[crash_override]

Found the solution....

try to purge the cacti log (from the web interface)


from the command line I've run this: php /var/www/html/cacti/poller.php > /dev/null 2>&1

and the result was: "file dimension limit exceded" (or similar, my system is in italian lang)

when I've purged log it restart logging and graphing.

Many thanks

Crash_Override

[omen]

I have the same issue too. How do I fix the down host? without creating new host again. Thanks in advance.

Please post your debug log output for one of the affected hosts

-rodney

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="uh1 - Traffic - 205.234.109.50 (eth0)" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:7: \
--font UNIT:8: \
DEF:a="/home/omen/public_html/monitor/rra/uh1_traffic_in_146.rrd":traffic_in:AVERAGE \
DEF:b="/home/omen/public_html/monitor/rra/uh1_traffic_in_146.rrd":traffic_in:MAX \
DEF:c="/home/omen/public_html/monitor/rra/uh1_traffic_in_146.rrd":traffic_out:AVERAGE \
DEF:d="/home/omen/public_html/monitor/rra/uh1_traffic_in_146.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefd=b,8,* \
CDEF:cdeff=c,8,* \
CDEF:cdefi=d,8,* \
AREA:cdefa#00CF00FF:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefd:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total In\:  0 bytes\n"  \
LINE1:cdeff#002A97FF:"Outbound"  \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total Out\: 0 bytes" 

RRDTool Says:

OK

But there a no graph at all.

[omen]

Found the solution....

try to purge the cacti log (from the web interface)


from the command line I've run this: php /var/www/html/cacti/poller.php > /dev/null 2>&1

and the result was: "file dimension limit exceded" (or similar, my system is in italian lang)

when I've purged log it restart logging and graphing.

Many thanks

Crash_Override

I've done purge the log file from the web interface and run the command as you did and there a no graph for the specific host

The results was :

Code: Select all

Log File [Total Lines: 1 - All Items Shown]
04/01/2008 09:18:50 AM - SYSTEM STATS: Time:67.8635 Method:cmd.php Processes:1 Threads:N/A Hosts:10 HostsPerProcess:10 DataSources:90 RRDsProcessed:78

[rcaston]

I was not very clear before. My fault, please do the following:

1. Set your log output to log to the logfile, and set the mode to DEBUG.

2. manually run one poll cycle.

3. examine the debug output in the cacti.log file.

4. Post the lines which contain references to the problem host.

Also

A. please post your version of cacti and spine.
B. please post what the "Poller Cache" displays for the problem host. [console] -> system utilities -> view poller cache (then search for the problem host)

[omen]

I was not very clear before. My fault, please do the following:

1. Set your log output to log to the logfile, and set the mode to DEBUG.

2. manually run one poll cycle.

3. examine the debug output in the cacti.log file.

4. Post the lines which contain references to the problem host.

Also

A. please post your version of cacti and spine.
B. please post what the "Poller Cache" displays for the problem host. [console] -> system utilities -> view poller cache (then search for the problem host)

Code: Select all

 04/01/2008 01:08:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/01/2008 01:08:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/01/2008 01:08:27 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='15'"
04/01/2008 01:08:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
04/01/2008 01:08:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/01/2008 01:07:47 PM - POLLER: Poller[0] NOTE: Cron is configured to run too often! The Poller Interval is '300' seconds, with a minimum Cron period of '300' seconds, but only 166 seconds have passed since the poller last ran.
04/01/2008 01:07:47 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '166', Max Runtime '298', Poller Runs: '1'
04/01/2008 01:07:47 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
04/01/2008 01:07:34 PM - POLLER: Poller[0] NOTE: Cron is configured to run too often! The Poller Interval is '300' seconds, with a minimum Cron period of '300' seconds, but only 153 seconds have passed since the poller last ran.
04/01/2008 01:07:34 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '153', Max Runtime '298', Poller Runs: '1'
04/01/2008 01:07:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
04/01/2008 01:06:32 PM - SYSTEM STATS: Time:90.7182 Method:cmd.php Processes:1 Threads:N/A Hosts:10 HostsPerProcess:10 DataSources:99 RRDsProcessed:78

That was the results from cacti.log
Im running cacti version 0.8.7a
And when click the problem host on poller cache below is the results:

Code: Select all

Data Source Debug

/usr/bin/rrdtool create \
/home/omen/public_html/monitor/rra/uh1_traffic_in_156.rrd \
--step 300  \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

And under Graph Management the results was:

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="uh1 - Traffic - 205.234.109.50 (eth0)" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:7: \
--font UNIT:8: \
DEF:a="/home/omen/public_html/monitor/rra/uh1_traffic_in_156.rrd":traffic_in:AVERAGE \
DEF:b="/home/omen/public_html/monitor/rra/uh1_traffic_in_156.rrd":traffic_in:MAX \
DEF:c="/home/omen/public_html/monitor/rra/uh1_traffic_in_156.rrd":traffic_out:AVERAGE \
DEF:d="/home/omen/public_html/monitor/rra/uh1_traffic_in_156.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefd=b,8,* \
CDEF:cdeff=c,8,* \
CDEF:cdefi=d,8,* \
AREA:cdefa#00CF00FF:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefd:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total In\:  187.35 MB\n"  \
LINE1:cdeff#002A97FF:"Outbound"  \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total Out\: 1.1 GB" 

RRDTool Says:

OK

The graph is actually there but half way:

[omen]

hope someone can help me to fix this problem?