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

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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:

Code: Select all

CACTID: Host[26] DS[729] WARNING: Result from SCRIPT not valid. Partial Result: .09
The truth is, this is a valid result from the script--the script that it is complaining about often returns values < 1. This is also something that cmd.php doesn't complain about.

Any help would be hugely appreciated. I've got a lot of data sources now... (1107--many of them scripts) and cmd.php is simply taking too long to collect the data.

Thanks in advance--

Zach
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

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
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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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
Attachments
cactilog1.txt
(145.23 KiB) Downloaded 650 times
cactilog2.txt
(145.37 KiB) Downloaded 787 times
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

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
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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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:

Code: Select all

CACTID: Poller[0] ERROR: Problem with MySQL: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1'
Please let me know if you'd like to see some debug log.

Thanks for all your help!
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Please send along the DEBUG log please.

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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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

Thanks for your help!
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

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

Post by TheWitness »

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

Thanks,

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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

Still seeing the messages. :cry:

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

Post by TheWitness »

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

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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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

Post by TheWitness »

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
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?
zsnyder
Posts: 36
Joined: Thu Jan 26, 2006 1:06 pm
Location: Seattle, WA

Post by zsnyder »

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
Attachments
Cacti Logs.rar
(1.58 KiB) Downloaded 364 times
User avatar
adrianmarsh
Cacti User
Posts: 437
Joined: Wed Aug 17, 2005 8:51 am
Location: UK

Post by adrianmarsh »

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 ?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest