[MDEV-7370] Server deadlocks on renaming a table for which persistent statistics exists - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.0(EOL)
Fix Version/s: 10.0.23
Component/s: Optimizer
Labels:
- eits

Description

With the following test case, server hangs seemingly forever on RENAME TABLE. Reducing lock_wait_timeout does not help. Happens both with MyISAM and InnoDB. If persistent statistics is not collected, there is no hang up. Reproducible on debug and release builds.

create database db1;

create database db2;

use db1;

create table t1 (i int);

analyze table t1 persistent for all;

rename table t1 to db2.t1;

# Cleanup

drop database db1;

drop database db2;

Stack trace from 10.0 revno 4543 on the hanging server
#0 __pthread_getspecific (key=3) at pthread_getspecific.c:32
#1 0x0000000000e49570 in my_thread_var_dbug () at 10.0/mysys/my_thr_init.c:432
#2 0x0000000000e65dd8 in code_state () at 10.0/dbug/dbug.c:350
#3 0x0000000000e682ba in _db_pargs_ (_line_=409, keyword=0x1129515 "mutex") at 10.0/dbug/dbug.c:1228
#4 0x0000000000e50314 in safe_mutex_unlock (mp=0x7f42bf81fd28, file=0x1124638 "10.0/mysys/mf_keycache.c", line=2879) at 10.0/mysys/thr_mutex.c:409
#5 0x0000000000e2c6d9 in inline_mysql_mutex_unlock (that=0x7f42bf81fd28, src_file=0x1124638 "10.0/mysys/mf_keycache.c", src_line=2879) at 10.0/include/mysql/p
si/mysql_thread.h:761
#6 0x0000000000e30c48 in simple_key_cache_read (keycache=0x7f42bf81fc70, file=61, filepos=6144, level=3, buff=0x7f42b86b9cb0 "", length=1024, block_length=3072, return_buffer=1) at /home/elens
t/bzr/10.0/mysys/mf_keycache.c:2879
#7 0x0000000000e34d0f in key_cache_read (keycache=0x7f42bf827270, file=61, filepos=4096, level=3, buff=0x7f42b86b94b0 "", length=3072, block_length=3072, return_buffer=1) at 1
0.0/mysys/mf_keycache.c:6211
#8 0x0000000000dd9943 in _mi_fetch_keypage (info=0x7f42b86b9070, keyinfo=0x7f42b84a0e70, page=4096, level=3, buff=0x7f42b86b94b0 "", return_buffer=1) at 10.0/storage/myisam/mi
_page.c:32
#9 0x0000000000ddd20d in _mi_search (info=0x7f42b86b9070, keyinfo=0x7f42b84a0e70, key=0x7f42b86bb15e "\003db1\002t1\001i", key_len=7, nextflag=1, pos=4096) at 10.0/storage/myisam/mi_search.c:85
#10 0x0000000000dfcdc1 in mi_rkey (info=0x7f42b86b9070, buf=0x7f42b8622088 "\337\003db1\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\002t1\217\217\217"..., inx=0, key=0x7f42c2299d80 "\003", keypart_map=3, search_flag=HA_READ_KEY_EXACT) at 10.0/storage/myisam/mi_rkey.c:99
#11 0x0000000000da7112 in ha_myisam::index_read_idx_map (this=0x7f42b847f088, buf=0x7f42b8622088 "\337\003db1\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\002t1\217\217\217"..., index=0, key=0x7f42c2299d80 "\003", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at 10.0/storage/myisam/ha_myisam.cc:1743
#12 0x000000000086e45c in handler::ha_index_read_idx_map (this=0x7f42b847f088, buf=0x7f42b8622088 "\337\003db1\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\217\002t1\217\217\217"..., index=0, key=0x7f42c2299d80 "\003", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at 10.0/sql/handler.cc:2614
#13 0x00000000007164be in Stat_table::find_next_stat_for_prefix (this=0x7f42c229aac0, prefix_parts=2) at 10.0/sql/sql_statistics.cc:493
#14 0x00000000007146bf in rename_table_in_stat_tables (thd=0x7f42baf2f070, db=0x7f42c229be00, tab=0x7f42c229bdf0, new_db=0x7f42c229be00, new_tab=0x7f42c229bde0) at 10.0/sql/sql_statistics.cc:3294
#15 0x00000000006a0267 in do_rename (thd=0x7f42baf2f070, ren_table=0x7f42b84141a0, new_db=0x7f42b8414160 "db2", new_table_name=0x7f42b8414168 "t1", new_table_alias=0x7f42b8414780 "t1", skip_error=false) at 10.0/sql/sql_rename.cc:283
#16 0x00000000006a0461 in rename_tables (thd=0x7f42baf2f070, table_list=0x7f42b84141a0, skip_error=false) at 10.0/sql/sql_rename.cc:358
#17 0x000000000069fe39 in mysql_rename_tables (thd=0x7f42baf2f070, table_list=0x7f42b84141a0, silent=false) at 10.0/sql/sql_rename.cc:153
#18 0x00000000006836b4 in execute_rename_table (thd=0x7f42baf2f070, first_table=0x7f42b84141a0, all_tables=0x7f42b84141a0) at 10.0/sql/sql_parse.cc:5331
#19 0x000000000067cd8c in mysql_execute_command (thd=0x7f42baf2f070) at 10.0/sql/sql_parse.cc:3172
#20 0x00000000006859bd in mysql_parse (thd=0x7f42baf2f070, rawbuf=0x7f42b8414088 "rename table t1 to db2.t1", length=25, parser_state=0x7f42c229d610) at 10.0/sql/sql_parse.cc:6407
#21 0x00000000006787b2 in dispatch_command (command=COM_QUERY, thd=0x7f42baf2f070, packet=0x7f42bbff6071 "rename table t1 to db2.t1", packet_length=25) at 10.0/sql/sql_parse.cc:1299
#22 0x0000000000677b57 in do_command (thd=0x7f42baf2f070) at 10.0/sql/sql_parse.cc:996

Attachments

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Elena Stepanova

Votes:: 3 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2014-12-25 00:47

Updated:: 2015-11-19 00:06

Resolved:: 2015-11-18 20:35

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.