Error: a record lock wait happens in a dictionary operation, index `CLUST_IND` of table `SYS_STATS`
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.5 |
Triaged
|
High
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
InnoDB: Error: a record lock wait happens in a dictionary operation!
InnoDB: index `CLUST_IND` of table `SYS_STATS`.
InnoDB: Submit a detailed bug report to http://
InnoDB: Assertion failure in thread 139707405539088 in file lock0lock.c line 1803
InnoDB: Failing assertion: 0
#5 0x00007f10385f7ee6 in abort () from /lib64/libc.so.6
#6 0x0000000000ac3359 in lock_rec_
index=
at Percona-
#7 0x0000000000ac3c28 in lock_rec_lock_slow (impl=0, mode=3, block=0x7f102fc
index=
at Percona-
#8 0x0000000000ac3ead in lock_rec_lock (impl=0, mode=3, block=0x7f102fc
index=
at Percona-
#9 0x0000000000acac5f in lock_clust_
rec=
thr=
at Percona-
#10 0x00000000009b5699 in sel_set_rec_lock (block=
index=
at Percona-
#11 0x00000000009b64f5 in row_sel (node=0x7f10180
at Percona-
#12 0x00000000009b71e0 in row_sel_step (thr=0x7f101802
at Percona-
#13 0x0000000000b10a4f in que_thr_step (thr=0x7f101802
at Percona-
#14 0x0000000000b10d83 in que_run_threads_low (thr=0x7f101802
at Percona-
#15 0x0000000000b10e97 in que_run_threads (thr=0x7f101802
at Percona-
#16 0x0000000000b110c7 in que_eval_sql (info=0x7f10180
sql=0xce8a90 "PROCEDURE DROP_TABLE_PROC () IS\nsys_foreign_id CHAR;\ntable_id CHAR;\nindex_id CHAR;\nforeign_id CHAR;\nfound INT;\nDECLARE CURSOR cur_fk IS\nSELECT ID FROM SYS_FOREIGN\nWHERE FOR_NAME = :table_name\nAND TO_B"..., reserve_
at Percona-
#17 0x00000000009a8cf5 in row_drop_
trx=
at Percona-
#18 0x000000000097a119 in ha_innobase:
name=0x1bd5ee0 "Percona-
at Percona-
#19 0x0000000000771856 in handler:
name=0x1bd5ee0 "Percona-
at Percona-
#20 0x00000000005bcd82 in rm_temporary_table (base=0x1355570,
path=0x1bd5ee0 "Percona-
at Percona-
#21 0x00000000005b6446 in close_temporary (table=0x1bd52d0, free_share=true, delete_table=true)
at Percona-
#22 0x00000000005b633b in close_temporary
delete_
#23 0x00000000006948a1 in mysql_alter_table (thd=0x1cb6550, new_db=0x1cc6190 "test",
new_
alter_
at Percona-
#24 0x00000000008ad103 in Alter_table_
at Percona-
#25 0x000000000060e93a in mysql_execute_
at Percona-
#26 0x0000000000611468 in mysql_parse (thd=0x1cb6550,
rawbuf=
parser_
#27 0x00000000006055ae in dispatch_command (command=COM_QUERY, thd=0x1cb6550,
packet=
at Percona-
#28 0x00000000006048a7 in do_command (thd=0x1cb6550)
at Percona-
#29 0x00000000006e7bce in do_handle_
at Percona-
#30 0x00000000006e768c in handle_
at Percona-
#31 0x00007f10398ffa4f in start_thread () from /lib64/
#32 0x00007f103869482d in clone () from /lib64/libc.so.6
~percona-
bzr version-info
revision-id: <email address hidden>
date: 2012-10-31 17:45:42 +0100
revno: 344
RQG grammar:
thread2_init:
CREATE TABLE t1 (i INT) ENGINE=InnoDB ; CREATE TEMPORARY TABLE t1 (i INT, KEY(i)) SELECT 1 AS i; ALTER TABLE t1 ADD COLUMN f1 INT DEFAULT 1 ;
thread1:
OPTIMIZE TABLE t1 | ANALYZE TABLE t1 ;
query:
ALTER TABLE t1 CHANGE COLUMN f1 f1 INT DEFAULT 2 ;
# End of RQG grammar
RQG command line:
perl runall.pl --threads=6 --duration=600 --queries=100M --mysqld=
Changed in percona-server: | |
importance: | Undecided → High |
status: | Confirmed → Triaged |
tags: | added: xtradb |
I was able to repeat this (from the error log):
121107 10:52:44 InnoDB: Error: a record lock wait happens in a dictionary operation! bugs.mysql. com mysql_thread
InnoDB: index `CLUST_IND` of table `SYS_STATS`.
InnoDB: Submit a detailed bug report to http://
121107 10:52:44 InnoDB: Error: dict X latch held in srv_suspend_