[MDEV-10551] Test innodb.defrag_mdl-9155 hangs on InnoDB 5.7 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.2
Component/s: Storage Engine - InnoDB
Labels:
None

Attachments

Issue Links

is part of

MDEV-10024 Fix test failures on InnoDB 5.7 in MariaDB 10.2

Closed

Activity

Ascending order - Click to sort in descending order

Jan Lindström (Inactive) created issue - 2016-08-12 08:14

Jan Lindström (Inactive) made changes - 2016-08-12 08:14

Field	Original Value	New Value
Link		This issue is part of ~~MDEV-10024~~ [ ~~MDEV-10024~~ ]

Jan Lindström (Inactive) added a comment - 2016-08-12 08:50

In MDL wait:

Thread 27 (Thread 0x7fffde85d300 (LWP 6747)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x00005555563c627c in safe_cond_timedwait (cond=0x7fff98000ca8, mp=0x7fff98000bf8, abstime=0x7fffde85a840, file=0x555556470be0 "/home/jan/mysql/10.2/include/mysql/psi/mysql_thread.h", line=1175) at /home/jan/mysql/10.2/mysys/thr_mutex.c:545

#2  0x0000555555b99b84 in inline_mysql_cond_timedwait (that=0x7fff98000ca8, mutex=0x7fff98000bf8, abstime=0x7fffde85a840, src_file=0x555556470eb8 "/home/jan/mysql/10.2/sql/mdl.cc", src_line=1083) at /home/jan/mysql/10.2/include/mysql/psi/mysql_thread.h:1175

#3  0x0000555555b9ae2b in MDL_wait::timed_wait (this=0x7fff98000bf8, owner=0x7fff98000bb0, abs_timeout=0x7fffde85a840, set_status_on_timeout=false, wait_state_name=0x555556c5fc50 <MDL_key::m_namespace_to_wait_state_name+48>) at /home/jan/mysql/10.2/sql/mdl.cc:1083

#4  0x0000555555b9c007 in MDL_context::acquire_lock (this=0x7fff98000bf8, mdl_request=0x7fff9801d3a8, lock_wait_timeout=31536000) at /home/jan/mysql/10.2/sql/mdl.cc:2057

#5  0x0000555555b9c499 in MDL_context::acquire_locks (this=0x7fff98000bf8, mdl_requests=0x7fffde85a980, lock_wait_timeout=31536000) at /home/jan/mysql/10.2/sql/mdl.cc:2177

#6  0x00005555559f1c86 in lock_table_names (thd=0x7fff98000b00, options=..., tables_start=0x7fff9801cf78, tables_end=0x0, lock_wait_timeout=31536000, flags=0) at /home/jan/mysql/10.2/sql/sql_base.cc:3658

#7  0x00005555559f219c in open_tables (thd=0x7fff98000b00, options=..., start=0x7fffde85acb8, counter=0x7fffde85acd4, flags=0, prelocking_strategy=0x7fffde85ad50) at /home/jan/mysql/10.2/sql/sql_base.cc:3871

#8  0x00005555559f33f8 in open_and_lock_tables (thd=0x7fff98000b00, options=..., tables=0x7fff9801cf78, derived=true, flags=0, prelocking_strategy=0x7fffde85ad50) at /home/jan/mysql/10.2/sql/sql_base.cc:4567

#9  0x00005555559e8828 in open_and_lock_tables (thd=0x7fff98000b00, tables=0x7fff9801cf78, derived=true, flags=0) at /home/jan/mysql/10.2/sql/sql_base.h:497

#10 0x0000555555ba0412 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fff98000b00, tables=0x7fff9801cf78, check_opt=0x7fff980053f0, operator_name=0x5555564725e0 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x555555c9784e <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /home/jan/mysql/10.2/sql/sql_admin.cc:468

#11 0x0000555555ba34cc in Sql_cmd_optimize_table::execute (this=0x7fff9801d578, thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_admin.cc:1299

#12 0x0000555555a5f110 in mysql_execute_command (thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:6082

#13 0x0000555555a6311e in mysql_parse (thd=0x7fff98000b00, rawbuf=0x7fff9801cea8 "optimize table t1", length=17, parser_state=0x7fffde85c240, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:7742

#14 0x0000555555a53b5d in dispatch_command (command=COM_QUERY, thd=0x7fff98000b00, packet=0x7fff981936e1 "", packet_length=17, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:1790

#15 0x0000555555a52acc in do_command (thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:1353

#16 0x0000555555b9042a in do_handle_one_connection (connect=0x555557e118f0) at /home/jan/mysql/10.2/sql/sql_connect.cc:1354

#17 0x0000555555b901b8 in handle_one_connection (arg=0x555557e118f0) at /home/jan/mysql/10.2/sql/sql_connect.cc:1260

#18 0x0000555555e88c38 in pfs_spawn_thread (arg=0x555557d61b90) at /home/jan/mysql/10.2/storage/perfschema/pfs.cc:1862

#19 0x00007ffff68856fa in start_thread (arg=0x7fffde85d300) at pthread_create.c:333

#20 0x00007ffff5452b5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Jan Lindström (Inactive) added a comment - 2016-08-12 08:50 In MDL wait: Thread 27 (Thread 0x7fffde85d300 (LWP 6747)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005555563c627c in safe_cond_timedwait (cond=0x7fff98000ca8, mp=0x7fff98000bf8, abstime=0x7fffde85a840, file=0x555556470be0 "/home/jan/mysql/10.2/include/mysql/psi/mysql_thread.h", line=1175) at /home/jan/mysql/10.2/mysys/thr_mutex.c:545 #2 0x0000555555b99b84 in inline_mysql_cond_timedwait (that=0x7fff98000ca8, mutex=0x7fff98000bf8, abstime=0x7fffde85a840, src_file=0x555556470eb8 "/home/jan/mysql/10.2/sql/mdl.cc", src_line=1083) at /home/jan/mysql/10.2/include/mysql/psi/mysql_thread.h:1175 #3 0x0000555555b9ae2b in MDL_wait::timed_wait (this=0x7fff98000bf8, owner=0x7fff98000bb0, abs_timeout=0x7fffde85a840, set_status_on_timeout=false, wait_state_name=0x555556c5fc50 <MDL_key::m_namespace_to_wait_state_name+48>) at /home/jan/mysql/10.2/sql/mdl.cc:1083 #4 0x0000555555b9c007 in MDL_context::acquire_lock (this=0x7fff98000bf8, mdl_request=0x7fff9801d3a8, lock_wait_timeout=31536000) at /home/jan/mysql/10.2/sql/mdl.cc:2057 #5 0x0000555555b9c499 in MDL_context::acquire_locks (this=0x7fff98000bf8, mdl_requests=0x7fffde85a980, lock_wait_timeout=31536000) at /home/jan/mysql/10.2/sql/mdl.cc:2177 #6 0x00005555559f1c86 in lock_table_names (thd=0x7fff98000b00, options=..., tables_start=0x7fff9801cf78, tables_end=0x0, lock_wait_timeout=31536000, flags=0) at /home/jan/mysql/10.2/sql/sql_base.cc:3658 #7 0x00005555559f219c in open_tables (thd=0x7fff98000b00, options=..., start=0x7fffde85acb8, counter=0x7fffde85acd4, flags=0, prelocking_strategy=0x7fffde85ad50) at /home/jan/mysql/10.2/sql/sql_base.cc:3871 #8 0x00005555559f33f8 in open_and_lock_tables (thd=0x7fff98000b00, options=..., tables=0x7fff9801cf78, derived=true, flags=0, prelocking_strategy=0x7fffde85ad50) at /home/jan/mysql/10.2/sql/sql_base.cc:4567 #9 0x00005555559e8828 in open_and_lock_tables (thd=0x7fff98000b00, tables=0x7fff9801cf78, derived=true, flags=0) at /home/jan/mysql/10.2/sql/sql_base.h:497 #10 0x0000555555ba0412 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fff98000b00, tables=0x7fff9801cf78, check_opt=0x7fff980053f0, operator_name=0x5555564725e0 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x555555c9784e <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /home/jan/mysql/10.2/sql/sql_admin.cc:468 #11 0x0000555555ba34cc in Sql_cmd_optimize_table::execute (this=0x7fff9801d578, thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_admin.cc:1299 #12 0x0000555555a5f110 in mysql_execute_command (thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:6082 #13 0x0000555555a6311e in mysql_parse (thd=0x7fff98000b00, rawbuf=0x7fff9801cea8 "optimize table t1", length=17, parser_state=0x7fffde85c240, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:7742 #14 0x0000555555a53b5d in dispatch_command (command=COM_QUERY, thd=0x7fff98000b00, packet=0x7fff981936e1 "", packet_length=17, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:1790 #15 0x0000555555a52acc in do_command (thd=0x7fff98000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:1353 #16 0x0000555555b9042a in do_handle_one_connection (connect=0x555557e118f0) at /home/jan/mysql/10.2/sql/sql_connect.cc:1354 #17 0x0000555555b901b8 in handle_one_connection (arg=0x555557e118f0) at /home/jan/mysql/10.2/sql/sql_connect.cc:1260 #18 0x0000555555e88c38 in pfs_spawn_thread (arg=0x555557d61b90) at /home/jan/mysql/10.2/storage/perfschema/pfs.cc:1862 #19 0x00007ffff68856fa in start_thread (arg=0x7fffde85d300) at pthread_create.c:333 #20 0x00007ffff5452b5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Jan Lindström (Inactive) made changes - 2016-08-12 08:50

Assignee

Jan Lindström [ jplindst ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2016-09-08 15:18

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2016-09-08 16:10

Fix Version/s		10.2.2 [ 22013 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:43

Workflow

MariaDB v3 [ 76645 ]

MariaDB v4 [ 150754 ]

People

Assignee:: Sergei Golubchik

Reporter:: Jan Lindström (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-08-12 08:14

Updated:: 2016-09-08 16:10

Resolved:: 2016-09-08 16:10

Git Integration

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

MariaDB Server