[MDEV-18906] lost connection to mysql server during query - CTE Created: 2019-03-13  Updated: 2019-04-15  Resolved: 2019-04-15

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - CTE
Affects Version/s: 10.2.11
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hyeyoung Kim Assignee: Alice Sherepa
Resolution: Incomplete Votes: 0
Labels: need_feedback

Issue Links:
Relates
relates to MDEV-17024 Crash on large query Closed

 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



 Comments   
Comment by Alice Sherepa [ 2019-03-13 ]

Could you please upgrade to the recent version and see if the bug is still reproducible. There have been numerous bug fixes made since 10.2.11

Generated at Thu Feb 08 08:47:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.