Description:
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
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-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)
