search

google-code-export / mysql-cacti-templates

Automatically exported from code.google.com/p/mysql-cacti-templates
GNU General Public License v2.0
1 stars 0 forks source link

Transactions in LOCK WAIT status cause error #91

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
This input in SHOW INNODB STATUS is handled,

#23 lock struct(s), heap size 3024, undo log entries 27

But this causes a problem:

# LOCK WAIT 12 lock struct(s), heap size 3024, undo log entries 5

The resulting error looks like this:

Array
(
    [0] => Array
        (
            [file] => /opt/cacti/scripts/ss_get_mysql_stats.php
            [line] => 791
            [function] => to_int
            [args] => Array
                (
                    [0] => LOCK
                )

        )

Original issue reported on code.google.com by baron.schwartz on 19 Nov 2009 at 2:29

GoogleCodeExporter commented 9 years ago 
This actually also made the locks be under-counted.  Fixed in r319.

Original comment by baron.schwartz on 19 Nov 2009 at 2:33