|
susmeet.khaire, to the latest logs
there are a number of threads waiting for an MDL lock. There must be actually no replication specifics. What is the MDL lock and its holder
need identifying.
The waiters include a replication thread, which is responsible for waiting status of other replication threads
Thread 10 (Thread 0x7f9490178700 (LWP 28410)):
|
#0 0x00007f94975abde2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#1 0x000055bf114665e2 in inline_mysql_cond_timedwait (src_file=0x55bf11b68620 "/home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.37/sql/mdl.cc", src_line=1094, abstime=0x7f94901770b0, mutex=0x7f8058000a10, that=0x7f8058000a40) at /usr/src/debug/MariaDB-10.3.37/src_0/include/mysql/psi/mysql_thread.h:1222
|
result = <optimized out>
|
#2 MDL_wait::timed_wait (this=this@entry=0x7f8058000a10, owner=0x7f80580009a0, abs_timeout=abs_timeout@entry=0x7f94901770b0, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=<optimized out>) at /usr/src/debug/MariaDB-10.3.37/src_0/sql/mdl.cc:1094
|
old_stage = {m_key = 0, m_name = 0x55bf11b4af26 "Opening tables", m_flags = 1476397584}
|
result = <optimized out>
|
wait_result = 0
|
#3 0x000055bf11467ba1 in MDL_context::acquire_lock (this=this@entry=0x7f8058000a10, mdl_request=mdl_request@entry=0x7f80589dc788, lock_wait_timeout=<optimized out>) at /usr/src/debug/MariaDB-10.3.37/src_0/sql/mdl.cc:2148
|
...
|
#13 0x000055bf114a562b in handle_rpl_parallel_thread (arg=<optimized out>) at /usr/src/debug/MariaDB-10.3.37/src_0/sql/rpl_parallel.cc:1335
|
|
as well as normal user threads:
Thread 9 (Thread 0x7f94800c6700 (LWP 29014)):
|
#0 0x00007f94975abde2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#1 0x000055bf114665e2 in inline_mysql_cond_timedwait (src_file=0x55bf11b68620 "/home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.37/sql/mdl.cc", src_line=1094, abstime=0x7f94800c1640, mutex=0x7f7f40000af0, that=0x7f7f40000b20) at /usr/src/debug/MariaDB-10.3.37/src_0/include/mysql/psi/mysql_thread.h:1222
|
result = <optimized out>
|
#2 MDL_wait::timed_wait (this=this@entry=0x7f7f40000af0, owner=0x7f7f40000a80, abs_timeout=abs_timeout@entry=0x7f948
|
|
|
Thread 8 (Thread 0x7f80fc774700 (LWP 17426)):
|
#0 0x00007f94975abde2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#1 0x000055bf114665e2 in inline_mysql_cond_timedwait (src_file=0x55bf11b68620 "/home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.37/sql/mdl.cc", src_line=1094, abstime=0x7f80fc76f640, mutex=0x7f7eec000af0, that=0x7f7eec000b20) at /usr/src/debug/MariaDB-10.3.37/src_0/include/mysql/psi/mysql_thread.h:1222
|
result = <optimized out>
|
#2 MDL_wait::timed_wait (this=this@entry=0x7f7eec000af0, owner=0x7f7eec000a80, abs_timeout=abs_timeout@entry=0x7f80fc76f640, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=<optimized out>) at /usr/src/debug/MariaDB-10.3.37/src_0/sql/mdl.cc:1094
|
|
Thread 5 (Thread 0x7f810408c700 (LWP 368)):
|
#0 0x00007f94975abde2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
Thread 3 (Thread 0x7f94801ce700 (LWP 30162)):
|
Thread 2 (Thread 0x7f80fc62a700 (LWP 10272)):
|
|
|