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

SQL syntax error when SHOW INNODB STATUS doesn't have information #26

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
A user posted the following:

Error executing 'SELECT CONCAT('', ((10 << 32) + 2142993823)) AS
innodb_transactions, CONCAT('', (((10 << 32) + 2142993823) - ((10 << 32) +
2142968463))) AS unpurged_txns, CONCAT('', (( << 32) + )) AS
log_bytes_written, CONCAT('', (( << 32) + )) AS log_bytes_flushed,
CONCAT('', ((( << 32) + ) - (( << 32) + ))) AS unflushed_log, CONCAT('',
0+231781322+910087356) AS spin_waits, CONCAT('', 61713300314) AS
spin_rounds, CONCAT('', 122774767+42298281+44021761) AS os_waits': You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '<< 32) + )) AS
log_bytes_written, CONCAT('', (( << 32) + )) AS log_bytes_flushed' at line 1

The problem was SHOW INNODB STATUS was truncated, so some of the items were
empty strings instead of integers.

Original issue reported on code.google.com by baron.schwartz on 9 Oct 2008 at 10:21

GoogleCodeExporter commented 9 years ago 
duplicate of issue 27.

Original comment by baron.schwartz on 9 Oct 2008 at 10:23