Bug #104408 MySQL got the single 11 and crush
Submitted: 25 Jul 2021 7:19 Modified: 25 Aug 2021 16:31
Reporter: z yz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any

[25 Jul 2021 7:19] z yz
Description:
the below is the error message (version 8.0.21):
16:40:00 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x2b1bb3614000
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 = 2b13ba13f74e thread_stack 0x40000
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1fada8e]
/rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x2eb) [0x108798b]
/lib64/libpthread.so.0(+0xf100) [0x2b0ef6ba3100]
/rdsdbbin/mysql/bin/mysqld(ha_innobase::change_active_index(unsigned int)+0x24) [0x20e2374]
/rdsdbbin/mysql/bin/mysqld(ha_innobase::rnd_init(bool)+0x1c) [0x20e297c]
/rdsdbbin/mysql/bin/mysqld(handler::ha_rnd_init(bool)+0x19) [0x1199f79]
/rdsdbbin/mysql/bin/mysqld(reposition_innodb_cursor(TABLE*, unsigned long long)+0x1e) [0x100d71e]
/rdsdbbin/mysql/bin/mysqld(MaterializeIterator::MaterializeQueryBlock(MaterializeIterator::QueryBlock const&, unsigned long long*)+0x2cd) [0x11516ed]
/rdsdbbin/mysql/bin/mysqld(MaterializeIterator::MaterializeRecursive()+0xfd) [0x115198d]
/rdsdbbin/mysql/bin/mysqld(MaterializeIterator::Init()+0x20a) [0x1151d3a]
/rdsdbbin/mysql/bin/mysqld(WindowingIterator::Init()+0x16) [0x114c5e6]
/rdsdbbin/mysql/bin/mysqld(MaterializeIterator::MaterializeQueryBlock(MaterializeIterator::QueryBlock const&, unsigned long long*)+0x71) [0x1151491]
/rdsdbbin/mysql/bin/mysqld(MaterializeIterator::Init()+0x2d9) [0x1151e09]
/rdsdbbin/mysql/bin/mysqld(SELECT_LEX_UNIT::ExecuteIteratorQuery(THD*)+0x39e) [0x101916e]
/rdsdbbin/mysql/bin/mysqld(SELECT_LEX_UNIT::execute(THD*)+0x2c) [0x10193ec]
/rdsdbbin/mysql/bin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x26b) [0xfb168b]
/rdsdbbin/mysql/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x496) [0xfbaec6]
/rdsdbbin/mysql/bin/mysqld(mysql_execute_command(THD*, bool)+0x1c07) [0xf5e507]
/rdsdbbin/mysql/bin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x50) [0xecc5e0]
/rdsdbbin/mysql/bin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x197) [0xece4c7]
/rdsdbbin/mysql/bin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xab) [0xecf0db]
/rdsdbbin/mysql/bin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xc3) [0xed0a63]
/rdsdbbin/mysql/bin/mysqld(sp_head::execute(THD*, bool)+0x3ae) [0xec5d8e]
/rdsdbbin/mysql/bin/mysqld(sp_head::execute_procedure(THD*, List<Item>*)+0x753) [0xec8e83]
/rdsdbbin/mysql/bin/mysqld(Event_job_data::execute(THD*, bool)+0xaca) [0x1082c0a]
/rdsdbbin/mysql/bin/mysqld(Event_worker_thread::run(THD*, Event_queue_element_for_exec*)+0x3d3) [0x13d3e93]
/rdsdbbin/mysql/bin/mysqld() [0x13d42b8]
/rdsdbbin/mysql/bin/mysqld() [0x252325f]
/lib64/libpthread.so.0(+0x7dc5) [0x2b0ef6b9bdc5]
/lib64/libc.so.6(clone+0x6d) [0x2b0ef73bec9d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (2b1b9fedc828): INSERT INTO     uam.v_sys_org_leader_tree     (         origin_id ,         origin_name ,         leader_id ,         city_code ,         org_code ,         org_type ,         dep_type ,         dep_hierarchy ,         leader_name ,         username ,         job_id ,         job_code ,         job_name ,         employee_code ,         porg_ids ,         porg_names ,         pleader_ids ,         pleader_names ,         pusernames ,         pjob_ids ,         pjob_codes ,         pjob_names ,         pemployee_codes ,         update_time     ) SELECT     origin_id ,     origin_name ,     leader_id ,     city_code ,     org_code ,     org_type ,     dep_type ,     dep_hierarchy ,     leader_name ,     username ,     job_id ,     job_code ,     job_name ,     employee_code ,     porg_ids ,     porg_names ,     pleader_ids ,     pleader_names ,     pusernames ,     pjob_ids ,     pjob_codes ,     pjob_names ,     pemployee_codes ,     now() FROM     uam.v_sys_org_leader_tree_job
Connection ID (thread ID): 6926225
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.

the configuration file as the attachment

How to repeat:
cannot repeat
[25 Jul 2021 7:20] z yz
configuration setting

Attachment: mychf.txt (text/plain), 11.30 KiB.

[25 Jul 2021 16:31] MySQL Verification Team
Thank you for the bug report. Please check latest released version 8.0.26, if the issue still is observed with this version provide a complete test case sql script with create table statement, insert data enough to repeat the issue and queries. Thanks.
[26 Aug 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".