ss_get_mysql_stats.php 1.1.8 / cacti 0.8.7h

[GoogleCodeExporter]

Hi,

We are currently testing the new version of Cacti : 0.8.7h
ss_get_mysql_stats.php : $version = "1.1.8";

We have several devices and services : all are OK except for three graphes :

- InnoDB Row Operations 
- Myisam indexes
- Mysql Command Counters

These 3 graphes whith the version 0.8.7g and same configuration worked great.
There is absolutely no error in the logs. And as you could see below, we 
receive the correct output.
We don't have any plugins installed. We tried to change to Spine but we have 
the same result.

10/21/2011 01:10:23 PM - CMDPHP: Poller[0] Host[183] DS[2289] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.91.11 --items c2,c3,c4,c5,c6,c7,c8,c9,ca,cb,cc --user --pass --port , 
output: c2:72029068 c3:1739310 c4:23885006 c5:25484281 c6:889 c7:5023017 c8:0 
c9:1 ca:0 cb:0 cc:0
10/21/2011 01:10:23 PM - CMDPHP: Poller[0] Host[177] DS[2328] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.13 --items bj,bm --user --pass --port , output: bj:32 bm:32
10/21/2011 01:10:23 PM - CMDPHP: Poller[0] Host[176] DS[2288] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.12 --items c2,c3,c4,c5,c6,c7,c8,c9,ca,cb,cc --user --pass --port , 
output: c2:26452432319 c3:71607562 c4:29762181 c5:1073756022 c6:421864 
c7:8097456 c8:0 c9:1 ca:0 cb:0 cc:0
10/21/2011 01:10:22 PM - CMDPHP: Poller[0] Host[177] DS[2327] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.13 --items b4,b5,b6 --user --pass --port , output: b4:10 b5:166838199 
b6:1193
10/21/2011 01:10:22 PM - CMDPHP: Poller[0] Host[183] DS[2277] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.91.11 --items bj,bm --user --pass --port , output: bj:6 bm:32
10/21/2011 01:10:22 PM - CMDPHP: Poller[0] Host[176] DS[2259] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.12 --items cr,cs,ct,cu --user --pass --port , output: cr:2097152 
cs:2097152 ct:320307664340 cu:320307664350
10/21/2011 01:10:21 PM - CMDPHP: Poller[0] Host[183] DS[2276] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.91.11 --items b4,b5,b6 --user --pass --port , output: b4:20 b5:61518400 
b6:124
10/21/2011 01:10:21 PM - CMDPHP: Poller[0] Host[177] DS[2326] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.13 --items bt,bu,c0,c1 --user --pass --port , output: bt:84 
bu:536583032 c0:570 c1:536870912
10/21/2011 01:10:21 PM - CMDPHP: Poller[0] Host[176] DS[2260] CMD: 
/usr/bin/php5 -q /home/cacti/cacti-0.8.7h/scripts/ss_get_mysql_stats.php --host 
10.66.90.12 --items b0,b1,b2,b3 --user --pass --port , output: b0:251853250 
b1:69566531 b2:1088670 b3:1990350155823 

Has anyone the same issue with this version of Cacti ?

Regards,

UgoD.

Original issue reported on code.google.com by ugode...@gmail.com on 21 Oct 2011 at 11:53

[GoogleCodeExporter]

Yeah,I have same issue when I upgrade Cacti to 0.8.7h
- Myisam indexes
- Mysql Command Counters

Original comment by lxe...@gmail.com on 4 Nov 2011 at 10:49

[GoogleCodeExporter]

Same issue here after upgrade from Cacti to to 0.8.7h.

Regards,

Dimi

Original comment by dimitrij...@gmail.com on 8 Nov 2011 at 12:04

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Same thing here, with all ending in graphs as "NaN" (not a number)

- innodb active/locked transaction
- innodb buffer bool
- innodb insert buffer usage
- innodb memory allocation
- innodb row operations
- innodb transactions
- myisam indexes
- mysql command counters
- mysql files and tables

Worked great with cacti/spine 0.8.7g, doesn't work anymore with 0.8.7h ...

Original comment by alau...@cusae.com on 22 Nov 2011 at 10:02

[GoogleCodeExporter]

Same issue on a new installation.

Original comment by DustBug1...@gmail.com on 30 Nov 2011 at 9:16

[GoogleCodeExporter]

Found the problem, it lies in cacti's functions.php . Using the file from svn 
makes the graphs work again.

http://bugs.cacti.net/view.php?id=2063

Original comment by arnaud.l...@gmail.com on 30 Nov 2011 at 10:36

[GoogleCodeExporter]

Thank you, worked for me! So it's no defect in mysql-cacti-templates but in 
cacti 0.8.7h (and will be fixed in 0.8.7i).

Original comment by DustBug1...@gmail.com on 30 Nov 2011 at 11:03

[GoogleCodeExporter]

Original comment by baron.schwartz on 4 Jan 2012 at 2:03

• Changed state: NotABug