CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry

blocke · Post by **blocke** » Mon Sep 13, 2004 2:36 pm

I have upgraded from 0.8.5a to 0.8.6 and I am trying to get either the cactid or cmd.php pollers working correctly. When I use the cactid poll method I get a ton of errors similar to the following:

09/13/2004 03:30:08 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '1354-traffic_out-2004-09-13 15:30:08' for key 1

I could not find the MySQL Duplicate entry error anywhere in the cactid or cacti source code. When I use cmd.php I don't see the above but I do see tons of:

09/13/2004 03:20:07 PM - CMDPHP: Poller[0] Host[0] WARNING: Result from SNMP not valid. Partial Result:

All graphs with both poller methods show gaps. It seems they poll successfully sometimes but not all the time (or something else is going on). My configuration worked fine with 0.8.5.

Anyone have any suggestions?

Thanks for your time.

Post by **TheWitness** » Mon Sep 13, 2004 2:55 pm

This would appear to be a recache issue. Use cmd.php for now. I will interface with you and others this evening.

TheWitness

Post by **TheWitness** » Mon Sep 13, 2004 3:03 pm

Blocke,

The WARNING message is legit. It is either a timeout of an unsupported OID. You need to run the poller 1 time at the debug level and determine the Hosts/OID's in question. Then you need to utilize a tool such as Getif to query the OID's, you may find that the OID's are not available.

This happens sometimes in polling for errors on router ports where the mutlicast packet counters are not supported OID's.

As mentioned, it can also be a timeout issue with your hosts. Please post your debug log. If you are concerned about it's contents, e-mail to larryjadams@comcast.net

TheWitness

blocke · Post by **blocke** » Mon Sep 13, 2004 3:19 pm

Turning on debug now and poking around.

Polling seems much more reliable using cmd.php with 1 process and 1 thread.

BTW, I've seen a couple of these:

09/13/2004 04:15:04 PM - CMDPHP: Poller[0] ASSERT: '684585982<684585982' failed. Recaching host 'xxx.xxx.xxx.xxx', data query #1.

Don't know if that is helpful or not. I'll email you logs if I see anything that doesn't look like my own dumb mistake (invalid OIDs, etc)

Thanks.

Post by **TheWitness** » Mon Sep 13, 2004 5:50 pm

That error message indicates that a polled host has rebooted.

In any event, I believe that if you keep polling with either cactid or cmd.php the problem will resolve itself.

TheWitness

Post by **TheWitness** » Mon Sep 13, 2004 7:37 pm

Blocke,

What OS are you running Cacti on?

TheWitness

Jeppe · Post by **Jeppe** » Fri Nov 26, 2004 3:38 am

Getting this problem constantly also...

11/26/2004 12:32:07 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '0-1-125:12' for key 1
11/26/2004 12:32:08 AM - CACTID: Poller[0] ASSERT: '10.2.196.225="10.2.196.225"' failed. Recaching host 'foo.bar.org', data query #12

And this goes on and on poll after poll. The assert seems a bit weird with the quoting stuff...

Let me know if you want the full debug log. (It's huge)

Thanks!

J

Post by **TheWitness** » Fri Nov 26, 2004 6:18 am

I seem to remember that error message, but I can't remember why it was showing up. Make sure that you are running cactid 0.8.6c and Cacti 0.8.6b with the patches. Then, make sure your environment variables are as such.

MIB=All (Do not have this set)
MIBDIRS="???" (Was improperly placed in the documentation as MIB"S"DIR)

Then, I am pretty sure your problem should go away.

TheWitness

Jeppe · Post by **Jeppe** » Tue Nov 30, 2004 3:39 am

Doing that but it didn't seem to help. Then I emptied the poller_output table from old crap (yes, it still accumulates there, beats me why) and that helped, atleast for now.

Perhaps related it sometimes I don't get that last statistics line to the log file. The processes just do their stuff and disappear after 5 minutes. (I sometimes hit the 5 min limit depending on the machine load)

J

--edit

Well, the duplicate entry messages came back on the 3rd poll.

Post by **TheWitness** » Tue Nov 30, 2004 5:20 am

Jeppe,

You did apply the patches right. http://www.cacti.net/downloads/0.8.6b/pre-patched

TheWitness

Jeppe · Post by **Jeppe** » Wed Dec 01, 2004 2:38 am

Yes, all patches applied.

Post by **TheWitness** » Wed Dec 01, 2004 8:40 pm

Are you polling the same host twice in the same polling cycle. Once by 1 name and a second time using another. If so, this caused Cactid to be unhealthy in the past. Old age pisses me off. Can't remember why this happens....

CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry

CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry

Who is online