Status for TOI threads
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Raghavendra D Prabhu | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
From InnoDB status:
---TRANSACTION 75A, not started
MySQL thread id 24, OS thread handle 0x7fa1fc0a1700, query id 1697 localhost 127.0.0.1 root checking permissions
DROP TABLE IF EXISTS c
From GDB trace:
Thread 4 (Thread 0x7fa1fc0a1700 (LWP 63486)):
#0 0x00007fa20f1e703f in pthread_
#1 0x00007fa20cce5b25 in wait (this=0x7fa1fc0
#2 galera:
#3 0x00007fa20cce078a in galera:
#4 0x00007fa20ccf4074 in galera_
#5 0x000000000068369b in wsrep_TOI_begin (table_
#6 wsrep_to_
#7 0x00000000005a1d08 in mysql_execute_
#8 0x00000000005a6de1 in mysql_parse (thd=thd@
#9 0x00000000005a7a53 in wsrep_mysql_parse (thd=thd@
#10 0x00000000005a8a29 in dispatch_command (command=
#11 0x00000000005aa934 in do_command (thd=0x38e97b0) at /media/
#12 0x00000000006582da in do_handle_
#13 0x000000000065850e in handle_
#14 0x00007fa20f1e30a2 in start_thread () from /usr/lib/
#15 0x00007fa20da46a2d in clone () from /usr/lib/libc.so.6
=======
So, as can be seen, the transaction is not waiting for permissions but is instead waiting on TOI.
Related branches
Changed in percona-xtradb-cluster: | |
status: | Fix Committed → Fix Released |
Added.
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =====
LIST OF TRANSACTIONS FOR EACH SESSION: innodb_ compressed_ int` innodb_ compressed_ int_autoinc` innodb_ compressed_ int` WHERE `col_varchar_ latin1_ key` = 168 ORDER BY `col_bigint` ,`col_bigint_ key`,`col_ char_12_ latin1` ,`col_char_ 12_latin1_ key`,`col_ char_12_ utf8`,` col_char_ 12_utf8_ key`,`c ol_int` ,`col_int_ key`,`col_ varchar_ latin1` ,`col_varchar_ latin1_ key`,`col_ varchar_ utf8`,` col_varchar_ utf8_key` ,`pk` LIMIT 1 innodb_ compressed_ key_pk_ parts_2_ char` innodb_ default_ key_pk_ parts_2_ char` innodb_ default_ int_autoinc` WHERE `col_int_key` IN ( 'g' , 3398041600 , 5 , 89 , 160 ) ORDER BY `col_bigint` ,`col_bigint_ key`,`col_ char_12_ latin1` ,`col_char_ 12_latin1_ key`,`col_ char_12_ utf 8`,`col_ char_12_ utf8_key` ,`col_int` ,`col_int_ key`,`col_ varchar_ latin1` ,`col_varchar_ latin1_ key`,`col_ varchar_ utf8`,` col_varchar_ utf8_key` ,`pk` LIMIT 1 `table1000_ innodb_ default_ int_autoinc` trx id AF4 lock mode IX
---TRANSACTION 0, not started
MySQL thread id 30, OS thread handle 0x7fe36c6bd700, query id 3120 localhost root sleeping
show engine innodb status
---TRANSACTION A98, not started
MySQL thread id 26, OS thread handle 0x7fe36c6fe700, query id 2999 localhost 127.0.0.1 root Waiting for table metadata lock
DROP TABLE `table100_
---TRANSACTION ADA, not started
MySQL thread id 25, OS thread handle 0x7fe36c73f700, query id 3018 localhost 127.0.0.1 root Preparing for TO isolation
DROP TABLE IF EXISTS s
---TRANSACTION AA1, not started
MySQL thread id 23, OS thread handle 0x7fe3701e2700, query id 2963 localhost 127.0.0.1 root Preparing for TO isolation
DROP TABLE `table100_
---TRANSACTION ADD, not started
MySQL thread id 20, OS thread handle 0x7fe3702a5700, query id 3020 localhost 127.0.0.1 root Waiting for table metadata lock
DELETE FROM `table100_
---TRANSACTION AA8, not started
MySQL thread id 19, OS thread handle 0x7fe3702e6700, query id 3066 localhost 127.0.0.1 root Preparing for TO isolation
ALTER TABLE q RENAME `table1_
---TRANSACTION A87, not started
MySQL thread id 13, OS thread handle 0x7fe3881d4700, query id 3010 localhost 127.0.0.1 root Preparing for TO isolation
CREATE TABLE x LIKE `table1_
---TRANSACTION AF4, ACTIVE 318 sec
mysql tables in use 1, locked 1
8 lock struct(s), heap size 1248, 51 row lock(s), undo log entries 1
MySQL thread id 16, OS thread handle 0x7fe38804f700, query id 3105 localhost 127.0.0.1 root wsrep in pre-commit stage
DELETE FROM `table1000_
TABLE LOCK table `test`.
====== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =