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

lost connection to mysql server during query - CTE

    XMLWordPrintable

    Details

      Description

      When I excute the query using CTE which include 'group by', 'max function' etc.
      Error was occured, and there was an message 'lost connection to mysql server during query'
      And DB restart again.
      I checked with mysqlcheck and everything reported fine.
      I am not sure why it is happened.

      Stack trace

      pure virtual method called
      terminate called without an active exception
      190312  6:08:40 [ERROR] mysqld got signal 6 ;
      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.2.11-MariaDB-log
      key_buffer_size=16777216
      read_buffer_size=262144
      max_used_connections=3
      max_threads=502
      thread_count=10
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1183685 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x2aeb03055008
      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 = 0x2ae92af0ad40 thread_stack 0x40000
      /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x562be500656e]
      /rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x30d)[0x562be4a7f7ed]
      /lib64/libpthread.so.0(+0xf100)[0x2ae92b1d8100]
      /lib64/libc.so.6(gsignal+0x37)[0x2ae92cadd5f7]
      /lib64/libc.so.6(abort+0x148)[0x2ae92cadece8]
      /usr/lib64/libstdc++.so.6(_ZN9__gnu_cxx27__verbose_terminate_handlerEv+0x155)[0x2ae92c501515]
      /usr/lib64/libstdc++.so.6(+0x5e6a6)[0x2ae92c4ff6a6]
      /usr/lib64/libstdc++.so.6(+0x5e6d3)[0x2ae92c4ff6d3]
      /usr/lib64/libstdc++.so.6(+0x5f19f)[0x2ae92c50019f]
      mysys/stacktrace.c:268(my_print_stacktrace)[0x562be4a858d7]
      sql/signal_handler.cc:168(handle_fatal_signal)[0x562be499be49]
      sql/table.cc:7694(TABLE::insert_all_rows_into_tmp_table(THD*, TABLE*, TMP_TABLE_PARAM*, bool))[0x562be48cd0ab]
      sql/sql_derived.cc:197(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x562be48ccce4]
      /rdsdbbin/mysql/bin/mysqld(_ZN13st_join_table12preread_initEv+0xdf)[0x562be492410f]
      sql/sql_select.cc:11889(st_join_table::preread_init())[0x562be4924418]
      sql/sql_select.cc:18183(do_select)[0x562be494360f]
      sql/sql_select.cc:3310(JOIN::exec())[0x562be4943823]
      sql/sql_select.cc:3711(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*))[0x562be494397a]
      sql/sql_derived.cc:1086(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x562be48ccfb0]
      sql/sql_derived.cc:197(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x562be48ccce4]
      sql/sql_select.cc:11889(st_join_table::preread_init())[0x562be492410f]
      sql/sql_select.cc:18606(sub_select(JOIN*, st_join_table*, bool))[0x562be4924418]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be492429e]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be492429e]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be49242e4]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be492429e]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be49242e4]
      sql/sql_class.h:3532(THD::get_stmt_da())[0x562be491c6f3]
      sql/sql_select.cc:18646(sub_select(JOIN*, st_join_table*, bool))[0x562be492429e]
      sql/sql_select.cc:18183(do_select)[0x562be494360f]
      sql/sql_select.cc:3310(JOIN::exec())[0x562be4943823]
      sql/sql_select.cc:3711(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*))[0x562be494397a]
      sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x562be49444d4]
      sql/sql_parse.cc:6566(execute_sqlcom_select)[0x562be482983f]
      sql/sql_parse.cc:3483(mysql_execute_command(THD*))[0x562be48ef77c]
      sql/sql_parse.cc:8047(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562be48f66ee]
      sql/sql_parse.cc:1809(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562be48f968d]
      sql/sql_parse.cc:1366(do_command(THD*))[0x562be48fa289]
      sql/sql_connect.cc:1397(do_handle_one_connection(CONNECT*))[0x562be49bea2a]
      sql/sql_connect.cc:1305(handle_one_connection)[0x562be49beb4d]
      perfschema/pfs.cc:1866(pfs_spawn_thread)[0x562be4fc0fd2]
      /lib64/libpthread.so.0(+0x7dc5)[0x2ae92b1d0dc5]
      /lib64/libc.so.6(clone+0x6d)[0x2ae92cb9ec9d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x2aeb03082020): WITH RECURSIVE  ORG_MST  (   ORG_ID  ,COMP_CD  ,HR_BIZPLC_CD  ,PARENT_ORG_ID  ,ORG_NM  ,ORG_TYPE  ,ORG_LVL  ,HR_ORG_CD  ,ENG_ORG_NM  ,ORG_FULL_NM  ,SORT_CD  )  AS ( --               SELECT HOM.ORG_ID        ,HOM.COMP_CD        ,HOM.HR_BIZPLC_CD        ,HOM.PARENT_ORG_ID        ,HOM.ORG_NM        ,HOM.ORG_TYPE        ,HOM.ORG_LVL        ,HOM.HR_ORG_CD        ,HOM.ENG_ORG_NM        ,HOM.ORG_FULL_NM        ,HOM.SORT_CD    FROM HR_ORG_MST HOM   WHERE HOM.COMP_CD = 'LG01'     AND HOM.HR_BIZPLC_CD =  'HQ'     -- SR NO : 28683     AND '20190212' BETWEEN HOM.EFFCT_STRT_DATE AND HOM.EFFCT_END_DATE     AND HOM.ORG_ID in ( SELECT DISTINCT ORG_ID                          FROM HR_ASG_MST ham                         WHERE '20190212' BETWEEN HAM.EFFCT_STRT_DATE AND HAM.EFFCT_END_DATE                            AND HAM.HR_BIZPLC_CD like '%'                       )  UNION ALL  SELECT HOM.ORG_ID        ,HOM.COMP_CD        ,HOM.HR_BIZPLC_CD        ,HOM.PARENT_ORG_ID        ,HOM.ORG_NM        ,HOM.ORG_TYPE        ,HOM.ORG_LVL        ,HOM.HR_ORG_CD        ,HOM.ENG_ORG_NM        ,HOM.ORG_FULL_NM        ,HOM.SORT_CD    FROM HR_ORG_MST HOM   WHERE HOM.COMP_CD = 'LG01'     AND HOM.HR_BIZPLC_CD ='HQ'     -- SR NO : 28683     AND hom.ORG_CLOSE_DATE LIKE '2019%'     AND HOM.ORG_ID in ( SELECT DISTINCT ORG_ID                           FROM HR_ASG_MST ham                          WHERE '20190212' BETWEEN HAM.EFFCT_STRT_DATE AND HAM.EFFCT_END_DATE                            AND HAM.HR_BIZPLC_CD like '%'                       )     --     AND HOM.EFFCT_END_DATE = HOM.ORG_CLOSE_DATE    )  ,ORG_HIERARCHY   (   SEARCH_ORG_ID  ,ORG_ID  ,PARENT_ORG_ID  ,ORG_LVL  ,SORT_CD  ,HR_BIZPLC_CD  ,NODE_LVL  )  AS ( --                  SELECT OM.ORG_ID SEARCH_ORG_ID        ,OM.ORG_ID         ,OM.PARENT_ORG_ID        ,OM.ORG_LVL        ,OM.SORT_CD        ,OM.HR_BIZPLC_CD        ,0 AS NODE_LVL    FROM ORG_MST OM   UNION ALL  SELECT OH.SEARCH_ORG_ID         ,OM.ORG_ID ORG_ID        ,OM.PARENT_ORG_ID        ,OM.ORG_LVL        ,OM.SORT_CD        ,OM.HR_BIZPLC_CD        ,NODE_LVL + 1 AS NODE_LVL    FROM ORG_MST OM    JOIN ORG_HIERARCHY OH ON (OM.PARENT_ORG_ID = OH.ORG_ID)  )  ,VAR_LIST   (  PREV_WEEK2_DATE  )  AS (  -- SELECT erpapp.DB_DATE_TO_CHAR(erpapp.db_add_days(erpapp.db_sysdate(), -14), 'YYYYMMDD') PREV_WEEK2_DATE  SELECT '20190201' PREV_WEEK2_DATE  FROM DUAL  )  ,VAR_DATE   (   STRT_DT  ,END_DT  )  AS (  -- SELECT erpapp.db_substr(HAM.STRT_DT, 1, 8) STRT_DT  --      ,erpapp.db_substr(HAM.END_DT, 1, 8) END_DT  SELECT '20180101' STRT_DT        ,'99991231' END_DT          FROM hr_cm_admin_msg HAM   WHERE HAM.MSG_GRP_CD = 'PRM_CORE_TLNT'     AND HAM.MSG_CD = 'RETRIEVE_PERIOD'  )  ,EMP_LIST  (   ORG_ID  ,TOT_CNT  ,RISK_GRD_CD_G  ,RISK_GRD_CD_Y  ,RISK_GRD_CD_O  ,RISK_GRD_CD_R  ,RISK_GRD_CD_B  ,RISK_GRD_CD_2W_G  ,RISK_GRD_CD_2W_Y  ,RISK_GRD_CD_2W_O  ,RISK_GRD_CD_2W_R  ,RISK_GRD_CD_2W_B  )   AS ( --                      SELECT HAM.ORG_ID        ,COUNT(1) TOT_CNT        ,SUM(CASE WHEN TRG.RSK_GRD_CD = 'G' THEN 1 ELSE 0 END) RISK_GRD_CD_G        ,SUM(CASE WHEN TRG.RSK_GRD_CD = 'Y' THEN 1 ELSE 0 END) RISK_GRD_CD_Y        ,SUM(CASE WHEN TRG.RSK_GRD_CD = 'O' THEN 1 ELSE 0 END) RISK_GRD_CD_O        ,SUM(CASE WHEN TRG.RSK_GRD_CD = 'R' THEN 1 ELSE 0 END) RISK_GRD_CD_R        ,SUM(CASE WHEN HPM.EMP_STAT_CD = 'T' OR TRG.RSK_GRD_CD = 'B' THEN 1 ELSE 0 END) RISK_GRD_CD_B        ,SUM(CASE WHEN PRE.CHG_FLAG > 0 AND TRG.RSK_GRD_CD = 'G' THEN 1 ELSE 0 END) RISK_GRD_CD_2W_G        ,SUM(CASE WHEN PRE.CHG_FLAG > 0 AND TRG.RSK_GRD_CD = 'Y' THEN 1 ELSE 0 END) RISK_GRD_CD_2W_Y        ,SUM(CASE WHEN PRE.CHG_FLAG > 0 AND TRG.RSK_GRD_CD = 'O' THEN 1 ELSE 0 END) RISK_GRD_CD_2W_O        ,SUM(CASE WHEN PRE.CHG_FLAG > 0 AND TRG.RSK_GRD_CD = 'R' THEN 1 ELSE 0 END) RISK_GRD_CD_2W_R        ,SUM(CASE WHEN PRE.CHG_FLAG > 0 AND (HPM.EMP_STAT_CD = 'T' OR TRG.RSK_GRD_CD = 'B') THEN 1 ELSE 0 END) RISK_GRD_CD_2W_B    FROM HR_PRM_CORE_TLNT_MST CTM    -- JOIN (SELECT erpapp.DB_DATE_TO_CHAR(erpapp.db_add_days(erpapp.db_sysdate(), -14), 'YYYYMMDD') PREV_WEEK2_DATE FROM DUAL) TMP ON (1=1)     JOIN (SELECT '20190201' PREV_WEEK2_DATE FROM DUAL) TMP ON (1=1)    JOIN VAR_DATE VD ON (1=1)    JOIN CM_CODE CT ON (CT.GRP_CD = 'HR_CORE_TALENT_DETAIL_TYPE'                    AND CT.CD = CTM.CORE_TLNT_DTL_TYPE                    AND CT.INV_ORG_ID = -1                    AND CT.COMP_CD = CTM.COMP_CD)    JOIN HR_PSN_MST HPM ON (CTM.EMP_ID = HPM.EMP_ID                        AND COALESCE(HPM.RETR_DATE, '99991231') >= VD.STRT_DT)    JOIN HR_ASG_MST HAM ON (HPM.EMP_ID = HAM.EMP_ID                        AND '20190212' BETWEEN HAM.EFFCT_STRT_DATE AND HAM.EFFCT_END_DATE)    LEFT OUTER JOIN HR_PRM_CORE_TLNT_RISK_GRADE TRG ON (CTM.EMP_ID = TRG.EMP_ID                                                    AND TRG.LST_YN = 'Y'                                                    AND TRG.CRT_DT >= CTM.STRT_DATE                                                    AND erpapp.db_substr(TRG.CRT_DT, 1, 8) <= CTM.END_DATE)    LEFT OUTER JOIN (SELECT TRG.EMP_ID                           ,COUNT(1) CHG_FLAG                           ,MAX(TRG.RSK_GRD_CHNG_DATE) RSK_GRD_CHNG_DATE                       FROM HR_PRM_CORE_TLNT_RISK_GRADE TRG                       JOIN VAR_LIST TMP ON (1=1)                      WHERE TRG.CRT_DT >= TMP.PREV_WEEK2_DATE                        AND TRG.PRE_RSK_GRD_CD IS NOT NULL                        AND TRG.PRE_RSK_GRD_CD <> TRG.RSK_GRD_CD                      GROUP BY TRG.EMP_ID) PRE ON (CTM.EMP_ID = PRE.EMP_ID                                               AND PRE.RSK_GRD_CHNG_DATE BETWEEN CTM.STRT_DATE AND CTM.END_DATE)   WHERE erpapp.db_nvl_char(CTM.END_DATE, '99991231') >= VD.STRT_DT    AND CTM.STRT_DATE <= VD.END_DT    AND CTM.COMP_CD = 'LG01'    AND ((erpapp.db_nvl_char('N', 'N') = 'N' AND erpapp.db_nvl_char(CT.ATTR2, '') = 'Y')     OR (erpapp.db_nvl_char('N', 'N') = 'Y'))  --   AND CTM.EMP_ID <> @LOGIN_EMP_ID  --   AND CT.PRNT_CD = @CORE_TLNT_TYPE  --   AND CTM.MNGMT_ORG_LVL_CD = @MNGMT_ORG_LVL_CD  --   AND CTM.MNGMT_GRD_CD = @MNGMT_GRD_CD     AND  HAM.HR_BIZPLC_CD like '%'   GROUP BY HAM.ORG_ID  )  ,ORG_SUM   (   ORG_ID  ,TOT_CNT  ,RISK_GRD_CD_G  ,RISK_GRD_CD_Y  ,RISK_GRD_CD_O  ,RISK_GRD_CD_R  ,RISK_GRD_CD_B  ,RISK_GRD_CD_2W_G  ,RISK_GRD_CD_2W_Y  ,RISK_GRD_CD_2W_O  ,RISK_GRD_CD_2W_R  ,RISK_GRD_CD_2W_B  )  AS (  SELECT OH.SEARCH_ORG_ID ORG_ID        ,SUM(EL.TOT_CNT) TOT_CNT        ,SUM(RISK_GRD_CD_G) RISK_GRD_CD_G        ,SUM(RISK_GRD_CD_Y) RISK_GRD_CD_Y        ,SUM(RISK_GRD_CD_O) RISK_GRD_CD_O        ,SUM(RISK_GRD_CD_R) RISK_GRD_CD_R        ,SUM(RISK_GRD_CD_B) RISK_GRD_CD_B        ,SUM(RISK_GRD_CD_2W_G) RISK_GRD_CD_2W_G        ,SUM(RISK_GRD_CD_2W_Y) RISK_GRD_CD_2W_Y        ,SUM(RISK_GRD_CD_2W_O) RISK_GRD_CD_2W_O        ,SUM(RISK_GRD_CD_2W_R) RISK_GRD_CD_2W_R        ,SUM(RISK_GRD_CD_2W_B) RISK_GRD_CD_2W_B    FROM ORG_HIERARCHY OH    LEFT OUTER JOIN EMP_LIST EL ON (EL.ORG_ID = OH.ORG_ID)   GROUP BY OH.SEARCH_ORG_ID  )  SELECT DISTINCT           OM.ORG_ID         ,OM.COMP_CD         ,OM.HR_BIZPLC_CD         ,OM.PARENT_ORG_ID         ,OM.ORG_NM         ,OM.ORG_LVL         ,TMP.NODE_LVL         ,OM.HR_ORG_CD         ,OM.SORT_CD         ,HPM.EMP_ID AS MGR_EMP_ID         ,HPM.EMP_NO AS MGR_EMP_NO         ,HPM.EMP_NM AS MGR_EMP_NM         ,HAM.JOB_TITLE_CD AS MGR_JOB_TITLE_CD         ,CCM.CD_NM AS MGR_JOB_TITLE_NM          ,OOS.TOT_CNT         ,OOS.RISK_GRD_CD_G         ,OOS.RISK_GRD_CD_Y         ,OOS.RISK_GRD_CD_O         ,OOS.RISK_GRD_CD_R         ,OOS.RISK_GRD_CD_B         ,OOS.RISK_GRD_CD_2W_G         ,OOS.RISK_GRD_CD_2W_Y         ,OOS.RISK_GRD_CD_2W_O         ,OOS.RISK_GRD_CD_2W_R         ,OOS.RISK_GRD_CD_2W_B    FROM ORG_MST OM    JOIN ORG_SUM OOS ON (OOS.ORG_ID = OM.ORG_ID)    LEFT OUTER JOIN HR_ORG_MGR HOM ON (HOM.ORG_ID = OM.ORG_ID                                   AND HOM.COMP_CD = OM.COMP_CD                                   AND '20190101' BETWEEN HOM.EFFCT_STRT_DATE AND HOM.EFFCT_END_DATE)    LEFT OUTER JOIN HR_PSN_MST HPM ON (HPM.EMP_ID = HOM.MGR_EMP_ID)    LEFT OUTER JOIN HR_ASG_MST HAM ON (HAM.EMP_ID = HPM.EMP_ID                                   AND '20190101' BETWEEN HAM.EFFCT_STRT_DATE AND HAM.EFFCT_END_DATE )    LEFT OUTER JOIN CM_CODE_M CCM ON (CCM.GRP_CD = 'HR_JOB_TITLE'                                  AND CCM.COMP_CD = HAM.COMP_CD                                  AND CCM.INV_ORG_ID = -1                                  AND CCM.CD = HAM.JOB_TITLE_CD                                  AND CCM.LANG_CD = 'KO')    LEFT OUTER JOIN (SELECT ORG_ID, MAX(NODE_LVL) NODE_LVL FROM ORG_HIERARCHY GROUP BY ORG_ID) TMP ON (OM.ORG_ID = TMP.ORG_ID)   ORDER BY OM.SORT_CD
      Connection ID (thread ID): 11
      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
       
      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.
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Uses event mutexes
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Using Linux native AIO
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Number of pools: 1
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Using SSE2 crc32 instructions
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Completed initialization of buffer pool
      2019-03-12  6:08:59 47929454798592 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Highest supported file format is Barracuda.
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Starting crash recovery from checkpoint LSN=35242687941
      2019-03-12  6:08:59 47921556463296 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.019454', position 671
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: Creating shared tablespace for temporary tables
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: Waiting for purge to start
      2019-03-12  6:09:04 47921556463296 [Note] InnoDB: 5.7.20 started; log sequence number 35242687950
      2019-03-12  6:09:04 47929544972032 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool
      2019-03-12  6:09:04 47921556463296 [Note] Plugin 'FEEDBACK' is disabled.
      2019-03-12  6:09:04 47921556463296 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog
      2019-03-12  6:09:04 47921556463296 [Note] Starting crash recovery...
      2019-03-12  6:09:04 47921556463296 [Note] Crash recovery finished.
      2019-03-12  6:09:04 47921556463296 [Note] Server socket created on IP: '::'.
      2019-03-12  6:09:04 47921556463296 [Note] Reading of all Master_info entries succeded
      2019-03-12  6:09:04 47921556463296 [Note] Added new Master_info '' to hash table
      2019-03-12  6:09:04 47921556463296 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections.
      Version: '10.2.11-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server
      2019-03-12  6:09:10 47929544972032 [Note] InnoDB: Buffer pool(s) load completed at 190312  6:09:10
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alice Alice Sherepa
              Reporter:
              khy Hyeyoung Kim
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: