You are here
mpm monitor a server having Multiple database instances bug
Tue, 2014-08-19 04:34 — earl86
I used mpm to monitor a server which having 3 mysql database instance.I keep getting the below errors in the FromDual log file:
30666:2014-08-18 19:24:50.378 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
30666:2014-08-18 19:24:50.378 - INFO: FromDualMySQLagent::setAgentLock
30666:2014-08-18 19:24:50.378 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
30666:2014-08-18 19:24:50.378 - WARN: Another agent with PID 30625 (our PID is 30666) is running. We will abort now.
30666:2014-08-18 19:24:50.378 - INFO: gRemoveLockFile is not set.
30666:2014-08-18 19:24:50.378 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
711:2014-08-18 18:32:10.461 - INFO: writeDataToCacheFile::writeDataToCacheFile
712:2014-08-18 18:32:10.461 - INFO: FromDualMySQLagent::clearCacheFile
712:2014-08-18 18:32:10.461 - INFO: sendData::sendData
712:2014-08-18 18:32:10.461 - INFO: writeDataToCacheFile::writeDataToCacheFile
711:2014-08-18 18:32:10.462 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
712:2014-08-18 18:32:10.463 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
711:2014-08-18 18:32:10.468 - INFO: sendCachedData::sendCachedData
712:2014-08-18 18:32:10.468 - INFO: sendCachedData::sendCachedData
711:2014-08-18 18:32:10.472 - ERR : Load of cache file failed. rc=1301
712:2014-08-18 18:32:10.472 - ERR : Load of cache file failed. rc=1301
711:2014-08-18 18:32:10.473 - INFO: Processing module mysql for section mysql2 finished.
712:2014-08-18 18:32:10.473 - INFO: Processing module mysql for section mysql2 finished.
711:2014-08-18 18:32:10.473 - INFO: Processing module myisam for section mysql2 now...
712:2014-08-18 18:32:10.473 - INFO: Processing module myisam for section mysql2 now...
711:2014-08-18 18:32:10.476 - INFO: FromDualMySQLmyisam::processMyisamInformation
712:2014-08-18 18:32:10.476 - INFO: FromDualMySQLmyisam::processMyisamInformation
711:2014-08-18 18:32:10.477 - INFO: FromDualMySQLagent::getGlobalVariables
712:2014-08-18 18:32:10.477 - INFO: FromDualMySQLagent::getGlobalVariables
711:2014-08-18 18:32:10.487 - INFO: FromDualMySQLagent::getGlobalStatus
712:2014-08-18 18:32:10.488 - INFO: FromDualMySQLagent::getGlobalStatus
711:2014-08-18 18:32:10.498 - INFO: sendData::sendData
711:2014-08-18 18:32:10.498 - INFO: writeDataToCacheFile::writeDataToCacheFile
712:2014-08-18 18:32:10.498 - INFO: sendData::sendData
712:2014-08-18 18:32:10.498 - INFO: writeDataToCacheFile::writeDataToCacheFile
711:2014-08-18 18:32:10.499 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
712:2014-08-18 18:32:10.499 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
711:2014-08-18 18:32:10.505 - INFO: sendCachedData::sendCachedData
712:2014-08-18 18:32:10.505 - INFO: sendCachedData::sendCachedData
711:2014-08-18 18:32:10.509 - ERR : Load of cache file failed. rc=1301
711:2014-08-18 18:32:10.509 - INFO: sendData::sendData
711:2014-08-18 18:32:10.510 - INFO: writeDataToCacheFile::writeDataToCacheFile
712:2014-08-18 18:32:10.510 - ERR : Load of cache file failed. rc=1301
712:2014-08-18 18:32:10.510 - INFO: sendData::sendData
712:2014-08-18 18:32:10.510 - INFO: writeDataToCacheFile::writeDataToCacheFile
711:2014-08-18 18:32:10.511 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
712:2014-08-18 18:32:10.511 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer
711:2014-08-18 18:32:10.516 - INFO: sendCachedData::sendCachedData
712:2014-08-18 18:32:10.517 - INFO: sendCachedData::sendCachedData
711:2014-08-18 18:32:10.521 - ERR : Load of cache file failed. rc=1301
711:2014-08-18 18:32:10.521 - INFO: Processing module myisam for section mysql2 finished.
712:2014-08-18 18:32:10.521 - ERR : Load of cache file failed. rc=1301
711:2014-08-18 18:32:10.522 - INFO: Processing module innodb for section mysql2 now...
712:2014-08-18 18:32:10.522 - INFO: Processing module myisam for section mysql2 finished.
712:2014-08-18 18:32:10.522 - INFO: Processing module innodb for section mysql2 now...
711:2014-08-18 18:32:10.533 - INFO: FromDualMySQLinnodb::processInnodbInformation
Are there any suggestions on how to fix this?
this is myql conf:
# All MySQL databases here
# Try to avoid section names with spaces!
[mysql1] # This MUST match Hostname in Zabbix!
Type = mysqld
MysqlHost = 192.168.1.10
MysqlPort = 3306
Modules = mysql myisam innodb master slave
PidFile = /tmp/mysqld1.pid
[mysql2] # This MUST match Hostname in Zabbix!
Type = mysqld
MysqlHost = 192.168.1.20
MysqlPort = 3306
Modules = mysql myisam innodb slave
PidFile = /tmp/mysqld2.pid
[mysql3] # This MUST match Hostname in Zabbix!
Type = mysqld
MysqlHost = 192.168.1.30
MysqlPort = 3306
Modules = mysql myisam innodb slave
PidFile = /tmp/mysqld3.pid
Thank you!
Load of cache file failed. rc=1301
Hello earl86
can you please set
Debug = 4
in thempm.conf
and send us the output?The failing code is this:
So
zabbix_sender
cannot send the data to the server. Either IP and port are wrong or there is a Firewall or similar stuff...Regards,
Oli