Cacti graph will drop some period of time.

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
SkyRocket
Posts: 12
Joined: Fri Aug 18, 2006 3:06 am

Cacti graph will drop some period of time.

Post by SkyRocket »

Anyone help me to figure out this problem on cacti graph.
Some period of time traffic will drop and up again.

Pls. help me (;_;)
Attachments
graph_conff1.JPG
graph_conff1.JPG (15.38 KiB) Viewed 1234 times
graph_conf1.JPG
graph_conf1.JPG (44.9 KiB) Viewed 1234 times
Top
SkyRocket
Posts: 12
Joined: Fri Aug 18, 2006 3:06 am

When I see on log message.....

Post by SkyRocket »

cat /var/log/message

Oct 16 07:25:42 cacti-srv Cacti[23495]: CMDPHP: Host[51] DS[1170] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23497]: CMDPHP: Host[51] DS[1173] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23495]: CMDPHP: Host[51] DS[1170] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23497]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (1173,'AllocMean','2006-10-16 07:25:04','U')"
Oct 16 07:25:42 cacti-srv Cacti[23495]: CMDPHP: Host[51] DS[1170] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23497]: CMDPHP: Host[51] DS[3026] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23495]: CMDPHP: Host[51] DS[1170] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:25:42 cacti-srv Cacti[23497]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (3026,'AllocMax','2006-10-16 07:25:04','U')"


Log message shows many a above example... may cause the problem on getting the value for creating graph. :cry: anyone pls help me
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

You're using cmd.php as a poller? Failing data comes from script or from SNMP? Perhaps a timeout issue?
Reinhard
Top
SkyRocket
Posts: 12
Joined: Fri Aug 18, 2006 3:06 am

-*- Graph cannot generate from script but SNMP is OK

Post by SkyRocket »

Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1303] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1795] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1202] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1194] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1286] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2074] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1295] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1171] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1185] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1284] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2048] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1191] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:57 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1188] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1200] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1241] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1303] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1277] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1198] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[1995] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: Host[51] DS[1260] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2228,'UtilMean','2006-10-16 07:15:05','33.72')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2013,'AllocMax','2006-10-16 07:15:05','98.81')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2266,'UtilSD','2006-10-16 07:15:05','4.34')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2261,'UtilSD','2006-10-16 07:15:05','6.20')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2200,'UtilMean','2006-10-16 07:15:05','22.61')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2186,'UtilMean','2006-10-16 07:15:05','22.21')"
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[1995] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2189,'UtilMax','2006-10-16 07:15:05','0.39')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (1997,'AllocMean','2006-10-16 07:15:05','0.00')"
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2185] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2194,'UtilMax','2006-10-16 07:15:05','33.63')"
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2185] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2003,'AllocSD','2006-10-16 07:15:05','7.49')"
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2185] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2219,'UtilMin','2006-10-16 07:15:05','5.85')"
Oct 16 07:15:58 cacti-srv Cacti[1839]: CMDPHP: Host[55] DS[2185] WARNING: Result from CMD not valid. Partial Result:
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2226,'UtilSD','2006-10-16 07:15:05','3.92')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2278,'NominalTollCapMax','2006-10-16 07:15:05','17.6')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2042,'AllocMin','2006-10-16 07:15:05','37.30')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2034,'AllocSD','2006-10-16 07:15:05','10.12')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2045,'AllocMax','2006-10-16 07:15:05','55.56')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2057,'AllocSD','2006-10-16 07:15:05','6.86')"
Oct 16 07:15:58 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2082,'CollProbMax','2006-10-16 07:15:05','8.67')"
Oct 16 07:15:59 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2226,'UtilMax','2006-10-16 07:15:05','16.87')"
Oct 16 07:15:59 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2241,'UtilMean','2006-10-16 07:15:05','34.29')"
Oct 16 07:15:59 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2199,'UtilMin','2006-10-16 07:15:05','8.98')"
Oct 16 07:15:59 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2064,'AllocMin','2006-10-16 07:15:05','1.17')"
Oct 16 07:15:59 cacti-srv Cacti[1833]: CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output
) values (2039,'AllocSD','2006-10-16 07:15:05','3.99')"
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Double check your cron entries. I have seen this before when the poller is being ran concurrently from 2 different cron entries.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
SkyRocket
Posts: 12
Joined: Fri Aug 18, 2006 3:06 am

Thank you for ur information

Post by SkyRocket »

My graph will smooth now..
Thk u so much
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest