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!

tags: 

Comments

Hello earl86

can you please set Debug = 4 in the mpm.conf and send us the output?

The failing code is this:

my $cmd = "$exe --zabbix-server $pServer --port $pPort --input-file $main::gParameter{'CacheFile'} --with-timestamps";

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

admin comment Tue, 2014-08-19 07:48