Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Post support questions that directly relate to Linux/Unix operating systems.
Moderators: Developers , Moderators
moshiur
Posts: 9 Joined: Sun Sep 23, 2007 4:41 am
Post
by moshiur » Sun Sep 23, 2007 4:50 am
Dear Sir,
I am using cacti and OS is CentOS 4.4. nowadays I am getting continuous error :
" error 1062 (23000) at line 1: dublicate entry ' 1869406' for key 1"
Can you please help me ?
Best Regards,
Moshiur
TheWitness
Developer
Posts: 17007 Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Post
by TheWitness » Sun Sep 23, 2007 7:11 pm
Likely 2 cron tasks running poller.php.
TheWitness
moshiur
Posts: 9 Joined: Sun Sep 23, 2007 4:41 am
Post
by moshiur » Sun Sep 23, 2007 11:49 pm
Is there any solution?
TheWitness
Developer
Posts: 17007 Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Post
by TheWitness » Mon Sep 24, 2007 5:22 am
Yes, remove the second cron entry (where ever it is).
TheWitness
moshiur
Posts: 9 Joined: Sun Sep 23, 2007 4:41 am
Post
by moshiur » Mon Sep 24, 2007 11:33 pm
Dear TheWitness/ Developer,
Can you please suggest me how do I identify the second cron entry in my CentOS 4.3 operating System. Or give me some commands so that I can remove it.
Best Regards,
Moshiur Rahman Khan
moshiur
Posts: 9 Joined: Sun Sep 23, 2007 4:41 am
Post
by moshiur » Tue Sep 25, 2007 4:16 am
For your information. I have attached here all log information of Cacti.log
Please help me.
[root@localhost ~]# tail -n 100 -f /var/www/html/log/cacti.log
09/25/2007 01:10:05 PM - CMDPHP: Poller[0] Host[5] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:10:09 PM - CACTID: Poller[0] Host[5] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:10:29 PM - SYSTEM STATS: Time:26.7289 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 01:10:33 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:13:06 PM - CMDPHP: Poller[0] Host[8] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:15:13 PM - CACTID: Poller[0] Host[8] NOTICE: HOST EVENT: Host Returned from DOWN State
09/25/2007 01:15:32 PM - SYSTEM STATS: Time:29.7464 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 01:15:36 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:19:02 PM - CMDPHP: Poller[0] Host[6] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 01:20:29 PM - SYSTEM STATS: Time:26.6237 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 01:20:34 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:20:34 PM - PCOMMAND: Poller[0] Host[6] WARNING: Recache Event Detected for Host
09/25/2007 01:20:36 PM - RECACHE STATS: RecacheTime:2.3014 HostsRecached:1
09/25/2007 01:25:05 PM - CACTID: Poller[0] Host[5] NOTICE: HOST EVENT: Host Returned from DOWN State
09/25/2007 01:25:24 PM - SYSTEM STATS: Time:21.9136 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:156
09/25/2007 01:25:29 PM - PCOMMAND: Poller[0] Host[5] WARNING: Recache Event Detected for Host
09/25/2007 01:25:29 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:25:31 PM - RECACHE STATS: RecacheTime:2.2132 HostsRecached:1
09/25/2007 01:30:09 PM - CACTID: Poller[0] Host[5] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:30:28 PM - SYSTEM STATS: Time:25.3299 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 01:30:39 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:34:03 PM - CMDPHP: Poller[0] Host[18] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 01:35:04 PM - CMDPHP: Poller[0] Host[5] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 01:35:26 PM - SYSTEM STATS: Time:23.9038 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:159
09/25/2007 01:35:34 PM - PCOMMAND: Poller[0] Host[18] WARNING: Recache Event Detected for Host
09/25/2007 01:35:34 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:35:37 PM - RECACHE STATS: RecacheTime:2.3077 HostsRecached:1
09/25/2007 01:40:23 PM - SYSTEM STATS: Time:20.7729 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:159
09/25/2007 01:40:27 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:45:23 PM - SYSTEM STATS: Time:19.9984 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:159
09/25/2007 01:45:28 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:47:04 PM - CMDPHP: Poller[0] Host[6] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:50:13 PM - CACTID: Poller[0] Host[8] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:50:30 PM - SYSTEM STATS: Time:27.9251 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 01:50:35 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 01:53:04 PM - CMDPHP: Poller[0] Host[8] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 01:54:07 PM - CMDPHP: Poller[0] Host[36] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 01:55:25 PM - SYSTEM STATS: Time:23.0542 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 01:55:30 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:00:45 PM - SYSTEM STATS: Time:41.3977 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 02:00:59 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:03:04 PM - CMDPHP: Poller[0] Host[8] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:05:11 PM - CACTID: Poller[0] Host[8] NOTICE: HOST EVENT: Host Returned from DOWN State
09/25/2007 02:05:29 PM - SYSTEM STATS: Time:25.7381 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 02:05:32 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:10:34 PM - SYSTEM STATS: Time:31.5495 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 02:10:39 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:13:09 PM - CMDPHP: Poller[0] Host[49] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:15:08 PM - CMDPHP: Poller[0] Host[17] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:15:31 PM - SYSTEM STATS: Time:28.7341 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 02:15:35 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:16:09 PM - CMDPHP: Poller[0] Host[49] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:20:10 PM - CACTID: Poller[0] Host[17] NOTICE: HOST EVENT: Host Returned from DOWN State
09/25/2007 02:20:27 PM - SYSTEM STATS: Time:24.6639 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:153
09/25/2007 02:20:31 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:25:08 PM - CMDPHP: Poller[0] Host[18] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:25:31 PM - SYSTEM STATS: Time:28.7095 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 02:25:35 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:30:35 PM - SYSTEM STATS: Time:32.6877 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 02:30:40 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:32:03 PM - CMDPHP: Poller[0] Host[5] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:34:12 PM - CMDPHP: Poller[0] Host[38] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:35:42 PM - SYSTEM STATS: Time:39.8539 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:144
09/25/2007 02:35:46 PM - PCOMMAND: Poller[0] Host[6] WARNING: Recache Event Detected for Host
09/25/2007 02:35:46 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:35:48 PM - RECACHE STATS: RecacheTime:2.1881 HostsRecached:1
09/25/2007 02:36:04 PM - CMDPHP: Poller[0] Host[6] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:40:08 PM - CMDPHP: Poller[0] Host[21] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:40:13 PM - CACTID: Poller[0] Host[8] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:40:15 PM - CMDPHP: Poller[0] Host[55] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:40:45 PM - SYSTEM STATS: Time:42.7363 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:141
09/25/2007 02:40:48 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:42:05 PM - CMDPHP: Poller[0] Host[21] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:43:04 PM - CMDPHP: Poller[0] Host[8] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:44:11 PM - CMDPHP: Poller[0] Host[55] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:45:33 PM - SYSTEM STATS: Time:30.9676 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:147
09/25/2007 02:45:37 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:48:04 PM - CMDPHP: Poller[0] Host[18] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:50:29 PM - SYSTEM STATS: Time:26.6695 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 02:50:33 PM - PCOMMAND: Poller[0] Host[18] WARNING: Recache Event Detected for Host
09/25/2007 02:50:33 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:50:36 PM - RECACHE STATS: RecacheTime:2.4405 HostsRecached:1
09/25/2007 02:54:06 PM - CMDPHP: Poller[0] Host[36] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 02:55:13 PM - CACTID: Poller[0] Host[8] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 02:55:33 PM - SYSTEM STATS: Time:30.6478 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 02:55:37 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 02:55:37 PM - PCOMMAND: Poller[0] Host[36] WARNING: Recache Event Detected for Host
09/25/2007 02:55:40 PM - RECACHE STATS: RecacheTime:2.2574 HostsRecached:1
09/25/2007 03:00:45 PM - SYSTEM STATS: Time:41.1553 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 03:00:52 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 03:02:03 PM - CMDPHP: Poller[0] Host[8] NOTICE: HOST EVENT: Host Returned from DOWN State:
09/25/2007 03:03:09 PM - CMDPHP: Poller[0] Host[46] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 03:05:35 PM - SYSTEM STATS: Time:31.7246 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 03:05:38 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 03:08:05 PM - CMDPHP: Poller[0] Host[17] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 03:10:06 PM - CMDPHP: Poller[0] Host[19] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP
09/25/2007 03:10:11 PM - CACTID: Poller[0] Host[17] NOTICE: HOST EVENT: Host Returned from DOWN State
09/25/2007 03:10:34 PM - SYSTEM STATS: Time:31.6477 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:147
09/25/2007 03:10:37 PM - THOLD: Poller[0] Checking Thresholds
09/25/2007 03:15:31 PM - SYSTEM STATS: Time:28.8251 Method:cactid Processes:1 Threads:1 Hosts:52 HostsPerProcess:52 DataSources:267 RRDsProcessed:150
09/25/2007 03:15:37 PM - THOLD: Poller[0] Checking Thresholds
gandalf
Developer
Posts: 22383 Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Post
by gandalf » Mon Oct 01, 2007 11:05 am
The "duplicate pooler issue" is described along with other issues at the second link of my signature
Reinhard
Users browsing this forum: No registered users and 2 guests