| Bug #55789 | information_schema innodb_trx repeats a bunch of columns | ||
|---|---|---|---|
| Submitted: | 5 Aug 2010 17:50 | Modified: | 5 Aug 2010 19:13 |
| Reporter: | Morgan Tocker | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: InnoDB Plugin storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.5.5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[5 Aug 2010 18:18]
MySQL Verification Team
Thank you for the bug report. mysql> show columns from innodb_trx like "%isolation%"; +---------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+-------+ | trx_isolation_level | varchar(16) | NO | | | | | trx_isolation_level | varchar(16) | NO | | | | +---------------------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> show variables like "%version%"; +-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | innodb_version | 1.2.0 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.99-m4-debug-log | | version_comment | Source distribution | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------+ 7 rows in set (0.00 sec)
[5 Aug 2010 19:13]
Calvin Sun
duplicate of bug#55395, which is fixed in 5.5.6-m3.
Description: Look at the sample output. It has tonnes of bogus info - most columns are outputted twice, and trx_isolation_level is repeated twice, but the second time it has no value. This could cause some serious problems for people writing automated tools. How to repeat: mysql> SELECT version(); +--------------+ | version() | +--------------+ | 5.5.5-m3-log | +--------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM innodb_trx -> \G *************************** 1. row *************************** trx_id: 3220F trx_state: RUNNING trx_started: 2010-08-05 13:20:48 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 3 trx_query: NULL trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 0 trx_lock_structs: 1 trx_lock_memory_bytes: 376 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_apative_hash_latched: 0 trx_adaptive_hash_timeout: 10000 trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 0 trx_lock_structs: 0 trx_lock_memory_bytes: 0 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: trx_unique_checks: 0 trx_foreign_key_checks: 0 trx_last_foreign_key_error: NULL trx_apative_hash_latched: 0 trx_adaptive_hash_timeout: 0 *************************** 2. row *************************** trx_id: 3220E trx_state: RUNNING trx_started: 2010-08-05 13:20:26 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 2 trx_query: NULL trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 0 trx_lock_structs: 2 trx_lock_memory_bytes: 376 trx_rows_locked: 1 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_apative_hash_latched: 0 trx_adaptive_hash_timeout: 10000 trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 0 trx_lock_structs: 0 trx_lock_memory_bytes: 0 trx_rows_locked: 0 trx_rows_modified: 0 trx_concurrency_tickets: 0 trx_isolation_level: trx_unique_checks: 0 trx_foreign_key_checks: 0 trx_last_foreign_key_error: NULL trx_apative_hash_latched: 0 trx_adaptive_hash_timeout: 0 2 rows in set (0.00 sec)