Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22793

when i using specific query, mariadb restarting.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3
    • Fix Version/s: N/A
    • Component/s: Query Cache
    • Labels:
      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              masewonj seungwonjang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration