Continus Error 1062 (23000)

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

Moderators: Developers, Moderators

Post Reply
moshiur
Posts: 9
Joined: Sun Sep 23, 2007 4:41 am

Continus Error 1062 (23000)

Post by moshiur »

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
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Likely 2 cron tasks running poller.php.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
moshiur
Posts: 9
Joined: Sun Sep 23, 2007 4:41 am

Continus Error 1062 (23000)

Post by moshiur »

Is there any solution?
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Yes, remove the second cron entry (where ever it is).

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
moshiur
Posts: 9
Joined: Sun Sep 23, 2007 4:41 am

error 1062 (23000) at line 1: dublicate entry ' 1869406' for

Post by moshiur »

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

error 1062 (23000) at line 1: dublicate entry ' 1869406' for

Post by moshiur »

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
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

The "duplicate pooler issue" is described along with other issues at the second link of my signature
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests