Hello we are using CentOS Stream 9 with
8.0.36-28 Percona Server (GPL), Release 28, Revision 47601f19.
We are restoring database and receive Mysqld got signal 11
mysql.err
–removed-- pass 194194
dump
–removed-- pass 194194
Please any help or advice?
hello @artsiom82,
Please attach the log files directly. I have removed the links from your post. There is no way to verify malicious files when using upload services.
@ matthewb
- I cant attach because “Sorry, new users can not upload attachments.”
- Dump of SQL is about 1,5 GB, a made RAR of it 200 MB, and i cant upload it directly cause i`m new user and “Sorry, the file you are trying to upload is not authorized (authorized extensions: jpg, jpeg, png, gif, heic, heif, txt, pdf, docx, log).”
- What to do and how to live with it?
You should not have a 1.5GB log file. The log file should be more like 5-10MB. Do not include the entire log, just the parts with the error and the signal 11 message. Maybe 100-200 lines before the sig 11 message.
@matthewb
I dont have 1,5 GB LOG, i have 1.5 GB DUMP of SQL…
LOG is 16 KB, but i cant upload it…
How to upload files?
Still
“Sorry, new users can not upload attachments.”
Why are you trying to upload your entire database?
Just copy/paste your log file into the forum text box and make it “code” in the box.
Like this
@matthewb
i`m not trying to upload entire database, i am trying to upload dump made by libcoredumper
here is the log of mysql (mysql.err)
2024-11-25T21:16:58.046307Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-28) starting as process 1241
2024-11-25T21:16:58.061032Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-25T21:16:58.202579Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-25T21:16:58.289730Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-11-25T21:16:58.289747Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-11-25T21:16:58.300787Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2024-11-25T21:16:58.300959Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-28' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 28, Revision 47601f19.
2024-11-25T21:19:33.564261Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36-28).
2024-11-25T21:19:34.820522Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-28) Percona Server (GPL), Release 28, Revision 47601f19.
2024-11-25T21:19:35.392192Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-28) starting as process 1940
2024-11-25T21:19:35.396098Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-25T21:19:35.505712Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-25T21:19:35.577903Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-11-25T21:19:35.577917Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-11-25T21:19:35.584490Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2024-11-25T21:19:35.584527Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-28' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 28, Revision 47601f19.
2024-11-25T21:22:39Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=d18f29188cae66133efa80e6eb798f0bc921812c
Server Version: 8.0.36-28 Percona Server (GPL), Release 28, Revision 47601f19
Thread pointer: 0x7ff564142200
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 = 7ff5b2779c10 thread_stack 0x80000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x15ec081]
/usr/sbin/mysqld(print_fatal_signal(int)+0x2cf) [0xde36df]
/usr/sbin/mysqld(handle_fatal_signal+0xb9) [0xde39b9]
/lib64/libc.so.6(+0x3e6f0) [0x7ff645e3e6f0]
/usr/sbin/mysqld(rtr_clean_rtr_info(rtr_info*, bool)+0x3f) [0x190ad2f]
/usr/sbin/mysqld(row_ins_sec_index_entry_low(unsigned int, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool)+0x253) [0x173d433]
/usr/sbin/mysqld(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0x152) [0x173e402]
/usr/sbin/mysqld(row_ins_step(que_thr_t*)+0x494) [0x1747b24]
/usr/sbin/mysqld() [0x17482d6]
/usr/sbin/mysqld(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*)+0x5e) [0x174cbde]
/usr/sbin/mysqld(ha_innobase::write_row(unsigned char*)+0x27f) [0x162b6cf]
/usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x15a) [0x9c59fa]
/usr/sbin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x64c) [0xc5411c]
/usr/sbin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x807) [0xc59b17]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x206) [0xcdd1d6]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x963) [0xc8c5e3]
/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*, bool)+0x61f) [0xc902ef]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1b23) [0xc925c3]
/usr/sbin/mysqld(do_command(THD*)+0x21d) [0xc930ad]
/usr/sbin/mysqld() [0xde49bf]
/usr/sbin/mysqld() [0x1991222]
/lib64/libc.so.6(+0x89c02) [0x7ff645e89c02]
/lib64/libc.so.6(+0x10ec40) [0x7ff645f0ec40]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7ff564340700): INSERT INTO `b_bp_workflow_state` VALUES ('65e9534222e9d8.89055966', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 644, 'Completed', ' ', NULL, '2024-03-07 08:40:18', '2024-03-07 08:40:18', 8290), ('65e9534262bd62.24279865', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 679, 'Completed', ' ', NULL, '2024-03-07 08:40:18', '2024-03-07 08:40:18', 8290), ('65e95342674c29.30718679', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 489, 'Terminated', ' .', NULL, '2024-03-07 08:40:42', '2024-03-07 08:40:18', NULL), ('65e953449e9de4.31543216', 'crm', 'CCrmDocumentLead', 'LEAD_399023', 0, 644, 'Completed', ' ', NULL, '2024-03-07 08:40:20', '2024-03-07 08:40:20', 41199), ('65e95344e3cd19.84724949', 'crm', 'CCrmDocumentLead', 'LEAD_399023', 0, 679, 'Completed', ' ', NULL, '2024-03-07 08:40:20', '2024-03-07 08:40:20', 41199), ('65e95344efb237.04438775', 'crm', 'CCr
Connection ID (thread ID): 16
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
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
Writing a core file using lib coredumper
PATH: (null)
2024-11-25T21:22:39.000000Z 0 [System] [MY-013951] [Server] 2024-11-25T21:22:39Z UTC - mysqld got signal 11 ;
2024-11-25T21:22:39.000001Z 0 [System] [MY-013951] [Server] Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
2024-11-25T21:22:39.000002Z 0 [System] [MY-013951] [Server] BuildID[sha1]=d18f29188cae66133efa80e6eb798f0bc921812c
2024-11-25T21:22:39.000003Z 0 [System] [MY-013951] [Server] Server Version: 8.0.36-28 Percona Server (GPL), Release 28, Revision 47601f19
2024-11-25T21:22:39.000004Z 0 [System] [MY-013951] [Server] Thread pointer: 0x7ff564142200
2024-11-25T21:22:39.000005Z 0 [System] [MY-013951] [Server] Attempting backtrace. You can use the following information to find out
2024-11-25T21:22:39.000006Z 0 [System] [MY-013951] [Server] where mysqld died. If you see no messages after this, something went
2024-11-25T21:22:39.000007Z 0 [System] [MY-013951] [Server] terribly wrong...
2024-11-25T21:22:39.000008Z 0 [System] [MY-013951] [Server] stack_bottom = 7ff5b2779c10 thread_stack 0x80000
2024-11-25T21:22:39.000009Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x15ec081]
2024-11-25T21:22:39.000010Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(print_fatal_signal(int)+0x2cf) [0xde36df]
2024-11-25T21:22:39.000011Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(handle_fatal_signal+0xb9) [0xde39b9]
2024-11-25T21:22:39.000012Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x3e6f0) [0x7ff645e3e6f0]
2024-11-25T21:22:39.000013Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(rtr_clean_rtr_info(rtr_info*, bool)+0x3f) [0x190ad2f]
2024-11-25T21:22:39.000014Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(row_ins_sec_index_entry_low(unsigned int, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*, bool)+0x253) [0x173d433]
2024-11-25T21:22:39.000015Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool)+0x152) [0x173e402]
2024-11-25T21:22:39.000016Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(row_ins_step(que_thr_t*)+0x494) [0x1747b24]
2024-11-25T21:22:39.000017Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld() [0x17482d6]
2024-11-25T21:22:39.000018Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*)+0x5e) [0x174cbde]
2024-11-25T21:22:39.000019Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(ha_innobase::write_row(unsigned char*)+0x27f) [0x162b6cf]
2024-11-25T21:22:39.000020Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x15a) [0x9c59fa]
2024-11-25T21:22:39.000021Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x64c) [0xc5411c]
2024-11-25T21:22:39.000022Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x807) [0xc59b17]
2024-11-25T21:22:39.000023Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x206) [0xcdd1d6]
2024-11-25T21:22:39.000024Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x963) [0xc8c5e3]
2024-11-25T21:22:39.000025Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*, bool)+0x61f) [0xc902ef]
2024-11-25T21:22:39.000026Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1b23) [0xc925c3]
2024-11-25T21:22:39.000027Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld(do_command(THD*)+0x21d) [0xc930ad]
2024-11-25T21:22:39.000028Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld() [0xde49bf]
2024-11-25T21:22:39.000029Z 0 [System] [MY-013951] [Server] /usr/sbin/mysqld() [0x1991222]
2024-11-25T21:22:39.000030Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x89c02) [0x7ff645e89c02]
2024-11-25T21:22:39.000031Z 0 [System] [MY-013951] [Server] /lib64/libc.so.6(+0x10ec40) [0x7ff645f0ec40]
2024-11-25T21:22:39.000032Z 0 [System] [MY-013951] [Server] Trying to get some variables.
2024-11-25T21:22:39.000033Z 0 [System] [MY-013951] [Server] Some pointers may be invalid and cause the dump to abort.
2024-11-25T21:22:39.000034Z 0 [System] [MY-013951] [Server] Query (7ff564340700): INSERT INTO `b_bp_workflow_state` VALUES ('65e9534222e9d8.89055966', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 644, 'Completed', ' ', NULL, '2024-03-07 08:40:18', '2024-03-07 08:40:18', 8290), ('65e9534262bd62.24279865', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 679, 'Completed', ' ', NULL, '2024-03-07 08:40:18', '2024-03-07 08:40:18', 8290), ('65e95342674c29.30718679', 'crm', 'CCrmDocumentLead', 'LEAD_400482', 0, 489, 'Terminated', ' .', NULL, '2024-03-07 08:40:42', '2024-03-07 08:40:18', NULL), ('65e953449e9de4.31543216', 'crm', 'CCrmDocumentLead', 'LEAD_399023', 0, 644, 'Completed', ' ', NULL, '2024-03-07 08:40:20', '2024-03-07 08:40:20', 41199), ('65e95344e3cd19.84724949', 'crm', 'CCrmDocumentLead', 'LEAD_399023', 0, 679, 'Completed', ' ', NULL, '2024-03-07 08:40:20', '2024-03-07 08:40:20', 41199), ('65e95344efb237.04438775', 'crm', 'CCr
2024-11-25T21:22:39.000035Z 0 [System] [MY-013951] [Server] Connection ID (thread ID): 16
2024-11-25T21:22:39.000036Z 0 [System] [MY-013951] [Server] Status: NOT_KILLED
2024-11-25T21:22:39.000037Z 0 [System] [MY-013951] [Server] Please help us make Percona Server better by reporting any
2024-11-25T21:22:39.000038Z 0 [System] [MY-013951] [Server] bugs at https://bugs.percona.com/
2024-11-25T21:22:39.000039Z 0 [System] [MY-013951] [Server] You may download the Percona Server operations manual by visiting
2024-11-25T21:22:39.000040Z 0 [System] [MY-013951] [Server] http://www.percona.com/software/percona-server/. You may find information
2024-11-25T21:22:39.000041Z 0 [System] [MY-013951] [Server] in the manual which will help you identify the cause of the crash.
2024-11-25T21:22:39.000042Z 0 [System] [MY-013951] [Server] Writing a core file using lib coredumper
2024-11-25T21:22:39.000043Z 0 [System] [MY-013951] [Server] PATH: (null)
2024-11-25T21:22:42.441143Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-28) starting as process 2176
2024-11-25T21:22:42.443514Z 0 [System] [MY-013951] [Server] A backtrace was processed and added to the main error-log in the appropriate format.
2024-11-25T21:22:42.446081Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-25T21:22:43.984263Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-25T21:22:44.079974Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-11-25T21:22:44.082588Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 662024-11-25T21:22:44.100330Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-11-25T21:22:44.100343Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 1002024-11-25T21:22:44.107914Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2024-11-25T21:22:44.107933Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-28' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 28, Revision 47601f19.
Again, above, your 2nd post, you said “2. Dump of SQL is about 1,5 GB” which says you are trying to upload the entire dump of your database.
For core dumps, if we need them, we have different ways of sending large data outside the forums.
Please explain, with full commands, how you took the backup, and how you restored it. Please include all commands, and log output of the backup process.