MySQL Bugs: #100346: crash

Bug #100346	crash
Submitted:	28 Jul 2020 6:10	Modified:	29 Oct 2021 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

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

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.

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]

it seems the temptable:Handler m_rnd_iterator was not initlized 
correctly when use temp table rnd_init/rnd_next

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?

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".