meaning the output is something like:
val1:'234234 ' val2:'1231 ' (ignore the ', used to show the spaces)
You can remove it by editing the script and fixing it.
MySQL error messages when using Cactid poller
Moderators: Developers, Moderators
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
i am having the same problem and it looks like it has something to do with the multiple threads of cactid
Its almost like 2 threads try to do the same thing when the system is under a bit of load.
When i run cactid manually i dont get the msg, and it doesnt always happen when running from cron either.
I just turned down the max threads from 4 to 1 and see if that fixes it.
Only a 5 second difference in process time so thats no big deal.
Its almost like 2 threads try to do the same thing when the system is under a bit of load.
When i run cactid manually i dont get the msg, and it doesnt always happen when running from cron either.
I just turned down the max threads from 4 to 1 and see if that fixes it.
Only a 5 second difference in process time so thats no big deal.
-
TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Cactid has problems if you have 2 hosts with the same IP/Hostname. It will often times cause problems. This only happens when you are attempting to generate the same graphs with both hosts however.
TheWitness
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?
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?
Hello,
I had the same Problem on RedHat 9 when I switch over to cactid from cmd.php.
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '4-mem_swap-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '7-proc-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '6-users-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '93--2005-06-05 18:20:01' for key 1
My problem was a duplicate cron job. I´ve installed it as pre compiled rpm-packet for redhat and the install routine places automaticly a cron file in the redhat specific cron folder /etc/cron.d/cacti.
So you must not make an manal entry in the etc/crontab, but when you do it the php script runs twice and you get the error.
Can see it with a "ps -ef |grep php"
/bin/sh php -c ....
and another
/bin/bash php -c ....
script always at same time.
Hope it helps, in my case cacti now run´s perfectly on an vmware GSX-Server over month´s.
Cray
I had the same Problem on RedHat 9 when I switch over to cactid from cmd.php.
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '4-mem_swap-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '7-proc-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:03 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '6-users-2005-06-05 18:20:01' for key 1
06/05/2005 06:20:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '93--2005-06-05 18:20:01' for key 1
My problem was a duplicate cron job. I´ve installed it as pre compiled rpm-packet for redhat and the install routine places automaticly a cron file in the redhat specific cron folder /etc/cron.d/cacti.
So you must not make an manal entry in the etc/crontab, but when you do it the php script runs twice and you get the error.
Can see it with a "ps -ef |grep php"
/bin/sh php -c ....
and another
/bin/bash php -c ....
script always at same time.
Hope it helps, in my case cacti now run´s perfectly on an vmware GSX-Server over month´s.
Cray
Who is online
Users browsing this forum: No registered users and 2 guests