[EDIT] Waiting on 1 of 1 pollers. DB Exec fail. Graphs NaN.

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

Moderators: Developers, Moderators

Post Reply
cvdeeden
Posts: 3
Joined: Tue Jan 22, 2013 2:53 pm

[EDIT] Waiting on 1 of 1 pollers. DB Exec fail. Graphs NaN.

Post by cvdeeden »

Hi all,

I got a new server so I installed cacti on it, as I did before which worked well.
But I forgot to change my timezone before installing cacti, which caused the update errors of my poller now.

Anyone know how to fix it? I have read you can reset the last run, but I can't seem to find it. And waiting for the seconds that it's incorrect will take me too long.

Here's my poller log when starting:

01/26/2013 07:49:35 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '274', Max Runtime '298', Poller Runs: '1'
01/26/2013 07:49:35 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/usr/share/cacti/cmd.php" 0 1]
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186576:3467724
ERROR: /usr/share/cacti/rra/localhost_mem_buffers_3.rrd: illegal attempt to update using time 1359186576 when last update time is 1359270601 (minimum one second step)
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1359186576:4063224
ERROR: /usr/share/cacti/rra/localhost_mem_swap_4.rrd: illegal attempt to update using time 1359186576 when last update time is 1359270601 (minimum one second step)
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1359186576:0.00:0.00:0.00
ERROR: /usr/share/cacti/rra/localhost_load_1min_5.rrd: illegal attempt to update using time 1359186576 when last update time is 1359270601 (minimum one second step)
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_users_6.rrd --template users 1359186576:1
ERROR: /usr/share/cacti/rra/localhost_users_6.rrd: illegal attempt to update using time 1359186576 when last update time is 1359270601 (minimum one second step)
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_proc_7.rrd --template proc 1359186576:162
ERROR: /usr/share/cacti/rra/localhost_proc_7.rrd: illegal attempt to update using time 1359186576 when last update time is 1359270601 (minimum one second step)
01/26/2013 07:49:36 AM - SYSTEM STATS: Time:0.3036 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5
Loop Time is: 0.31
Sleep Time is: 299.69
Total Time is: 0.31


And here's my latest cacti.log (DEBUG):
01/26/2013 07:54:03 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096843 --end=1359183243 --title='Localhost - Processes' --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:03 To 2013/01/26 07\:54\:03\c" COMMENT:" \n" --vertical-label='processes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_proc_7.rrd":'proc':AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:54:03 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096843 --end=1359183243 --title='Localhost - Logged in Users' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:03 To 2013/01/26 07\:54\:03\c" COMMENT:" \n" --vertical-label='users' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_users_6.rrd":'users':AVERAGE AREA:a#4668E4FF:"Users" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:54:03 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096843 --end=1359183243 --title='Localhost - Load Average' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' --units-exponent='0' COMMENT:"From 2013/01/25 07\:54\:03 To 2013/01/26 07\:54\:03\c" COMMENT:" \n" --vertical-label='processes in the run queue' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_1min':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_5min':AVERAGE DEF:c="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_15min':AVERAGE CDEF:cdefg='TIME,1359182943,GT,a,a,UN,0,a,IF,IF,TIME,1359182943,GT,b,b,UN,0,b,IF,IF,TIME,1359182943,GT,c,c,UN,0,c,IF,IF,+,+' AREA:a#EACC00FF:"1 Minute Average" GPRINT:a:LAST:" Current\:%8.2lf\n" AREA:b#EA8F00FF:"5 Minute Average":STACK GPRINT:b:LAST:" Current\:%8.2lf\n" AREA:c#FF0000FF:"15 Minute Average":STACK GPRINT:c:LAST:"Current\:%8.2lf\n" LINE1:cdefg#000000FF:""
01/26/2013 07:54:03 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096843 --end=1359183243 --title='Localhost - Memory Usage' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:03 To 2013/01/26 07\:54\:03\c" COMMENT:" \n" --vertical-label='kilobytes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_mem_buffers_3.rrd":'mem_buffers':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_mem_swap_4.rrd":'mem_swap':AVERAGE AREA:a#FF4105FF:"Free" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n" AREA:b#FFC73BFF:"Swap":STACK GPRINT:b:LAST:"Current\:%8.2lf %s" GPRINT:b:AVERAGE:"Average\:%8.2lf %s" GPRINT:b:MAX:"Maximum\:%8.2lf %s\n"
01/26/2013 07:54:01 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096841 --end=1359183241 --title='Localhost - Memory Usage' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:01 To 2013/01/26 07\:54\:01\c" COMMENT:" \n" --vertical-label='kilobytes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_mem_buffers_3.rrd":'mem_buffers':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_mem_swap_4.rrd":'mem_swap':AVERAGE AREA:a#FF4105FF:"Free" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n" AREA:b#FFC73BFF:"Swap":STACK GPRINT:b:LAST:"Current\:%8.2lf %s" GPRINT:b:AVERAGE:"Average\:%8.2lf %s" GPRINT:b:MAX:"Maximum\:%8.2lf %s\n"
01/26/2013 07:54:01 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096841 --end=1359183241 --title='Localhost - Processes' --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:01 To 2013/01/26 07\:54\:01\c" COMMENT:" \n" --vertical-label='processes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_proc_7.rrd":'proc':AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:54:01 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096841 --end=1359183241 --title='Localhost - Logged in Users' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:54\:01 To 2013/01/26 07\:54\:01\c" COMMENT:" \n" --vertical-label='users' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_users_6.rrd":'users':AVERAGE AREA:a#4668E4FF:"Users" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:54:01 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096841 --end=1359183241 --title='Localhost - Load Average' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' --units-exponent='0' COMMENT:"From 2013/01/25 07\:54\:01 To 2013/01/26 07\:54\:01\c" COMMENT:" \n" --vertical-label='processes in the run queue' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_1min':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_5min':AVERAGE DEF:c="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_15min':AVERAGE CDEF:cdefg='TIME,1359182941,GT,a,a,UN,0,a,IF,IF,TIME,1359182941,GT,b,b,UN,0,b,IF,IF,TIME,1359182941,GT,c,c,UN,0,c,IF,IF,+,+' AREA:a#EACC00FF:"1 Minute Average" GPRINT:a:LAST:" Current\:%8.2lf\n" AREA:b#EA8F00FF:"5 Minute Average":STACK GPRINT:b:LAST:" Current\:%8.2lf\n" AREA:c#FF0000FF:"15 Minute Average":STACK GPRINT:c:LAST:"Current\:%8.2lf\n" LINE1:cdefg#000000FF:""
01/26/2013 07:50:02 AM - SYSTEM STATS: Time:0.4079 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:7
01/26/2013 07:50:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_proc_7.rrd --template proc 1359186601:173
01/26/2013 07:50:02 AM - SYSTEM STATS: Time:0.4005 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:8
01/26/2013 07:50:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_proc_7.rrd --template proc 1359186601:173
01/26/2013 07:50:02 AM - CMDPHP: Poller[0] Time: 0.1642 s, Theads: N/A, Hosts: 1
01/26/2013 07:50:02 AM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: 169
01/26/2013 07:50:02 AM - CMDPHP: Poller[0] Time: 0.1187 s, Theads: N/A, Hosts: 1
01/26/2013 07:50:02 AM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: 173
01/26/2013 07:50:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_users_6.rrd --template users 1359186601:1
01/26/2013 07:50:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_users_6.rrd --template users 1359186601:1
01/26/2013 07:50:02 AM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: 1
01/26/2013 07:50:02 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1359186601:0.00:0.00:0.00
01/26/2013 07:50:02 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
01/26/2013 07:50:02 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
01/26/2013 07:50:02 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1359186601:4063224
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1359186601:4063224
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: 4063224
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_users_6.rrd --template users 1359186601:1
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: 1
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186601:3438556
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186601:3438556
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: 3438556
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1359186601:0.00:0.00:0.00
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1359186601:0.00:0.00:0.00
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
01/26/2013 07:50:01 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1359186601:4063224
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] PING: UDP Ping Success (0.16 ms)
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: 4063224
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186601:3440704
01/26/2013 07:50:01 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186601:3440704
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: 3440704
01/26/2013 07:50:01 AM - CMDPHP: Poller[0] Host[1] PING: UDP Ping Success (0.15 ms)
01/26/2013 07:50:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/usr/share/cacti/cmd.php" 0 1]
01/26/2013 07:50:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/usr/share/cacti/cmd.php" 0 1]
01/26/2013 07:50:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '26', Max Runtime '298', Poller Runs: '1'
01/26/2013 07:50:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '26', Max Runtime '298', Poller Runs: '1'
01/26/2013 07:49:47 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096586 --end=1359182986 --title='Localhost - Logged in Users' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:46 To 2013/01/26 07\:49\:46\c" COMMENT:" \n" --vertical-label='users' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_users_6.rrd":'users':AVERAGE AREA:a#4668E4FF:"Users" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:49:47 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096586 --end=1359182986 --title='Localhost - Processes' --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:46 To 2013/01/26 07\:49\:46\c" COMMENT:" \n" --vertical-label='processes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_proc_7.rrd":'proc':AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:49:47 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096586 --end=1359182986 --title='Localhost - Memory Usage' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:46 To 2013/01/26 07\:49\:46\c" COMMENT:" \n" --vertical-label='kilobytes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_mem_buffers_3.rrd":'mem_buffers':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_mem_swap_4.rrd":'mem_swap':AVERAGE AREA:a#FF4105FF:"Free" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n" AREA:b#FFC73BFF:"Swap":STACK GPRINT:b:LAST:"Current\:%8.2lf %s" GPRINT:b:AVERAGE:"Average\:%8.2lf %s" GPRINT:b:MAX:"Maximum\:%8.2lf %s\n"
01/26/2013 07:49:47 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096586 --end=1359182986 --title='Localhost - Load Average' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' --units-exponent='0' COMMENT:"From 2013/01/25 07\:49\:46 To 2013/01/26 07\:49\:46\c" COMMENT:" \n" --vertical-label='processes in the run queue' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_1min':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_5min':AVERAGE DEF:c="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_15min':AVERAGE CDEF:cdefg='TIME,1359182687,GT,a,a,UN,0,a,IF,IF,TIME,1359182687,GT,b,b,UN,0,b,IF,IF,TIME,1359182687,GT,c,c,UN,0,c,IF,IF,+,+' AREA:a#EACC00FF:"1 Minute Average" GPRINT:a:LAST:" Current\:%8.2lf\n" AREA:b#EA8F00FF:"5 Minute Average":STACK GPRINT:b:LAST:" Current\:%8.2lf\n" AREA:c#FF0000FF:"15 Minute Average":STACK GPRINT:c:LAST:"Current\:%8.2lf\n" LINE1:cdefg#000000FF:""
01/26/2013 07:49:45 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096585 --end=1359182985 --title='Localhost - Logged in Users' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:45 To 2013/01/26 07\:49\:45\c" COMMENT:" \n" --vertical-label='users' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_users_6.rrd":'users':AVERAGE AREA:a#4668E4FF:"Users" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:49:45 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096585 --end=1359182985 --title='Localhost - Processes' --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:45 To 2013/01/26 07\:49\:45\c" COMMENT:" \n" --vertical-label='processes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_proc_7.rrd":'proc':AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINT:a:LAST:"Current\:%8.0lf" GPRINT:a:AVERAGE:"Average\:%8.0lf" GPRINT:a:MAX:"Maximum\:%8.0lf\n"
01/26/2013 07:49:45 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096585 --end=1359182985 --title='Localhost - Memory Usage' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' COMMENT:"From 2013/01/25 07\:49\:45 To 2013/01/26 07\:49\:45\c" COMMENT:" \n" --vertical-label='kilobytes' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_mem_buffers_3.rrd":'mem_buffers':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_mem_swap_4.rrd":'mem_swap':AVERAGE AREA:a#FF4105FF:"Free" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n" AREA:b#FFC73BFF:"Swap":STACK GPRINT:b:LAST:"Current\:%8.2lf %s" GPRINT:b:AVERAGE:"Average\:%8.2lf %s" GPRINT:b:MAX:"Maximum\:%8.2lf %s\n"
01/26/2013 07:49:45 AM - WEBLOG: Poller[0] CACTI2RRD: /usr/bin/rrdtool graph - --imgformat=PNG --start=1359096585 --end=1359182985 --title='Localhost - Load Average' --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit='0' --units-exponent='0' COMMENT:"From 2013/01/25 07\:49\:45 To 2013/01/26 07\:49\:45\c" COMMENT:" \n" --vertical-label='processes in the run queue' --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_1min':AVERAGE DEF:b="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_5min':AVERAGE DEF:c="/usr/share/cacti/rra/localhost_load_1min_5.rrd":'load_15min':AVERAGE CDEF:cdefg='TIME,1359182685,GT,a,a,UN,0,a,IF,IF,TIME,1359182685,GT,b,b,UN,0,b,IF,IF,TIME,1359182685,GT,c,c,UN,0,c,IF,IF,+,+' AREA:a#EACC00FF:"1 Minute Average" GPRINT:a:LAST:" Current\:%8.2lf\n" AREA:b#EA8F00FF:"5 Minute Average":STACK GPRINT:b:LAST:" Current\:%8.2lf\n" AREA:c#FF0000FF:"15 Minute Average":STACK GPRINT:c:LAST:"Current\:%8.2lf\n" LINE1:cdefg#000000FF:""
01/26/2013 07:49:36 AM - SYSTEM STATS: Time:0.3036 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_proc_7.rrd --template proc 1359186576:162
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Time: 0.1218 s, Theads: N/A, Hosts: 1
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: 162
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_users_6.rrd --template users 1359186576:1
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: 1
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1359186576:0.00:0.00:0.00
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
01/26/2013 07:49:36 AM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1359186576:4063224
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: 4063224
01/26/2013 07:49:36 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1359186576:3467724
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: 3467724
01/26/2013 07:49:36 AM - CMDPHP: Poller[0] Host[1] PING: UDP Ping Success (0.13 ms)
01/26/2013 07:49:35 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q "/usr/share/cacti/cmd.php" 0 1]
01/26/2013 07:49:35 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '274', Max Runtime '298', Poller Runs: '1'



Permissions OK, HTTPD OK, Centos 6.3, latest php, snmp, rrdtool, cacti, etc. Updated everything.

Just this poller error :)




Any ideas or help?


PS not using spine!
Last edited by cvdeeden on Sun Jan 27, 2013 3:05 pm, edited 1 time in total.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: illegal attempt to update using time 1359186576 when las

Post by gandalf »

cvdeeden wrote:Hi all,

I got a new server so I installed cacti on it, as I did before which worked well.
But I forgot to change my timezone before installing cacti, which caused the update errors of my poller now.

Anyone know how to fix it? I have read you can reset the last run, but I can't seem to find it. And waiting for the seconds that it's incorrect will take me too long.
Then, please delete all rrd files. Cacti will recreate them using the current timestamp on next poller's run.
R.
cvdeeden
Posts: 3
Joined: Tue Jan 22, 2013 2:53 pm

Re: illegal attempt to update using time 1359186576 when las

Post by cvdeeden »

Hi Gandalf,

Awesome, that worked! Cacti created new files (under user root???)
But my graphs still display 'nan' (I have tried to chown the files to cacti:cacti, as it all is, but that didnt work).


The poller.php tells me he is still waiting for 1 poller, any idea?



01/27/2013 09:59:14 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '3 00', Time Since Last: '156', Max Runtime '298', Poller Runs: '1'
01/27/2013 09:59:14 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empt y. Issues Found: 10, Data Sources: mem_buffers(DS[3]), mem_buffers(DS[3]), mem_ swap(DS[4]), mem_swap(DS[4]), (DS[5]), (DS[5]), users(DS[6]), users(DS[6]), proc (DS[7]), proc(DS[7])
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
OK u:0.00 s:0.01 r:0.10
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
OK u:0.00 s:0.01 r:0.11
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
OK u:0.00 s:0.01 r:0.12
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
OK u:0.00 s:0.01 r:0.14
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
Waiting on 1 of 1 pollers.
OK u:0.00 s:0.01 r:0.17
01/27/2013 09:59:14 PM - SYSTEM STATS: Time:0.2877 Method:cmd.php Processes:1 Th reads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5



This is my log file (MEDIUM), the DB Exec errors are annoying. I could fix them by repairing them, but Im tired of doing that everytime I see this error.
01/27/2013 10:00:01 PM - SYSTEM STATS: Time:0.4849 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5
01/27/2013 10:00:01 PM - SYSTEM STATS: Time:0.4804 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:6
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Time: 0.2246 s, Theads: N/A, Hosts: 1
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (7, 'proc', '2013-01-27 22:00:01', '174')'
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Time: 0.2241 s, Theads: N/A, Hosts: 1
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: 174
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: 172
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: 1
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: 1
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: 1min:0.11 5min:0.06 10min:0.01
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: 1min:0.11 5min:0.06 10min:0.01
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: 4063224
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: 4063224
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (3, 'mem_buffers', '2013-01-27 22:00:01', '3229104')'
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: 3229104
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: 3229104
01/27/2013 10:00:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '47', Max Runtime '298', Poller Runs: '1'
01/27/2013 10:00:01 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '47', Max Runtime '298', Poller Runs: '1'
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: illegal attempt to update using time 1359186576 when las

Post by gandalf »

cvdeeden wrote: This is my log file (MEDIUM), the DB Exec errors are annoying. I could fix them by repairing them, but Im tired of doing that everytime I see this error.
01/27/2013 10:00:01 PM - SYSTEM STATS: Time:0.4849 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:5
01/27/2013 10:00:01 PM - SYSTEM STATS: Time:0.4804 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:5 RRDsProcessed:6
01/27/2013 10:00:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (7, 'proc', '2013-01-27 22:00:01', '174')'
It is very likely, that two pollers are running in parallel. See 2nd link of my sig
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests