Obyis's blog

Furthermore, I noticed more than 700 files created BY ZABBIX in /tmp on only masters. They are named like : DeadlockMessage.tmp.17145 & ForeignKeyMessage.tmp.11416

4187:2014-06-03 16:06:51.934 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started. 4187:2014-06-03 16:06:51.934 - INFO: FromDualMySQLagent::setAgentLock 4187:2014-06-03 16:06:51.934 - INFO: Read configuration from /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf

4187:2014-06-03 16:06:53.350 - ERR : got TERM signal. Cleaning up stuff an exit (rc=1). 4187:2014-06-03 16:06:53.351 - INFO: FromDualMySQLagent::removeAgentLock 4187:2014-06-03 16:06:53.351 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1).

Maybe by postponing the interval between two checks, it could be better ? I noticed it’s happening only on huge databases

Hi ! Looks like it’s working for the master module.

So what’s the fix to apply ? Thanks !

Here are the output of this command: hostnameX FromDual.MySQL.master.Binlog_position 1400661892 232071 hostnameX FromDual.MySQL.master.Slave_count 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_event_count 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_total_size 1400661892 407016903 hostnameX FromDual.MySQL.master.Binlog_ignore_filter 1400661892 hostnameX FromDual.MySQL.master.Binlog_count 1400661892 8 hostnameX FromDual.MySQL.master.Binlog_do_filter 1400661892 tableX hostnameX FromDual.MySQL.master.Binlog_number 1400661892 682 hostnameX FromDual.MySQL.master.Binlog_avg_event_size 1400661892 0 hostnameX FromDual.MySQL.master.Binlog_file 1400661892 mysql-bin.000682

Hello,

Here is the log when I’m adding the module master. My latest data are at 10:40 on Zabbix UI.

Thanks to a UserParameter I guess:

UserParameter=FromDual.MySQL.check,/usr/local/mysql_performance_monitor/FromDualMySQL agent.pl /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf

Hello, This debug is when the MPM stops after some hours of work. I’ll send the debug for the module master after.

5698:2014-05-15 13:55:33.212 - INFO: FromDual Performance Monitor for MySQL (0.9.2) run started. 5698:2014-05-15 13:55:33.226 - INFO: FromDualMySQLagent::setAgentLock 5698:2014-05-15 13:55:33.227 - INFO: Read configuration from /usr/local/mysql_performance_monitor/etc/FromDualMySQLagent.conf 5698:2014-05-15 13:55:33.227 - INFO: Sections found: default, hostnameX 5698:2014-05-15 13:55:33.227 - INFO: Reading default section 5698:2014-05-15 13:55:33.227 - DBG : ZabbixServer - ipAddrX 5698:2014-05-15 13:55:33.227 - DBG : Modules - process mysql myisam innodb 5698:2014-05-15 13:55:33.227 - DBG : LogFile - /var/log/zabbix/FromDualMySQLagent.log 5698:2014-05-15 13:55:33.227 - DBG : Type - mysqld 5698:2014-05-15 13:55:33.227 - DBG : Password - ************ 5698:2014-05-15 13:55:33.227 - DBG : Disabled - false 5698:2014-05-15 13:55:33.227 - DBG : Username - db_user 5698:2014-05-15 13:55:33.227 - DBG : Debug - 4 5698:2014-05-15 13:55:33.227 - DBG : TimeShift - 0 5698:2014-05-15 13:55:33.227 - DBG : Socket - /var/lib/mysql/mysql.sock 5698:2014-05-15 13:55:33.227 - DBG : CacheFileBase - /tmp/FromDualAgentCache 5698:2014-05-15 13:55:33.227 - DBG : AgentLockFile - /tmp/FromDualMySQLagent.lock 5698:2014-05-15 13:55:33.227 - DBG : MysqlPort - 3306 5698:2014-05-15 13:55:33.228 - DBG : Hash - 5698:2014-05-15 13:55:33.228 - DBG : ZabbixServerPort - 10051 5698:2014-05-15 13:55:33.228 - DBG : Methode - https 5698:2014-05-15 13:55:33.228 - DBG : ClusterLog - /var/lib/mysql-cluster/ndb_1_cluster.log 5698:2014-05-15 13:55:33.228 - DBG : MaaS - off 5698:2014-05-15 13:55:33.228 - DBG : PidFile - 5698:2014-05-15 13:55:33.228 - DBG : Url - https://support.fromdual.com/maas/receiver.php 5698:2014-05-15 13:55:33.233 - DBG : MysqlHost - 127.0.0.1 5698:2014-05-15 13:55:33.233 - INFO: Processing section default now 5698:2014-05-15 13:55:33.233 - INFO: Processing section hostnameX now 5698:2014-05-15 13:55:33.234 - DBG : The defaults parameters of this configuration file are: 5698:2014-05-15 13:55:33.234 - DBG : ZabbixServer - ipAddrX 5698:2014-05-15 13:55:33.234 - DBG : Modules - process mysql myisam innodb 5698:2014-05-15 13:55:33.234 - DBG : LogFile - /var/log/zabbix/FromDualMySQLagent.log 5698:2014-05-15 13:55:33.234 - DBG : Type - mysqld 5698:2014-05-15 13:55:33.234 - DBG : Password - ************ 5698:2014-05-15 13:55:33.234 - DBG : Disabled - false 5698:2014-05-15 13:55:33.234 - DBG : Username - db_user 5698:2014-05-15 13:55:33.234 - DBG : Debug - 4 5698:2014-05-15 13:55:33.234 - DBG : TimeShift - 0 5698:2014-05-15 13:55:33.234 - DBG : Socket - /var/lib/mysql/mysql.sock 5698:2014-05-15 13:55:33.234 - DBG : MysqlPort - 3306 5698:2014-05-15 13:55:33.234 - DBG : AgentLockFile - /tmp/FromDualMySQLagent.lock 5698:2014-05-15 13:55:33.234 - DBG : CacheFileBase - /tmp/FromDualAgentCache 5698:2014-05-15 13:55:33.235 - DBG : Hash - 5698:2014-05-15 13:55:33.235 - DBG : ZabbixServerPort - 10051 5698:2014-05-15 13:55:33.235 - DBG : Methode - https 5698:2014-05-15 13:55:33.235 - DBG : ClusterLog - /var/lib/mysql-cluster/ndb_1_cluster.log 5698:2014-05-15 13:55:33.235 - DBG : MaaS - off 5698:2014-05-15 13:55:33.235 - DBG : PidFile - 5698:2014-05-15 13:55:33.235 - DBG : Url - https://support.fromdual.com/maas/receiver.php 5698:2014-05-15 13:55:33.235 - DBG : MysqlHost - 127.0.0.1 5698:2014-05-15 13:55:33.235 - DBG : The parameters of section hostnameX are: 5698:2014-05-15 13:55:33.235 - DBG : MysqlPort - 3306 5698:2014-05-15 13:55:33.235 - DBG : Type - mysqld 5698:2014-05-15 13:55:33.235 - DBG : Modules - mpm server process mysql innodb slave 5698:2014-05-15 13:55:33.235 - DBG : The combined (default + section) parameters for section hostnameX are: 5698:2014-05-15 13:55:33.235 - DBG : ZabbixServer - ipAddrX 5698:2014-05-15 13:55:33.236 - DBG : Modules - mpm server process mysql innodb slave 5698:2014-05-15 13:55:33.236 - DBG : LogFile - /var/log/zabbix/FromDualMySQLagent.log 5698:2014-05-15 13:55:33.236 - DBG : Type - mysqld 5698:2014-05-15 13:55:33.236 - DBG : Password - ************ 5698:2014-05-15 13:55:33.236 - DBG : Disabled - false 5698:2014-05-15 13:55:33.236 - DBG : Username - db_user 5698:2014-05-15 13:55:33.236 - DBG : Debug - 4 5698:2014-05-15 13:55:33.236 - DBG : TimeShift - 0 5698:2014-05-15 13:55:33.236 - DBG : Socket - /var/lib/mysql/mysql.sock 5698:2014-05-15 13:55:33.236 - DBG : CacheFile - /tmp/FromDualAgentCache.hostnameX.cache 5698:2014-05-15 13:55:33.236 - DBG : MysqlPort - 3306 5698:2014-05-15 13:55:33.236 - DBG : AgentLockFile - /tmp/FromDualMySQLagent.lock 5698:2014-05-15 13:55:33.236 - DBG : CacheFileBase - /tmp/FromDualAgentCache 5698:2014-05-15 13:55:33.236 - DBG : Hostname - hostnameX 5698:2014-05-15 13:55:33.236 - DBG : Hash - 5698:2014-05-15 13:55:33.236 - DBG : ZabbixServerPort - 10051 5698:2014-05-15 13:55:33.236 - DBG : Methode - https 5698:2014-05-15 13:55:33.237 - DBG : ClusterLog - /var/lib/mysql-cluster/ndb_1_cluster.log 5698:2014-05-15 13:55:33.237 - DBG : MaaS - off 5698:2014-05-15 13:55:33.237 - DBG : PidFile - 5698:2014-05-15 13:55:33.237 - DBG : Url - https://support.fromdual.com/maas/receiver.php 5698:2014-05-15 13:55:33.237 - DBG : MysqlHost - 127.0.0.1 5698:2014-05-15 13:55:33.237 - INFO: Modules for section hostnameX: mpm server process mysql innodb slave 5698:2014-05-15 13:55:33.237 - INFO: Processing module mpm for section hostnameX now… 5698:2014-05-15 13:55:33.324 - INFO: FromDualMySQLmpm::processMpmInformation 5698:2014-05-15 13:55:33.325 - INFO: sendData::sendData 5698:2014-05-15 13:55:33.325 - INFO: writeDataToCacheFile::writeDataToCacheFile 5698:2014-05-15 13:55:33.325 - DBG : hostnameX FromDual.MySQL.mpm.mpm_version 1400154933 0.9.2 5698:2014-05-15 13:55:33.325 - DBG : hostnameX FromDual.MySQL.mpm.mpm_mr_version 1400154933 000902 5698:2014-05-15 13:55:33.325 - INFO: FromDualMySQLagent::checkConnectionToZabbixServer 5698:2014-05-15 13:55:33.325 - DBG : Check connection to zabbix server. 5698:2014-05-15 13:55:33.326 - DBG : /usr/local/zabbix/bin/zabbix_sender –zabbix-server ipAddrX –port 10051 –host ‘hostnameX’ –key FromDual.server.check –value ‘1’ -vv zabbix_sender [5701]: DEBUG: answer [{ “response”:“success”, “info”:“processed: 0; failed: 1; total: 1; seconds spent: 0.000025”}] info from server: “processed: 0; failed: 1; total: 1; seconds spent: 0.000025” sent: 1; skipped: 0; total: 1 5698:2014-05-15 13:55:33.345 - DBG : (ret=512). 5698:2014-05-15 13:55:33.345 - DBG : Partial success (ret=512 / rc=0).

Hello, I don’t know if you received my previous post => Module Master stucks the MPM.

Hello, Thanks, it works well with thoses fixes.

Unfortunately, I discovered that the error : “ERR : Load of cache file failed. rc=1301” is coming with the module “Master”. When I remove it, there are no more errors. So the MPM is stucked because of the module Master. For the moment, it’s running without that module.

Hello,

I still have the same error in the log even after installed libdigest-sha-perl “15116:2014-05-07 10:20:38.922 - ERR : Can’t locate object method “new” via package “Digest::SHA1” (perhaps you forgot to load “Digest::SHA1”?) at /usr/local/mysql_performance_monitor/lib/InnoDbStatus.pm line 54.”

Hi, Here is an error I got : 28991:2014-05-06 15:24:38.940 - ERR : Can’t locate object method “new” via package “Digest::SHA1” (perhaps you forgot to load “Digest::SHA1”?) at /usr/local/mysql_performance_monitor/lib/InnoDbStatus.pm line 54.