Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.6.18, 10.6.21, 10.6.22
-
None
-
None
Description
A server is crashing periodically and the stack traces all share last two calls:
/usr/sbin/mysqld(ha_maria::drop_table(char const*)
|
/usr/sbin/mysqld(free_tmp_table(THD*, TABLE*)
|
....
|
...
|
.
|
The rest of the stack is different but seems to indicate it's always related to a temporary table.
/usr/sbin/mysqld(ha_maria::drop_table(char const*)+0x18)[0x55bce17420d8]
|
/usr/sbin/mysqld(free_tmp_table(THD*, TABLE*)+0xd7)[0x55bce13687a7]
|
/usr/sbin/mysqld(Create_tmp_table::cleanup_on_failure(THD*, TABLE*)+0x20)[0x55bce1368ca0]
|
/usr/sbin/mysqld(create_tmp_table_for_schema(THD*, TMP_TABLE_PARAM*, st_schema_table const&, long long, st_mysql_const_lex_string const&, bool, bool)+0xd1)[0x55bce136a0d1]
|
/usr/sbin/mysqld(create_schema_table(THD*, TABLE_LIST*)+0x12f)[0x55bce13a8ecf]
|
/usr/sbin/mysqld(mysql_schema_table(THD*, LEX*, TABLE_LIST*)+0x26)[0x55bce13a8fa6]
|
/usr/sbin/mysqld(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)+0x3ec)[0x55bce12ac92c]
|
/usr/sbin/mysqld(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*)+0x39)[0x55bce12adbf9]
|
/usr/sbin/mysqld(+0x7df97d)[0x55bce131397d]
|
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x451a)[0x55bce132222a]
|
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x1e7)[0x55bce130d6f7]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool)+0xf05)[0x55bce131a915]
|
/usr/sbin/mysqld(do_command(THD*, bool)+0x149)[0x55bce131ce89]
|
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*, bool)+0x385)[0x55bce1439815]
|
/usr/sbin/mysqld(handle_one_connection+0x5d)[0x55bce1439b6d]
|
/usr/sbin/mysqld(+0xca0b8d)[0x55bce17d4b8d]
|
2025-04-18 18:20:30 0 [Warning] /usr/sbin/mysqld: Thread 710739766 (user : 'gatekeeperadmin20200604') did not exit
|
/usr/sbin/mysqld(ha_maria::drop_table(char const*)+0x18)[0x55b6438330d8]
|
/usr/sbin/mysqld(free_tmp_table(THD*, TABLE*)+0xd7)[0x55b6434597a7]
|
/usr/sbin/mysqld(JOIN::cleanup(bool)+0x1ff)[0x55b64347393f]
|
/usr/sbin/mysqld(JOIN::join_free()+0x187)[0x55b643473fe7]
|
/usr/sbin/mysqld(JOIN::exec_inner()+0xe9e)[0x55b64347d28e]
|
/usr/sbin/mysqld(JOIN::exec()+0x3b)[0x55b64347d6cb]
|
/usr/sbin/mysqld(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x10a)[0x55b64347b86a]
|
/usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x157)[0x55b64347c017]
|
/usr/sbin/mysqld(+0x7df9d1)[0x55b6434049d1]
|
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x451a)[0x55b64341322a]
|
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x1e7)[0x55b6433fe6f7]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool)+0xf05)[0x55b64340b915]
|
/usr/sbin/mysqld(do_command(THD*, bool)+0x149)[0x55b64340de89]
|
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*, bool)+0x385)[0x55b64352a815]
|
/usr/sbin/mysqld(handle_one_connection+0x5d)[0x55b64352ab6d]
|
/usr/sbin/mysqld(+0xca0b8d)[0x55b6438c5b8d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609)[0x7f7908e70609]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f7908a41353]
|
/usr/sbin/mysqld(ha_maria::drop_table(char const*)+0x18)[0x5646d2f590d8]
|
/usr/sbin/mysqld(free_tmp_table(THD*, TABLE*)+0xd7)[0x5646d2b7f7a7]
|
/usr/sbin/mysqld(Create_tmp_table::cleanup_on_failure(THD*, TABLE*)+0x20)[0x5646d2b7fca0]
|
/usr/sbin/mysqld(create_tmp_table_for_schema(THD*, TMP_TABLE_PARAM*, st_schema_table const&, long long, st_mysql_const_lex_string const&, bool, bool)+0xd1)[0x5646d2b810d1]
|
/usr/sbin/mysqld(create_schema_table(THD*, TABLE_LIST*)+0x12f)[0x5646d2bbfecf]
|
/usr/sbin/mysqld(mysql_schema_table(THD*, LEX*, TABLE_LIST*)+0x26)[0x5646d2bbffa6]
|
/usr/sbin/mysqld(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)+0x3ec)[0x5646d2ac392c]
|
/usr/sbin/mysqld(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*)+0x39)[0x5646d2ac4bf9]
|
/usr/sbin/mysqld(+0x7df97d)[0x5646d2b2a97d]
|
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x451a)[0x5646d2b3922a]
|
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x1e7)[0x5646d2b246f7]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool)+0xf05)[0x5646d2b31915]
|
/usr/sbin/mysqld(do_command(THD*, bool)+0x149)[0x5646d2b33e89]
|
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*, bool)+0x385)[0x5646d2c50815]
|
/usr/sbin/mysqld(handle_one_connection+0x5d)[0x5646d2c50b6d]
|
/usr/sbin/mysqld(+0xca0b8d)[0x5646d2febb8d]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609)[0x7fe2bfa86609]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fe2bf657353]
|
|
I'm failing to find an existing bug report for this.