05:45:51 UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x4027704c1000 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 = 4000199cc657 thread_stack 0x40000 /rdsdbbin/oscar/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x30) [0x25c3d10] /rdsdbbin/oscar/bin/mysqld(print_fatal_signal(int)+0x27c) [0x11ce59c] /rdsdbbin/oscar/bin/mysqld(handle_fatal_signal+0x368) [0x11ce968] linux-vdso.so.1(__kernel_rt_sigreturn+0) [0x400004f09850] /rdsdbbin/oscar/bin/mysqld(TABLE_LIST::query_block_id_for_explain() const+0x20) [0x10ad8e0] /rdsdbbin/oscar/bin/mysqld(PT_common_table_expr::print(THD const*, String*, enum_query_type)+0xa4) [0x15e71c4] /rdsdbbin/oscar/bin/mysqld(PT_with_clause::print(THD const*, String*, enum_query_type)+0x94) [0x15e7394] /rdsdbbin/oscar/bin/mysqld(Query_expression::print(THD const*, String*, enum_query_type)+0x30) [0xf6ab70] /rdsdbbin/oscar/bin/mysqld(explain_query(THD*, THD const*, Query_expression*)+0x370) [0x15b62f0] /rdsdbbin/oscar/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x158) [0xff3a58] /rdsdbbin/oscar/bin/mysqld(mysql_execute_command_internal(THD*, bool)+0x1244) [0xf981c4] /rdsdbbin/oscar/bin/mysqld(mysql_execute_command(THD*, bool)+0x12c) [0xf9bdec] /rdsdbbin/oscar/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x3ac) [0xf9cd0c] /rdsdbbin/oscar/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xc30) [0xf9de90] /rdsdbbin/oscar/bin/mysqld(do_command(THD*)+0xe4) [0xf9f9a4] /rdsdbbin/oscar/bin/mysqld(THD_task::process_connection()+0x244) [0x11bce24] /rdsdbbin/oscar/bin/mysqld(Thread_pool::worker_loop()+0x174) [0x11bae94] /rdsdbbin/oscar/bin/mysqld(Thread_pool::worker_launch(void*)+0x24) [0x11bb0a4] /rdsdbbin/oscar/bin/mysqld() [0x2b26a18] /lib64/libpthread.so.0(+0x7230) [0x400004fa3230] /lib64/libc.so.6(+0xdb7dc) [0x400006ed97dc] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (402a5d586030): /* ApplicationName=DBeaver 22.0.3 - SQLEditor / explain WITH AUTH_MD AS ( SELECT /+ JOIN_FIXED_ORDER() */ DISTINCT TEMP.MD_CD FROM MT_OPER_ORG_STR_MD_MPNG TEMP WHERE (STR_CD, TEAM_CD, PC_CD) IN ( SELECT DISTINCT ST.STR_CD AS strCd , TEAM.TEAM_CD AS teamCd , PC.PC_CD AS pcCd FROM MT_ORG_M ST JOIN MT_ORG_M TEAM ON ST.STR_CD = TEAM.STR_CD JOIN MT_ORG_M PC ON TEAM.STR_CD = PC.STR_CD AND TEAM.TEAM_CD = PC.TEAM_CD WHERE ST.ORG_LVL_CD = '0' AND TEAM.ORG_LVL_CD = '2' AND PC.ORG_LVL_CD = '4' AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN ST.BGN_YMD AND ST.END_YMD AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN TEAM.BGN_YMD AND TEAM.END_YMD AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN PC.BGN_YMD AND PC.END_YMD AND ST.STR_CD IN ( '07', '01', '14', '18', '90', '81', 'D1', '16', '03', '19', '40', '37', '15', '70', '06' Connection ID (thread ID): 83318341 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. aurora_disable_backtrace_compare flag : 0 Dedupe string file location set to /rdsdbdata/tmp Unable to open backtrace_dedupe_strings.txt : No such file or directory Found 0 previous dedupe strings Printing Backtrace handle_fatal_signal+604 __kernel_rt_sigreturn+0 _ZNK10TABLE_LIST26query_block_id_for_explainEv+32 _ZN20PT_common_table_expr5printEPK3THDP6String15enum_query_type+164 _ZN14PT_with_clause5printEPK3THDP6String15enum_query_type+148 _ZN16Query_expression5printEPK3THDP6String15enum_query_type+48 _Z13explain_queryP3THDPKS_P16Query_expression+880 _ZN11Sql_cmd_dml7executeEP3THD+344 _Z30mysql_execute_command_internalP3THDb+4676 _Z21mysql_execute_commandP3THDb+300 _Z20dispatch_sql_commandP3THDP12Parser_state+940 _Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+3120 _Z10do_commandP3THD+228 _ZN8THD_task18process_connectionEv+580 _ZN11Thread_pool11worker_loopEv+372 _ZN11Thread_pool13worker_launchEPv+36 /rdsdbbin/oscar/bin/mysqld /lib64/libpthread.so.0 /lib64/libc.so.6 Backtrace Metrics write directory set to /rdsdbdata/tmp cluster replica status 0 Failover:reduction dedupe strings don't match Backtrace write directory set to /rdsdbdata/tmp Backtrace backtrace to : /rdsdbdata/tmp/mysqld-backtrace.txtDedupe string write directory set to /rdsdbdata/tmp Backtrace write directory set to /rdsdbdata/log/backtrace Writing a core file bin/oscar/bin/mysqld(Thread_pool::worker_loop()+0x174) [0x11bae94] /rdsdbbin/oscar/bin/mysqld(Thread_pool::worker_launch(void*)+0x24) [0x11bb0a4] /rdsdbbin/oscar/bin/mysqld() [0x2b26a18] /lib64/libpthread.so.0(+0x7230) [0x400004fa3230] /lib64/libc.so.6(+0xdb7dc) [0x400006ed97dc] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (402a5d586030): /* ApplicationName=DBeaver 22.0.3 - SQLEditor / explain WITH AUTH_MD AS ( SELECT /+ JOIN_FIXED_ORDER() */ DISTINCT TEMP.MD_CD FROM MT_OPER_ORG_STR_MD_MPNG TEMP WHERE (STR_CD, TEAM_CD, PC_CD) IN ( SELECT DISTINCT ST.STR_CD AS strCd , TEAM.TEAM_CD AS teamCd , PC.PC_CD AS pcCd FROM MT_ORG_M ST JOIN MT_ORG_M TEAM ON ST.STR_CD = TEAM.STR_CD JOIN MT_ORG_M PC ON TEAM.STR_CD = PC.STR_CD AND TEAM.TEAM_CD = PC.TEAM_CD WHERE ST.ORG_LVL_CD = '0' AND TEAM.ORG_LVL_CD = '2' AND PC.ORG_LVL_CD = '4' AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN ST.BGN_YMD AND ST.END_YMD AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN TEAM.BGN_YMD AND TEAM.END_YMD AND DATE_FORMAT(NOW(), '%Y%m%d') BETWEEN PC.BGN_YMD AND PC.END_YMD AND ST.STR_CD IN ( '07', '01', '14', '18', '90', '81', 'D1', '16', '03', '19', '40', '37', '15', '70', '06' Connection ID (thread ID): 83318341 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. aurora_disable_backtrace_compare flag : 0 Dedupe string file location set to /rdsdbdata/tmp Unable to open backtrace_dedupe_strings.txt : No such file or directory Found 0 previous dedupe strings Printing Backtrace handle_fatal_signal+604 __kernel_rt_sigreturn+0 _ZNK10TABLE_LIST26query_block_id_for_explainEv+32 _ZN20PT_common_table_expr5printEPK3THDP6String15enum_query_type+164 _ZN14PT_with_clause5printEPK3THDP6String15enum_query_type+148 _ZN16Query_expression5printEPK3THDP6String15enum_query_type+48 _Z13explain_queryP3THDPKS_P16Query_expression+880 _ZN11Sql_cmd_dml7executeEP3THD+344 _Z30mysql_execute_command_internalP3THDb+4676 _Z21mysql_execute_commandP3THDb+300 _Z20dispatch_sql_commandP3THDP12Parser_state+940 _Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+3120 _Z10do_commandP3THD+228 _ZN8THD_task18process_connectionEv+580 _ZN11Thread_pool11worker_loopEv+372 _ZN11Thread_pool13worker_launchEPv+36 /rdsdbbin/oscar/bin/mysqld /lib64/libpthread.so.0 /lib64/libc.so.6 Backtrace Metrics write directory set to /rdsdbdata/tmp cluster replica status 0 Failover:reduction dedupe strings don't match Backtrace write directory set to /rdsdbdata/tmp Backtrace backtrace to : /rdsdbdata/tmp/mysqld-backtrace.txtDedupe string write directory set to /rdsdbdata/tmp Backtrace write directory set to /rdsdbdata/log/backtrace Writing a core file