Hi Team,
We are facing with DB crashing frequently in 8.0.30 percona version.
Below are the errors reported during crash .
01:04:20 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Build ID: Not Available
Server Version: 8.0.30-22 Percona Server (GPL), Release 22, Revision 7e301439b65
Thread pointer: 0x7f906801e000
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 = 7f9087ef8bb0 thread_stack 0x100000
/home/mysqld/sys/8.0.30_percona/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x206883d]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(print_fatal_signal(int)+0x30f) [0x114a4af]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(handle_fatal_signal+0xc5) [0x114a585]
/lib64/libpthread.so.0(+0xf630) [0x7f919eeee630]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(Prepared_statement::trace_parameter_types()+0xb4) [0xff5a84]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(Prepared_statement::prepare_query()+0x184) [0xff90d4]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(Prepared_statement::prepare(char const*, unsigned long, Item_param**)+0x82a) [0xffa1fa]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(mysqld_stmt_prepare(THD*, char const*, unsigned int, Prepared_statement*)+0xb6) [0xffac96]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xfd8) [0xfca7c8]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(do_command(THD*)+0x282) [0xfcc862]
/home/mysqld/sys/8.0.30_percona/bin/mysqld() [0x113a880]
/home/mysqld/sys/8.0.30_percona/bin/mysqld() [0x253e925]
/lib64/libpthread.so.0(+0x7ea5) [0x7f919eee6ea5]
/lib64/libc.so.6(clone+0x6d) [0x7f919d22fb2d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (xxx ): insert into xxxx (xx , xxx, xxx) values (?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?),(?, ?, ?
Connection ID (thread ID): 763267
Status: NOT_KILLED
Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/
05:01:20 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Build ID: Not Available
Server Version: 8.0.30-22 Percona Server (GPL), Release 22, Revision 7e301439b65
Thread pointer: 0x7f9a3001e000
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 = 7f9b0121abb0 thread_stack 0x100000
/home/mysqld/sys/8.0.30_percona/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x206883d]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(print_fatal_signal(int)+0x30f) [0x114a4af]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(handle_fatal_signal+0xc5) [0x114a585]
/lib64/libpthread.so.0(+0xf630) [0x7f9b537c9630]
/lib64/libc.so.6(+0x1565da) [0x7f9b51b625da]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(String::append(char const*, unsigned long)+0xa1) [0x11230e1]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(Prepared_statement::insert_parameters(String*, bool, PS_PARAM*)+0x16f) [0xffbf9f]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(Prepared_statement::set_parameters(String*, bool, PS_PARAM*)+0x33) [0xffc853]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(mysqld_stmt_execute(THD*, Prepared_statement*, bool, unsigned long, PS_PARAM*)+0x10e) [0xffd3ce]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x104d) [0xfca83d]
/home/mysqld/sys/8.0.30_percona/bin/mysqld(do_command(THD*)+0x282) [0xfcc862]
/home/mysqld/sys/8.0.30_percona/bin/mysqld() [0x113a880]
/home/mysqld/sys/8.0.30_percona/bin/mysqld() [0x253e925]
/lib64/libpthread.so.0(+0x7ea5) [0x7f9b537c1ea5]
/lib64/libc.so.6(clone+0x6d) [0x7f9b51b0ab2d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 4674
Status: NOT_KILLED