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

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

Post by TheWitness »

Just to confirm, you are using the latest BRANCH_0_8_6 that you made yourself or are you using something else?

Please advise,

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
adrianmarsh
Cacti User
Posts: 437
Joined: Wed Aug 17, 2005 8:51 am
Location: UK

Post by adrianmarsh »

Using the one you posted in this thread
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

What version of cygwin1.dll?
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?
anuraganuj
Cacti User
Posts: 70
Joined: Tue Feb 21, 2006 9:50 am

this is no problem

Post by anuraganuj »

hi all,

i did lotzz of investigation on this u know this is not a problem at all,
what cmd.php does is it matches a hosts all cached fields.in case thereis change it update poller_command tableto mark that host for recaching.
but table has a integrity constraint.so once a host is marked for one specific type of data query it would do for all fields in that data query, but cmd.php tryies to make entry for each and every field in poller_command table which is not required that is why database does nt allow and hence this error come what needs to be done is to change logic of verification a bit that whenever a field is found to me unmatching after marking it for recaching it should skip to other fields under other data query,

if you get this for a particulr host then may be you are using verify all fileds as recaching method
anuraganuj
Cacti User
Posts: 70
Joined: Tue Feb 21, 2006 9:50 am

please post latest cactid

Post by anuraganuj »

can some body post cactid 086g i ahve cactid which was in zip 806g but whne it starts it says cactid 086f starting
User avatar
adrianmarsh
Cacti User
Posts: 437
Joined: Wed Aug 17, 2005 8:51 am
Location: UK

Post by adrianmarsh »

Thewitness: Oopss... Sorry... didn't see the notification you'd asked a question. I'll post the answer next week when I'm back in the office.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests