Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
log.
00604 1:11:31 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 10.3.13-MariaDB-log
key_buffer_size=16777216
read_buffer_size=2097152
max_used_connections=99
max_threads=2002
thread_count=72
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6211175 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x2ad2b63e3008
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 = 0x2ad1d33b1e28 thread_stack 0x40000
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x564bcfc58669]
mysys/stacktrace.c:270(my_print_stacktrace)[0x564bcf71c37d]
sigaction.c:0(__restore_rt)[0x2ad153c67100]
/rdsdbbin/mysql/bin/mysqld(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x77)[0x564bcf655d67]
sql/opt_subselect.cc:3556(fix_semijoin_strategies_for_picked_join_order(JOIN*))[0x564bcf57e757]
sql/sql_select.cc:9562(JOIN::get_best_combination())[0x564bcf59b203]
sql/sql_select.cc:1935(JOIN::optimize_stage2())[0x564bcf59fba5]
sql/sql_select.cc:1456(JOIN::optimize())[0x564bcf517979]
sql/sql_derived.cc:935(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x564bcf517211]
sql/sql_derived.cc:197(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x564bcf5310de]
sql/sql_lex.cc:4104(st_select_lex::handle_derived(LEX*, unsigned int))[0x564bcf5fc236]
sql/table.cc:8186(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x564bcf5310de]
sql/sql_lex.cc:4104(st_select_lex::handle_derived(LEX*, unsigned int))[0x564bcf59b22c]
sql/sql_select.cc:1938(JOIN::optimize_stage2())[0x564bcf59e206]
sql/sql_select.cc:1914(JOIN::optimize_inner())[0x564bcf59fb6f]
sql/sql_select.cc:1453(JOIN::optimize())[0x564bcf5a1999]
sql/sql_select.cc:4225(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564bcf5a1b86]
sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564bcf544698]
sql/sql_parse.cc:6671(execute_sqlcom_select)[0x564bcf551817]
sql/sql_parse.cc:3807(mysql_execute_command(THD*))[0x564bcf553edb]
sql/sql_parse.cc:8276(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x564bcf55666d]
sql/sql_parse.cc:1864(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x564bcf5573af]
sql/sql_parse.cc:1406(do_command(THD*))[0x564bcf621fcc]
sql/sql_connect.cc:1446(do_handle_one_connection(CONNECT*))[0x564bcf6221a4]
sql/sql_connect.cc:1354(handle_one_connection)[0x564bcfc0591a]
pthread_create.c:0(start_thread)[0x2ad153c5fdc5]
/lib64/libc.so.6(clone+0x6d)[0x2ad153f6ac9d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x2ad2b6112020): SELECT HYCR.YEA_RUN_ID ,HYCR.COMP_CD ,HYRM.YEA_YYYY ,HYCR.EMP_ID ,HPM.EMP_NO ,HPM.EMP_NM ,CM4.CD_NM AS JOB_TITLE_NM ,HOM.ORG_NM ,erpapp.DB_DECRYPT(HPM.SSN) AS SSN ,HYRM.YEA_RUN_TYPE ,CM1.CD_NM AS YEA_RUN_TYPE_NM ,HYCR.YEA_RUN_SUB_TYPE ,CM2.CD_NM AS YEA_RUN_SUB_TYPE_NM ,HYRM.YEA_RUN_SEQ AS YEA_RUN_SEQS ,HYRM.YEA_RUN_NM ,HYRM.YEA_RUN_STAT_CD ,CM3.CD_NM AS YEA_RUN_STAT_NM ,CASE WHEN HYCR.DEADLINE_DT IS NOT NULL THEN 'Y' ELSE 'N' END AS CLOSED_FLAG ,HYCR.DEADLINE_DT ,CASE WHEN LST.YEA_RUN_ID IS NULL THEN 'N' ELSE 'Y' END AS LST_CLOSE_YN – SR#34246 ,HYCR.STD_TAX_CRDT_YN ,HYCR.SINGLE_TAX_RATE_YN ,HYCR.TOT_PAY_AMT ,HYCR.FIX_ITAX_AMT ,HYCR.FIX_RTAX_AMT ,HYCR.FIX_FTAX_AMT ,HYCR.ADJ_ITAX_AMT ,HYCR.ADJ_RTAX_AMT ,HYCR.ADJ_FTAX_AMT ,CM5.CD_NM AS ANM – ,CM6.CD_NM AS BNM – ,CM7.CD_NM AS CNM – JSP ,CC5.ATTR1 AS DNM – ,CU.EMP_NM AS UPDT_NM ,HYCR.UPDT_DT ,HYRI.FSE_TYPE ,CM8.CD_NM AS FSE_TYPE_NM FROM HR_YEA_CALC_RESULT HYCR JOIN HR_YEA_RUN_MASTER HYRM ON HYCR.YEA_RUN_ID = HYRM.YEA_RUN_ID JOIN HR_YEA_RUN_EMP_INFO HYRI ON HYCR.YEA_RUN_ID = HYRI.YEA_RUN_ID AND HYCR.EMP_ID = HYRI.EMP_ID JOIN HR_PSN_MST HPM ON HPM.EMP_ID = HYCR.EMP_ID JOIN HR_ASG_MST HAM ON HAM.EMP_ID = HYCR.EMP_ID AND HAM.COMP_CD = HYCR.COMP_CD LEFT OUTER JOIN HR_ORG_MST HOM ON HOM.ORG_ID = HAM.ORG_ID AND HOM.COMP_CD = HAM.COMP_CD AND erpapp.DB_NVL_CHAR(HPM.RETR_DATE,erpapp.DB_DATE_TO_CHAR(erpapp.DB_SYSDATE(),'YYYYMMDD')) >= HOM.EFFCT_STRT_DATE AND erpapp.DB_NVL_CHAR(HPM.RETR_DATE,erpapp.DB_DATE_TO_CHAR(erpapp.DB_SYSDATE(),'YYYYMMDD')) <= HOM.EFFCT_END_DATE LEFT OUTER JOIN CM_CODE_M CM1 ON CM1.GRP_CD = 'HR_YEA_RUN_TYPE' AND CM1.CD = HYRM.YEA_RUN_TYPE AND CM1.LANG_CD = 'KO' AND (CM1.COMP_CD = '' OR CM1.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE_M CM2 ON CM2.GRP_CD = 'HR_YEA_RUN_SUB_TYPE' AND CM2.CD = HYCR.YEA_RUN_SUB_TYPE AND CM2.LANG_CD = 'KO' AND (CM2.COMP_CD = '' OR CM2.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE_M CM3 ON CM3.GRP_CD = 'HR_YEA_RUN_STAT_CD' AND CM3.CD = HYRM.YEA_RUN_STAT_CD AND CM3.LANG_CD = 'KO' AND (CM3.COMP_CD = '' OR CM3.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE_M CM4 ON CM4.GRP_CD = 'HR_JOB_TITLE' AND CM4.CD = HAM.JOB_TITLE_CD AND CM4.LANG_CD = 'KO' AND (CM4.COMP_CD = '' OR CM4.COMP_CD = 'H100') LEFT OUTER JOIN ( SELECT C.YEA_RUN_ID, C.YEA_RUN_SUB_TYPE, C.EMP_ID, C.COMP_CD FROM (SELECT MST.COMP_CD, MST.YEA_YYYY , EMP.EMP_ID , MAX(RST.DEADLINE_DT) AS DEADLINE_DT FROM HR_YEA_RUN_MASTER MST JOIN HR_YEA_RUN_EMP_INFO EMP ON MST.YEA_RUN_ID = EMP.YEA_RUN_ID JOIN HR_YEA_CALC_RESULT RST ON RST.YEA_RUN_ID = EMP.YEA_RUN_ID AND RST.EMP_ID = EMP.EMP_ID WHERE MST.YEA_YYYY = '2020' AND MST.COMP_CD = 'H100' AND RST.DEADLINE_DT IS NOT NULL GROUP BY MST.COMP_CD, MST.YEA_YYYY , EMP.EMP_ID ) LST JOIN HR_YEA_RUN_MASTER M ON M.YEA_YYYY = LST.YEA_YYYY AND M.COMP_CD = LST.COMP_CD JOIN HR_YEA_RUN_EMP_INFO E ON E.YEA_RUN_ID = M.YEA_RUN_ID AND E.EMP_ID = LST.EMP_ID JOIN HR_YEA_CALC_RESULT C ON C.YEA_RUN_ID = E.YEA_RUN_ID AND C.EMP_ID = LST.EMP_ID AND C.DEADLINE_DT = LST.DEADLINE_DT AND C.DEADLINE_DT IS NOT NULL WHERE M.YEA_YYYY = '2020' AND M.COMP_CD = 'H100' ) LST ON LST.YEA_RUN_ID = HYCR.YEA_RUN_ID AND LST.YEA_RUN_SUB_TYPE = HYCR.YEA_RUN_SUB_TYPE AND LST.EMP_ID = HYCR.EMP_ID LEFT OUTER JOIN CM_CODE_M CM5 – ON CM5.GRP_CD = 'HR_YEA_WTHOLD_RCPT_LIST' AND CM5.CD = '2020' AND CM5.LANG_CD = 'KO' AND (CM5.COMP_CD = '' OR CM5.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE CC5 – ON CC5.GRP_CD = 'HR_YEA_WTHOLD_RCPT_LIST' AND CC5.CD = '2020' AND (CC5.COMP_CD = '' OR CC5.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE_M CM6 – ON CM6.GRP_CD = 'HR_YEA_DONATE_REPORT' AND CM6.CD = '2020' AND CM6.LANG_CD = 'KO' AND (CM6.COMP_CD = '' OR CM6.COMP_CD = 'H100') LEFT OUTER JOIN CM_CODE_M CM7 – JSP ON CM7.GRP_CD = 'HR_YEA_CALC_RSLT_PAGE_LIST' AND CM7.CD = '2020' AND CM7.LANG_CD = 'KO' AND (CM7.COMP_CD = '' OR CM7.COMP_CD = 'H100') LEFT OUTER JOIN CM_USER CU ON CU.COMP_CD = HYCR.COMP_CD AND CU.USER_NM = HPM.EMP_NO LEFT OUTER JOIN CM_CODE_M CM8 ON CM8.GRP_CD = 'HR_YEA_FSE_TYPE' AND CM8.CD = HYRI.FSE_TYPE AND CM8.LANG_CD = 'KO' AND (CM8.COMP_CD = '*' OR CM8.COMP_CD = 'H100') WHERE HYCR.COMP_CD = 'H100' AND HYRM.YEA_YYYY = '2020' AND erpapp.DB_NVL_CHAR(HPM.RETR_DATE,erpapp.DB_DATE_TO_CHAR(erpapp.DB_SYSDATE(),'YYYYMMDD')) >= HAM.EFFCT_STRT_DATE AND erpapp.DB_NVL_CHAR(HPM.RETR_DATE,erpapp.DB_DATE_TO_CHAR(erpapp.DB_SYSDATE(),'YYYYMMDD')) <= HAM.EFFCT_END_DATE AND HYRM.YEA_RUN_TYPE = 'D' AND HYRM.YEA_RUN_SEQ = 3 AND HYCR.YEA_RUN_SUB_TYPE = 'D' AND HYCR.YEA_RUN_ID = 7 AND HYCR.EMP_ID = 1255 limit 0, 10000
Connection ID (thread ID): 7065
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
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.
2020-06-04 1:11:51 0 [Note] InnoDB: Using Linux native AIO
2020-06-04 1:11:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-06-04 1:11:51 0 [Note] InnoDB: Uses event mutexes
2020-06-04 1:11:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-04 1:11:51 0 [Note] InnoDB: Number of pools: 1
2020-06-04 1:11:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-06-04 1:11:51 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2020-06-04 1:11:51 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-04 1:11:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-06-04 1:11:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58605282037
2020-06-04 1:11:52 0 [Note] InnoDB: Transaction 214161732 was in the XA prepared state.
2020-06-04 1:11:52 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2020-06-04 1:11:52 0 [Note] InnoDB: Trx id counter is 214161733
2020-06-04 1:11:52 0 [Note] InnoDB: Starting final batch to recover 1830 pages from redo log.
2020-06-04 1:11:52 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065
2020-06-04 1:11:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-04 1:11:52 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2020-06-04 1:11:52 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2020-06-04 1:11:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-04 1:11:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-04 1:11:52 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-04 1:11:52 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.
2020-06-04 1:11:52 0 [Note] InnoDB: Waiting for purge to start
2020-06-04 1:11:52 0 [Note] InnoDB: 10.3.13 started; log sequence number 58605738865; transaction id 214161735
2020-06-04 1:11:52 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool
2020-06-04 1:11:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-04 1:11:52 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log'
2020-06-04 1:11:52 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog
2020-06-04 1:11:52 0 [Note] Starting crash recovery...
2020-06-04 1:11:52 0 [Note] InnoDB: Starting recovery for XA transactions...
2020-06-04 1:11:52 0 [Note] InnoDB: Transaction 214161732 in prepared state after recovery
2020-06-04 1:11:52 0 [Note] InnoDB: Transaction contains changes to 1 rows
2020-06-04 1:11:52 0 [Note] InnoDB: 1 transactions in prepared state after recovery
2020-06-04 1:11:52 0 [Note] Found 1 prepared transaction(s) in InnoDB
2020-06-04 1:11:52 0 [Note] Crash recovery finished.
2020-06-04 1:11:52 0 [Note] Server socket created on IP: '::'.
2020-06-04 1:11:52 0 [Note] Reading of all Master_info entries succeded
2020-06-04 1:11:52 0 [Note] Added new Master_info '' to hash table
2020-06-04 1:11:52 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections.
Version: '10.3.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 19815 Source distribution
2020-06-04 1:11:52 9 [ERROR] mysqld: Table 'general_log' is marked as crashed and should be repaired
2020-06-04 1:12:01 16 [ERROR] Failed to write to mysql.general_log: Lock wait timeout exceeded; try restarting transaction
2020-06-04 1:12:01 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
2020-06-04 1:12:02 15 [ERROR] Failed to write to mysql.general_log: Lock wait timeout exceeded; try restarting transaction
2020-06-04 1:12:02 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
2020-06-04 1:12:16 26 [ERROR] Failed to write to mysql.general_log: Lock wait timeout exceeded; try restarting transaction
2020-06-04 1:12:16 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
2020-06-04 1:12:28 0 [Note] InnoDB: Buffer pool(s) load completed at 200604 1:12:28
2020-06-04 1:12:31 33 [ERROR] Failed to write to mysql.general_log: Lock wait timeout exceeded; try restarting transaction
2020-06-04 1:12:31 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
2020-06-04 1:12:46 39 [ERROR] Failed to write to mysql.general_log: Lock wait timeout exceeded; try restarting transaction
2020-06-04 1:12:46 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
2020-06-04 1:13:02 53 [Warning] Aborted connection 53 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error writing communication packets)
200604 1:14:14 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attachments
Issue Links
- duplicates
-
MDEV-18467 Server crashes in fix_semijoin_strategies_for_picked_join_order
- Closed