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

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

Sorry it took so long for me to get around to doing this...

I downloaded the source from svn today & compiled. Now when I run cactid, I get not only thousands of the Duplicate entry error, but also an error stating:

TheWitness · Posted: Thu Mar 09, 2006 5:54 pm Post subject:

Please post the error messages that you received to this post. Then, please open a bug report relative to the calculation error with the .09 value. The link is http://bugs.cacti.net.

Thanks,

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

I've opened the bug; #0000717.

I've attached the log files from two seperate polling cycles so you can see the errors. When I switch back to cmd.php, all is fine.

Thanks--

Zach

TheWitness · Posted: Thu Mar 09, 2006 10:14 pm Post subject:

The duplicate entry messages are normal when converting to Cactid on the first poll. It will only take place for the first poll after you goto Cactid. Then subsequent polls will be fine.

With regard to the validation error, I will have to dig into the code and find out what I screwed up and when.

Like I said, expect a patch this weekend.

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

I allowed Cactid to poll for nearly a half-hour, but I still received the duplicate entry messages after each polling cycle. I'm also seeing a new error that I never saw with the previous version of Cactid before:

TheWitness · Posted: Fri Mar 10, 2006 8:30 pm Post subject:

Please send along the DEBUG log please.

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

I have PM'd you the DEBUG log, as requested.

Thanks for your help!

TheWitness · Posted: Sat Mar 11, 2006 8:24 am Post subject:

I did not see the mysql error. That was corrected in the patched version. You have an error in one of your templates, but I still want to get to the bottom of these error messages. I have been ignoring them for some time since they usually just go away. Read my PM back to you.

TheWitness

TheWitness · Posted: Sun Mar 12, 2006 12:48 pm Post subject:

On the duplicate issue, can you please recheck the SVN version and post.

Thanks,

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

Still seeing the messages.

I've captured a DEBUG log if you'd like to look through it. As for my flawed Data Query (#20), I'm looking in to that now. I suspect that it has something to do with the fact that I'm trying to use the Verify All Fields Re-Index Method... there are also messages in the log after each Cactid run that say Recache Event Detected for Host. I am guessing that this is because Verify All Fields results in a Recache Event on each polling cycle. Is this correct?

Thanks again for your help--

Z

TheWitness · Posted: Mon Mar 13, 2006 8:07 pm Post subject:

You are correct. Maybe I should turn the logging down then to something like Medium or higher only?

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

Yes, adjusting the logging would be stellar. I don't mind seeing recache events for the other two Re-index Methods, but I really don't care to log them when they're going to happen at each polling cycle.

Why is it that cmd.php doesn't log the recache events after each poll?

Also, perhaps I wasn't completely clear in my previous post: I'm still seeing the Duplicate Entry messages--those were what I referred to on my first line. Even the most recent build of Cactid didn't resolve that issue.

Thanks for all your help!

TheWitness · Posted: Tue Mar 14, 2006 1:10 pm Post subject:

That's a good question. Can you please open a bug report to that affect and I will make the correction.

bugs.cacti.net

Reference this post in the bug repot.

Thanks,

TheWitness

zsnyder · Joined: 26 Jan 2006 Posts: 36 Location: Seattle, WA

Sorry this has gone so long without any reply.

I've taken a few more log snapshots running Cactid. I'm still seeing the thousands of lines of Duplicate Entry errors, but only with Cactid. I'm posting a couple of regular log files with this post, and I've PM'd a DEBUG log to TheWitness.

Thanks for all your help!

Z

adrianmarsh · Cacti User Joined: 17 Aug 2005 Posts: 417 Location: UK

I'm guessing this is still a problem then? I tried to upgrade again tonight to g, but got all the polling errors. I was using a version I downloaded in Feb, so I guess theres a newer SVN version available ? Which should I use ?