after one day since Boost started with Boost On Demand option enabled i recive and error. When i'm trying to see any of my graph, they are blank (no data generated from polling period).
On logs i see an error:
Code: Select all
11/16/2010 03:20:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"SHOW TABLES LIKE '%boost%'"
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:21 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:23 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:23 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:24 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:24 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:20:24 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:09 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:09 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:09 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:09 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:09 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:11 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:11 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:11 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:11 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
11/16/2010 03:21:12 PM - BOOST SERVER: Poller[0] WARNING: Broken connection detected '127.0.0.1'
After reload Boost server (cacti_rrdsvc restart) everything goes back to normal work. Graphs are generated through "Boost on Demand" option.
I think there could be a problem with mysql_timeout in boost (he is set to NULL, and Boost server loose connection with MySQL server after couple of hours).
General Information
Date Tue, 16 Nov 2010 16:39:09 +0100
Cacti Version 0.8.7g
Cacti OS unix
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.4.x
Poller Information
Interval 300
Type spine
Items Action[0]: 11488
Action[1]: 5
Action[2]: 27022
Total: 38515
Concurrent Processes 6
Max Threads 100
PHP Servers 10
Script Timeout 15
Max OID 0
PHP Information
PHP Version 5.3.3
PHP OS Linux
PHP uname Linux 2010 x86_64
PHP SNMP Installed
max_execution_time 30
memory_limit 1024M
Boost Storage Statistics
Database Engine: MEMORY
Current Boost Table Size: 647 MBytes
Avg Bytes/Record: 545 Bytes
Max Record Length: 247 Bytes
Max Allowed Boost Table Size: 6 GBytes
Estimated Maximum Records: 12377427 Records
I have test it on Boost v 4.2/4.0-1/3.1/2.4 - with the same result.
[UPDATE]
I think it may be a problem with php 5.3.x (http://dev.mysql.com/doc/refman/5.1/en/gone-away.html).
I've test all of these solutions (increase number of connections etc.).
After 8 hours is disconnecting with MySQL server and it doesn't reconnect.
In attachment you can find my strace boost_server.php PID details.
Regards,
Alex