[#MDEV-15508] [Draft] Possible deadlock, InnoDB: Error: Waited for 140 secs for hash index ref

https://api.travis-ci.org/v3/job/350408953/log.txt

It happened in undo log upgrade scenario (from previous 10.1), but already after upgrade, during presumably normal operation of the new server.

vardir: var-mdev15508.tar.gz at ftp://ftp.askmonty.org/public/jira/

10.1 8ef727b3d072c13788553f2174fd8bd70481f658
InnoDB: Error: Waited for 5 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 10 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 15 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 20 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 25 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 30 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 35 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 40 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 45 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 50 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 55 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 60 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 65 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 70 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 75 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 80 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 85 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 90 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 95 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 100 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 105 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 110 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 115 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 120 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 125 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 130 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 135 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"
InnoDB: Error: Waited for 140 secs for hash index ref_count (1) to drop to 0.
index: "PRIMARY" table: "test/#sql-ib135-1138019654"

Status information:

Current dir: /home/travis/logs/current1_1/data/
Running threads: 5 Stack size: 295936
Current locks:
lock: 0x7fb54c082630:

lock: 0x7fb54c0988a0: read
read : 0x7fb54c08e980 (8:2);

lock: 0x7fb544047bd0:

lock: 0x7fb54404a880:

lock: 0x7fb5500cee60:

lock: 0x7fb5401374f0:

lock: 0x7fb544054200:

lock: 0x7fb54c01baa0:

lock: 0x7fb544030ad0:

lock: 0x7fb54c0789d0:

lock: 0x7fb54c0711a0:

lock: 0x7fb54c056250: read
read : 0x7fb54c060d00 (9:2);

lock: 0x7fb544027c30:

lock: 0x7fb54c034100:

lock: 0x7fb54c029260:

lock: 0x7fb54401ead0:

lock: 0x7fb5409be890:

lock: 0x7fb5409b75e0:

lock: 0x7fb5409b0330:

lock: 0x7fb5409a90a0:

lock: 0x7fb540989e60:

lock: 0x7fb5409833e0:

lock: 0x7fb54095bf90:

lock: 0x7fb540938940:

lock: 0x7fb5408f4a70:

lock: 0x7fb5408e6530:

lock: 0x7fb5408d7fd0:

lock: 0x7fb5408d0cb0:

lock: 0x7fb5408c99b0:

lock: 0x7fb5408c26b0:

lock: 0x7fb54089b280:

lock: 0x7fb54088d550:

lock: 0x7fb540886af0:

lock: 0x7fb54087f840:

lock: 0x7fb540878590:

lock: 0x7fb540871330:

lock: 0x7fb54086a970:

lock: 0x7fb54083bbc0:

lock: 0x7fb540835240:

lock: 0x7fb5405a9040:

lock: 0x7fb5405a5f10:

lock: 0x7fb5405a1620:

lock: 0x7fb54059cc90:

lock: 0x7fb5405984a0:

lock: 0x7fb5405942d0:

lock: 0x7fb540571b40:

lock: 0x7fb54055f4a0:

lock: 0x7fb540554f40:

lock: 0x7fb540551440:

lock: 0x7fb540546a30:

lock: 0x7fb5405204b0:

lock: 0x7fb5405189c0:

lock: 0x7fb540511830:

lock: 0x7fb5403be4b0:

lock: 0x7fb5403fce90:

lock: 0x7fb54035be80:

lock: 0x7fb540113cd0:

lock: 0x7fb5400cec50:

lock: 0x7fb54004e8e0:

lock: 0x7fb5400292b0:

lock: 0x7fb54001d5e0:

lock: 0x7fb540011550:

lock: 0x7fb52400fcc0:

lock: 0x3b0e0c0:

lock: 0x3af5900:

lock: 0x3adecd0:

lock: 0x3ad6490:

lock: 0x3aaa010:

lock: 0x3a9dff0:

lock: 0x3a92f30:

lock: 0x3a85770:

lock: 0x3a67900:

lock: 0x37e1540:

lock: 0x21ab740:

lock: 0x21ab5e0:

lock: 0x21a9d20:

lock: 0x21a9bc0:

lock: 0x21a9a60:

lock: 0x21a9fe0:

lock: 0x21a7120:

lock: 0x21ab480:

lock: 0x21a7c20:

lock: 0x21a8040:

lock: 0x21a7ac0:

lock: 0x21a7ee0:

lock: 0x21a7960:

lock: 0x21a7d80:

lock: 0x21a8880:

lock: 0x21a8720:

lock: 0x21a85c0:

lock: 0x21a7800:

lock: 0x21a73e0:

lock: 0x21a76a0:

lock: 0x21a7280:

lock: 0x21a7540:

lock: 0x21a8460:

lock: 0x21a8300:

lock: 0x21a81a0:

lock: 0x21aaf00:

lock: 0x21ab320:

lock: 0x21ab1c0:

lock: 0x21ab060:

lock: 0x21aa980:

lock: 0x21aa820:

lock: 0x21aa6c0:

lock: 0x21aa560:

lock: 0x21aa400:

lock: 0x21aac40:

lock: 0x21aa2a0:

lock: 0x21aa140:

lock: 0x21aaae0:

lock: 0x21a9e80:

lock: 0x21a97a0:

lock: 0x21a9900:

lock: 0x21a9640:

lock: 0x21a94e0:

lock: 0x21a8f60:

lock: 0x21a9380:

lock: 0x21a9220:

lock: 0x21a8e00:

lock: 0x21a90c0:

lock: 0x21a8ca0:

lock: 0x21a8b40:

lock: 0x21a89e0:

lock: 0x21aada0:

DB Table Version Thread Open Lock
test t027 1 8 1 Read lock without concurrent inserts
test t006 1 0 1 Not in use
test t006 1 0 1 Not in use
mysql servers 1 0 1 Not in use
test t015 1 0 1 Not in use
test t002 1 0 1 Not in use
test t002 1 0 1 Not in use
performance_sc events_stages_history_long 1 0 1 Not in use
test t4 1 0 1 Not in use
performance_sc host_cache 1 0 1 Not in use
mysql procs_priv 1 0 1 Not in use
test t004 1 0 1 Not in use
mysql table_stats 1 0 1 Not in use
mysql index_stats 1 0 1 Not in use
test t008 1 0 1 Not in use
test t023 1 0 1 Not in use
mysql plugin 1 0 1 Not in use
performance_sc events_stages_summary_by_account_by_event_name 1 0 1 Not in use
test t035 1 0 1 Not in use
performance_sc performance_timers 1 0 1 Not in use
test t8 1 0 1 Not in use
performance_sc events_statements_summary_global_by_event_name 1 0 1 Not in use
test t003 1 0 1 Not in use
mysql time_zone_transition 1 0 1 Not in use
performance_sc socket_summary_by_instance 1 0 1 Not in use
mysql time_zone_leap_second 1 0 1 Not in use
performance_sc events_statements_summary_by_account_by_event_name 1 0 1 Not in use
test t007 1 0 1 Not in use
performance_sc socket_instances 1 0 1 Not in use
performance_sc rwlock_instances 1 0 1 Not in use
test t025 1 0 1 Not in use
test t2 1 0 1 Not in use
performance_sc events_statements_history_long 1 0 1 Not in use
test t021 1 0 1 Not in use
test t009 1 0 1 Not in use
test t009 1 0 1 Not in use
performance_sc accounts 1 0 1 Not in use
performance_sc objects_summary_global_by_type 1 0 1 Not in use
performance_sc events_stages_summary_global_by_event_name 1 0 1 Not in use
performance_sc events_waits_summary_by_user_by_event_name 1 0 1 Not in use
test t001 1 0 1 Not in use
performance_sc events_waits_summary_by_host_by_event_name 1 0 1 Not in use
test t005 1 0 1 Not in use
test t029 1 9 1 Read lock without concurrent inserts
performance_sc file_summary_by_event_name 1 0 1 Not in use
test t031 1 0 1 Not in use
test t011 1 0 1 Not in use
test t6 1 0 1 Not in use
performance_sc setup_timers 1 0 1 Not in use
mysql time_zone 1 0 1 Not in use
test t3 1 0 1 Not in use
performance_sc setup_actors 1 0 1 Not in use
mysql help_category 1 0 1 Not in use
performance_sc events_waits_history 1 0 1 Not in use
test t020 1 0 1 Not in use
mysql host 1 0 1 Not in use
mysql general_log 1 0 1 Not in use
test t017 1 0 1 Not in use
performance_sc events_waits_summary_by_instance 1 0 1 Not in use
mysql user 1 0 1 Not in use
test t9 1 0 1 Not in use
performance_sc events_waits_current 1 0 1 Not in use
mysql roles_mapping 1 0 1 Not in use
mysql time_zone_transition_type 1 0 1 Not in use
test t013 1 0 1 Not in use
performance_sc events_statements_summary_by_digest 1 0 1 Not in use
mysql proxies_priv 1 0 1 Not in use
mysql event 1 0 1 Not in use
test t1 1 0 1 Not in use
test t022 1 0 1 Not in use
test t022 1 0 1 Not in use
performance_sc cond_instances 1 0 1 Not in use
performance_sc file_instances 1 0 1 Not in use
test t033 1 0 1 Not in use
performance_sc events_waits_summary_by_thread_by_event_name 1 0 1 Not in use
performance_sc file_summary_by_instance 1 0 1 Not in use
mysql columns_priv 1 0 1 Not in use
test t026 1 0 1 Not in use
test t026 1 0 1 Not in use
performance_sc socket_summary_by_event_name 1 0 1 Not in use
test t5 1 0 1 Not in use
performance_sc events_waits_summary_global_by_event_name 1 0 1 Not in use
test t018 1 0 1 Not in use
test t036 1 0 1 Not in use
performance_sc events_stages_current 1 0 1 Not in use
mysql proc 1 0 1 Not in use
mysql help_keyword 1 0 1 Not in use
mysql func 1 0 1 Not in use
performance_sc events_statements_summary_by_thread_by_event_name 1 0 1 Not in use
performance_sc table_lock_waits_summary_by_table 1 0 1 Not in use
test t010 1 0 1 Not in use
mysql time_zone_name 1 0 1 Not in use
performance_sc threads 1 0 1 Not in use
mysql db 1 0 1 Not in use
performance_sc mutex_instances 1 0 1 Not in use
test t032 1 0 1 Not in use
performance_sc table_io_waits_summary_by_index_usage 1 0 1 Not in use
performance_sc events_statements_current 1 0 1 Not in use
mysql slow_log 1 0 1 Not in use
performance_sc setup_consumers 1 0 1 Not in use
performance_sc events_stages_summary_by_thread_by_event_name 1 0 1 Not in use
performance_sc events_waits_summary_by_account_by_event_name 1 0 1 Not in use
test t014 1 0 1 Not in use
mysql column_stats 1 0 1 Not in use
performance_sc events_waits_history_long 1 0 1 Not in use
test t012 1 0 1 Not in use
performance_sc table_io_waits_summary_by_table 1 0 1 Not in use
performance_sc events_statements_summary_by_host_by_event_name 1 0 1 Not in use
performance_sc events_statements_summary_by_user_by_event_name 1 0 1 Not in use
mysql help_topic 1 0 1 Not in use
test t030 1 0 1 Not in use
performance_sc events_statements_history 1 0 1 Not in use
mysql help_relation 1 0 1 Not in use
performance_sc events_stages_history 1 0 1 Not in use
mysql tables_priv 1 0 1 Not in use
performance_sc setup_objects 1 0 1 Not in use
performance_sc session_connect_attrs 1 0 1 Not in use
test t016 1 0 1 Not in use
test t034 1 0 1 Not in use
performance_sc events_stages_summary_by_user_by_event_name 1 0 1 Not in use
performance_sc events_stages_summary_by_host_by_event_name 1 0 1 Not in use
performance_sc session_account_connect_attrs 1 0 1 Not in use
mysql gtid_slave_pos 1 0 1 Not in use
mysql innodb_table_stats 1 0 1 Not in use
mysql innodb_index_stats 1 0 1 Not in use
performance_sc users 1 0 1 Not in use
performance_sc hosts 1 0 1 Not in use
performance_sc setup_instruments 1 0 1 Not in use

Current refresh version: 1

Key caches:
default
Buffer_size: 134217728
Block_size: 1024
Division_limit: 100
Age_threshold: 300
Partitions: 0
blocks used: 1
not flushed: 0
w_requests: 0
writes: 0
r_requests: 2
reads: 1


handler status:
read_key: 231
read_next: 14497
read_rnd 46
read_first: 53
write: 15147
delete 0
update: 0

Table status:
Opened tables: 335
Open tables: 128
Open files: 60
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Thread database.table_name Locked/Waiting Lock_type

8 test.t027 Locked - read Read lock without concurrent inserts
9 test.t029 Locked - read Read lock without concurrent inserts




Memory status:
Non-mmapped space allocated from system: 9347072
Number of free chunks: 201
Number of fastbin blocks: 0
Number of mmapped regions: 12
Space in mmapped regions: 304832512
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 5767200
Total free space: 3579872
Top-most, releasable space: 2496848
Estimated memory (with thread stack): 315659264



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:140
LUA : init_queue:150
WOC : NO
Next activation : never
180307 21:39:00 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.1.32-MariaDB-debug
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=6
max_threads=153
thread_count=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467268 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48400
maria/ma_close.c:113(maria_close)[0xf3aaad]
/home/travis/server/bin/mysqld(handle_fatal_signal+0x38f)[0x8e1059]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7fb58c45ecb0]
/lib/x86_64-linux-gnu/libc.so.6(__poll+0x53)[0x7fb58bb7c913]
/home/travis/server/bin/mysqld(_Z26handle_connections_socketsv+0x398)[0x5da1bb]
/home/travis/server/bin/mysqld(_Z11mysqld_mainiPPc+0xaed)[0x5d912f]
/home/travis/server/bin/mysqld(main+0x20)[0x5ce164]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7fb58bab37ed]
/home/travis/server/bin/mysqld[0x5ce089]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file

Selected threads which are doing something
Thread 30 (Thread 0x7fb588069b00 (LWP 25780)):
#0 0x00007fb58c45ad84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1 0x0000000000c5c967 in os_cond_wait (cond=0x3c63eb0, fast_mutex=0x3c63e78) at /home/travis/src/storage/xtradb/os/os0sync.cc:196
#2 0x0000000000c5cca1 in os_event_wait_low (event=0x3c63e78, reset_sig_count=110) at /home/travis/src/storage/xtradb/os/os0sync.cc:477
#3 0x0000000000d261b5 in sync_array_wait_event (arr=0x36d44d0, index=6) at /home/travis/src/storage/xtradb/sync/sync0arr.cc:474
#4 0x0000000000d2c405 in mutex_spin_wait (_mutex=0x3c63e78, high_priority=false, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567) at /home/travis/src/storage/xtradb/sync/sync0sync.cc:689
#5 0x0000000000de786f in mutex_enter_func (mutex=0x3c63e78, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:331
#6 0x0000000000de79eb in pfs_mutex_enter_func (mutex=0x3c63e78, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:415
#7 0x0000000000debdf0 in dict_table_close (table=0x7fb5240192b8, dict_locked=0, try_drop=1) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:567
#8 0x0000000000ccd7aa in row_prebuilt_free (prebuilt=0x7fb54054c0e8, dict_locked=0) at /home/travis/src/storage/xtradb/row/row0mysql.cc:959
#9 0x0000000000bbb0a5 in ha_innobase::close (this=0x7fb540548d98) at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:6809
#10 0x00000000008e78a9 in handler::ha_close (this=0x7fb540548d98) at /home/travis/src/sql/handler.cc:2596
#11 0x0000000000791b89 in closefrm (table=0x7fb540545900, free_share=true) at /home/travis/src/sql/table.cc:3058
#12 0x00000000006355c7 in intern_close_table (table=0x7fb540545900) at /home/travis/src/sql/sql_base.cc:354
#13 0x00000000008689a2 in tc_purge (mark_flushed=true) at /home/travis/src/sql/table_cache.cc:204
#14 0x00000000006359eb in close_cached_tables (thd=0x0, tables=0x0, wait_for_refresh=false, timeout=31536000) at /home/travis/src/sql/sql_base.cc:485
#15 0x000000000080cc39 in reload_acl_and_cache (thd=0x0, options=2147499823, tables=0x0, write_to_binlog=0x7fb588069290) at /home/travis/src/sql/sql_reload.cc:334
#16 0x00000000005d476b in signal_hand (arg=0x0) at /home/travis/src/sql/mysqld.cc:3451
#17 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#18 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6
#19 0x0000000000000000 in ?? ()

Thread 28 (Thread 0x7fb574446b00 (LWP 25808)):

#0  0x00007fb58bb81633 in select () from /lib/x86_64-linux-gnu/libc.so.6

#1  0x0000000000c5d585 in os_thread_sleep (tm=10000) at /home/travis/src/storage/xtradb/os/os0thread.cc:307

#2  0x0000000000df12b8 in dict_index_remove_from_cache_low (table=0x7fb540206d68, index=0x7fb540211d48, lru_evict=0) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2736

#3  0x0000000000defe89 in dict_table_remove_from_cache_low (table=0x7fb540206d68, lru_evict=0) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2089

#4  0x0000000000df0341 in dict_table_remove_from_cache (table=0x7fb540206d68) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2147

#5  0x0000000000cd4114 in row_drop_table_for_mysql (name=0x7fb5400ebc40 "test/#sql-ib135-1138019654", trx=0x7fb540054de8, drop_db=false, create_failed=0, nonatomic=false) at /home/travis/src/storage/xtradb/row/row0mysql.cc:4414

#6  0x0000000000cc4b3b in row_merge_drop_table (trx=0x7fb540054de8, table=0x7fb540206d68) at /home/travis/src/storage/xtradb/row/row0merge.cc:3822

#7  0x0000000000bea292 in ha_innobase::commit_inplace_alter_table (this=0x7fb54c08e548, altered_table=0x7fb5400bb700, ha_alter_info=0x7fb574442980, commit=true) at /home/travis/src/storage/xtradb/handler/handler0alter.cc:6321

#8  0x00000000008eb915 in handler::ha_commit_inplace_alter_table (this=0x7fb54c08e548, altered_table=0x7fb5400bb700, ha_alter_info=0x7fb574442980, commit=true) at /home/travis/src/sql/handler.cc:4220

#9  0x0000000000763072 in mysql_inplace_alter_table (thd=0x3d342f0, table_list=0x7fb540005450, table=0x7fb54c0884c0, altered_table=0x7fb5400bb700, ha_alter_info=0x7fb574442980, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fb574443f50, alter_ctx=0x7fb574442ab0) at /home/travis/src/sql/sql_table.cc:7198

#10 0x0000000000767939 in mysql_alter_table (thd=0x3d342f0, new_db=0x7fb540005a40 "test", new_name=0x0, create_info=0x7fb574444180, table_list=0x7fb540005450, alter_info=0x7fb5744442b0, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9024

#11 0x00000000007d8d2a in Sql_cmd_alter_table::execute (this=0x7fb540005a48, thd=0x3d342f0) at /home/travis/src/sql/sql_alter.cc:325

#12 0x00000000006ab4e6 in mysql_execute_command (thd=0x3d342f0) at /home/travis/src/sql/sql_parse.cc:5682

#13 0x00000000006afa68 in mysql_parse (thd=0x3d342f0, rawbuf=0x7fb540005318 "ALTER TABLE `t027` ROW_FORMAT=REDUNDANT /* QNO 1330 CON_ID 8 */", length=63, parser_state=0x7fb5744454e0) at /home/travis/src/sql/sql_parse.cc:7352

#14 0x000000000069e64b in dispatch_command (command=COM_QUERY, thd=0x3d342f0, packet=0x3d3d421 "ALTER TABLE `t027` ROW_FORMAT=REDUNDANT /* QNO 1330 CON_ID 8 */ ", packet_length=64) at /home/travis/src/sql/sql_parse.cc:1477

#15 0x000000000069d3ba in do_command (thd=0x3d342f0) at /home/travis/src/sql/sql_parse.cc:1106

#16 0x00000000007d4496 in do_handle_one_connection (thd_arg=0x3d342f0) at /home/travis/src/sql/sql_connect.cc:1330

#17 0x00000000007d41e7 in handle_one_connection (arg=0x3d342f0) at /home/travis/src/sql/sql_connect.cc:1242

#18 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#19 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6

#20 0x0000000000000000 in ?? ()

Thread 26 (Thread 0x7fb5743fcb00 (LWP 25810)):

#0  0x00007fb58c45ad84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0

#1  0x0000000000c5c967 in os_cond_wait (cond=0x3c63eb0, fast_mutex=0x3c63e78) at /home/travis/src/storage/xtradb/os/os0sync.cc:196

#2  0x0000000000c5cca1 in os_event_wait_low (event=0x3c63e78, reset_sig_count=110) at /home/travis/src/storage/xtradb/os/os0sync.cc:477

#3  0x0000000000d261b5 in sync_array_wait_event (arr=0x36d44d0, index=1) at /home/travis/src/storage/xtradb/sync/sync0arr.cc:474

#4  0x0000000000d2c405 in mutex_spin_wait (_mutex=0x3c63e78, high_priority=false, file_name=0x11a3918 "/home/travis/src/storage/xtradb/dict/dict0stats.cc", line=833) at /home/travis/src/storage/xtradb/sync/sync0sync.cc:689

#5  0x0000000000e0bfbd in mutex_enter_func (mutex=0x3c63e78, file_name=0x11a3918 "/home/travis/src/storage/xtradb/dict/dict0stats.cc", line=833, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:331

#6  0x0000000000e0c07e in pfs_mutex_enter_func (mutex=0x3c63e78, file_name=0x11a3918 "/home/travis/src/storage/xtradb/dict/dict0stats.cc", line=833, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:415

#7  0x0000000000e10aee in dict_stats_snapshot_create (table=0x7fb54407f538) at /home/travis/src/storage/xtradb/dict/dict0stats.cc:833

#8  0x0000000000e13a30 in dict_stats_save (table_orig=0x7fb54407f538, only_for_index=0x0) at /home/travis/src/storage/xtradb/dict/dict0stats.cc:2527

#9  0x0000000000e15432 in dict_stats_update (table=0x7fb54407f538, stats_upd_option=DICT_STATS_RECALC_PERSISTENT) at /home/travis/src/storage/xtradb/dict/dict0stats.cc:3303

#10 0x0000000000be8591 in alter_stats_rebuild (table=0x7fb54407f538, table_name=0x7fb54c05605d "t029", thd=0x3d47ef0) at /home/travis/src/storage/xtradb/handler/handler0alter.cc:5703

#11 0x0000000000bea5ba in ha_innobase::commit_inplace_alter_table (this=0x7fb54c0608c8, altered_table=0x7fb5440699d0, ha_alter_info=0x7fb5743f8980, commit=true) at /home/travis/src/storage/xtradb/handler/handler0alter.cc:6367

#12 0x00000000008eb915 in handler::ha_commit_inplace_alter_table (this=0x7fb54c0608c8, altered_table=0x7fb5440699d0, ha_alter_info=0x7fb5743f8980, commit=true) at /home/travis/src/sql/handler.cc:4220

#13 0x0000000000763072 in mysql_inplace_alter_table (thd=0x3d47ef0, table_list=0x7fb544005470, table=0x7fb54c05fc80, altered_table=0x7fb5440699d0, ha_alter_info=0x7fb5743f8980, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fb5743f9f50, alter_ctx=0x7fb5743f8ab0) at /home/travis/src/sql/sql_table.cc:7198

#14 0x0000000000767939 in mysql_alter_table (thd=0x3d47ef0, new_db=0x7fb544005a60 "test", new_name=0x0, create_info=0x7fb5743fa180, table_list=0x7fb544005470, alter_info=0x7fb5743fa2b0, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9024

#15 0x00000000007d8d2a in Sql_cmd_alter_table::execute (this=0x7fb544005a70, thd=0x3d47ef0) at /home/travis/src/sql/sql_alter.cc:325

#16 0x00000000006ab4e6 in mysql_execute_command (thd=0x3d47ef0) at /home/travis/src/sql/sql_parse.cc:5682

#17 0x00000000006afa68 in mysql_parse (thd=0x3d47ef0, rawbuf=0x7fb544005328 "ALTER TABLE `t029` FORCE, ALGORITHM=INPLACE /* QNO 1315 CON_ID 9 */", length=67, parser_state=0x7fb5743fb4e0) at /home/travis/src/sql/sql_parse.cc:7352

#18 0x000000000069e64b in dispatch_command (command=COM_QUERY, thd=0x3d47ef0, packet=0x3b27dc1 "ALTER TABLE `t029` FORCE, ALGORITHM=INPLACE /* QNO 1315 CON_ID 9 */ ", packet_length=68) at /home/travis/src/sql/sql_parse.cc:1477

#19 0x000000000069d3ba in do_command (thd=0x3d47ef0) at /home/travis/src/sql/sql_parse.cc:1106

#20 0x00000000007d4496 in do_handle_one_connection (thd_arg=0x3d47ef0) at /home/travis/src/sql/sql_connect.cc:1330

#21 0x00000000007d41e7 in handle_one_connection (arg=0x3d47ef0) at /home/travis/src/sql/sql_connect.cc:1242

#22 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#23 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6

#24 0x0000000000000000 in ?? ()

Thread 24 (Thread 0x7fb5743b2b00 (LWP 25814)):

#0  0x00007fb58c45ad84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0

#1  0x0000000000c5c967 in os_cond_wait (cond=0x3c63eb0, fast_mutex=0x3c63e78) at /home/travis/src/storage/xtradb/os/os0sync.cc:196

#2  0x0000000000c5cca1 in os_event_wait_low (event=0x3c63e78, reset_sig_count=110) at /home/travis/src/storage/xtradb/os/os0sync.cc:477

#3  0x0000000000d261b5 in sync_array_wait_event (arr=0x36d44d0, index=3) at /home/travis/src/storage/xtradb/sync/sync0arr.cc:474

#4  0x0000000000d2c405 in mutex_spin_wait (_mutex=0x3c63e78, high_priority=false, file_name=0x1151180 "/home/travis/src/storage/xtradb/que/que0que.cc", line=1278) at /home/travis/src/storage/xtradb/sync/sync0sync.cc:689

#5  0x0000000000c880a2 in mutex_enter_func (mutex=0x3c63e78, file_name=0x1151180 "/home/travis/src/storage/xtradb/que/que0que.cc", line=1278, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:331

#6  0x0000000000c8821e in pfs_mutex_enter_func (mutex=0x3c63e78, file_name=0x1151180 "/home/travis/src/storage/xtradb/que/que0que.cc", line=1278, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:415

#7  0x0000000000c8aca2 in que_eval_sql (info=0x7fb54c05e0d8, sql=0x11a4908 "PROCEDURE FETCH_STATS () IS\nfound INT;\nDECLARE FUNCTION fetch_table_stats_step;\nDECLARE FUNCTION fetch_index_stats_step;\nDECLARE CURSOR table_stats_cur IS\n  SELECT\n  n_rows,\n  clustered_index_size,\n  "..., reserve_dict_mutex=1, trx=0x7fb54c062198) at /home/travis/src/storage/xtradb/que/que0que.cc:1278

#8  0x0000000000e14f97 in dict_stats_fetch_from_ps (table=0x7fb54c03c838) at /home/travis/src/storage/xtradb/dict/dict0stats.cc:3163

#9  0x0000000000e1567c in dict_stats_update (table=0x7fb54c089e68, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at /home/travis/src/storage/xtradb/dict/dict0stats.cc:3390

#10 0x0000000000bb2cfe in dict_stats_init (table=0x7fb54c089e68) at /home/travis/src/storage/xtradb/include/dict0stats.ic:174

#11 0x0000000000bba617 in ha_innobase::open (this=0x7fb54c05acd8, name=0x7fb54c058ad8 "./test/t028", mode=2, test_if_locked=18) at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:6518

#12 0x00000000008e74c4 in handler::ha_open (this=0x7fb54c05acd8, table_arg=0x7fb54c05a090, name=0x7fb54c058ad8 "./test/t028", mode=2, test_if_locked=18) at /home/travis/src/sql/handler.cc:2531

#13 0x0000000000791801 in open_table_from_share (thd=0x3b374b0, share=0x7fb54c0585f8, alias=0x7fb54c005898 "t028", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fb54c05a090, is_create_table=false) at /home/travis/src/sql/table.cc:2970

#14 0x0000000000639b53 in open_table (thd=0x3b374b0, table_list=0x7fb54c0058a0, ot_ctx=0x7fb5743b0560) at /home/travis/src/sql/sql_base.cc:2553

#15 0x000000000063c39d in open_and_process_table (thd=0x3b374b0, lex=0x3b3aef0, tables=0x7fb54c0058a0, counter=0x7fb5743b06ac, flags=0, prelocking_strategy=0x7fb5743b06f0, has_prelocking_list=false, ot_ctx=0x7fb5743b0560) at /home/travis/src/sql/sql_base.cc:4068

#16 0x000000000063d3eb in open_tables (thd=0x3b374b0, options=..., start=0x7fb5743b0658, counter=0x7fb5743b06ac, flags=0, prelocking_strategy=0x7fb5743b06f0) at /home/travis/src/sql/sql_base.cc:4579

#17 0x000000000063e6ef in open_and_lock_tables (thd=0x3b374b0, options=..., tables=0x7fb54c0058a0, derived=true, flags=0, prelocking_strategy=0x7fb5743b06f0) at /home/travis/src/sql/sql_base.cc:5259

#18 0x0000000000632197 in open_and_lock_tables (thd=0x3b374b0, tables=0x7fb54c0058a0, derived=true, flags=0) at /home/travis/src/sql/sql_base.h:535

#19 0x000000000067fb0d in mysql_insert (thd=0x3b374b0, table_list=0x7fb54c0058a0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at /home/travis/src/sql/sql_insert.cc:749

#20 0x00000000006a4f80 in mysql_execute_command (thd=0x3b374b0) at /home/travis/src/sql/sql_parse.cc:3915

#21 0x00000000006afa68 in mysql_parse (thd=0x3b374b0, rawbuf=0x7fb54c005718 "INSERT IGNORE INTO `t028` ( `pk`, `col_varchar_8_key` ) VALUES ( NULL, 'y' )  /* QNO 1278 CON_ID 11 */", length=102, parser_state=0x7fb5743b14e0) at /home/travis/src/sql/sql_parse.cc:7352

#22 0x000000000069e64b in dispatch_command (command=COM_QUERY, thd=0x3b374b0, packet=0x3b3cb31 " INSERT IGNORE INTO `t028` ( `pk`, `col_varchar_8_key` ) VALUES ( NULL, 'y' )  /* QNO 1278 CON_ID 11 */ ", packet_length=104) at /home/travis/src/sql/sql_parse.cc:1477

#23 0x000000000069d3ba in do_command (thd=0x3b374b0) at /home/travis/src/sql/sql_parse.cc:1106

#24 0x00000000007d4496 in do_handle_one_connection (thd_arg=0x3b374b0) at /home/travis/src/sql/sql_connect.cc:1330

#25 0x00000000007d41e7 in handle_one_connection (arg=0x3b374b0) at /home/travis/src/sql/sql_connect.cc:1242

#26 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#27 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6

#28 0x0000000000000000 in ?? ()

Thread 21 (Thread 0x7fb5740b2b00 (LWP 25812)):

#0  0x00007fb58c45ad84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0

#1  0x0000000000c5c967 in os_cond_wait (cond=0x3c63eb0, fast_mutex=0x3c63e78) at /home/travis/src/storage/xtradb/os/os0sync.cc:196

#2  0x0000000000c5cca1 in os_event_wait_low (event=0x3c63e78, reset_sig_count=110) at /home/travis/src/storage/xtradb/os/os0sync.cc:477

#3  0x0000000000d261b5 in sync_array_wait_event (arr=0x36d44d0, index=2) at /home/travis/src/storage/xtradb/sync/sync0arr.cc:474

#4  0x0000000000d2c405 in mutex_spin_wait (_mutex=0x3c63e78, high_priority=false, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567) at /home/travis/src/storage/xtradb/sync/sync0sync.cc:689

#5  0x0000000000de786f in mutex_enter_func (mutex=0x3c63e78, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:331

#6  0x0000000000de79eb in pfs_mutex_enter_func (mutex=0x3c63e78, file_name=0x119d268 "/home/travis/src/storage/xtradb/dict/dict0dict.cc", line=567, priority=IB_DEFAULT_PRIO) at /home/travis/src/storage/xtradb/include/sync0sync.ic:415

#7  0x0000000000debdf0 in dict_table_close (table=0x7fb5500af6b8, dict_locked=0, try_drop=1) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:567

#8  0x0000000000ccd7aa in row_prebuilt_free (prebuilt=0x7fb544047e08, dict_locked=0) at /home/travis/src/storage/xtradb/row/row0mysql.cc:959

#9  0x0000000000bbb0a5 in ha_innobase::close (this=0x7fb54406c478) at /home/travis/src/storage/xtradb/handler/ha_innodb.cc:6809

#10 0x00000000008e78a9 in handler::ha_close (this=0x7fb54406c478) at /home/travis/src/sql/handler.cc:2596

#11 0x0000000000791b89 in closefrm (table=0x7fb544059560, free_share=true) at /home/travis/src/sql/table.cc:3058

#12 0x00000000006355c7 in intern_close_table (table=0x7fb544059560) at /home/travis/src/sql/sql_base.cc:354

#13 0x0000000000868f35 in tc_release_table (table=0x7fb544059560) at /home/travis/src/sql/table_cache.cc:360

#14 0x0000000000636cd5 in close_thread_table (thd=0x3b2be50, table_ptr=0x3b2bf18) at /home/travis/src/sql/sql_base.cc:1089

#15 0x000000000063649e in close_open_tables (thd=0x3b2be50) at /home/travis/src/sql/sql_base.cc:812

#16 0x0000000000636a60 in close_thread_tables (thd=0x3b2be50) at /home/travis/src/sql/sql_base.cc:1036

#17 0x00000000007e71a2 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=0x3b2be50, tables=0x7fb5500043b0, check_opt=0x3b307a0, operator_name=0x101d418 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x8eb4cc <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0) at /home/travis/src/sql/sql_admin.cc:1119

#18 0x00000000007e7b8c in Sql_cmd_optimize_table::execute (this=0x7fb5500049a8, thd=0x3b2be50) at /home/travis/src/sql/sql_admin.cc:1306

#19 0x00000000006ab4e6 in mysql_execute_command (thd=0x3b2be50) at /home/travis/src/sql/sql_parse.cc:5682

#20 0x00000000006afa68 in mysql_parse (thd=0x3b2be50, rawbuf=0x7fb550004298 "OPTIMIZE TABLE `t019` /* QNO 1219 CON_ID 10 */", length=46, parser_state=0x7fb5740b14e0) at /home/travis/src/sql/sql_parse.cc:7352

#21 0x000000000069e64b in dispatch_command (command=COM_QUERY, thd=0x3b2be50, packet=0x3b33421 "", packet_length=47) at /home/travis/src/sql/sql_parse.cc:1477

#22 0x000000000069d3ba in do_command (thd=0x3b2be50) at /home/travis/src/sql/sql_parse.cc:1106

#23 0x00000000007d4496 in do_handle_one_connection (thd_arg=0x3b2be50) at /home/travis/src/sql/sql_connect.cc:1330

#24 0x00000000007d41e7 in handle_one_connection (arg=0x3b2be50) at /home/travis/src/sql/sql_connect.cc:1242

#25 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#26 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6

#27 0x0000000000000000 in ?? ()

Thread 10 (Thread 0x7fb55affd700 (LWP 25771)):

#0  0x00007fb58c45ad84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0

#1  0x0000000000c5c967 in os_cond_wait (cond=0x21ede18, fast_mutex=0x21edde0) at /home/travis/src/storage/xtradb/os/os0sync.cc:196

#2  0x0000000000c5cca1 in os_event_wait_low (event=0x21edde0, reset_sig_count=311) at /home/travis/src/storage/xtradb/os/os0sync.cc:477

#3  0x0000000000d261b5 in sync_array_wait_event (arr=0x36d44d0, index=0) at /home/travis/src/storage/xtradb/sync/sync0arr.cc:474

#4  0x0000000000d29c6b in rw_lock_s_lock_spin (_lock=0x21eddc0, pass=0, priority_lock=false, high_priority=false, file_name=0x1165dd0 "/home/travis/src/storage/xtradb/row/row0purge.cc", line=772) at /home/travis/src/storage/xtradb/sync/sync0rw.cc:551

#5  0x0000000000ce77c6 in rw_lock_s_lock_func (lock=0x21eddc0, pass=0, file_name=0x1165dd0 "/home/travis/src/storage/xtradb/row/row0purge.cc", line=772) at /home/travis/src/storage/xtradb/include/sync0rw.ic:432

#6  0x0000000000ce7c56 in pfs_rw_lock_s_lock_func (lock=0x21eddc0, pass=0, file_name=0x1165dd0 "/home/travis/src/storage/xtradb/row/row0purge.cc", line=772) at /home/travis/src/storage/xtradb/include/sync0rw.ic:1060

#7  0x0000000000ceb518 in row_purge_parse_undo_rec (node=0x3d2ce78, undo_rec=0x7fb5500635f0 "\210\217\016\025\002", updated_extern=0x7fb55affccde, thr=0x3c593c0) at /home/travis/src/storage/xtradb/row/row0purge.cc:772

#8  0x0000000000ceb9a6 in row_purge (node=0x3d2ce78, undo_rec=0x7fb5500635f0 "\210\217\016\025\002", thr=0x3c593c0) at /home/travis/src/storage/xtradb/row/row0purge.cc:913

#9  0x0000000000cebc00 in row_purge_step (thr=0x3c593c0) at /home/travis/src/storage/xtradb/row/row0purge.cc:996

#10 0x0000000000c8a661 in que_thr_step (thr=0x3c593c0) at /home/travis/src/storage/xtradb/que/que0que.cc:1089

#11 0x0000000000c8a862 in que_run_threads_low (thr=0x3c593c0) at /home/travis/src/storage/xtradb/que/que0que.cc:1151

#12 0x0000000000c8a9f4 in que_run_threads (thr=0x3c593c0) at /home/travis/src/storage/xtradb/que/que0que.cc:1192

#13 0x0000000000d39e53 in trx_purge (n_purge_threads=1, batch_size=300, truncate=false) at /home/travis/src/storage/xtradb/trx/trx0purge.cc:1228

#14 0x0000000000d1da10 in srv_do_purge (n_threads=1, n_total_purged=0x7fb55affce70) at /home/travis/src/storage/xtradb/srv/srv0srv.cc:3444

#15 0x0000000000d1dfc4 in srv_purge_coordinator_thread (arg=0x0) at /home/travis/src/storage/xtradb/srv/srv0srv.cc:3594

#16 0x00007fb58c456e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#17 0x00007fb58bb882ed in clone () from /lib/x86_64-linux-gnu/libc.so.6

#18 0x0000000000000000 in ?? ()

[MDEV-15508] [Draft] Possible deadlock, InnoDB: Error: Waited for 140 secs for hash index ref_count (1) to drop to 0 Created: 2018-03-07 Updated: 2020-08-25 Resolved: 2018-05-29
Status:	Closed
Project:	MariaDB Server
Component/s:	Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s:	10.1, 10.1.31
Fix Version/s:	10.1.34, 10.2.16, 10.3.8

[MDEV-15508] [Draft] Possible deadlock, InnoDB: Error: Waited for 140 secs for hash index ref_count (1) to drop to 0 Created: 2018-03-07 Updated: 2020-08-25 Resolved: 2018-05-29