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: | |
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
[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 2021 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 2021 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 2021 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 2021 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".