Bug #100346 crash
Submitted: 28 Jul 2020 6:10 Modified: 29 Oct 7:00
Reporter: can can Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.16-7 OS:Any
Assigned to: CPU Architecture:x86

[28 Jul 2020 6:10] can can
Description:
03:48:29 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f9dc33a6000
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 = 7f9d6df6ec00 thread_stack 0x46000
/usr/local/mysql/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x2e) [0x1e0e78e]
/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x323) [0x10bc673]
/lib64/libpthread.so.0(+0xf5d0) [0x7f9f1cbe35d0]
/usr/local/mysql/bin/mysqld(temptable::Handler::rnd_next(unsigned char*)+0x2e) [0x23540fe]
/usr/local/mysql/bin/mysqld(handler::ha_rnd_next(unsigned char*)+0x18c) [0xd314fc]
/usr/local/mysql/bin/mysqld(TableScanIterator::Read()+0x1d) [0xebf1fd]
/usr/local/mysql/bin/mysqld(TemptableAggregateIterator::Init()+0x27b) [0x116ca9b]
/usr/local/mysql/bin/mysqld(MaterializeIterator::Init()+0x24b) [0x116c2cb]
/usr/local/mysql/bin/mysqld(NestedLoopIterator::Read()+0xc1) [0x1169fc1]
/usr/local/mysql/bin/mysqld(JOIN::exec()+0x33b) [0xf48dab]
/usr/local/mysql/bin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2bc) [0xfd0bac]
/usr/local/mysql/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x3e8) [0xfd8948]
/usr/local/mysql/bin/mysqld(mysql_execute_command(THD*, bool)+0x33cb) [0xf85e3b]
/usr/local/mysql/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x3f7) [0xf887e7]
/usr/local/mysql/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2dbb) [0xf8ba7b]
/usr/local/mysql/bin/mysqld(do_command(THD*)+0x21c) [0xf8c5cc]
/usr/local/mysql/bin/mysqld() [0x10adc60]
/usr/local/mysql/bin/mysqld() [0x1eb2a72]
/lib64/libpthread.so.0(+0x7dd5) [0x7f9f1cbdbdd5]
/lib64/libc.so.6(clone+0x6d) [0x7f9f1adabead]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f9dab72b028): is an invalid pointer
Connection ID (thread ID): 147886
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.

How to repeat:
unkonw
[28 Jul 2020 7:00] MySQL Verification Team
Sorry but we don't deal with bugs in Percona Server.
If you can repeat same crash on Oracle MySQL Server,  feel free to reopen this bug.
[29 Sep 6:38] jony wang
we also encounter the same problem with Oracle MySQL 8.0

the error log message:

09:18:09 UTC - mysqld got signal 11 ;

Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

Thread pointer: 0x7f8bfc005eb0

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 = 7f8c6c0ead80 thread_stack 0x40000

/u01/mysql/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x2e) [0x1d4c1de]

/u01/mysql/bin/mysqld(handle_fatal_signal+0x2f3) [0xeb7ef3]

/lib64/libpthread.so.0(+0xf100) [0x7f8d9e884100]

/u01/mysql/bin/mysqld(temptable::Handler::rnd_next(unsigned char*)+0x2e) [0x22695fe]

/u01/mysql/bin/mysqld(handler::ha_rnd_next(unsigned char*)+0x18c) [0xfc280c]

/u01/mysql/bin/mysqld(TableScanIterator::Read()+0x1d) [0xcebf6d]

/u01/mysql/bin/mysqld(TemptableAggregateIterator::Init()+0x1b9) [0xf76da9]

/u01/mysql/bin/mysqld(MaterializeIterator::Init()+0xf2) [0xf764d2]

/u01/mysql/bin/mysqld(NestedLoopIterator::Read()+0xa1) [0xf74151]

/u01/mysql/bin/mysqld(MaterializeIterator::Init()+0x2b4) [0xf76694]

/u01/mysql/bin/mysqld(filesort(THD*, Filesort*, bool, RowIterator*, Sort_result*, unsigned long long*, unsigned long long*)+0x409) [0xfadff9]

/u01/mysql/bin/mysqld(SortingIterator::DoSort(QEP_TAB*)+0xa9) [0xd08819]

/u01/mysql/bin/mysqld(SortingIterator::Init()+0x47) [0xd08947]

/u01/mysql/bin/mysqld(AggregateIterator::Init()+0x16) [0xf73fe6]

/u01/mysql/bin/mysqld(MaterializeIterator::Init()+0xf2) [0xf764d2]

/u01/mysql/bin/mysqld(NestedLoopIterator::Read()+0xa1) [0xf74151]

/u01/mysql/bin/mysqld(JOIN::exec()+0x527) [0xd55757]

/u01/mysql/bin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2ee) [0xdd4dae]

/u01/mysql/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x438) [0xddcb88]

/u01/mysql/bin/mysqld(mysql_execute_command(THD*, bool)+0x27e3) [0xd8cf53]

/u01/mysql/bin/mysqld(mysql_parse(THD*, Parser_state*)+0x30f) [0xd8f16f]

/u01/mysql/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2873) [0xd91ef3]

/u01/mysql/bin/mysqld(do_command(THD*)+0x1ad) [0xd92e5d]

/u01/mysql/bin/mysqld() [0xea9968]

/u01/mysql/bin/mysqld() [0x21e766f]
[29 Sep 6:40] jony wang
it seems the temptable:Handler m_rnd_iterator was not initlized 
correctly when use temp table rnd_init/rnd_next
[29 Sep 7:00] MySQL Verification Team
we need to know if crash happens on 8.0.26, and if yes,  what exact query caused crash.  and what are the table structures involved?
[30 Oct 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".