All,
I have a problem where the MySQL pmda silently dies, and I can't see why.
I have given below the PMCD and PMDA logs, and I cant see any useful
failure signatures.
I would appreciate any help...
Regards
Chandana
PMDA LOG
=========
[m4u-chandana@guinness-a pmcd]$ cat mysql.log
Log for pmdamysql on guinness-a.m4u.com.au started Wed Apr 17 10:44:56 2013
[Wed Apr 17 10:44:56] pmdamysql(21980) Warning: cannot find the user pcp
to switch to
[Wed Apr 17 10:45:01] pmdamysql(21980) Info: MySQL connection established
PMCD Log shows MySQL agent
===========================
[m4u-chandana@guinness-a pmcd]$ tail pmcd.log
[Wed Apr 17 10:44:54] pmcd(26050) Info: Reloading PMNS "DEFAULT"
[Wed Apr 17 10:44:56] pmcd(26050) Info:
pmcd RESTARTED at Wed Apr 17 10:44:56 2013
Current PMCD clients ...
fd client connection from ipc ver operations
denied
== ======================================== =======
=================
7 guinness-a.m4u.com.au 2
11 192.168.123.1 2 store
active agent dom pid in out ver protocol parameters
============ === ===== === === === ======== ==========
pmcd 2 2 dso i:5
lib=/var/lib/pcp/pmdas/pmcd/pmda_pmcd.so entry=pmcd_init [(nil)]
linux 60 2 dso i:4
lib=/var/lib/pcp/pmdas/linux/pmda_linux.so entry=linux_init [(nil)]
mmv 70 2 dso i:4
lib=/var/lib/pcp/pmdas/mmv/pmda_mmv.so entry=mmv_init [(nil)]
process 71 26063 8 9 2 bin pipe
cmd=/var/lib/pcp/pmdas/process/pmdaprocess -d 71
mysql 66 21980 14 15 2 bin pipe cmd=perl
/var/lib/pcp/pmdas/mysql/pmdamysql.pl
Host access list:
00 01 Cur/MaxCons host-spec host-mask lvl host-name
== == =========== ========= ========= === ==============
y y 0 0 ae7ba8c0 ffffffff 0 localhost
y 0 0 a40732d2 ffffffff 0 210.50.7.164
y 0 0 a50732d2 ffffffff 0 210.50.7.165
y 0 0 a60732d2 ffffffff 0 210.50.7.166
y 0 0 a70732d2 ffffffff 0 210.50.7.167
y 0 0 a80732d2 ffffffff 0 210.50.7.168
y 0 0 a90732d2 ffffffff 0 210.50.7.169
y 0 0 aa0732d2 ffffffff 0 210.50.7.170
y 0 0 ab0732d2 ffffffff 0 210.50.7.171
y 0 0 ac0732d2 ffffffff 0 210.50.7.172
y 0 0 ad0732d2 ffffffff 0 210.50.7.173
y 0 0 ae0732d2 ffffffff 0 210.50.7.174
y 0 0 f004647a ffffffff 0 122.100.4.240
y 0 0 f104647a ffffffff 0 122.100.4.241
y 0 0 f204647a ffffffff 0 122.100.4.242
y 0 0 f304647a ffffffff 0 122.100.4.243
y 0 0 f404647a ffffffff 0 122.100.4.244
y 0 0 1504647a ffffffff 0 122.100.4.21
y 0 0 1604647a ffffffff 0 122.100.4.22
y 0 0 1704647a ffffffff 0 122.100.4.23
y 0 0 22532daf ffffffff 0 175.45.83.34
y 0 0 0000a8c0 0000ffff 2 192.168.*
n n 0 0 00000000 00000000 4 *
[Wed Apr 17 10:44:56] pmcd(26050) Info: PMNS file "DEFAULT" is unchanged
The agent is now working:
=========================
pminfo -f mysql.slave_status.seconds_behind_master
mysql.slave_status.seconds_behind_master
value 435702
MYSQL PMDA dies - PMCD log
==========================
[Wed Apr 17 10:44:56] pmcd(26050) Info: PMNS file "DEFAULT" is unchanged
[Wed Apr 17 11:40:13] pmcd(26050) Info: pmcd caught SIGTERM from
pid=23541 uid=0
[Wed Apr 17 11:40:14] pmcd(26050) Info: CleanupAgent ...
Cleanup "process" agent (dom 71): terminated, exit(0)
[Wed Apr 17 11:40:14] pmcd(26050) Info: CleanupAgent ...
Cleanup "mysql" agent (dom 66): terminated, exit(1)
[Wed Apr 17 11:40:14] pmcd(26050) Info: pmcd Shutdown
Log finished Wed Apr 17 11:40:14 2013
PMDA log
=========
Log for pmdamysql on guinness-a.m4u.com.au started Wed Apr 17 10:44:56 2013
[Wed Apr 17 10:44:56] pmdamysql(21980) Warning: cannot find the user pcp
to switch to
[Wed Apr 17 10:45:01] pmdamysql(21980) Info: MySQL connection established
Log finished Wed Apr 17 11:40:13 2013
|