boost_server.php consumes 99% cpu
Moderators: Developers, Moderators
-
- Posts: 33
- Joined: Mon Aug 08, 2005 1:15 am
- Location: Los Angeles, CA
- Contact:
Hey All
Hey all,
Cacti8.6j, cactid, boost 1.2 w/ dedicated MySQL 5 (boost tables from memory), php(5) limit is 256MB, mysql key_buffer ~ 1GB, max_heap_size=512MB
The boost server will run nicely for awhile, updateing the RRDs (it seems).
05/20/2007 07:35:24 PM - SYSTEM STATS: Time:23.4675 Method:cactid Processes:10 Threads:10 Hosts:353 HostsPerProcess:36 DataSources:3038 RRDsProcessed:0
05/20/2007 07:31:17 PM - SYSTEM BOOST STATS: Time:51.2698 RRDUpdates:36456
Then all the sudden if i have not accessed the server in a day or so, i cant get the graphs to update. if i enter to view a graph, it just sits there untill it times out. Cacti log showing tons of:
05/20/2007 07:56:18 PM - Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/20/2007 07:56:18 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/20/2007 07:56:18 PM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1708'
the boost status is:
Boost On Demand Updating: Idle
Total Data Sources: 3038
Total Boost Records: 18203
Table Size Estimates
Current Boost Table Size: 24 MBytes
Avg Bytes/Record: 545 Bytes
Max Allowed Boost Table Size: 502 MBytes
Estimated Maximum Records: 965593 Records
Previous Runtime
Last Start Time: 2007-05-20 19:30:26
Last Run Duration: 51.2698 Seconds
RRD's Updated: 36456
Run Time Configuration
Update Frequency: 1 Hour
Next Start Time: 2007-05-20 20:30:26
Maximum Records: 1000000 Records
Maximum Allowed Runtime: 20 Minutes
Boost Server Details
Server Config Status: Enabled
Multiprocess Server: Single Process
Update Timeout: 10 Seconds
Server/Port: localhost@9050
Authorized Update Web Servers: 127.0.0.1
RRDtool Binary Used: /usr/bin/rrdtool
Image Caching
Image Cacing Status: Disabled
Cache Directory:
Cached Files: WARNING: N/A
Cached Files Size: WARNING: Directory Does NOT Exist!!
Ill do a "Rebuild Poller Cache"
And the graphs will update again.
If i do a restart on the process it seems fine, not crashed.
[root@monitor init.d]# service cacti_rrdsvc restart
Stopping Cacti RRDTool Process: [ OK ]
Starting Cacti RRDTool Process: [ OK ]
I also cleared both boost tables once, problem reoccured.
I do get this error once in awhile, seems to happen after a host dident respond.
05/20/2007 06:05:01 PM - CMDPHP: Poller[0] WARNING: Poller found partially populated poller_output table.
CPU is always normal, never 99% like in previous posts from other users.
Load avg <0.6 on CentOS 4.4.
ideas?
Regards,
Martin Madsen
Bel Air Internet
Cacti8.6j, cactid, boost 1.2 w/ dedicated MySQL 5 (boost tables from memory), php(5) limit is 256MB, mysql key_buffer ~ 1GB, max_heap_size=512MB
The boost server will run nicely for awhile, updateing the RRDs (it seems).
05/20/2007 07:35:24 PM - SYSTEM STATS: Time:23.4675 Method:cactid Processes:10 Threads:10 Hosts:353 HostsPerProcess:36 DataSources:3038 RRDsProcessed:0
05/20/2007 07:31:17 PM - SYSTEM BOOST STATS: Time:51.2698 RRDUpdates:36456
Then all the sudden if i have not accessed the server in a day or so, i cant get the graphs to update. if i enter to view a graph, it just sits there untill it times out. Cacti log showing tons of:
05/20/2007 07:56:18 PM - Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/20/2007 07:56:18 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/20/2007 07:56:18 PM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1708'
the boost status is:
Boost On Demand Updating: Idle
Total Data Sources: 3038
Total Boost Records: 18203
Table Size Estimates
Current Boost Table Size: 24 MBytes
Avg Bytes/Record: 545 Bytes
Max Allowed Boost Table Size: 502 MBytes
Estimated Maximum Records: 965593 Records
Previous Runtime
Last Start Time: 2007-05-20 19:30:26
Last Run Duration: 51.2698 Seconds
RRD's Updated: 36456
Run Time Configuration
Update Frequency: 1 Hour
Next Start Time: 2007-05-20 20:30:26
Maximum Records: 1000000 Records
Maximum Allowed Runtime: 20 Minutes
Boost Server Details
Server Config Status: Enabled
Multiprocess Server: Single Process
Update Timeout: 10 Seconds
Server/Port: localhost@9050
Authorized Update Web Servers: 127.0.0.1
RRDtool Binary Used: /usr/bin/rrdtool
Image Caching
Image Cacing Status: Disabled
Cache Directory:
Cached Files: WARNING: N/A
Cached Files Size: WARNING: Directory Does NOT Exist!!
Ill do a "Rebuild Poller Cache"
And the graphs will update again.
If i do a restart on the process it seems fine, not crashed.
[root@monitor init.d]# service cacti_rrdsvc restart
Stopping Cacti RRDTool Process: [ OK ]
Starting Cacti RRDTool Process: [ OK ]
I also cleared both boost tables once, problem reoccured.
I do get this error once in awhile, seems to happen after a host dident respond.
05/20/2007 06:05:01 PM - CMDPHP: Poller[0] WARNING: Poller found partially populated poller_output table.
CPU is always normal, never 99% like in previous posts from other users.
Load avg <0.6 on CentOS 4.4.
ideas?
Regards,
Martin Madsen
Bel Air Internet
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
I suspect that you might either 1) Need more memory for PHP 2) Have a buggy version (leaky) of PHP 3) Need the following added to poller.php
Just below: "db_execute("truncate poller_time")"; add the following:
TheWitness
Just below: "db_execute("truncate poller_time")"; add the following:
Code: Select all
$rows = db_execute("SELECT count(*) FROM poller_output");
if ($rows) {
cacti_log("WARNING: Rows remaining in poller_output table, truncating\n");
db_execute("TRUNCATE poller_output");
}
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?
-
- Posts: 33
- Joined: Mon Aug 08, 2005 1:15 am
- Location: Los Angeles, CA
- Contact:
hey
patched poller.php as you said. PHP now has 512MB to play with. I changed the boost server to use rrdupdate (/usr/bin/rrdupdate). Now things run smooth, the log looks like this now:
05/21/2007 03:25:26 PM - SYSTEM STATS: Time:24.3985 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:25:02 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
05/21/2007 03:20:26 PM - SYSTEM STATS: Time:25.3634 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:20:01 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
05/21/2007 03:15:27 PM - SYSTEM STATS: Time:25.3788 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:15:01 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
But all graphs are smooth no gaps and i have yet to encounter the graphs not being generated on demand after the changes.
Thanks,
Martin Madsen
Bel Air Internet
05/21/2007 03:25:26 PM - SYSTEM STATS: Time:24.3985 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:25:02 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
05/21/2007 03:20:26 PM - SYSTEM STATS: Time:25.3634 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:20:01 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
05/21/2007 03:15:27 PM - SYSTEM STATS: Time:25.3788 Method:cactid Processes:10 Threads:10 Hosts:388 HostsPerProcess:39 DataSources:3410 RRDsProcessed:0
05/21/2007 03:15:01 PM - CMDPHP: Poller[0] WARNING: Rows remaining in poller_output table, truncating
But all graphs are smooth no gaps and i have yet to encounter the graphs not being generated on demand after the changes.
Thanks,
Martin Madsen
Bel Air Internet
-
- Posts: 33
- Joined: Mon Aug 08, 2005 1:15 am
- Location: Los Angeles, CA
- Contact:
hey all
Happend again, cacti was not requested to provide graphs for 9-10 hours, tried this morning and it just sat there. log says:
05/23/2007 09:51:01 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/23/2007 09:51:01 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/23/2007 09:51:01 AM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1991'
05/23/2007 09:51:01 AM - BOOST: Poller[0] ERROR: Timeout detected. Boost server is down. Contact support immediately!!
05/23/2007 09:51:01 AM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1990'
05/23/2007 09:51:01 AM - BOOST: Poller[0] ERROR: Timeout detected. Boost server is down. Contact support immediately!!
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
hundreds of these, restarted the cacti_rrdsvc process, shutdown no problem and came back up no problem. and it all started working again.
Also i dident loose any data by doing this. Ill just setup a cronjob to restart the service once every 4 hours just in case, until next release or someone finds the root of the problem.
Regards,
Martin Madsen
Bel Air Internet
05/23/2007 09:51:01 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/23/2007 09:51:01 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
05/23/2007 09:51:01 AM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1991'
05/23/2007 09:51:01 AM - BOOST: Poller[0] ERROR: Timeout detected. Boost server is down. Contact support immediately!!
05/23/2007 09:51:01 AM - BOOST: Poller[0] WARNING: RRD Update Warning 'FAILED' for Local Data ID '1990'
05/23/2007 09:51:01 AM - BOOST: Poller[0] ERROR: Timeout detected. Boost server is down. Contact support immediately!!
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
05/23/2007 09:51:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT * FROM poller_output_boost_processes"
hundreds of these, restarted the cacti_rrdsvc process, shutdown no problem and came back up no problem. and it all started working again.
Also i dident loose any data by doing this. Ill just setup a cronjob to restart the service once every 4 hours just in case, until next release or someone finds the root of the problem.
Regards,
Martin Madsen
Bel Air Internet
-
- Posts: 33
- Joined: Mon Aug 08, 2005 1:15 am
- Location: Los Angeles, CA
- Contact:
another thing
One more thing I wanna add:
Current Boost Status
Boost On Demand Updating: Idle
Total Data Sources: 4628
Total Boost Records: 13755
Table Size Estimates
Current Boost Table Size: 56 MBytes
Avg Bytes/Record: 545 Bytes
Max Allowed Boost Table Size: 502 MBytes
Estimated Maximum Records: 965593 Records
The status shows 13755 records with a fixed length of 545 bytes a piece.
13755 * 545 bytes = 7320 Kbytes
Why is the table then taking up 56 Mbytes?
Maybe this is normal for memory tables, they keep the max memory allocation they have had in the history of the table. But I cant find any explanation for it though.
A bug? There is only 13755 records in the table i verified, its not like tons of old records are hanging around.
Regards,
Martin Madsen
Current Boost Status
Boost On Demand Updating: Idle
Total Data Sources: 4628
Total Boost Records: 13755
Table Size Estimates
Current Boost Table Size: 56 MBytes
Avg Bytes/Record: 545 Bytes
Max Allowed Boost Table Size: 502 MBytes
Estimated Maximum Records: 965593 Records
The status shows 13755 records with a fixed length of 545 bytes a piece.
13755 * 545 bytes = 7320 Kbytes
Why is the table then taking up 56 Mbytes?
Maybe this is normal for memory tables, they keep the max memory allocation they have had in the history of the table. But I cant find any explanation for it though.
A bug? There is only 13755 records in the table i verified, its not like tons of old records are hanging around.
Regards,
Martin Madsen
Re: hey
is there an rrdupdate binary for windows?merlinthemagic wrote:patched poller.php as you said. PHP now has 512MB to play with. I changed the boost server to use rrdupdate (/usr/bin/rrdupdate). Now things run smooth, the log looks like this now:
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Yes, for Cygwin at least.
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?
I am having the same issue:
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - SYSTEM STATS: Time:278.8272 Method:spine Processes:15 Threads:15 Hosts:931 HostsPerProcess:63 DataSources:94632 RRDsProcessed:0
I have tried restarting the rrdsvc without any luck. Any thoughts?
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:47 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:42 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SELECT * FROM poller_output_boost_processes"
10/07/2008 11:04:41 AM - SYSTEM STATS: Time:278.8272 Method:spine Processes:15 Threads:15 Hosts:931 HostsPerProcess:63 DataSources:94632 RRDsProcessed:0
I have tried restarting the rrdsvc without any luck. Any thoughts?
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
A 2006 error means your connection has been dropped. Check your mysql error log for information relative to this.
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?
What version of boost? You should be using the Subversion one. Latest stable (1.7) is not really usable.
Are there any messages about boost around the 2006 errors? E.g.
Are there any messages about boost around the 2006 errors? E.g.
Code: Select all
ERROR: Timeout detected. Boost server is down. Contact support immediately!!
Who is online
Users browsing this forum: No registered users and 4 guests