problems with percona jmx queries - Partial Result: U

[cml]

Hello,

I recently installed cacti-0.8.8a-1.el5.rf and percona-monitoring-plugins-1.0.1.tar.gz.

I am attempting to use the JMX monitors. I have configured all the parameters such that the command line query works:

-sh-3.2$ /usr/bin/php -q /var/www/cacti/scripts/ss_get_by_ssh.php --host gftest01 --type jmx --port2 38686 --items j4,j5

j4:4204877600 j5:6382354432-sh-3.2$

However, when the poller runs it, I see this error:

08/29/2012 11:45:29 AM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
08/29/2012 11:45:59 AM - CMDPHP: Poller[0] Host[2] SNMP: Host responded to SNMP
08/29/2012 11:45:59 AM - CMDPHP: Poller[0] Host[2] DS[14] WARNING: Result from CMD not valid. Partial Result: U
08/29/2012 11:45:59 AM - CMDPHP: Poller[0] Host[2] DS[14] CMD: /usr/bin/php -q /var/www/cacti/scripts/ss_get_by_ssh.php --host gftest01 --type jmx --port2 38686 --items j4,j5,j6, output: U
08/29/2012 11:45:59 AM - CMDPHP: Poller[0] Time: 0.8941 s, Theads: N/A, Hosts: 1

Same issue if I run the poller by hand, or if I run cmd.php by hand.

I have tried every troubleshooting step I can think of, but I cannot understand why the script works but the poller does not.

Anyone have any ideas on what else I can try?

Edit - I'm seeing a lot of Waiting on 1 of 1 pollers. in the log.

[cml]

I discovered that it's not just JMX. Any percona ssh monitor appears to be doing the same thing. Just tried it with a memory monitor.

[cml]

I find by enabling debugging in the ss_get_by_ssh script, I see the correct output generated by the jmx monitor:


2012-08-29 11:45:59 extract_desired() at /var/www/cacti/scripts/ss_get_by_ssh.php:150 <- ss_get_by_ssh() at /var/www/cacti/scripts/ss_get_by_ssh.php:499
'g0:-1 g1:-1 g2:-1 g3:-1 g4:-1 g5:-1 g6:-1 g7:-1 g8:-1 g9:-1 ga:-1 gb:-1 gc:-1 gd:-1 ge:-1 gf:-1 gg:-1 gh:-1 gi:-1 gj:-1 gk:-1 gl:-1 gm:-1 gn:-1 go:-1 gp:-1 gq:-1 gr:-1 gs:-1 gt:-1 gu:-1 gv:-1 gw:-1 gx:-1 gy:-1 jv:-1 gz:-1 h0:-1 h1:-1 h2:-1 h3:-1 h4:-1 h5:-1 h6:-1 h7:-1 h8:-1 h9:-1 ha:-1 hb:-1 hc:-1 hd:-1 he:-1 hf:-1 hg:-1 hh:-1 hi:-1 hj:-1 hk:-1 hl:-1 hm:-1 hn:-1 ho:-1 hp:-1 hq:-1 hr:-1 hs:-1 ht:-1 hu:-1 hv:-1 hw:-1 hx:-1 hy:-1 hz:-1 i0:-1 i1:-1 i2:-1 i3:-1 i4:-1 i5:-1 i6:-1 i7:-1 i8:-1 i9:-1 ia:-1 ib:-1 ic:-1 id:-1 ie:-1 if:-1 ig:-1 ih:-1 ii:-1 ij:-1 ik:-1 il:-1 im:-1 in:-1 io:-1 ip:-1 iq:-1 ir:-1 is:-1 it:-1 iu:-1 iv:-1 iw:-1 ix:-1 iy:-1 iz:-1 j0:-1 j1:-1 j2:-1 j3:-1 j4:3431413936 j5:6382551040 j6:6382551040 j7:626698032 j8:2176385024 j9:2197815296 ja:2577 jb:16384 kl:1 km:8 kn:200 jc:-1 jd:-1 je:-1 jf:-1 jg:-1 jh:-1 ji:-1 jj:-1 jk:-1 jl:-1 jm:-1 jn:-1 jo:-1 jp:-1 jq:-1 jr:-1 js:-1 jt:-1 ju:-1 jw:-1 jx:-1 jy:-1 jz:-1 k0:-1 k1:-1 k2:-1 k3:-1 k4:-1 k5:-1 k6:-1 k7:-1 k8:-1 k9:-1 ka:-1 kb:-1 kc:-1 kd:-1 ke:-1 kf:-1 kg:-1 kh:-1 ki:-1 kj:-1 kk:-1 ko:-1 kp:-1 kq:2606464064 kr:4294967296 ks:4294967296'
2012-08-29 11:45:59 extract_desired() at /var/www/cacti/scripts/ss_get_by_ssh.php:160 <- ss_get_by_ssh() at /var/www/cacti/scripts/ss_get_by_ssh.php:499
'j4:3431413936 j5:6382551040 j6:6382551040'
2012-08-29 11:45:59 at /var/www/cacti/scripts/ss_get_by_ssh.php:117
'j4:3431413936 j5:6382551040 j6:6382551040'


However, the cache file from ss_get_by_ssh in /tmp/ does not have any data:


g0:-1 g1:-1 g2:-1 g3:-1 g4:-1 g5:-1 g6:-1 g7:-1 g8:-1 g9:-1 ga:-1 gb:-1 gc:-1 gd:-1 ge:-1 gf:-1 gg:-1 gh:-1 gi:-1 gj:-1 gk:-1 gl:-1 gm:-1 gn:-1 go:-1 gp:-1 gq:-1 gr:-1 gs:-1 gt:-1 gu:-1 gv:-1 gw:-1 gx:-1 gy:-1 jv:-1 gz:-1 h0:-1 h1:-1 h2:-1 h3:-1 h4:-1 h5:-1 h6:-1 h7:-1 h8:-1 h9:-1 ha:-1 hb:-1 hc:-1 hd:-1 he:-1 hf:-1 hg:-1 hh:-1 hi:-1 hj:-1 hk:-1 hl:-1 hm:-1 hn:-1 ho:-1 hp:-1 hq:-1 hr:-1 hs:-1 ht:-1 hu:-1 hv:-1 hw:-1 hx:-1 hy:-1 hz:-1 i0:-1 i1:-1 i2:-1 i3:-1 i4:-1 i5:-1 i6:-1 i7:-1 i8:-1 i9:-1 ia:-1 ib:-1 ic:-1 id:-1 ie:-1 if:-1 ig:-1 ih:-1 ii:-1 ij:-1 ik:-1 il:-1 im:-1 in:-1 io:-1 ip:-1 iq:-1 ir:-1 is:-1 it:-1 iu:-1 iv:-1 iw:-1 ix:-1 iy:-1 iz:-1 j0:-1 j1:-1 j2:-1 j3:-1 j4:-1 j5:-1 j6:-1 j7:-1 j8:-1 j9:-1 ja:-1 jb:-1 kl:-1 km:-1 kn:-1 jc:-1 jd:-1 je:-1 jf:-1 jg:-1 jh:-1 ji:-1 jj:-1 jk:-1 jl:-1 jm:-1 jn:-1 jo:-1 jp:-1 jq:-1 jr:-1 js:-1 jt:-1 ju:-1 jw:-1 jx:-1 jy:-1 jz:-1 k0:-1 k1:-1 k2:-1 k3:-1 k4:-1 k5:-1 k6:-1 k7:-1 k8:-1 k9:-1 ka:-1 kb:-1 kc:-1 kd:-1 ke:-1 kf:-1 kg:-1 kh:-1 ki:-1 kj:-1 kk:-1 ko:-1 kp:-1

[paulgevers]

I have no idea of this script, but what you describe sounds like an permissions issue. Please check that the script does return the values you want if run with cactiuser.

[cml]

I solved the problem. It turns out my ss_get_by_ssh.php.cnf had a blank line at the end of it, and this was getting prepended to the output of ss_get_by_ssh.php, which in turn broke cmd.php's result parsing. I removed the blank line from the end of the .cnf file, and now everything is working as it should.