Sirious problem in latest MySQL version 8.0.22 that was pulled by portage a few days ago. Problem causes server to crash when firing triggers. As a result my server was down, I had to mask mysql-8.0.22, build previous version and restore db backups, because mysql does not support downgrade. That was a little bit pain. I extremely recommend to mask mysql 8.0.22 in portage directory globally to prevent it pulling buggy version that can cause server to be down. Here is a topic on stack about this issue: https://stackoverflow.com/questions/64440469/mysql-server-restarts-after-trigger-execution There are some reports about this problem to Oracle but all of them are hidden and I have no idea about progress of its fix, ex: https://bugs.mysql.com/bug.php?id=101257 Also there are reports that Percona has same problem, maybe it should be masked too: https://jira.percona.com/browse/PS-7477 mysql logs: 13:16:24 UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f2c08000d10 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 = 7f2cb4514d00 thread_stack 0x46000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x5626abaaa3bd] /usr/sbin/mysqld(handle_fatal_signal+0x31b) [0x5626aa9281fb] /lib64/libpthread.so.0(+0x12cd0) [0x7f2ccdc83cd0] /usr/sbin/mysqld(Item_splocal::this_item()+0x14) [0x5626aaa4f454] /usr/sbin/mysqld(Item_sp_variable::is_null()+0xe) [0x5626aaa4f41e] /usr/sbin/mysqld(Item_func_isnull::val_int()+0x21) [0x5626aaa74981] /usr/sbin/mysqld(Item::val_bool()+0xd6) [0x5626aaa54946] /usr/sbin/mysqld(sp_instr_jump_if_not::exec_core/usr/sbin/mysqld(fill_record_n_invoke_before_triggers(THD*, COPY_INFO*, mem_root_deque<Item*> const&, mem_root_deque<Item*> const&, TABLE*, enum_trigger_event_type, int, bool, bool*)+0x1d4) [0x5626aa777044] /usr/sbin/mysqld(Sql_cmd_update::update_single_table(THD*)+0xff5) [0x5626aa8bbc65] /usr/sbin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xc5) [0x5626aa8bd005] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x510) [0x5626aa848b70] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f9) [0x5626aa7ece99] /usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x48) [0x5626aa7695f8] /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1ac) [0x5626aa76b47c] /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9b) [0x5626aa76c2cb] /usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xbc) [0x5626aa76ccbc] /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5e0) [0x5626aa762880] /usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x291) [0x5626aa763151] /usr/sbin/mysqld(Trigger::execute(THD*)+0xfa) [0x5626aa8f40aa] /usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x19) [0x5626aa8f5599] /usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x43) [0x56 26aa8eef53] /usr/sbin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x71d) [0x5626aac85f3d] /usr/sbin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x7f4) [0x5626aac86f14] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x510) [0x5626aa848b70] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f9) [0x5626aa7ece99] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x42f) [0x5626aa7f181f] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x202a) [0x5626aa7f3cda] /usr/sbin/mysqld(do_command(THD*)+0x197) [0x5626aa7f4947] /usr/sbin/mysqld(+0x10b3331) [0x5626aa919331] /usr/sbin/mysqld(+0x272e5e8) [0x5626abf945e8] /lib64/libpthread.so.0(+0x80e5) [0x7f2ccdc790e5] /lib64/libc.so.6(clone+0x3f) [0x7f2cccd6b14f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f2c0a28f1d8): is an invalid pointer Connection ID (thread ID): 387 Status: NOT_KILLED 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. (THD*, unsigned int*)+0x30) [0x5626aa7698c0] /usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x60f) [0x5626aa76b8df] /usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9b) [0x5626aa76c2cb] /usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5e0) [0x5626aa762880] /usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x291) [0x5626aa763151] /usr/sbin/mysqld(Trigger::execute(THD*)+0xfa) [0x5626aa8f40aa] /usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x19) [0x5626aa8f5599] /usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x43) [0x56 26aa8eef53]
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=83a86eee469fdc6c81ce73e5a39e0a66f5309753 commit 83a86eee469fdc6c81ce73e5a39e0a66f5309753 Author: Thomas Deutschmann <whissi@gentoo.org> AuthorDate: 2021-01-21 21:14:54 +0000 Commit: Thomas Deutschmann <whissi@gentoo.org> CommitDate: 2021-01-21 22:32:10 +0000 dev-db/mysql: bump to v8.0.23 Closes: https://bugs.gentoo.org/763960 Bug: https://bugs.gentoo.org/766339 Package-Manager: Portage-3.0.14, Repoman-3.0.2 Signed-off-by: Thomas Deutschmann <whissi@gentoo.org> dev-db/mysql/Manifest | 2 + dev-db/mysql/mysql-8.0.23.ebuild | 1159 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 1161 insertions(+)
