SPINE: Poller[0] FATAL: MySQL Error:'2013'

[pswolfwind]

Hi All,
I'm using cacti 0.8.8c with mysql 5.5.40 and php 5.5.19, it's running on a virtual machine. At first my cacti kept reporting error like these when I added over 300 devices:

Code: Select all

27172 03/08/2016 02:00:01 PM - POLLER: Poller[0] WARNING: There are '1' detected       as overrunning a polling process, please investigate
27173 03/08/2016 02:00:01 PM - POLLER: Poller[0] WARNING: Poller Output Table no      t Empty.  Issues Found: 3, Data Sources: (DS[451]), (DS[452]), (DS[453])
27174 03/08/2016 02:00:02 PM - PHPSVR: Poller[0] Maximum runtime of 300 seconds       exceeded for the Script Server. Exiting.
27175 03/08/2016 02:00:02 PM - SPINE: Poller[0] ERROR: SS[0] PHP Script Server c      ommunications lost.  Restarting PHP Script Server
27176 03/08/2016 02:00:17 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Pro      cessing Hosts Internal
27177 03/08/2016 02:00:17 PM - SPINE: Poller[0] ERROR: Spine Timed Out While Pro      cessing Hosts Internal
27178 03/08/2016 02:05:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds       exceeded. Exiting.

So I edited the spine parameter to this now:

cacti parameter now

cacti parameter.png (51.62 KiB) Viewed 1501 times

But then cacti keeping reporting errors in the title:

Code: Select all

03/09/2016 04:45:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:03 PM - SPINE: Poller[0] FATAL: MySQL Error:'2013', Message:'Lost connection to MySQL server during query' (Spine thread)
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/09/2016 04:40:02 PM - SPINE: Poller[0] FATAL: MySQL Error:'2013', Message:'Lost connection to MySQL server during query' (Spine thread)
03/09/2016 04:35:47 PM - WEATHERMAP: Poller[0] STATS: Weathermap 0.97c run complete - Wed, 09 Mar 16 16:35:47 +0800: 1 maps were run in 1 seconds with 1 warnings.
03/09/2016 04:35:47 PM - WEATHERMAP: Poller[0] [Map 4] r3.hkg1.conf: Wrote map to /home/cacti/plugins/weathermap/output/9b7b4522ec79396005f5.png and /home/cacti/plugins/weathermap/output/9b7b4522ec79396005f5.thumb.png
03/09/2016 04:35:46 PM - WEATHERMAP: Poller[0] [Map 4] r3.hkg1.conf: About to write image file. If this is the last message in your log, increase memory_limit in php.ini [WMPOLL01]
03/09/2016 04:35:46 PM - WEATHERMAP: Poller[0] WARNING: [Map 4] r3.hkg1.conf: NewColourFromPercent: Clipped 101.3138352% to 100% for item R1.hkg1-node07899 [WMWARN33]
03/09/2016 04:35:46 PM - WEATHERMAP: Poller[0] [Map 4] r3.hkg1.conf: Map: /home/cacti/plugins/weathermap/configs/r3.hkg1.conf -> /home/cacti/plugins/weathermap/output/9b7b4522ec79396005f5.html & /home/cacti/plugins/weathermap/output/9b7b4522ec79396005f5.png
03/09/2016 04:35:46 PM - WEATHERMAP: Poller[0] Weathermap 0.97c starting - Normal logging mode. Turn on DEBUG in Cacti for more information
03/09/2016 04:35:46 PM - SYSTEM STATS: Time:45.4598 Method:spine Processes:5 Threads:5 Hosts:392 HostsPerProcess:79 DataSources:946 RRDsProcessed:610
03/09/2016 04:35:19 PM - SPINE: Poller[0] Host[215] Hostname[116.52.157.238] NOTICE: HOST EVENT: Host Returned from DOWN State
03/09/2016 04:35:01 PM - POLLER: Poller[0] WARNING: There are '1' detected as overrunning a polling process, please investigate

cacti log now.txt

current cacti log

(142.53 KiB) Downloaded 130 times

There are also error 2006 like

Code: Select all

03/09/2016 02:35:03 PM - SPINE: Poller[0] WARNING: SQL Failed! Error:'2006', Message:'MySQL server has gone away', Attempting to Reconnect

this errors are not happening at every polling(5 mins) though.

I've read a few posts on this forum and increased the max_connection and max_allowed_packet in my.cnf but error still persists.. I've run spine -R -S 2 times but see no problem,could you help me out? Thanks