2019-11-04 19:31:45 74949 [Warning] Aborted connection 74949 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got timeout reading communication packets) 2019-11-04 19:32:05 74856 [Warning] Aborted connection 74856 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got timeout reading communication packets) 2019-11-04 19:32:16 74957 [Warning] Aborted connection 74957 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got timeout reading communication packets) 2019-11-04 20:06:48 74093 [Warning] Aborted connection 74093 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got timeout reading communication packets) 191104 23:47:49 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=97 max_threads=1002 thread_count=70 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ae43af2d108 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 = 0x2ae14edc1de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55912a8725f9] /rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x57d)[0x55912a3055ed] 2019-11-04 23:48:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:48:01 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:48:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:48:01 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:48:01 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:48:01 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:48:01 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:48:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:48:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12547168963 2019-11-04 23:48:01 0 [Note] InnoDB: Starting final batch to recover 2 pages from redo log. 2019-11-04 23:48:02 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:48:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:48:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:48:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:48:02 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:48:02 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:48:02 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:48:02 0 [Note] InnoDB: 10.3.8 started; log sequence number 12547169093; transaction id 1130423 2019-11-04 23:48:02 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:48:02 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:48:02 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:48:02 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:48:02 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:48:02 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:48:02 0 [Note] Starting crash recovery... 2019-11-04 23:48:02 0 [Note] Crash recovery finished. 2019-11-04 23:48:02 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:48:02 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:48:02 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:48:02 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:48:02 9 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-04 23:48:02 10 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:48:03 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=2 max_threads=1002 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b209a650008 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 = 0x2b1d4fe96de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55c03845f5f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55c037ef25ed] sigaction.c:0(__restore_rt)[0x2b1d50c15100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55c03849ad99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55c037d20636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55c037d2690f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55c037d2e6cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c037d30fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c037d31b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55c037dfaeec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55c037dfb0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55c0384116fa] pthread_create.c:0(start_thread)[0x2b1d50c0ddc5] /lib64/libc.so.6(clone+0x6d)[0x2b1d51430c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b209a6a06e0): WITH W_DATA AS ( SELECT 1 AS ORD_NUM , 'CNYS' AS CNYS_BRHS_TYPE , LPAD(REPLACE(A01.DONG_NAME, ' ', ''), 4, 0) AS DONG_ORD , A01.HO_NAME AS HO_ORD , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A01.MVN_DATE /* */ , A01.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_CNYS_INFO A01 LEFT OUTER JOIN RNDP.TB_SYS_USER A02 /* */ ON A02.USER_NO = A01.MVN_USER_NO WHERE A01.MVN_USER_NAME != ' ' UNION ALL SELECT 2 AS ORD_NUM , 'BRHS' AS CNYS_BRHS_TYPE , DONG_NAME AS DONG_ORD , CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.HO_NAME, 1) IN ('A', 'B') THEN LPAD(SUBSTRING(A01.HO_NAME, 2), 11, 0) ELSE LPAD(A01.HO_NAME, 11, 0) END HO_ORD /* */ , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A02.MVN_DATE /* */ , A02.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_BRHS_INFO A01 /* */ INNER JOIN RNDP.TB_SUP_BRHS_MVN_INFO A02 /* */ ON A01.MVN_SN = A02.MVN_SN LEFT OUTER JOIN RNDP.TB_SYS_USER A03 /* */ ON A03.USER_NO = A02.MVN_MAN_USER_NO ) SELECT A01.CNYS_BRHS_TYPE , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , DATE_FORMAT(A01.MVN_DATE, '%Y.%m.%d') AS MVN_DATE /* */ , DATE_FORMAT(A01.LVHS_DATE, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.USER_NAME /* ( * ) */ FROM W_DATA A01 WHERE 1 = 1 LIMIT 0, 200 Connection ID (thread ID): 10 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. 2019-11-04 23:49:21 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:49:21 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:49:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:49:21 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:49:21 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:49:21 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:49:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:49:21 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:49:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12547167443 2019-11-04 23:49:22 0 [Note] InnoDB: Starting final batch to recover 2 pages from redo log. 2019-11-04 23:49:22 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:49:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:49:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:49:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:49:22 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:49:22 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:49:22 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:49:22 0 [Note] InnoDB: 10.3.8 started; log sequence number 12547169093; transaction id 1130423 2019-11-04 23:49:22 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:49:22 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:49:22 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:49:22 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:49:22 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:49:22 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:49:22 0 [Note] Starting crash recovery... 2019-11-04 23:49:22 0 [Note] Crash recovery finished. 2019-11-04 23:49:22 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:49:22 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:49:22 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:49:22 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:49:22 9 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-04 23:49:23 12 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-04 23:49:24 16 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-04 23:49:25 21 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-04 23:49:30 0 [Note] InnoDB: Buffer pool(s) load completed at 191104 23:49:30 2019-11-04 23:49:33 60 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:49:44 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=51 max_threads=1002 thread_count=58 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ba956ca9588 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 = 0x2ba6bf13fde8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x5594e60f25f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x5594e5b855ed] sigaction.c:0(__restore_rt)[0x2ba617788100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x5594e612dd99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x5594e59b3636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x5594e59b990f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x5594e59c16cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5594e59c3fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5594e59c4b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x5594e5a8deec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x5594e5a8e0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x5594e60a46fa] pthread_create.c:0(start_thread)[0x2ba617780dc5] /lib64/libc.so.6(clone+0x6d)[0x2ba617fa3c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2ba956ceefa0): WITH W_DATA AS ( SELECT 1 AS ORD_NUM , 'CNYS' AS CNYS_BRHS_TYPE , LPAD(REPLACE(A01.DONG_NAME, ' ', ''), 4, 0) AS DONG_ORD , A01.HO_NAME AS HO_ORD , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A01.MVN_DATE /* */ , A01.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_CNYS_INFO A01 LEFT OUTER JOIN RNDP.TB_SYS_USER A02 /* */ ON A02.USER_NO = A01.MVN_USER_NO WHERE A01.MVN_USER_NAME != ' ' UNION ALL SELECT 2 AS ORD_NUM , 'BRHS' AS CNYS_BRHS_TYPE , DONG_NAME AS DONG_ORD , CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.HO_NAME, 1) IN ('A', 'B') THEN LPAD(SUBSTRING(A01.HO_NAME, 2), 11, 0) ELSE LPAD(A01.HO_NAME, 11, 0) END HO_ORD /* */ , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A02.MVN_DATE /* */ , A02.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_BRHS_INFO A01 /* */ INNER JOIN RNDP.TB_SUP_BRHS_MVN_INFO A02 /* */ ON A01.MVN_SN = A02.MVN_SN LEFT OUTER JOIN RNDP.TB_SYS_USER A03 /* */ ON A03.USER_NO = A02.MVN_MAN_USER_NO ) SELECT A01.CNYS_BRHS_TYPE , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , DATE_FORMAT(A01.MVN_DATE, '%Y.%m.%d') AS MVN_DATE /* */ , DATE_FORMAT(A01.LVHS_DATE, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.USER_NAME /* ( * ) */ FROM W_DATA A01 WHERE 1 = 1 LIMIT 0, 200 Connection ID (thread ID): 64 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. 2019-11-04 23:50:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:50:01 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:50:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:50:01 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:50:01 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:50:01 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:50:01 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:50:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:50:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12547453096 2019-11-04 23:50:01 0 [Note] InnoDB: Transaction 1130724 was in the XA prepared state. 2019-11-04 23:50:01 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-04 23:50:01 0 [Note] InnoDB: Trx id counter is 1130725 2019-11-04 23:50:01 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log. 2019-11-04 23:50:02 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:50:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:50:02 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-04 23:50:02 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-04 23:50:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:50:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:50:02 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:50:02 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:50:02 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:50:02 0 [Note] InnoDB: 10.3.8 started; log sequence number 12547484851; transaction id 1130727 2019-11-04 23:50:02 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:50:02 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:50:02 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:50:02 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:50:02 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:50:02 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:50:02 0 [Note] Starting crash recovery... 2019-11-04 23:50:02 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-04 23:50:02 0 [Note] InnoDB: Transaction 1130724 in prepared state after recovery 2019-11-04 23:50:02 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-04 23:50:02 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-04 23:50:02 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-04 23:50:02 0 [Note] Crash recovery finished. 2019-11-04 23:50:02 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:50:02 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:50:02 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:50:02 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:50:02 9 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-04 23:50:02 10 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 2019-11-04 23:50:02 11 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 191104 23:50:02 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=4 max_threads=1002 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b0e15e70088 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 = 0x2b0acb77fde8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x56365c1fe5f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x56365bc915ed] sigaction.c:0(__restore_rt)[0x2b0acc4fe100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x56365c239d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x56365babf636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x56365bac590f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x56365bacd6cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56365bacffad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56365bad0b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x56365bb99eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x56365bb9a0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x56365c1b06fa] pthread_create.c:0(start_thread)[0x2b0acc4f6dc5] /lib64/libc.so.6(clone+0x6d)[0x2b0accd19c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b0e15ebcda0): WITH W_DATA AS ( SELECT 1 AS ORD_NUM , 'CNYS' AS CNYS_BRHS_TYPE , LPAD(REPLACE(A01.DONG_NAME, ' ', ''), 4, 0) AS DONG_ORD , A01.HO_NAME AS HO_ORD , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A01.MVN_DATE /* */ , A01.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A01.MVN_USER_NAME, NULL, A02.USER_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_CNYS_INFO A01 LEFT OUTER JOIN RNDP.TB_SYS_USER A02 /* */ ON A02.USER_NO = A01.MVN_USER_NO WHERE A01.MVN_USER_NAME != ' ' UNION ALL SELECT 2 AS ORD_NUM , 'BRHS' AS CNYS_BRHS_TYPE , DONG_NAME AS DONG_ORD , CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.HO_NAME, 1) IN ('A', 'B') THEN LPAD(SUBSTRING(A01.HO_NAME, 2), 11, 0) ELSE LPAD(A01.HO_NAME, 11, 0) END HO_ORD /* */ , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , A02.MVN_DATE /* */ , A02.LVHS_DATE /* */ , CONCAT(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 1, 1), REGEXP_REPLACE(SUBSTR(IF(A03.USER_NAME, NULL, A02.MVN_NAME), 2),'[ - a-z]','*')) AS USER_NAME /* ( * ) */ FROM RNDP.TB_SUP_BRHS_INFO A01 /* */ INNER JOIN RNDP.TB_SUP_BRHS_MVN_INFO A02 /* */ ON A01.MVN_SN = A02.MVN_SN LEFT OUTER JOIN RNDP.TB_SYS_USER A03 /* */ ON A03.USER_NO = A02.MVN_MAN_USER_NO ) SELECT A01.CNYS_BRHS_TYPE , A01.DONG_NAME /* */ , A01.HO_NAME /* */ , DATE_FORMAT(A01.MVN_DATE, '%Y.%m.%d') AS MVN_DATE /* */ , DATE_FORMAT(A01.LVHS_DATE, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.USER_NAME /* ( * ) */ FROM W_DATA A01 WHERE 1 = 1 LIMIT 0, 200 Connection ID (thread ID): 10 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. 2019-11-04 23:51:21 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:51:21 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:51:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:51:21 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:51:21 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:51:21 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:51:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:51:21 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:51:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12547386321 2019-11-04 23:51:22 0 [Note] InnoDB: Transaction 1130730 was in the XA prepared state. 2019-11-04 23:51:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-04 23:51:22 0 [Note] InnoDB: Trx id counter is 1130731 2019-11-04 23:51:22 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log. 2019-11-04 23:51:22 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:51:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:51:22 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-04 23:51:22 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-04 23:51:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:51:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:51:22 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:51:22 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:51:22 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:51:22 0 [Note] InnoDB: 10.3.8 started; log sequence number 12547485531; transaction id 1130733 2019-11-04 23:51:22 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:51:22 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:51:22 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:51:22 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:51:22 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:51:22 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:51:22 0 [Note] Starting crash recovery... 2019-11-04 23:51:22 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-04 23:51:22 0 [Note] InnoDB: Transaction 1130730 in prepared state after recovery 2019-11-04 23:51:22 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-04 23:51:22 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-04 23:51:22 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-04 23:51:22 0 [Note] Crash recovery finished. 2019-11-04 23:51:22 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:51:22 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:51:22 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:51:22 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:51:23 9 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-04 23:51:23 10 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-04 23:51:23 12 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:51:23 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=4 max_threads=1002 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b9e26830ec8 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 = 0x2b9df61cede8 thread_stack 0x40000 2019-11-04 23:51:23 13 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x557d1f0fe5f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x557d1eb915ed] sigaction.c:0(__restore_rt)[0x2b9df6ecb100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x557d1f139d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x557d1e9bf636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x557d1e9c590f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x557d1e9cd6cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557d1e9cffad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557d1e9d0b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x557d1ea99eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x557d1ea9a0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x557d1f0b06fa] pthread_create.c:0(start_thread)[0x2b9df6ec3dc5] /lib64/libc.so.6(clone+0x6d)[0x2b9df76e6c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b9e268839a0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 12 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. 2019-11-04 23:52:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:52:37 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:52:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:52:37 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:52:37 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:52:37 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:52:38 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:52:38 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:52:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12547386321 2019-11-04 23:52:38 0 [Note] InnoDB: Transaction 1130767 was in the XA prepared state. 2019-11-04 23:52:38 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-04 23:52:38 0 [Note] InnoDB: Trx id counter is 1130768 2019-11-04 23:52:38 0 [Note] InnoDB: Starting final batch to recover 17 pages from redo log. 2019-11-04 23:52:38 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:52:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:52:39 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-04 23:52:39 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-04 23:52:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:52:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:52:39 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:52:39 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:52:39 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:52:39 0 [Note] InnoDB: 10.3.8 started; log sequence number 12547501225; transaction id 1130770 2019-11-04 23:52:39 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:52:39 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:52:39 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:52:39 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:52:39 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:52:39 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:52:39 0 [Note] Starting crash recovery... 2019-11-04 23:52:39 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-04 23:52:39 0 [Note] InnoDB: Transaction 1130767 in prepared state after recovery 2019-11-04 23:52:39 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-04 23:52:39 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-04 23:52:39 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-04 23:52:39 0 [Note] Crash recovery finished. 2019-11-04 23:52:39 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:52:39 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:52:39 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:52:39 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:52:39 9 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-04 23:52:39 10 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-04 23:52:39 12 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-04 23:52:45 23 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-04 23:52:48 11 [Warning] Aborted connection 11 to db: 'rndp' user: 'RNDP_MGR' host: '10.33.48.115' (Got an error reading communication packets) 2019-11-04 23:52:54 0 [Note] InnoDB: Buffer pool(s) load completed at 191104 23:52:54 2019-11-04 23:54:02 44 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 2019-11-04 23:54:54 53 [Warning] IP address '10.33.60.97' could not be resolved: Name or service not known 191104 23:56:24 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=24 max_threads=1002 thread_count=31 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ab27fe4dfc8 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 = 0x2aaf90180de8 thread_stack 0x40000 2019-11-04 23:56:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:56:31 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:56:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:56:31 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:56:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:56:31 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:56:31 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:56:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:56:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12551002937 2019-11-04 23:56:31 0 [Note] InnoDB: Transaction 1132413 was in the XA prepared state. 2019-11-04 23:56:31 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-04 23:56:31 0 [Note] InnoDB: Trx id counter is 1132414 2019-11-04 23:56:31 0 [Note] InnoDB: Starting final batch to recover 9 pages from redo log. 2019-11-04 23:56:32 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:56:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:56:32 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-04 23:56:32 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-04 23:56:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:56:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:56:32 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:56:32 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:56:32 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:56:32 0 [Note] InnoDB: 10.3.8 started; log sequence number 12551035754; transaction id 1132416 2019-11-04 23:56:32 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:56:32 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:56:32 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:56:32 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:56:32 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:56:32 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:56:32 0 [Note] Starting crash recovery... 2019-11-04 23:56:32 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-04 23:56:32 0 [Note] InnoDB: Transaction 1132413 in prepared state after recovery 2019-11-04 23:56:32 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-04 23:56:32 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-04 23:56:32 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-04 23:56:32 0 [Note] Crash recovery finished. 2019-11-04 23:56:32 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:56:32 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:56:32 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:56:32 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:56:32 9 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:56:33 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=1 max_threads=1002 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ba35fc5bc88 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 = 0x2ba0156c4de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x556b7e5715f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x556b7e0045ed] sigaction.c:0(__restore_rt)[0x2ba016484100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x556b7e5acd99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x556b7de32636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x556b7de3890f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x556b7de406cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556b7de42fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556b7de43b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x556b7df0ceec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x556b7df0d0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x556b7e5236fa] pthread_create.c:0(start_thread)[0x2ba01647cdc5] /lib64/libc.so.6(clone+0x6d)[0x2ba016c9fc9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2ba35fcabee0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 9 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. 2019-11-04 23:57:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:57:51 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:57:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:57:51 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:57:51 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:57:51 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:57:51 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:57:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:57:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12551002937 2019-11-04 23:57:52 0 [Note] InnoDB: Starting final batch to recover 10 pages from redo log. 2019-11-04 23:57:52 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:57:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:57:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:57:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:57:52 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:57:52 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:57:52 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:57:52 0 [Note] InnoDB: 10.3.8 started; log sequence number 12551036052; transaction id 1132420 2019-11-04 23:57:52 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:57:52 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:57:52 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:57:52 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:57:52 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:57:52 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:57:52 0 [Note] Starting crash recovery... 2019-11-04 23:57:52 0 [Note] Crash recovery finished. 2019-11-04 23:57:52 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:57:52 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:57:52 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:57:52 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:57:53 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-04 23:57:55 12 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 2019-11-04 23:57:55 13 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-04 23:57:56 18 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-04 23:57:58 0 [Note] InnoDB: Buffer pool(s) load completed at 191104 23:57:58 2019-11-04 23:58:20 31 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-04 23:58:25 33 [Warning] IP address '10.33.60.97' could not be resolved: Name or service not known 2019-11-04 23:58:35 36 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:58:35 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=22 max_threads=1002 thread_count=29 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b06ecd51f08 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 = 0x2b03cbde5de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55b77c8835f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55b77c3165ed] sigaction.c:0(__restore_rt)[0x2b039a1db100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55b77c8bed99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55b77c144636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55b77c14a90f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55b77c1526cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b77c154fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b77c155b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55b77c21eeec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55b77c21f0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55b77c8356fa] pthread_create.c:0(start_thread)[0x2b039a1d3dc5] /lib64/libc.so.6(clone+0x6d)[0x2b039a9f6c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b06ebc198a0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 36 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. 2019-11-04 23:58:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:58:47 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:58:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:58:47 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:58:47 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:58:47 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:58:47 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:58:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:58:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12551699838 2019-11-04 23:58:47 0 [Note] InnoDB: Starting final batch to recover 6 pages from redo log. 2019-11-04 23:58:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 23:58:47 0 [Note] InnoDB: Uses event mutexes 2019-11-04 23:58:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-04 23:58:47 0 [Note] InnoDB: Number of pools: 1 2019-11-04 23:58:47 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 23:58:47 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-04 23:58:47 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 23:58:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 23:58:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12551699838 2019-11-04 23:58:47 0 [Note] InnoDB: Starting final batch to recover 6 pages from redo log. 2019-11-04 23:58:48 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:58:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:58:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:58:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:58:48 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:58:48 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:58:48 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:58:48 0 [Note] InnoDB: 10.3.8 started; log sequence number 12551702547; transaction id 1132730 2019-11-04 23:58:48 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:58:48 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:58:48 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:58:48 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:58:48 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:58:48 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:58:48 0 [Note] Starting crash recovery... 2019-11-04 23:58:48 0 [Note] Crash recovery finished. 2019-11-04 23:58:48 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:58:48 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:58:48 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:58:48 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:58:48 9 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:58:48 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=1 max_threads=1002 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ab786a5be08 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 = 0x2ab43c322de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55d22eb625f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55d22e5f55ed] sigaction.c:0(__restore_rt)[0x2ab43d0e2100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55d22eb9dd99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55d22e423636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55d22e42990f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55d22e4316cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d22e433fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d22e434b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55d22e4fdeec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55d22e4fe0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55d22eb146fa] pthread_create.c:0(start_thread)[0x2ab43d0dadc5] /lib64/libc.so.6(clone+0x6d)[0x2ab43d8fdc9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2ab786aab1e0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 9 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. 2019-11-04 23:58:48 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-04 23:58:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 23:58:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 23:58:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 23:58:48 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 23:58:48 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-04 23:58:48 0 [Note] InnoDB: Waiting for purge to start 2019-11-04 23:58:48 0 [Note] InnoDB: 10.3.8 started; log sequence number 12551702547; transaction id 1132730 2019-11-04 23:58:48 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-04 23:58:48 0 [Note] Plugin 'FEEDBACK' is disabled. 191104 23:58:48 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191104 23:58:48 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-04 23:58:48 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-04 23:58:48 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-04 23:58:48 0 [Note] Starting crash recovery... 2019-11-04 23:58:48 0 [Note] Crash recovery finished. 2019-11-04 23:58:48 0 [Note] Server socket created on IP: '::'. 2019-11-04 23:58:48 0 [Note] Reading of all Master_info entries succeded 2019-11-04 23:58:48 0 [Note] Added new Master_info '' to hash table 2019-11-04 23:58:48 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-04 23:58:48 9 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191104 23:58:48 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=1 max_threads=1002 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2ab786a5be08 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 = 0x2ab43c322de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55d22eb625f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55d22e5f55ed] sigaction.c:0(__restore_rt)[0x2ab43d0e2100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55d22eb9dd99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55d22e423636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55d22e42990f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55d22e4316cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d22e433fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d22e434b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55d22e4fdeec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55d22e4fe0c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55d22eb146fa] pthread_create.c:0(start_thread)[0x2ab43d0dadc5] /lib64/libc.so.6(clone+0x6d)[0x2ab43d8fdc9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2ab786aab1e0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 9 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. 2019-11-05 2019-11-05 0:00:06 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:00:06 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:00:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:00:06 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:00:06 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:00:06 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:00:06 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:00:06 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:00:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12551699838 2019-11-05 0:00:07 0 [Note] InnoDB: Starting final batch to recover 6 pages from redo log. 2019-11-05 0:00:07 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:00:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:00:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:00:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:00:07 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:00:07 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:00:07 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:00:07 0 [Note] InnoDB: 10.3.8 started; log sequence number 12551702547; transaction id 1132730 2019-11-05 0:00:07 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:00:07 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:00:07 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:00:07 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:00:07 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:00:07 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:00:07 0 [Note] Starting crash recovery... 2019-11-05 0:00:07 0 [Note] Crash recovery finished. 2019-11-05 0:00:07 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:00:07 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:00:07 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:00:07 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:00:08 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:00:08 10 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:00:09 14 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:00:10 10 [Warning] Aborted connection 10 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:00:17 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:00:17 2019-11-05 0:00:24 33 [Warning] IP address '10.33.60.97' could not be resolved: Name or service not known 2019-11-05 0:00:25 34 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:00:27 13 [Warning] Aborted connection 13 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:00:27 9 [Warning] Aborted connection 9 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:00:27 12 [Warning] Aborted connection 12 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:01:50 59 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191105 0:01:54 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=35 max_threads=1002 thread_count=42 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2abe8e1d81c8 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 = 0x2abbd63c1de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55cfc2ddc5f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55cfc286f5ed] sigaction.c:0(__restore_rt)[0x2abb508ef100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55cfc2e17d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55cfc269d636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55cfc26a390f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55cfc26ab6cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cfc26adfad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cfc26aeb6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55cfc2777eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55cfc27780c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55cfc2d8e6fa] pthread_create.c:0(start_thread)[0x2abb508e7dc5] /lib64/libc.so.6(clone+0x6d)[0x2abb5110ac9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2abe8e14b8e0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 60 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. 2019-11-05 0:02:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:02:01 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:02:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:02:01 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:02:01 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:02:01 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:02:01 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:02:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:02:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12552170379 2019-11-05 0:02:01 0 [Note] InnoDB: Starting final batch to recover 5 pages from redo log. 2019-11-05 0:02:02 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:02:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:02:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:02:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:02:02 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:02:02 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:02:02 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:02:02 0 [Note] InnoDB: 10.3.8 started; log sequence number 12552176066; transaction id 1133677 2019-11-05 0:02:02 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:02:02 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:02:02 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:02:02 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:02:02 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:02:02 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:02:02 0 [Note] Starting crash recovery... 2019-11-05 0:02:02 0 [Note] Crash recovery finished. 2019-11-05 0:02:02 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:02:02 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:02:02 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:02:02 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:02:02 9 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:02:02 10 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:02:03 13 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191105 0:02:03 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=5 max_threads=1002 thread_count=12 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b4fda0626c8 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 = 0x2b4fa9abfde8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x5615d054b5f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x5615cffde5ed] sigaction.c:0(__restore_rt)[0x2b4faa7bc100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x5615d0586d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x5615cfe0c636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x5615cfe1290f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x5615cfe1a6cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5615cfe1cfad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5615cfe1db6f] sql/sql_parse.cc:1399(do_command(THD*))[0x5615cfee6eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x5615cfee70c4] sql/sql_connect.cc:1353(handle_one_connection)[0x5615d04fd6fa] pthread_create.c:0(start_thread)[0x2b4faa7b4dc5] /lib64/libc.so.6(clone+0x6d)[0x2b4faafd7c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b4fda0af820): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 13 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. 2019-11-05 0:03:21 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:03:21 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:03:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:03:21 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:03:21 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:03:21 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:03:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:03:21 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:03:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12552176768 2019-11-05 0:03:22 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. 2019-11-05 0:03:22 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:03:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:03:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:03:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:03:22 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:03:22 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:03:22 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:03:22 0 [Note] InnoDB: 10.3.8 started; log sequence number 12552176954; transaction id 1133677 2019-11-05 0:03:22 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:03:22 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:03:22 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:03:22 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:03:22 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:03:22 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:03:22 0 [Note] Starting crash recovery... 2019-11-05 0:03:22 0 [Note] Crash recovery finished. 2019-11-05 0:03:22 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:03:22 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:03:22 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:03:22 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:03:22 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:03:23 12 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:03:25 18 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:03:30 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:03:30 2019-11-05 0:03:31 0 [Note] /rdsdbbin/mysql/bin/mysqld (initiated by: rdsadmin[rdsadmin] @ localhost []): Normal shutdown 2019-11-05 0:03:31 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-11-05 0:03:31 0 [Note] InnoDB: FTS optimize thread exiting. 191105 0:03:31 server_audit: STOPPED 2019-11-05 0:03:31 0 [Note] InnoDB: Starting shutdown... 2019-11-05 0:03:31 0 [Note] InnoDB: Dumping buffer pool(s) to /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:03:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 191105 0:03:31 2019-11-05 0:03:33 0 [Note] InnoDB: Shutdown completed; log sequence number 12552329910; transaction id 1133793 2019-11-05 0:03:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:03:33 0 [Note] /rdsdbbin/mysql/bin/mysqld: Shutdown complete 2019-11-05 0:03:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:03:35 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:03:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:03:35 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:03:35 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:03:35 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:03:35 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:03:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:03:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:03:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:03:35 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:03:35 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:03:35 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:03:35 0 [Note] InnoDB: 10.3.8 started; log sequence number 12552329910; transaction id 1133795 2019-11-05 0:03:35 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:03:35 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:03:35 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:03:35 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:03:35 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:03:35 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:03:35 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:03:35 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:03:35 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:03:36 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:03:42 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:03:42 2019-11-05 0:03:45 16 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:03:46 19 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:03:50 23 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:06:07 54 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-05 0:06:07 55 [Warning] IP address '10.31.202.203' could not be resolved: Name or service not known 2019-11-05 0:06:35 36 [Warning] Aborted connection 36 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:35 13 [Warning] Aborted connection 13 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:35 9 [Warning] Aborted connection 9 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:35 45 [Warning] Aborted connection 45 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:35 14 [Warning] Aborted connection 14 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:35 18 [Warning] Aborted connection 18 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:06:48 24 [Warning] Aborted connection 24 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 39 [Warning] Aborted connection 39 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 29 [Warning] Aborted connection 29 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 27 [Warning] Aborted connection 27 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 23 [Warning] Aborted connection 23 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 26 [Warning] Aborted connection 26 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 52 [Warning] Aborted connection 52 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:06:48 28 [Warning] Aborted connection 28 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:07:39 91 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 2019-11-05 0:07:45 92 [Warning] IP address '10.33.97.182' could not be resolved: Name or service not known 2019-11-05 0:08:14 103 [Warning] IP address '10.33.60.97' could not be resolved: Name or service not known 2019-11-05 0:08:28 73 [ERROR] mysqld: Can't find record in 'slow_log' 2019-11-05 0:08:28 73 [ERROR] Failed to write to mysql.slow_log: Can't find record in 'slow_log' 2019-11-05 0:09:04 112 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 191105 0:09:08 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=46 max_threads=1002 thread_count=53 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b19a7657988 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 = 0x2b16881a4de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x559a40c085f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x559a4069b5ed] sigaction.c:0(__restore_rt)[0x2b16565c5100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x559a40c43d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x559a404c9636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x559a404cf90f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x559a404d76cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x559a404d9fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559a404dab6f] sql/sql_parse.cc:1399(do_command(THD*))[0x559a405a3eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x559a405a40c4] sql/sql_connect.cc:1353(handle_one_connection)[0x559a40bba6fa] pthread_create.c:0(start_thread)[0x2b16565bddc5] /lib64/libc.so.6(clone+0x6d)[0x2b1656de0c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b19a76aa3a0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 113 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. 2019-11-05 0:09:17 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:09:17 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:09:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:09:17 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:09:17 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:09:17 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:09:17 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:09:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:09:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12557829276 2019-11-05 0:09:17 0 [Note] InnoDB: Starting final batch to recover 9 pages from redo log. 2019-11-05 0:09:18 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:09:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:09:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:09:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:09:18 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:09:18 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:09:18 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:09:18 0 [Note] InnoDB: 10.3.8 started; log sequence number 12557836767; transaction id 1136894 2019-11-05 0:09:18 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:09:18 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:09:18 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:09:18 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:09:18 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:09:18 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:09:18 0 [Note] Starting crash recovery... 2019-11-05 0:09:18 0 [Note] Crash recovery finished. 2019-11-05 0:09:18 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:09:18 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:09:18 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:09:18 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:09:19 9 [Warning] IP address '10.33.121.198' could not be resolved: Name or service not known 2019-11-05 0:09:19 10 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 191105 0:09:19 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=2 max_threads=1002 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b8ebbc95d08 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 = 0x2b8b71b5bde8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55c1218d65f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55c1213695ed] sigaction.c:0(__restore_rt)[0x2b8b7291b100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55c121911d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55c121197636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55c12119d90f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55c1211a56cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c1211a7fad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c1211a8b6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55c121271eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55c1212720c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55c1218886fa] pthread_create.c:0(start_thread)[0x2b8b72913dc5] /lib64/libc.so.6(clone+0x6d)[0x2b8b73136c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b8ebbce54e0): WITH w_data AS (SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, Lpad(Replace(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */, Concat(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(Substr(If(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ( 'A', 'B' ) THEN Lpad(Substring(A01.ho_name, 2), 11, 0) ELSE Lpad(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, Concat(Substr(If(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(Substr(If(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, Date_format(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, Date_format(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */ , A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 9 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. 2019-11-05 0:10:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:10:36 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:10:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:10:36 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:10:36 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:10:36 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:10:36 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:10:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:10:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12557836940 2019-11-05 0:10:37 0 [Note] InnoDB: Transaction 1136904 was in the XA prepared state. 2019-11-05 0:10:37 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-05 0:10:37 0 [Note] InnoDB: Trx id counter is 1136905 2019-11-05 0:10:37 0 [Note] InnoDB: Starting final batch to recover 1 pages from redo log. 2019-11-05 0:10:37 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:10:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:10:37 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-05 0:10:37 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-05 0:10:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:10:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:10:37 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:10:37 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:10:37 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:10:37 0 [Note] InnoDB: 10.3.8 started; log sequence number 12557837560; transaction id 1136907 2019-11-05 0:10:37 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:10:37 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:10:37 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:10:37 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:10:37 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:10:37 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:10:37 0 [Note] Starting crash recovery... 2019-11-05 0:10:37 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-05 0:10:37 0 [Note] InnoDB: Transaction 1136904 in prepared state after recovery 2019-11-05 0:10:37 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-05 0:10:37 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-05 0:10:37 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-05 0:10:37 0 [Note] Crash recovery finished. 2019-11-05 0:10:37 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:10:37 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:10:37 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:10:37 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:10:38 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:10:38 10 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:10:42 44 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-05 0:10:44 53 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:10:48 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:10:48 2019-11-05 0:11:16 72 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:13:11 90 [Warning] IP address '10.31.202.203' could not be resolved: Name or service not known 2019-11-05 0:14:31 101 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 2019-11-05 0:17:16 0 [Note] /rdsdbbin/mysql/bin/mysqld (initiated by: rdsadmin[rdsadmin] @ localhost []): Normal shutdown 2019-11-05 0:17:16 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-11-05 0:17:16 0 [Note] InnoDB: FTS optimize thread exiting. 191105 0:17:16 server_audit: STOPPED 2019-11-05 0:17:16 0 [Note] InnoDB: Starting shutdown... 2019-11-05 0:17:16 0 [Note] InnoDB: Dumping buffer pool(s) to /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:17:16 0 [Note] InnoDB: Buffer pool(s) dump completed at 191105 0:17:16 2019-11-05 0:17:18 0 [Note] InnoDB: Shutdown completed; log sequence number 12562230958; transaction id 1140479 2019-11-05 0:17:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:17:18 0 [Note] /rdsdbbin/mysql/bin/mysqld: Shutdown complete 2019-11-05 0:17:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:17:19 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:17:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:17:19 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:17:19 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:17:19 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:17:20 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:17:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:17:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:17:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:17:20 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:17:20 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:17:20 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:17:20 0 [Note] InnoDB: 10.3.8 started; log sequence number 12562230958; transaction id 1140481 2019-11-05 0:17:20 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:17:20 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:17:20 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:17:20 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:17:20 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:17:20 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:17:20 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:17:20 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:17:20 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:17:21 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:17:23 12 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:17:25 14 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:17:31 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:17:31 2019-11-05 0:17:35 19 [Warning] IP address '10.31.203.132' could not be resolved: Name or service not known 2019-11-05 0:17:45 22 [Warning] IP address '10.33.97.182' could not be resolved: Name or service not known 2019-11-05 0:17:58 13 [Warning] Aborted connection 13 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:17:58 15 [Warning] Aborted connection 15 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:17:58 12 [Warning] Aborted connection 12 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:17:58 20 [Warning] Aborted connection 20 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:18:02 33 [Warning] Aborted connection 33 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:18:02 36 [Warning] Aborted connection 36 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:18:02 25 [Warning] Aborted connection 25 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:18:02 35 [Warning] Aborted connection 35 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:18:44 60 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:24:44 125 [Warning] IP address '10.31.202.203' could not be resolved: Name or service not known 2019-11-05 0:27:19 145 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 191105 0:27:20 [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.8-MariaDB-log key_buffer_size=16777216 read_buffer_size=2097152 max_used_connections=37 max_threads=1002 thread_count=44 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4142942 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2b9a09e98488 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 = 0x2b972c7c1de8 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x55ea73ca95f9] mysys/stacktrace.c:270(my_print_stacktrace)[0x55ea7373c5ed] sigaction.c:0(__restore_rt)[0x2b96b76ac100] /rdsdbbin/mysql/bin/mysqld(+0xde5d99)[0x55ea73ce4d99] strings/ctype-utf8.c:5302(my_strcasecmp_utf8)[0x55ea7356a636] sql/sql_parse.cc:7297(check_table_access(THD*, unsigned long, TABLE_LIST*, bool, unsigned int, bool))[0x55ea7357090f] sql/sql_parse.cc:3780(mysql_execute_command(THD*))[0x55ea735786cc] sql/sql_parse.cc:8236(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ea7357afad] sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55ea7357bb6f] sql/sql_parse.cc:1399(do_command(THD*))[0x55ea73644eec] sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*))[0x55ea736450c4] sql/sql_connect.cc:1353(handle_one_connection)[0x55ea73c5b6fa] pthread_create.c:0(start_thread)[0x2b96b76a4dc5] /lib64/libc.so.6(clone+0x6d)[0x2b96b7ec7c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2b9a09daa7a0): WITH w_data AS ( SELECT 1 AS ORD_NUM, 'CNYS' AS CNYS_BRHS_TYPE, LPAD( REPLACE(A01.dong_name, ' ', ''), 4, 0) AS DONG_ORD, A01.ho_name AS HO_ORD, A01.dong_name /* */, A01.ho_name /* */, A01.mvn_date /* */, A01.lvhs_date /* */ , CONCAT(SUBSTR(IF(A01.mvn_user_name, NULL, A02.user_name), 1, 1), Regexp_replace(SUBSTR(IF(A01.mvn_user_name, NULL, A02.user_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_cnys_info A01 LEFT OUTER JOIN rndp.tb_sys_user A02 /* */ ON A02.user_no = A01.mvn_user_no WHERE A01.mvn_user_name != ' ' UNION ALL SELECT 2 AS ORD_NUM, 'BRHS' AS CNYS_BRHS_TYPE, dong_name AS DONG_ORD, CASE /* A, B A,B 11 ( ) */ WHEN LEFT(A01.ho_name, 1) IN ('A', 'B') THEN LPAD(SUBSTRING(A01.ho_name, 2), 11, 0) ELSE LPAD(A01.ho_name, 11, 0) END HO_ORD /* */, A01.dong_name /* */, A01.ho_name /* */, A02.mvn_date /* */, A02.lvhs_date /* */, CONCAT(SUBSTR(IF(A03.user_name, NULL, A02.mvn_name), 1, 1), Regexp_replace(SUBSTR(IF(A03.user_name, NULL, A02.mvn_name), 2), '[ - a-z]', '*')) AS USER_NAME /* ( * ) */ FROM rndp.tb_sup_brhs_info A01 /* */ INNER JOIN rndp.tb_sup_brhs_mvn_info A02 /* */ ON A01.mvn_sn = A02.mvn_sn LEFT OUTER JOIN rndp.tb_sys_user A03 /* */ ON A03.user_no = A02.mvn_man_user_no) SELECT A01.cnys_brhs_type, A01.dong_name /* */, A01.ho_name /* */, DATE_FORMAT(A01.mvn_date, '%Y.%m.%d') AS MVN_DATE /* */, DATE_FORMAT(A01.lvhs_date, '%Y.%m.%d') AS LVHS_DATE /* */, A01.user_name /* ( * ) */ FROM w_data A01 WHERE 1 = 1 ORDER BY A01.ord_num ASC, A01.dong_ord ASC, A01.ho_ord ASC LIMIT 0, 200 Connection ID (thread ID): 145 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. 2019-11-05 0:27:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-05 0:27:31 0 [Note] InnoDB: Uses event mutexes 2019-11-05 0:27:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-11-05 0:27:31 0 [Note] InnoDB: Number of pools: 1 2019-11-05 0:27:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-05 0:27:31 0 [Note] InnoDB: Initializing buffer pool, total size = 11G, instances = 8, chunk size = 128M 2019-11-05 0:27:31 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-05 0:27:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-05 0:27:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12563783923 2019-11-05 0:27:31 0 [Note] InnoDB: Transaction 1143443 was in the XA prepared state. 2019-11-05 0:27:31 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-05 0:27:31 0 [Note] InnoDB: Trx id counter is 1143444 2019-11-05 0:27:31 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. 2019-11-05 0:27:32 0 [Note] InnoDB: Last binlog file 'mysql-bin-changelog.000004', position 1065 2019-11-05 0:27:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-05 0:27:32 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-05 0:27:32 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-05 0:27:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-05 0:27:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-05 0:27:32 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:27:32 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:27:32 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:27:32 0 [Note] InnoDB: 10.3.8 started; log sequence number 12563786000; transaction id 1143446 2019-11-05 0:27:32 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:27:32 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:27:32 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:27:32 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:27:32 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:27:32 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:27:32 0 [Note] Starting crash recovery... 2019-11-05 0:27:32 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-05 0:27:32 0 [Note] InnoDB: Transaction 1143443 in prepared state after recovery 2019-11-05 0:27:32 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-05 0:27:32 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-05 0:27:32 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-05 0:27:32 0 [Note] Crash recovery finished. 2019-11-05 0:27:32 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:27:32 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:27:32 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:27:32 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:27:34 9 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:27:36 12 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:27:37 13 [Warning] IP address '10.31.203.132' could not be resolved: Name or service not known 2019-11-05 0:27:38 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:27:38 2019-11-05 0:27:41 15 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 2019-11-05 0:27:45 34 [Warning] IP address '10.33.97.182' could not be resolved: Name or service not known 2019-11-05 0:27:45 36 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:28:28 64 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:30:30 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-05 0:30:30 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB. 2019-11-05 0:30:30 0 [Note] InnoDB: Waiting for purge to start 2019-11-05 0:30:30 0 [Note] InnoDB: 10.3.8 started; log sequence number 12564599286; transaction id 1144462 2019-11-05 0:30:30 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool 2019-11-05 0:30:30 0 [Note] Plugin 'FEEDBACK' is disabled. 191105 0:30:30 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 191105 0:30:30 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2019-11-05 0:30:30 0 [Warning] /rdsdbbin/mysql/bin/mysqld: unknown variable 'loose-rocksdb_log_dir=/rdsdbdata/db/log' 2019-11-05 0:30:30 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog 2019-11-05 0:30:30 0 [Note] Starting crash recovery... 2019-11-05 0:30:30 0 [Note] Crash recovery finished. 2019-11-05 0:30:30 0 [Note] Server socket created on IP: '::'. 2019-11-05 0:30:30 0 [Note] Reading of all Master_info entries succeded 2019-11-05 0:30:30 0 [Note] Added new Master_info '' to hash table 2019-11-05 0:30:30 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.3.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2019-11-05 0:30:37 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 0:30:37 2019-11-05 0:30:44 11 [Warning] IP address '10.88.120.19' could not be resolved: Name or service not known 2019-11-05 0:30:45 12 [Warning] IP address '10.31.178.75' could not be resolved: Name or service not known 2019-11-05 0:30:47 15 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:30:47 16 [Warning] IP address '10.88.120.156' could not be resolved: Name or service not known 2019-11-05 0:30:48 17 [Warning] IP address '10.33.46.160' could not be resolved: Name or service not known 2019-11-05 0:30:53 20 [Warning] IP address '10.31.203.132' could not be resolved: Name or service not known 2019-11-05 0:33:16 14 [Warning] Aborted connection 14 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 41 [Warning] Aborted connection 41 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 26 [Warning] Aborted connection 26 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 25 [Warning] Aborted connection 25 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 24 [Warning] Aborted connection 24 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 38 [Warning] Aborted connection 38 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 36 [Warning] Aborted connection 36 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 40 [Warning] Aborted connection 40 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 49 [Warning] Aborted connection 49 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 35 [Warning] Aborted connection 35 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 34 [Warning] Aborted connection 34 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 55 [Warning] Aborted connection 55 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 23 [Warning] Aborted connection 23 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 22 [Warning] Aborted connection 22 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 54 [Warning] Aborted connection 54 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 31 [Warning] Aborted connection 31 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 29 [Warning] Aborted connection 29 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 11 [Warning] Aborted connection 11 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 47 [Warning] Aborted connection 47 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 42 [Warning] Aborted connection 42 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 37 [Warning] Aborted connection 37 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 39 [Warning] Aborted connection 39 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 13 [Warning] Aborted connection 13 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 33 [Warning] Aborted connection 33 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:16 30 [Warning] Aborted connection 30 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.19' (Got an error reading communication packets) 2019-11-05 0:33:29 56 [Warning] Aborted connection 56 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:33:29 43 [Warning] Aborted connection 43 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:33:29 45 [Warning] Aborted connection 45 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:33:29 44 [Warning] Aborted connection 44 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:33:29 15 [Warning] Aborted connection 15 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:33:29 16 [Warning] Aborted connection 16 to db: 'rndp' user: 'RNDP_APP' host: '10.88.120.156' (Got an error reading communication packets) 2019-11-05 0:34:37 117 [Warning] IP address '10.33.31.161' could not be resolved: Name or service not known 2019-11-05 0:35:20 123 [Warning] IP address '10.34.73.41' could not be resolved: Name or service not known 2019-11-05 0:35:20 123 [Warning] Access denied for user 'root'@'10.34.73.41' (using password: NO) 2019-11-05 0:35:31 125 [Warning] Access denied for user 'root'@'10.34.73.41' (using password: YES) 2019-11-05 0:36:10 137 [Warning] IP address '10.31.203.56' could not be resolved: Name or service not known 2019-11-05 0:38:06 157 [Warning] IP address '10.33.97.182' could not be resolved: Name or service not known 2019-11-05 0:39:04 166 [Warning] IP address '10.33.96.154' could not be resolved: Name or service not known 2019-11-05 0:39:25 127 [ERROR] mysqld: Can't find record in 'slow_log' 2019-11-05 0:39:25 127 [ERROR] Failed to write to mysql.slow_log: Can't find record in 'slow_log' 2019-11-05 0:40:08 188 [Warning] IP address '10.33.48.115' could not be resolved: Name or service not known 2019-11-05 0:42:08 335 [Warning] IP address '10.31.202.203' could not be resolved: Name or service not known 2019-11-05 0:50:03 96 [ERROR] mysqld: Can't find record in 'slow_log' 2019-11-05 0:50:03 96 [ERROR] Failed to write to mysql.slow_log: Can't find record in 'slow_log' 2019-11-05 0:56:34 335 [ERROR] mysqld: Table 'slow_log' is marked as crashed and should be repaired 2019-11-05 0:56:34 335 [ERROR] mysqld: Table 'slow_log' is marked as crashed and should be repaired 2019-11-05 1:08:31 2621 [Warning] IP address '10.33.60.97' could not be resolved: Name or service not known 2019-11-05 1:11:24 2869 [Warning] IP address '10.31.203.134' could not be resolved: Name or service not known 2019-11-05 1:34:53 137 [Warning] Aborted connection 137 to db: 'mysql' user: 'root' host: '10.31.203.56' (Got timeout reading communication packets) 2019-11-05 4:15:15 16945 [Warning] Aborted connection 16945 to db: 'rndp' user: 'RNDP_MGR' host: '10.33.48.115' (Got an error reading communication packets) 2019-11-05 6:32:05 24378 [Warning] IP address '10.31.203.131' could not be resolved: Name or service not known 2019-11-05 6:32:05 24378 [Warning] Access denied for user 'root'@'10.31.203.131' (using password: YES)