Issue 78 in innotop: Innotop fails to start: INNODB_BLOCKED_BLOCKER: DBD::mysql::st execute failed: Unknown column 'r.trx_rows_modified'

[inn...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 78 by emarc...@gmail.com: Innotop fails to start:
INNODB_BLOCKED_BLOCKER: DBD::mysql::st execute failed: Unknown
column 'r.trx_rows_modified'
http://code.google.com/p/innotop/issues/detail?id=78

What steps will reproduce the problem?

1. Install Innotop 1.9
2. Innotop fails to start with the message: Innotop fails to start:
INNODB_BLOCKED_BLOCKER: DBD::mysql::st execute failed: Unknown
column 'r.trx_rows_modified'


What is the expected output? What do you see instead?

Innotop screen

What version of the product are you using? On what operating system?

- Innotop 1.9
- Server version: 5.1.63-rel13.4-log Percona Server (GPL), 13.4, Revision
443
- CentOS release 5.8 (Final)

Please provide any additional information below.

The table schema INNODB_TRX doesn't have the column 'rx_rows_modified'.
Could it be that the innotop 1.9 is not compatible with the mysql version
used?

desc INFORMATION_SCHEMA.INNODB_TRX;
+-----------------------+---------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key |
Default | Extra |
+-----------------------+---------------------+------+-----+---------------------+-------+
| trx_id | varchar(18) | NO |
| | |
| trx_state | varchar(13) | NO |
| | |
| trx_started | datetime | NO | | 0000-00-00
00:00:00 | |
| trx_requested_lock_id | varchar(81) | YES | |
NULL | |
| trx_wait_started | datetime | YES | |
NULL | |
| trx_weight | bigint(21) unsigned | NO | |
0 | |
| trx_mysql_thread_id | bigint(21) unsigned | NO | |
0 | |
| trx_query | varchar(1024) | YES | |
NULL | |
+-----------------------+---------------------+------+-----+---------------------+-------+
8 rows in set (0.01 sec)

[inn...@googlecode.com]

Updates:
Status: Accepted

Comment #1 on issue 78 by baron.sc...@gmail.com: Innotop fails to start:

INNODB_BLOCKED_BLOCKER: DBD::mysql::st execute failed: Unknown
column 'r.trx_rows_modified'
http://code.google.com/p/innotop/issues/detail?id=78

Yes, that's probably the case.