Mysqld got signal 11

MySQL & MariaDB Percona Server for MySQL 8.0
,
1

Hello

I understand this might be a repetitive question, but can someone shed some light on where the issue could be.
Our test instance crashes intermediately on same INSERT and mysqld restarts immediately.

13:07:48 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Build ID: e8de225be5945e9ad0279fcd08607fdf7a4b6c92
Server Version: 8.0.22-13 Percona Server (GPL), Release 13, Revision 6f7822f

Thread pointer: 0x7fe06812d4d0
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 = 7fe0c804bc70 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x210c1ed]
/usr/sbin/mysqld(handle_fatal_signal+0x3c3) [0x1260d53]
/lib64/libpthread.so.0(+0xf630) [0x7fe31c0c6630]
/usr/sbin/mysqld(Item_splocal::this_item()+0x14) [0xe36af4]
/usr/sbin/mysqld(Item_sp_variable::val_str(String*)+0x20) [0xe38e80]
/usr/sbin/mysqld(Arg_comparator::compare_string()+0x27) [0xe5c147]
/usr/sbin/mysqld(Item_func_eq::val_int()+0x2b) [0xe580bb]
/usr/sbin/mysqld(Item::val_bool()+0xcc) [0xe3dddc]
/usr/sbin/mysqld(Item_cond_and::val_int()+0x3a) [0xe592ba]
/usr/sbin/mysqld(Item::val_bool()+0xcc) [0xe3dddc]
/usr/sbin/mysqld(sp_instr_jump_if_not::exec_core(THD*, unsigned int*)+0x2d) [0x106f66d]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x63b) [0x10717db]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xa1) [0x1072251]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x5c7) [0x1068e57]
/usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x29a) [0x106975a]
/usr/sbin/mysqld(Trigger::execute(THD*)+0x10b) [0x12288eb]
/usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x18) [0x1229cb8]
/usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x46) [0x1223066]
/usr/sbin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x6f4) [0x10dda94]
/usr/sbin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0xa69) [0x10deca9]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x6c0) [0x116f5b0]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xaf8) [0x110e5a8]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x4ec) [0x111329c]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1be5) [0x1115345]
/usr/sbin/mysqld(do_command(THD*)+0x204) [0x1116574]
/usr/sbin/mysqld() [0x1251c40]
/usr/sbin/mysqld() [0x2620ea4]
/lib64/libpthread.so.0(+0x7ea5) [0x7fe31c0beea5]
/lib64/libc.so.6(clone+0x6d) [0x7fe31a20db0d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fe068e58518): INSERT INTO competap (LETCBT,CENEMI,NROCBT,COD,FEC,IDUSUARIO,DES) VALUES (‘R’,‘7701’,‘49’,‘5’,‘2022-09-27 17:14:00’,‘Interface Transportadora’,‘ENTREGADA’)
Connection ID (thread ID): 559
Status: NOT_KILLED

Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/

You may download the Percona Server operations manual by visiting
Percona Server for MySQL is a drop-in replacement for MySQL. You may find information
in the manual which will help you identify the cause of the crash.
2022-10-06T13:07:50.092851Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 71883
2022-10-06T13:07:50.117111Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-10-06T13:07:52.465785Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-10-06T13:07:53.137542Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ‘10.29.69.53’ port: 33060, socket: /var/lib/mysql/mysqlx.sock
2022-10-06T13:07:53.161021Z 0 [System] [MY-010229] [Server] Starting XA crash recovery…
2022-10-06T13:07:53.173957Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2022-10-06T13:07:53.315094Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-10-06T13:07:53.315485Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-10-06T13:07:53.373804Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.22-13’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona Server (GPL), Release 13, Revision 6f7822f.

Regards
Srikanth

1 Like
2

Hi,

Thank you for posting in Percona Forums. Looks like you are getting a SIGNAL 11. This could be either a bug or a hardware malfunction.

You can do some of the following:

  • If you can perform a safe shutdown, try to upgrade to a more recent version of MySQL.

  • You can check also /var/log/messages or dmesg command output to see if you are getting any error message.

  • As this is happening always with the same insert, I would consider a storage malfunction as the possible cause. Could you check the storage?

  • Is it feasible to manually dump, drop, recreate the table and load the data? If there is storage problem, this could help.

  • Check https://bugs.mysql.com/ to see if there is a similar bug for your version already reported.

I hope this helps.

Pep

1 Like
3

Hello @Srikanth_Lingala,
The crash report says there might be triggers on this table? Can you please remove the triggers first and then try the INSERT? Is there a fulltext index on this table also?

Before all that, 8.0.22 is a bit old. Can you please upgrade to 8.0.30 and see if your issue resolves?

1 Like