View Issue Details

IDProjectCategoryView StatusLast Update
0000171FromDual Performance Monitor for MariaDB and MySQL (fpmmm)fpmmm Slave modulepublic2018-05-03 18:14
Reporterssiddique Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status newResolutionopen 
PlatformLinuxOSRed HatOS Version4.4
Summary0000171: Slave data not being retrieved even though all other modules are not working
DescriptionHello,

We are facing issue with fromdual slave module. No data is getting retrieved hence not getting to zabbix server.
Following is the debug output of the log.

28631:2018-05-02 12:06:02.889 - INFO: sendData
28631:2018-05-02 12:06:02.889 - INFO: writeDataToCacheFile
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Exec_Master_Log_Pos 1525262762 ""
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Read_Master_Log_Pos 1525262762 ""
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Relay_Log_Pos 1525262762 ""
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Seconds_Behind_Master 1525262762 "9999"
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Slave_IO_Running 1525262762 "0"
28631:2018-05-02 12:06:02.890 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.Slave_SQL_Running 1525262762 "0"
28631:2018-05-02 12:06:02.890 - INFO: checkConnectionToZabbixServer
28631:2018-05-02 12:06:02.890 - DBG : Check connection to zabbix server.
28631:2018-05-02 12:06:02.894 - DBG : /usr/bin/zabbix_sender --zabbix-server 172.16.100.105 --port 10051 --host 'dtxdal2-mysql-3' --key FromDual.server.check --value '1' -vv
28631:2018-05-02 12:06:02.899 - DBG : (ret=2).
28631:2018-05-02 12:06:02.899 - DBG : info from server: "processed: 0; failed: 1; total: 1; seconds spent: 0.000032"
28631:2018-05-02 12:06:02.899 - DBG : sent: 1; skipped: 0; total: 1
28631:2018-05-02 12:06:02.899 - DBG : Partial success (ret=2 / rc=0).
28631:2018-05-02 12:06:02.899 - DBG : Connection to zabbix server seems OK.
28631:2018-05-02 12:06:02.899 - INFO: sendCachedData
28631:2018-05-02 12:06:02.899 - DBG : Sending cache file to zabbix server.
28631:2018-05-02 12:06:02.899 - DBG : Cache file found.
28631:2018-05-02 12:06:02.903 - INFO: /usr/bin/zabbix_sender --zabbix-server 172.16.100.105 --port 10051 --input-file /var/lib/zabbix/fpmmmCache.dtxdal2-mysql-3.cache --with-timestamps -vv
28631:2018-05-02 12:06:02.909 - DBG : (ret=2 / rc=0).
28631:2018-05-02 12:06:02.909 - INFO: info from server: "processed: 3; failed: 3; total: 6; seconds spent: 0.000212"
28631:2018-05-02 12:06:02.909 - INFO: sent: 6; skipped: 0; total: 6
28631:2018-05-02 12:06:02.909 - INFO: clearCacheFile
28631:2018-05-02 12:06:02.909 - INFO: sendData
28631:2018-05-02 12:06:02.909 - INFO: writeDataToCacheFile
28631:2018-05-02 12:06:02.910 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.read_only 1525262762 "OFF"
28631:2018-05-02 12:06:02.910 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.slave_skip_errors 1525262762 "OFF"
28631:2018-05-02 12:06:02.910 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.sync_relay_log 1525262762 "10000"
28631:2018-05-02 12:06:02.910 - DBG : dtxdal2-mysql-3 FromDual.MySQL.slave.sync_relay_log_info 1525262762 "10000"
28631:2018-05-02 12:06:02.910 - INFO: checkConnectionToZabbixServer
28631:2018-05-02 12:06:02.910 - DBG : Check connection to zabbix server.
28631:2018-05-02 12:06:02.913 - DBG : /usr/bin/zabbix_sender --zabbix-server 172.16.100.105 --port 10051 --host 'dtxdal2-mysql-3' --key FromDual.server.check --value '1' -vv
28631:2018-05-02 12:06:02.919 - DBG : (ret=2).
28631:2018-05-02 12:06:02.919 - DBG : info from server: "processed: 0; failed: 1; total: 1; seconds spent: 0.000036"
28631:2018-05-02 12:06:02.919 - DBG : sent: 1; skipped: 0; total: 1
28631:2018-05-02 12:06:02.919 - DBG : Partial success (ret=2 / rc=0).
28631:2018-05-02 12:06:02.919 - DBG : Connection to zabbix server seems OK.
Steps To ReproduceEnable slave module and run fpmmm
Additional Informationfpmmm version 0.10.4
mysql version server version: 5.6.39-83.1-56-log Percona XtraDB Cluster (GPL), Release rel83.1, Revision 0a72eda, WSREP version 26.25, wsrep_26.25
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-05-03 18:14 ssiddique New Issue