View Issue Details

IDProjectCategoryView StatusLast Update
0000154FromDual Performance Monitor for MariaDB and MySQL (fpmmm)fpmmm Agentpublic2014-09-02 09:20
Reporterearl86 Assigned Tooli  
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
PlatformLinuxOSCentosOS Version6.x
Product Version0.9.3 
Summary0000154: bug:mpm monitor 3 instances database of mysql which with different ip on one server
Description19414:2014-08-26 20:56:21.046 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16168:2014-08-26 20:53:40.863 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16167:2014-08-26 20:53:40.892 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:40.906 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:40.938 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:40.947 - ERR : Load of cache file failed. rc=1301
16185:2014-08-26 20:53:40.961 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16185:2014-08-26 20:53:40.961 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16185:2014-08-26 20:53:40.961 - WARN: Another agent with PID 16167 (our PID is 16185) is running. We will abort now.
16185:2014-08-26 20:53:40.962 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16167:2014-08-26 20:53:40.975 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:40.986 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:40.997 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:41.019 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:41.029 - ERR : Load of cache file failed. rc=1301
16167:2014-08-26 20:53:41.416 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
16330:2014-08-26 20:53:51.026 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16331:2014-08-26 20:53:51.050 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16331:2014-08-26 20:53:51.050 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16331:2014-08-26 20:53:51.050 - WARN: Another agent with PID 16330 (our PID is 16331) is running. We will abort now.
16331:2014-08-26 20:53:51.050 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16332:2014-08-26 20:53:51.076 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16332:2014-08-26 20:53:51.076 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16332:2014-08-26 20:53:51.076 - WARN: Another agent with PID 16330 (our PID is 16332) is running. We will abort now.
16332:2014-08-26 20:53:51.076 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16330:2014-08-26 20:53:51.078 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.092 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.125 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.137 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.177 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.189 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.200 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.223 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.234 - ERR : Load of cache file failed. rc=1301
16330:2014-08-26 20:53:51.624 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
16499:2014-08-26 20:54:00.665 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16499:2014-08-26 20:54:00.731 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.744 - ERR : Load of cache file failed. rc=1301
16506:2014-08-26 20:54:00.772 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16506:2014-08-26 20:54:00.772 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16506:2014-08-26 20:54:00.772 - WARN: Another agent with PID 16499 (our PID is 16506) is running. We will abort now.
16506:2014-08-26 20:54:00.772 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16499:2014-08-26 20:54:00.775 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.784 - ERR : Load of cache file failed. rc=1301
16521:2014-08-26 20:54:00.824 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16521:2014-08-26 20:54:00.824 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16521:2014-08-26 20:54:00.824 - WARN: Another agent with PID 16499 (our PID is 16521) is running. We will abort now.
16521:2014-08-26 20:54:00.824 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16499:2014-08-26 20:54:00.832 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.844 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.854 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.876 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:00.888 - ERR : Load of cache file failed. rc=1301
16499:2014-08-26 20:54:01.272 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
16721:2014-08-26 20:54:10.885 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16722:2014-08-26 20:54:10.930 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16722:2014-08-26 20:54:10.930 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16722:2014-08-26 20:54:10.930 - WARN: Another agent with PID 16721 (our PID is 16722) is running. We will abort now.
16722:2014-08-26 20:54:10.930 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16721:2014-08-26 20:54:10.940 - ERR : Load of cache file failed. rc=1301
16721:2014-08-26 20:54:10.954 - ERR : Load of cache file failed. rc=1301
16721:2014-08-26 20:54:10.972 - ERR : Load of cache file failed. rc=1301
16721:2014-08-26 20:54:10.981 - ERR : Load of cache file failed. rc=1301
16733:2014-08-26 20:54:10.991 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
16733:2014-08-26 20:54:10.991 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
16733:2014-08-26 20:54:10.991 - WARN: Another agent with PID 16721 (our PID is 16733) is running. We will abort now.
16733:2014-08-26 20:54:10.991 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
16721:2014-08-26 20:54:11.027 - ERR : Load of cache file failed. rc=1301
16721:2014-08-26 20:54:11.039 - ERR : Load of cache file failed. rc=1301
16721:2014-08-26 20:54:11.068 - WARN: Cache file is too big (210550). Removing it (rc=1901).
16721:2014-08-26 20:54:11.499 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=0).
16887:2014-08-26 20:54:20.682 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
21864:2014-08-28 00:26:20.913 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
21864:2014-08-28 00:26:20.913 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
21864:2014-08-28 00:26:20.913 - WARN: Another agent with PID 21860 (our PID is 21864) is running. We will abort now.
21864:2014-08-28 00:26:20.913 - INFO: FromDual Performance Monitor for MySQL run finshed (rc=1316).
21880:2014-08-28 00:26:20.993 - INFO: FromDual Performance Monitor for MySQL (0.9.3) run started.
21880:2014-08-28 00:26:20.993 - WARN: Agent Lock file /tmp/FromDualMySQLagent.lock already exists.
21880:2014-08-28 00:26:20.993 - WARN: Another agent with PID 21860 (our PID is 21880) is running. We will abort now.
Additional InformationFromDualMySQLagent.conf
[default]

# Type of section:
# mysqld for a normal MySQL database
# ndbd for a MySQL cluster
Type = mysqld

# Debug levels are:
# 1 is logging only errors
# 2 is logging errors and warnings (this is the default)
# 3 logs some informations messages as well
# 4 logs everything (for debugging purposes only)

Debug = 2
LogFile = /var/log/zabbix/FromDualMySQLagent.log
# Directory where the Cache files should be written to:
CacheFileBase = /var/log/zabbix/cache/FromDualAgentCache

# If you agent is not located in the same time zone as your server
# For US something like -6.0 to our MaaS Server
# For Asia something like +7.0 to our MaaS Server
# TimeShift = +0.0

# Information for MySQL connections:
Username = test
Password = test


# Zabbix Server IP address
ZabbixServer = 192.168.1.2

# If section is disabled
Disabled = false

# Possible modules for databases are:
# process mysql myisam aria innodb pbxt ndb master slave drbd galera memcache
# Possible modules for servers are:
# mpm server
# Usual modules are
Modules = mysql myisam innodb

# Special parameter which is used for module ndb and process
#ClusterLog = /var/lib/mysql-cluster/ndb_1_cluster.log
#PidFile = /var/lib/mysql/mysqld.pid


# If you want to use Monitoring as a Service:

# MaaS = on
# Hash = <enter hash value we provide you>
# Methodes are: direct, https, email. Currently only http works
# Methode = https
# Url = https://support.fromdual.com/maas/receiver.php

[db_server]

Type = mysqld
Modules = mpm


# All MySQL databases here
# Try to avoid section names with spaces!


[msyql1] # This MUST match Hostname in Zabbix!

Type = mysqld
MysqlHost = 192.168.1.3
MysqlPort = 3306
Modules = mysql myisam innodb slave
PidFile = /data1/mysql/msyql1/tmp/mysqld.pid


[msyql2] # This MUST match Hostname in Zabbix!

Type = mysqld
MysqlHost = 192.168.1.4
MysqlPort = 3306
Modules = mysql myisam innodb slave
PidFile = /data1/mysql/msyql2/tmp/mysqld.pid


[msyql3] # This MUST match Hostname in Zabbix!

Type = mysqld
MysqlHost = 192.168.1.5
MysqlPort = 3306
Modules = mysql myisam innodb slave
PidFile = /data1/mysql/msyql3/tmp/mysqld.pid
TagsNo tags attached.

Activities

oli

2014-09-02 09:20

developer   ~0000135

Hello earl86

Can you please set Debug = 4 and let us know what comes around the 1301 return code?

I assume there are some "empty" values which are not formatted properly. You can possibly just delete the cache files to make it work again.

It would be interesting for us which values are not formatted properly. We fixed some with 0.9.3 but possibly not all...

Regards,
Oli

Issue History

Date Modified Username Field Change
2014-08-28 09:31 earl86 New Issue
2014-08-28 09:31 earl86 Status new => assigned
2014-08-28 09:31 earl86 Assigned To => oli
2014-09-02 09:20 oli Note Added: 0000135
2015-05-01 11:07 administrator Category mpm Agent => fpmmm Agent