SHOW ENGINE INNODB STATUS has two TRANSACTIONS sections

Bug #1404565 reported by Elena Stepanova
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Laurynas Biveinis
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
Medium
Laurynas Biveinis

Bug Description

Initially reported as https://mariadb.atlassian.net/browse/MDEV-7349

SHOW ENGINE INNODB STATUS in 5.6 displays two identical TRANSACTIONS sections.

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.22-71.0-debug Source distribution

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [test]> show engine innodb status \G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2014-12-21 02:22:22 7faa1f5af700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 8 seconds
-----------------
BACKGROUND THREAD
-----------------

...

----------
SEMAPHORES
----------
----------
MUTEX INFO
----------

...

-------------
RW-LATCH INFO
-------------

...

------------
TRANSACTIONS
------------
Trx id counter 1282
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
History list length 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7faa1f5af700, query id 7 localhost ::1 root init
show engine innodb status
--------
FILE I/O
--------

...

-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------

...

---
LOG
---

...

----------------------
BUFFER POOL AND MEMORY
----------------------

...

--------------
ROW OPERATIONS
--------------

...

------------
TRANSACTIONS
------------
Trx id counter 1282
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
History list length 0
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7faa1f5af700, query id 7 localhost ::1 root init
show engine innodb status
----------------------------
END OF INNODB MONITOR OUTPUT
============================

1 row in set (0.01 sec)

Related branches

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Verified with PS 5.6.21

nilnandan@desktop:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.6.21-70.1 Percona Server (GPL), Release 70.1, Revision 698

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show engine innodb status \G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2014-12-31 13:29:23 7ff2e009f700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 25 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 21600 srv_idle
srv_master_thread log flush and writes: 21598
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3
OS WAIT ARRAY INFO: signal count 3
Mutex spin waits 60, rounds 140, OS waits 1
RW-shared spins 2, rounds 60, OS waits 2
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 2.33 mutex, 30.00 RW-shared, 0.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 4868
Purge done for trx's n:o < 2917 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7ff2e009f700, query id 110 localhost root init
show engine innodb status
--------
FILE I/O
--------
..
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
..
---
LOG
---
..
----------------------
BUFFER POOL AND MEMORY
----------------------
..
--------------
ROW OPERATIONS
--------------
..
------------
TRANSACTIONS
------------
Trx id counter 4868
Purge done for trx's n:o < 2917 undo n:o < 0 state: running but idle
History list length 26
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 37, OS thread handle 0x7ff2e009f700, query id 110 localhost root init
show engine innodb status
----------------------------
END OF INNODB MONITOR OUTPUT
============================

1 row in set (0.01 sec)

mysql>

tags: added: xtradb
tags: added: low-hanging-fruit merge-regression
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1595

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.