Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Description
Debug discussion with Thiru. Seen in bb-10.10-MDEV-28883, but likely unrelated as per discussions with Thiru. Core+mysqld+libs+error log sent via drive/email.
10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug) |
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000153a4b571859 in __GI_abort () at abort.c:79
|
#2 0x000055eb6d644864 in safe_mutex_destroy (mp=mp@entry=0x1539c84caf50,
|
file=file@entry=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", line=line@entry=274)
|
at /test/bb-10.10-MDEV-28883_dbg/mysys/thr_mutex.c:602
|
#3 0x000055eb6d57deef in inline_mysql_mutex_destroy (src_line=274,
|
src_file=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", that=0x1539c84caf50)
|
at /test/bb-10.10-MDEV-28883_dbg/include/mysql/psi/mysql_thread.h:724
|
#4 fts_cache_destroy (cache=0x1539c84caf50) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:274
|
#5 0x000055eb6d5828f0 in fts_t::~fts_t (this=0x1539c8201250, __in_chrg=<optimized out>)
|
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5080
|
#6 0x000055eb6d58295c in fts_free (table=table@entry=0x1539c84c5790)
|
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5117
|
#7 0x000055eb6d5147f5 in dict_sys_t::remove (this=this@entry=0x55eb6e05c940 <dict_sys>, table=0x1539c84c5790,
|
lru=lru@entry=false, keep=keep@entry=false) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:1957
|
#8 0x000055eb6d514cfb in dict_sys_t::close (this=0x55eb6e05c940 <dict_sys>)
|
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:4592
|
#9 0x000055eb6d4025f3 in innodb_shutdown () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/srv/srv0start.cc:1765
|
#10 0x000055eb6d1fd64c in innobase_end () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/handler/ha_innodb.cc:4310
|
#11 0x000055eb6cefdff9 in ha_finalize_handlerton (plugin=0x55eb6fecc900) at /test/bb-10.10-MDEV-28883_dbg/sql/handler.cc:596
|
#12 0x000055eb6cc3354a in plugin_deinitialize (plugin=0x55eb6fecc900, ref_check=ref_check@entry=true)
|
at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1269
|
#13 0x000055eb6cc3742b in reap_plugins () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1343
|
#14 0x000055eb6cc37f0e in plugin_shutdown () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:2051
|
#15 0x000055eb6cadd2b0 in clean_up (print_message=print_message@entry=true) at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:1987
|
#16 0x000055eb6cae966c in mysqld_main (argc=<optimized out>, argv=<optimized out>)
|
at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:5937
|
#17 0x000055eb6cadcb66 in main (argc=<optimized out>, argv=<optimized out>) at /test/bb-10.10-MDEV-28883_dbg/sql/main.cc:34
|
10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug) |
2022-07-02 5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) while getting next doc id for table `test`.`articles`
|
2022-07-02 5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) during SYNC of table `test`.`articles`
|
2022-07-02 5:06:35 0 [Note] InnoDB: FTS optimize thread exiting.
|
2022-07-02 5:06:35 0 [Note] InnoDB: Starting shutdown...
|
safe_mutex: Found wrong usage of mutex 'cache->lock' and 'LOCK_global_system_variables'
|
Mutex currently locked (in reverse order):
|
LOCK_global_system_variables /test/bb-10.10-MDEV-28883_dbg/storage/innobase/buf/buf0dump.cc line 182
|
cache->lock /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc line 4077
|
2022-07-02 5:06:35 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/130567/9332/data/ib_buffer_pool
|
2022-07-02 5:06:35 0 [Note] InnoDB: Buffer pool(s) dump completed at 220702 5:06:35
|
safe_mutex: Trying to destroy a mutex cache->lock that was locked at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 4077 at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 274
|
Attachments
Issue Links
- duplicates
-
MDEV-29342 Assertion failure in file que0que.cc line 728
- Closed
- relates to
-
MDEV-29277 On error, fts_sync_table() fails to release a table handle
- Closed