MySQL Forums
Forum List  »  General

MySQL 8.0.22 crashing in loop
Posted by: Lewis Graham
Date: November 06, 2020 01:50PM

One of our MySQL instances is crashing in a loop.
It starts up, and works fine for a few minutes. Then we get signal 11 and a stacktrace in the log. I have only included a couple of crashes from the log file - the log file is huge.

We have tried reinstalling with CentOS 7.x and 8.x, and also with MySQL 8.0.21 and 8.0.22.

Is this a bug or bad configuration? Or some problem with VMWare on which it runs?

Would really appreciate any help!

Thanks

Lewis

--- SNIP - /var/log/mysqld.log ---

2020-11-06T08:50:21.424726Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-11-06T08:50:21.424748Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
2020-11-06T08:50:21.426380Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 87972
2020-11-06T08:50:21.433732Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-06T08:50:24.051757Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-06T08:50:24.239229Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-11-06T08:50:24.312780Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-11-06T08:50:24.317696Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-11-06T08:50:24.444964Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-11-06T08:50:24.445175Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-11-06T08:50:24.466536Z 5 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2020-11-06T08:50:24.469142Z 5 [System] [MY-010562] [Repl] Slave I/O thread for channel '': connected to master 'repl@acd-dbm2:3306',replication started in log 'binlog.000103' at position 78592075
2020-11-06T08:50:24.471851Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
08:52:35 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7fa230001290
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 = 7fa173396d90 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x21afe01]
/usr/sbin/mysqld(handle_fatal_signal+0x313) [0x1011083]
/lib64/libpthread.so.0(+0x12dd0) [0x7fa903a78dd0]
/usr/sbin/mysqld(Item_splocal::this_item()+0x18) [0x113e9e8]
/usr/sbin/mysqld(Item_sp_variable::is_null()+0x11) [0x113e9b1]
/usr/sbin/mysqld(Item_func_isnotnull::val_int()+0x1b) [0x11621db]
/usr/sbin/mysqld(Item::val_bool()+0xcd) [0x11460dd]
/usr/sbin/mysqld(Item_cond_and::val_int()+0x44) [0x1161fc4]
/usr/sbin/mysqld(Item::val_bool()+0xcd) [0x11460dd]
/usr/sbin/mysqld(sp_instr_jump_if_not::exec_core(THD*, unsigned int*)+0x31) [0xe4e211]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x614) [0xe50344]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x2a5) [0xe46cf5]
/usr/sbin/mysqld(Trigger::execute(THD*)+0x10c) [0xfdbc0c]
/usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x20) [0xfdcff0]
/usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x4a) [0xfd697a]
/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*)+0x1c8) [0xe5c1d8]
/usr/sbin/mysqld(Sql_cmd_update::update_single_table(THD*)+0xf66) [0xfa2d26]
/usr/sbin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xd5) [0xfa4105]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x53) [0xe4df43]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1bf) [0xe4feef]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xc7) [0xe526d7]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x7eb) [0xe494cb]
/usr/sbin/mysqld(Sql_cmd_call::execute_inner(THD*)+0x154) [0x135ed84]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x53) [0xe4df43]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1bf) [0xe4feef]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xc7) [0xe526d7]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x7eb) [0xe494cb]
/usr/sbin/mysqld(Sql_cmd_call::execute_inner(THD*)+0x154) [0x135ed84]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x42b) [0xed695b]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1edc) [0xed8cdc]
/usr/sbin/mysqld(do_command(THD*)+0x1a4) [0xed9984]
/usr/sbin/mysqld() [0x1002260]
/usr/sbin/mysqld() [0x2754042]
/lib64/libpthread.so.0(+0x82de) [0x7fa903a6e2de]
/lib64/libc.so.6(clone+0x43) [0x7fa901a22e83]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fa230ef3d58): UPDATE Users SET dtLastAcdStatus = _LoginLogoutTime, TelActive = _AgentTel, dtAcdLoggedIn = IF( bOldLoggedIn_, dtAcdLoggedIn, _LoginLogoutTime ), dtLastCall = IF( _bResetDtLastCall, _LoginLogoutTime, dtLastCall ), AcdMissedCallCounter = 0, AcdMissedCallCounterNoAnswer = 0, AcdMissedCallCounterBusy = 0, AcdMissedCallCounterRejected = 0, AcdLoginTotalCalls = 0, AcdLoginCallSeconds = 0, dtEarliestRedial = IF( NOT bOldCalls_, DATE_ADD( dtNow_, INTERVAL FirstCallDelay_ SECOND ), dtEarliestRedial ), PauseDuration = GetUsersPauseDuration( PauseDuration, _AcdAgentStatusID, AcdAgentStatusID, dtNow_, dtPauseStart ), dtPauseStart = GetUsersDtPauseStart( _AcdAgentStatusID, dtNow_ ), AcdAgentStatusID = _AcdAgentStatusID WHERE ( ID = _UsersID )
Connection ID (thread ID): 91
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.
2020-11-06T08:52:37.444644Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-11-06T08:52:37.444665Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
2020-11-06T08:52:37.445671Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 88510
2020-11-06T08:52:37.452787Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-06T08:52:40.161365Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-06T08:52:40.339655Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-11-06T08:52:40.410595Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-11-06T08:52:40.415096Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-11-06T08:52:40.535756Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-11-06T08:52:40.535959Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-11-06T08:52:40.556745Z 6 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2020-11-06T08:52:40.559503Z 6 [System] [MY-010562] [Repl] Slave I/O thread for channel '': connected to master 'repl@acd-dbm2:3306',replication started in log 'binlog.000104' at position 156
2020-11-06T08:52:40.562186Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
08:54:15 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f77d0000fc0
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 = 7f7a702bad90 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x21afe01]
/usr/sbin/mysqld(handle_fatal_signal+0x313) [0x1011083]
/lib64/libpthread.so.0(+0x12dd0) [0x7f7f2bb69dd0]
/usr/sbin/mysqld(Item_splocal::this_item()+0x18) [0x113e9e8]
/usr/sbin/mysqld(Item_sp_variable::is_null()+0x11) [0x113e9b1]
/usr/sbin/mysqld(Item_func_isnotnull::val_int()+0x1b) [0x11621db]
/usr/sbin/mysqld(Item::val_bool()+0xcd) [0x11460dd]
/usr/sbin/mysqld(Item_cond_and::val_int()+0x44) [0x1161fc4]
/usr/sbin/mysqld(Item::val_bool()+0xcd) [0x11460dd]
/usr/sbin/mysqld(sp_instr_jump_if_not::exec_core(THD*, unsigned int*)+0x31) [0xe4e211]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x614) [0xe50344]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x2a5) [0xe46cf5]
/usr/sbin/mysqld(Trigger::execute(THD*)+0x10c) [0xfdbc0c]
/usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x20) [0xfdcff0]
/usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x4a) [0xfd697a]
/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*)+0x1c8) [0xe5c1d8]
/usr/sbin/mysqld(Sql_cmd_update::update_single_table(THD*)+0xf66) [0xfa2d26]
/usr/sbin/mysqld(Sql_cmd_update::execute_inner(THD*)+0xd5) [0xfa4105]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x53) [0xe4df43]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1bf) [0xe4feef]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xc7) [0xe526d7]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x7eb) [0xe494cb]
/usr/sbin/mysqld(Sql_cmd_call::execute_inner(THD*)+0x154) [0x135ed84]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x53) [0xe4df43]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x1bf) [0xe4feef]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x9e) [0xe50dce]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xc7) [0xe526d7]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5db) [0xe463bb]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x7eb) [0xe494cb]
/usr/sbin/mysqld(Sql_cmd_call::execute_inner(THD*)+0x154) [0x135ed84]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x535) [0xf2e6c5]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x9f0) [0xed2240]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x42b) [0xed695b]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1edc) [0xed8cdc]
/usr/sbin/mysqld(do_command(THD*)+0x1a4) [0xed9984]
/usr/sbin/mysqld() [0x1002260]
/usr/sbin/mysqld() [0x2754042]
/lib64/libpthread.so.0(+0x82de) [0x7f7f2bb5f2de]
/lib64/libc.so.6(clone+0x43) [0x7f7f29b13e83]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f77d1221bd8): UPDATE Users SET PauseDuration = GetUsersPauseDuration( PauseDuration, _AcdAgentStatusID, AcdAgentStatusID, dtNow_, dtPauseStart ), dtPauseStart = GetUsersDtPauseStart( _AcdAgentStatusID, dtNow_ ), AcdAgentStatusID = _AcdAgentStatusID, dtLastAcdStatus = dtNow_, dtLastCall = IF( TIMESTAMPDIFF( MICROSECOND, dtLastCall, dtNow_ ) < 0, dtNow_, dtLastCall ), dtAcdLoggedIn = dtNow_, LastTelActive = TelActive, TelActive = '', PbxTelStatusID = IF( bPbxTelStatusSetByTelActive = TRUE, 0, PbxTelStatusID ), LastCONNRES = NULL WHERE ( ID = _UsersID )
Connection ID (thread ID): 28
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.

Options: ReplyQuote


Subject
Written By
Posted
MySQL 8.0.22 crashing in loop
November 06, 2020 01:50PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.