Bug #102270 upgrade my database to 8.0.22 from 8.0.21,but mysqld process always reboot when
Submitted: 18 Jan 2021 10:15 Modified: 18 Jan 2021 10:22
Reporter: tuantuan Xue Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.22 OS:Any
Assigned to: CPU Architecture:Any

[18 Jan 2021 10:15] tuantuan Xue
do some batch DML operation through Java program

How to repeat:
you can report the following error:
Communications link failure.Last packet sent to the server was 0 ms ago

at this time, there are the following exceptions in the errlog of MySQL:

00:46:22 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f5f9000bef0
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 = 7f625069fca0 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x202b02e]
/usr/sbin/mysqld(handle_fatal_signal+0x323) [0x1024333]
/lib64/libpthread.so.0() [0x3eb300f7e0]
/usr/sbin/mysqld(Item_func_sp::get_initial_pseudo_tables() const+0x11) [0x11b6c71]
/usr/sbin/mysqld(Item_func::update_used_tables()+0x19) [0x11b5f79]
/usr/sbin/mysqld(Item_func_sp::update_used_tables()+0x11) [0x11b6d91]
/usr/sbin/mysqld(SELECT_LEX::update_used_tables()+0x9f) [0xf25acf]
/usr/sbin/mysqld(JOIN::destroy()+0x578) [0xf41258]
/usr/sbin/mysqld(SELECT_LEX::cleanup(THD*, bool)+0x65) [0xfb1855]
/usr/sbin/mysqld(SELECT_LEX_UNIT::cleanup(THD*, bool)+0xa6) [0xfb19d6]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xb51) [0xeed1d1]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3f8) [0xef18f8]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x170b) [0xef347b]
/usr/sbin/mysqld(do_command(THD*)+0x174) [0xef49a4]
/usr/sbin/mysqld() [0x1015d10]
/usr/sbin/mysqld() [0x25581bc]
/lib64/libpthread.so.0() [0x3eb3007aa1]
/lib64/libc.so.6(clone+0x6d) [0x3eb28e8c4d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f5f9002be48): is an invalid pointer
Connection ID (thread ID): 228

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-10-23T08:46:23.131822+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 18720
2020-10-23T08:46:23.143107+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-23T08:46:30.031105+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

Suggested fix:
I don't have any idea, and it's the same problem in many environments. 
i can only go back to the original version(8.0.21)
[18 Jan 2021 10:22] tuantuan Xue
Duplicate submission
[18 Jan 2021 10:22] tuantuan Xue
Duplicate submission