180906 8:30:01 [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.2.14-MariaDB-log key_buffer_size=67108864 read_buffer_size=4194304 max_used_connections=287 max_threads=1025 thread_count=237 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8506085 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f63fd196008 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 = 0x7f7ccf50cdc8 thread_stack 0x49000 /data/mariadb/bin/mysqld(my_print_stacktrace+0x2b)[0x5607153de42b] /data/mariadb/bin/mysqld(handle_fatal_signal+0x535)[0x560714eb10b5] /usr/lib64/libpthread.so.0(+0xf5e0)[0x7f7cd1bc95e0] /data/mariadb/bin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x623)[0x560714dc03d3] /data/mariadb/bin/mysqld(_ZN12With_element20prepare_unreferencedEP3THD+0x84)[0x560714e47524] /data/mariadb/bin/mysqld(_ZN11With_clause29prepare_unreferenced_elementsEP3THD+0x33)[0x560714e47593] /data/mariadb/bin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0xba4)[0x560714d71504] /data/mariadb/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x316)[0x560714d81c36] /data/mariadb/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d4)[0x560714d82d44] /data/mariadb/bin/mysqld(+0x456cb9)[0x560714c73cb9] /data/mariadb/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3370)[0x560714d324b0] /data/mariadb/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x29a)[0x560714d3762a] /data/mariadb/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1cfe)[0x560714d3998e] /data/mariadb/bin/mysqld(_Z10do_commandP3THD+0x16e)[0x560714d39f5e] /data/mariadb/bin/mysqld(_Z11tp_callbackP13TP_connection+0x67)[0x560714e31107] /data/mariadb/bin/mysqld(+0x66d270)[0x560714e8a270] /usr/lib64/libpthread.so.0(+0x7e25)[0x7f7cd1bc1e25] /usr/lib64/libc.so.6(clone+0x6d)[0x7f7cd12e534d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f6478692020): is an invalid pointer Connection ID (thread ID): 1161636 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=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: WITH EXT_CUST AS ( SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PCERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT CCUSTSALE.CUST_CD AS CUST_CD FROM PCERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PCERPDB.T_AGL_CUST_SALE CCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PWERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT WCUSTSALE.CUST_CD AS CUST_CD FROM PWERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PWERPDB.T_AGL_CUST_SALE WCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' ), TMP_EMP_CUST AS (SELECT CUST_EMP.CUST_CD FROM pcerpdb.T_AGL_CUST_EMP CUST_EMP WHERE CUST_EMP.CUST_TYPE_CD = '12' AND CUST_EMP.EMP_NO = '1008536' AND ( ( CUST_EMP.ST_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') OR CUST_EMP.END_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') ) OR ( DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT OR DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT ) ) UNION ALL SELECT EXT_CUST.CUST_CD FROM EXT_CUST ), TCUST AS ( SELECT TCUST.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M TCUST ON TMP_EMP_CUST.CUST_CD = TCUST.CUST_CD WHERE (instr(upper(TCUST.CUST_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_SNM), upper('공구')) > 0 or instr(upper(TCUST.CUST_INIT_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_CD), upper('공구')) > 0 ) UNION SELECT CCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_CUST_SALE CCUSTSALE ON TMP_EMP_CUST.CUST_CD = CCUSTSALE.CUST_CD STRAIGHT_JOIN pcerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 UNION SELECT WCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pwerpdb.T_AGL_CUST_SALE WCUSTSALE ON TMP_EMP_CUST.CUST_CD = WCUSTSALE.CUST_CD STRAIGHT_JOIN pwerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 ) select * From EXT_CUST 2018-09-06 8:30:55 139741541042048 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2018-09-06 8:30:55 139741541042048 [Warning] InnoDB: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead; Please refer to https://mariadb.com/kb/en/library/set-transaction/ 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Uses event mutexes 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Using Linux native AIO 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Number of pools: 1 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Using SSE2 crc32 instructions 2018-09-06 8:30:55 139741541042048 [Note] InnoDB: Initializing buffer pool, total size = 84G, instances = 24, chunk size = 128M 2018-09-06 8:31:02 139741541042048 [Note] InnoDB: Completed initialization of buffer pool 2018-09-06 8:31:04 139641461921536 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-09-06 8:31:05 139741541042048 [Note] InnoDB: Highest supported file format is Barracuda. 2018-09-06 8:31:06 139741541042048 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7831609538881 2018-09-06 8:31:19 139741541042048 [Note] InnoDB: To recover: 59271 pages from log 2018-09-06 8:31:29 139741541042048 [Note] InnoDB: 9 transaction(s) which must be rolled back or cleaned up in total 1671494 row operations to undo 2018-09-06 8:31:29 139741541042048 [Note] InnoDB: Trx id counter is 607754496 2018-09-06 8:31:29 139741541042048 [Note] InnoDB: Starting final batch to recover 58058 pages from redo log. 2018-09-06 8:31:34 139641822807808 [Note] InnoDB: To recover: 43330 pages from log 2018-09-06 8:31:49 139741541042048 [Note] InnoDB: Last binlog file '/log/mariadb_log/mysql-bin.000966', position 893341587 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: To roll back: 9 transactions, 1671494 rows 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: Setting file '/data/mariadata/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: File '/data/mariadata/data/ibtmp1' size is now 12 MB. 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754090 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: Waiting for purge to start 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754084 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754080 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754075 2018-09-06 8:31:58 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754070 2018-09-06 8:31:58 139741541042048 [Note] InnoDB: 5.7.21 started; log sequence number 7831609550958 2018-09-06 8:31:58 139640807839488 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/data/ib_buffer_pool 2018-09-06 8:31:58 139741541042048 [Note] Plugin 'FEEDBACK' is disabled. 180906 8:31:58 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 2018-09-06 8:31:58 139741541042048 [Note] Semi-sync replication initialized for transactions. 2018-09-06 8:31:58 139741541042048 [Note] Semi-sync replication enabled on the master. 2018-09-06 8:31:59 139741541042048 [Note] Recovering after a crash using /log/mariadb_log/mysql-bin 2018-09-06 8:31:59 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607754068 2018-09-06 8:31:59 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607665057 2018-09-06 8:32:00 139641403471616 [Note] InnoDB: Rolled back recovered transaction 607609670 2018-09-06 8:32:00 139741541042048 [Note] Starting crash recovery... 2018-09-06 8:32:00 139741541042048 [Note] Crash recovery finished. 2018-09-06 8:32:01 139741541042048 [Warning] Failed to create a socket for IPv6 '::': errno: 97. 2018-09-06 8:32:01 139741541042048 [Note] Server socket created on IP: '0.0.0.0'. 2018-09-06 8:32:01 139741541042048 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired 2018-09-06 8:32:01 139741541042048 [Warning] Checking table: './mysql/event' 2018-09-06 8:32:01 139741541042048 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly 2018-09-06 8:32:01 139741539641088 [Note] Event Scheduler: scheduler thread started with id 7 2018-09-06 8:32:01 139741541042048 [Note] /data/mariadb/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 2018-09-06 8:32:13 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 1246873 rows 2018-09-06 8:32:28 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 1118965 rows 2018-09-06 8:32:43 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 1102503 rows 2018-09-06 8:32:58 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 1016743 rows 2018-09-06 8:33:13 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 891315 rows 2018-09-06 8:33:28 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 742654 rows 2018-09-06 8:33:43 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 609694 rows 2018-09-06 8:33:58 139641403471616 [Note] InnoDB: To roll back: 1 transactions, 178129 rows 2018-09-06 8:33:59 139641403471616 [Note] InnoDB: Rolled back recovered transaction 606555801 2018-09-06 8:33:59 139641403471616 [Note] InnoDB: Rollback of non-prepared transactions completed 180906 8:34:56 [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.2.14-MariaDB-log key_buffer_size=67108864 read_buffer_size=4194304 max_used_connections=3 max_threads=1025 thread_count=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8506085 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f012a812008 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 = 0x7f18198c2dc8 thread_stack 0x49000 /data/mariadb/bin/mysqld(my_print_stacktrace+0x2b)[0x55b4aa70742b] /data/mariadb/bin/mysqld(handle_fatal_signal+0x535)[0x55b4aa1da0b5] /usr/lib64/libpthread.so.0(+0xf5e0)[0x7f181bdfe5e0] /data/mariadb/bin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x623)[0x55b4aa0e93d3] /data/mariadb/bin/mysqld(_ZN12With_element20prepare_unreferencedEP3THD+0x84)[0x55b4aa170524] /data/mariadb/bin/mysqld(_ZN11With_clause29prepare_unreferenced_elementsEP3THD+0x33)[0x55b4aa170593] /data/mariadb/bin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0xba4)[0x55b4aa09a504] sql/sql_union.cc:603(st_select_lex_unit::prepare(THD*, select_result*, unsigned long))[0x55b4aa0aac36] sql/sql_cte.cc:964(With_element::prepare_unreferenced(THD*))[0x55b4aa0abd44] sql/sql_select.cc:891(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55b4a9f9ccb9] sql/sql_parse.cc:6469(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b4aa05b4b0] sql/sql_parse.cc:7914(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b4aa06062a] sql/sql_parse.cc:1815(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b4aa06298e] sql/sql_parse.cc:1371(do_command(THD*))[0x55b4aa062f5e] sql/threadpool_common.cc:366(tp_callback(TP_connection*))[0x55b4aa15a107] sql/threadpool_generic.cc:1604(worker_main(void*))[0x55b4aa1b3270] /usr/lib64/libpthread.so.0(+0x7e25)[0x7f181bdf6e25] /usr/lib64/libc.so.6(clone+0x6d)[0x7f181b51a34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f012a859020): is an invalid pointer Connection ID (thread ID): 17 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=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: WITH EXT_CUST AS ( SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PCERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT CCUSTSALE.CUST_CD AS CUST_CD FROM PCERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PCERPDB.T_AGL_CUST_SALE CCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PWERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT WCUSTSALE.CUST_CD AS CUST_CD FROM PWERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PWERPDB.T_AGL_CUST_SALE WCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' ), TMP_EMP_CUST AS (SELECT CUST_EMP.CUST_CD FROM pcerpdb.T_AGL_CUST_EMP CUST_EMP WHERE CUST_EMP.CUST_TYPE_CD = '12' AND CUST_EMP.EMP_NO = '1008536' AND ( ( CUST_EMP.ST_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') OR CUST_EMP.END_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') ) OR ( DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT OR DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT ) ) UNION ALL SELECT EXT_CUST.CUST_CD FROM EXT_CUST ), TCUST AS ( SELECT TCUST.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M TCUST ON TMP_EMP_CUST.CUST_CD = TCUST.CUST_CD WHERE (instr(upper(TCUST.CUST_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_SNM), upper('공구')) > 0 or instr(upper(TCUST.CUST_INIT_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_CD), upper('공구')) > 0 ) UNION SELECT CCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_CUST_SALE CCUSTSALE ON TMP_EMP_CUST.CUST_CD = CCUSTSALE.CUST_CD STRAIGHT_JOIN pcerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 UNION SELECT WCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pwerpdb.T_AGL_CUST_SALE WCUSTSALE ON TMP_EMP_CUST.CUST_CD = WCUSTSALE.CUST_CD STRAIGHT_JOIN pwerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 ) select * From EXT_CUST 2018-09-06 8:35:03 140031979366272 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2018-09-06 8:35:03 140031979366272 [Warning] InnoDB: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead; Please refer to https://mariadb.com/kb/en/library/set-transaction/ 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Uses event mutexes 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Using Linux native AIO 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Number of pools: 1 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Using SSE2 crc32 instructions 2018-09-06 8:35:03 140031979366272 [Note] InnoDB: Initializing buffer pool, total size = 84G, instances = 24, chunk size = 128M 2018-09-06 8:35:09 140031979366272 [Note] InnoDB: Completed initialization of buffer pool 2018-09-06 8:35:11 139931896502016 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-09-06 8:35:11 140031979366272 [Note] InnoDB: Highest supported file format is Barracuda. 2018-09-06 8:35:13 140031979366272 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7832090476694 2018-09-06 8:35:26 140031979366272 [Note] InnoDB: Read redo log up to LSN=7832047474176 2018-09-06 8:35:29 140031979366272 [Note] InnoDB: Starting final batch to recover 46052 pages from redo log. 2018-09-06 8:35:36 140031979366272 [Note] InnoDB: Last binlog file '/log/mariadb_log/mysql-bin.000966', position 893341587 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: Setting file '/data/mariadata/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: File '/data/mariadata/data/ibtmp1' size is now 12 MB. 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: Waiting for purge to start 2018-09-06 8:35:37 140031979366272 [Note] InnoDB: 5.7.21 started; log sequence number 7832090478070 2018-09-06 8:35:37 139931250812672 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/data/ib_buffer_pool 2018-09-06 8:35:37 140031979366272 [Note] Plugin 'FEEDBACK' is disabled. 180906 8:35:37 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 2018-09-06 8:35:37 140031979366272 [Note] Semi-sync replication initialized for transactions. 2018-09-06 8:35:37 140031979366272 [Note] Semi-sync replication enabled on the master. 2018-09-06 8:35:37 140031979366272 [Note] Recovering after a crash using /log/mariadb_log/mysql-bin 2018-09-06 8:35:37 140031979366272 [Note] Starting crash recovery... 2018-09-06 8:35:37 140031979366272 [Note] Crash recovery finished. 2018-09-06 8:35:37 140031979366272 [Warning] Failed to create a socket for IPv6 '::': errno: 97. 2018-09-06 8:35:37 140031979366272 [Note] Server socket created on IP: '0.0.0.0'. 2018-09-06 8:35:37 140031977961216 [Note] Event Scheduler: scheduler thread started with id 7 2018-09-06 8:35:37 140031979366272 [Note] /data/mariadb/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 2018-09-06 9:47:06 139931250812672 [Note] InnoDB: Buffer pool(s) load completed at 180906 9:47:06 180906 11:01:56 [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.2.14-MariaDB-log key_buffer_size=67108864 read_buffer_size=4194304 max_used_connections=49 max_threads=1025 thread_count=55 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8506085 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f44be012008 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 = 0x7f5b2a8cedc8 thread_stack 0x49000 /data/mariadb/bin/mysqld(my_print_stacktrace+0x2b)[0x558632b4c42b] /data/mariadb/bin/mysqld(handle_fatal_signal+0x535)[0x55863261f0b5] /usr/lib64/libpthread.so.0(+0xf5e0)[0x7f5bbb5905e0] /data/mariadb/bin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x623)[0x55863252e3d3] /data/mariadb/bin/mysqld(_ZN12With_element20prepare_unreferencedEP3THD+0x84)[0x5586325b5524] /data/mariadb/bin/mysqld(_ZN11With_clause29prepare_unreferenced_elementsEP3THD+0x33)[0x5586325b5593] /data/mariadb/bin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0xba4)[0x5586324df504] /data/mariadb/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x316)[0x5586324efc36] /data/mariadb/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d4)[0x5586324f0d44] /data/mariadb/bin/mysqld(+0x456cb9)[0x5586323e1cb9] /data/mariadb/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3370)[0x5586324a04b0] /data/mariadb/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x29a)[0x5586324a562a] /data/mariadb/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1cfe)[0x5586324a798e] /data/mariadb/bin/mysqld(_Z10do_commandP3THD+0x16e)[0x5586324a7f5e] /data/mariadb/bin/mysqld(_Z11tp_callbackP13TP_connection+0x67)[0x55863259f107] /data/mariadb/bin/mysqld(+0x66d270)[0x5586325f8270] /usr/lib64/libpthread.so.0(+0x7e25)[0x7f5bbb588e25] /usr/lib64/libc.so.6(clone+0x6d)[0x7f5bbacac34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f44be059020): is an invalid pointer Connection ID (thread ID): 11 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: WITH EXT_CUST AS ( SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PCERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT CCUSTSALE.CUST_CD AS CUST_CD FROM PCERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PCERPDB.T_AGL_CUST_SALE CCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PWERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT WCUSTSALE.CUST_CD AS CUST_CD FROM PWERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PWERPDB.T_AGL_CUST_SALE WCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' ), TMP_EMP_CUST AS (SELECT CUST_EMP.CUST_CD FROM pcerpdb.T_AGL_CUST_EMP CUST_EMP WHERE CUST_EMP.CUST_TYPE_CD = '12' AND CUST_EMP.EMP_NO = '1008536' AND ( ( CUST_EMP.ST_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') OR CUST_EMP.END_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') ) OR ( DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT OR DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT ) ) ), TCUST AS ( SELECT TCUST.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M TCUST ON TMP_EMP_CUST.CUST_CD = TCUST.CUST_CD WHERE (instr(upper(TCUST.CUST_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_SNM), upper('공구')) > 0 or instr(upper(TCUST.CUST_INIT_NM), upper('공구')) > 0 or instr(upper(TCUST.CUST_CD), upper('공구')) > 0 ) UNION SELECT CCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_CUST_SALE CCUSTSALE ON TMP_EMP_CUST.CUST_CD = CCUSTSALE.CUST_CD STRAIGHT_JOIN pcerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 UNION SELECT WCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pwerpdb.T_AGL_CUST_SALE WCUSTSALE ON TMP_EMP_CUST.CUST_CD = WCUSTSALE.CUST_CD STRAIGHT_JOIN pwerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('공구')) > 0 ) SELECT CTXUSER.CTX_ID , CTXUSER.CUST_CD , WSTD_PRIC_LVL_CD AS WGRADE , CCSTD_PRIC_LVL_CD AS CGRADE , CASE 'C' WHEN 'C' THEN CCUST_NM ELSE WCUST_NM END AS CUST_NM , CASE 'C' WHEN 'C' THEN CDEPT_KOR_NM ELSE WDEPT_KOR_NM END AS DEPT_NM , CASE 'C' WHEN 'C' THEN CCOMM_DTL_NM ELSE WCOMM_DTL_NM END AS AREA_NM , CASE WHEN WSTD_PRIC_LVL_CD IS NOT NULL AND CCSTD_PRIC_LVL_CD IS NULL THEN 'WELDING' WHEN WSTD_PRIC_LVL_CD IS NULL AND CCSTD_PRIC_LVL_CD IS NOT NULL THEN 'CHEGIM' ELSE 'BOTH' END AS CTXTRADEGUBUNSTR , CASE WHEN WSTD_PRIC_LVL_CD IS NOT NULL AND CCSTD_PRIC_LVL_CD IS NULL THEN 'W' WHEN WSTD_PRIC_LVL_CD IS NULL AND CCSTD_PRIC_LVL_CD IS NOT NULL THEN 'C' ELSE 'CW' END AS CTX_TRADE_GUBUN , CASE WHEN WSTD_PRIC_LVL_CD IS NOT NULL AND CCSTD_PRIC_LVL_CD IS NULL THEN (SELECT SALE_PLAC_CD FROM pwerpdb.T_AGL_CUST_SALE WHERE CUST_CD = CTXUSER.CUST_CD LIMIT 1 ) WHEN WSTD_PRIC_LVL_CD IS NULL AND CCSTD_PRIC_LVL_CD IS NOT NULL THEN (SELECT SALE_PLAC_CD FROM pcerpdb.T_AGL_CUST_SALE WHERE CUST_CD = CTXUSER.CUST_CD LIMIT 1 ) ELSE (SELECT SALE_PLAC_CD FROM pcerpdb.T_AGL_CUST_SALE WHERE CUST_CD = CTXUSER.CUST_CD LIMIT 1 ) END AS STOCKGUBUN , CASE WHEN CTXUSER.REG_DT > DATE_ADD(CURDATE() , INTERVAL -100 DAY) THEN 'NEW' ELSE 'PASS' END AS NEW_CUST , CTMONTH_YN , WTMONTH_YN /*,(SELECT CUST_CD FROM pcerpdb.T_AAR_FORW_CUST WHERE CUST_CD = CTXUSER.CUST_CD AND CLAIM_YM = '201612' GROUP BY CUST_CD) AS AFC */ , NULL AS AFC , CASE 'C' WHEN 'C' THEN CCEO_NM ELSE WCEO_NM END AS CEO_NM , CASE 'C' WHEN 'C' THEN CASE WHEN CREAL_EBIZ_USE_YN = 'Y' THEN 'Y' ELSE '' END ELSE CASE WHEN WREAL_EBIZ_USE_YN = 'Y' THEN 'Y' ELSE '' END END AS REAL_EBIZ_USE_YN , CASE 'C' WHEN 'C' THEN CBIZ_NO ELSE WBIZ_NO END AS BIZ_NO , CASE 'C' WHEN 'C' THEN CCEO_MAIL ELSE WCEO_MAIL END AS CEO_MAIL , CASE 'C' WHEN 'C' THEN CFAX_NO ELSE WFAX_NO END AS FAX_NO , CASE 'C' WHEN 'C' THEN CTEL_NO ELSE WTEL_NO END AS TEL_NO , CASE 'C' WHEN 'C' THEN CEMP_NO ELSE WEMP_NO END AS EMP_NO , CASE 'C' WHEN 'C' THEN CKOR_NM ELSE WKOR_NM END AS KOR_NM , CASE 'C' WHEN 'C' THEN SUBSTRING_INDEX(CMOPRSN, ',', 1) ELSE SUBSTRING_INDEX(WMOPRSN, ',', 1) END AS MOBL_NO , CASE 'C' WHEN 'C' THEN SUBSTRING_INDEX(CMOPRSN, ',', -1) ELSE SUBSTRING_INDEX(WMOPRSN, ',', -1) END AS CHAR_PRSN_NM , COUNT(*) OVER() CNT FROM (SELECT CUST_CD , MAX(WCUST_NM) AS WCUST_NM , MAX(WSTD_PRIC_LVL_CD) AS WSTD_PRIC_LVL_CD , MAX(WCOMM_DTL_NM) AS WCOMM_DTL_NM , MAX(WDEPT_KOR_NM) AS WDEPT_KOR_NM , MAX(WCUST_SNM) AS WCUST_SNM , MAX(CCUST_NM) AS CCUST_NM , MAX(CSTD_PRIC_LVL_CD) AS CCSTD_PRIC_LVL_CD , MAX(CCOMM_DTL_NM) AS CCOMM_DTL_NM , MAX(CDEPT_KOR_NM) AS CDEPT_KOR_NM , MAX(CCUST_SNM) AS CCUST_SNM , MAX(CTMONTH_YN) AS CTMONTH_YN , MAX(WTMONTH_YN) AS WTMONTH_YN , MAX(CCEO_NM) AS CCEO_NM , MAX(WCEO_NM) AS WCEO_NM , MAX(CREAL_EBIZ_USE_YN) AS CREAL_EBIZ_USE_YN , MAX(WREAL_EBIZ_USE_YN) AS WREAL_EBIZ_USE_YN , MAX(CBIZ_NO) AS CBIZ_NO , MAX(WBIZ_NO) AS WBIZ_NO , MAX(CCEO_MAIL) AS CCEO_MAIL , MAX(WCEO_MAIL) AS WCEO_MAIL , MAX(CFAX_NO) AS CFAX_NO , MAX(WFAX_NO) AS WFAX_NO , MAX(CTEL_NO) AS CTEL_NO , MAX(WTEL_NO) AS WTEL_NO , MAX(CEMP_NO) AS CEMP_NO , MAX(WEMP_NO) AS WEMP_NO , MAX(CKOR_NM) AS CKOR_NM , MAX(WKOR_NM) AS WKOR_NM , MAX(CMOPRSN) AS CMOPRSN , MAX(WMOPRSN) AS WMOPRSN FROM (SELECT WCUST.CUST_CD , WCUST.CUST_NM AS WCUST_NM , WCUSTSALE.STD_PRIC_LVL_CD AS WSTD_PRIC_LVL_CD , COMMCD.COMM_DTL_NM AS WCOMM_DTL_NM , DEPT.DEPT_KOR_NM AS WDEPT_KOR_NM , WCUST.CUST_SNM AS WCUST_SNM , NULL AS CCUST_NM , NULL AS CSTD_PRIC_LVL_CD , NULL AS CCOMM_DTL_NM , NULL AS CDEPT_KOR_NM , NULL AS CCUST_SNM , NULL AS CTMONTH_YN , WCUSTSALE.TMONTH_YN AS WTMONTH_YN , NULL AS CCEO_NM , WCUST.CEO_NM AS WCEO_NM , NULL AS CREAL_EBIZ_USE_YN , WCUSTSALE.REAL_EBIZ_USE_YN AS WREAL_EBIZ_USE_YN , NULL AS CBIZ_NO , WCUST.BIZ_NO AS WBIZ_NO , NULL AS CCEO_MAIL , WCUST.CEO_MAIL AS WCEO_MAIL , NULL AS CFAX_NO , WTYPE.FAX_NO AS WFAX_NO , NULL AS CTEL_NO , WTYPE.TEL_NO AS WTEL_NO , NULL AS CEMP_NO , PERS.EMP_NO AS WEMP_NO , NULL AS CKOR_NM , PERS.KOR_NM AS WKOR_NM , NULL AS CMOPRSN , (SELECT CONCAT(MOBL_NO,',',CHAR_PRSN_NM) FROM pcerpdb.T_AGL_CUST_CHAR WHERE CUST_TYPE_CD = '12' AND CUST_CD = WCUST.CUST_CD LIMIT 1) AS WMOPRSN FROM TCUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M WCUST ON TCUST.CUST_CD = WCUST.CUST_CD STRAIGHT_JOIN pwerpdb.T_AGL_CUST_SALE WCUSTSALE ON WCUST.CUST_CD = WCUSTSALE.CUST_CD STRAIGHT_JOIN pwerpdb.T_AGL_CUST_TYPE WTYPE ON WCUST.CUST_CD = WTYPE.CUST_CD STRAIGHT_JOIN pwerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = WCUSTSALE.AREA_CD STRAIGHT_JOIN pwerpdb.T_HRS_DEPT_M DEPT ON DEPT.DEPT_CD = COMMCD.CHR_MNG_ALTI1 LEFT JOIN pwerpdb.T_AGL_CUST_EMP EMP ON EMP.CUST_CD = WCUST.CUST_CD AND EMP.CUST_TYPE_CD = '12' AND EMP.CHAR_EMP_CLS = '11' AND DATE_FORMAT(SYSDATE(),'%Y%m%d') >= EMP.ST_DT AND (DATE_FORMAT(SYSDATE(),'%Y%m%d') >= EMP.END_DT OR EMP.END_DT IS NULL) LEFT JOIN pwerpdb.T_HRS_HUMAN_PERS PERS ON PERS.EMP_NO = EMP.EMP_NO WHERE WTYPE.CUST_TYPE_CD = '12' AND WTYPE.CUST_STAT_CD NOT IN ('*' , 'D' , 'd' , 'X' , 'x' , '6') AND WCUSTSALE.PRID_MNG_CLS_CD <> '1' AND COMMCD.COMM_CD = 'AGL_AREA_CD' UNION ALL SELECT CCUST.CUST_CD , NULL AS WCUST_NM , NULL AS WSTD_PRIC_LVL_CD , NULL AS WCOMM_DTL_NM , NULL AS WDEPT_KOR_NM , NULL AS WCUST_SNM , CCUST.CUST_NM AS CCUST_NM , CCUSTSALE.STD_PRIC_LVL_CD AS CSTD_PRIC_LVL_CD , COMMCD.COMM_DTL_NM AS CCOMM_DTL_NM , CASE WHEN CCUSTSALE.SALE_PLAC_CD = 'S1' AND CCUSTSALE.MDSM_EXCG_YN = 'Y' THEN '서울마케팅팀' WHEN CCUSTSALE.SALE_PLAC_CD = 'D1' AND CCUSTSALE.MDSM_EXCG_YN = 'Y' THEN '15팀' ELSE DEPT.DEPT_KOR_NM END AS CDEPT_KOR_NM , CCUST.CUST_SNM AS CCUST_SNM , CCUSTSALE.TMONTH_YN AS CTMONTH_YN , NULL AS WTMONTH_YN , CCUST.CEO_NM AS CCEO_NM , NULL AS WCEO_NM , CCUSTSALE.REAL_EBIZ_USE_YN AS CREAL_EBIZ_USE_YN , NULL AS WREAL_EBIZ_USE_YN , CCUST.BIZ_NO AS CBIZ_NO , NULL AS WBIZ_NO , CCUST.CEO_MAIL AS CCEO_MAIL , NULL AS WCEO_MAIL , CTYPE.FAX_NO AS CFAX_NO , NULL AS WFAX_NO , CTYPE.TEL_NO AS CTEL_NO , NULL AS WTEL_NO , PERS.EMP_NO AS CEMP_NO , NULL AS WEMP_NO , PERS.KOR_NM AS CKOR_NM , NULL AS WKOR_NM , (SELECT CONCAT(MOBL_NO,',',CHAR_PRSN_NM) FROM pcerpdb.T_AGL_CUST_CHAR WHERE CUST_TYPE_CD = '12' AND CUST_CD = CCUST.CUST_CD LIMIT 1) AS CMOPRSN , NULL AS WMOPRSN FROM TCUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M CCUST ON TCUST.CUST_CD = CCUST.CUST_CD STRAIGHT_JOIN pcerpdb.T_AGL_CUST_SALE CCUSTSALE ON CCUST.CUST_CD = CCUSTSALE.CUST_CD STRAIGHT_JOIN pcerpdb.T_AGL_CUST_TYPE CTYPE ON CCUST.CUST_CD = CTYPE.CUST_CD STRAIGHT_JOIN pcerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = CCUSTSALE.AREA_CD STRAIGHT_JOIN pcerpdb.T_HRS_DEPT_M DEPT ON DEPT.DEPT_CD = COMMCD.CHR_MNG_ALTI1 LEFT JOIN pcerpdb.T_AGL_CUST_EMP EMP ON EMP.CUST_CD = CCUST.CUST_CD AND EMP.CUST_TYPE_CD = '12' AND EMP.CHAR_EMP_CLS = '11' AND DATE_FORMAT(SYSDATE(),'%Y%m%d') >= EMP.ST_DT AND (DATE_FORMAT(SYSDATE(),'%Y%m%d') >= EMP.END_DT OR EMP.END_DT IS NULL) LEFT JOIN pcerpdb.T_HRS_HUMAN_PERS PERS ON PERS.EMP_NO = EMP.EMP_NO WHERE CTYPE.CUST_TYPE_CD = '12' AND CTYPE.CUST_STAT_CD NOT IN ('*' , 'D' , 'd' , 'X' , 'x' , '6') AND CCUSTSALE.PRID_MNG_CLS_CD <> '1' AND COMMCD.COMM_CD = 'AGL_AREA_CD' ) T1 GROUP BY CUST_CD ) T1 STRAIGHT_JOIN ctxdb.T_CTX_USER CTXUSER ON T1.CUST_CD = CTXUSER.CUST_CD INNER JOIN pcerpdb.T_AGL_CUST_EMP CUST_EMP ON CUST_EMP.CUST_CD = T1.CUST_CD AND CUST_EMP.CUST_TYPE_CD = '12' AND ( ( CUST_EMP.ST_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') OR CUST_EMP.END_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') ) OR ( DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT OR DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT ) ) WHERE 1 = 1 AND CCSTD_PRIC_LVL_CD IS NOT NULL ORDER BY AREA_NM , CUST_NM LIMIT 0, 30 2018-09-06 11:02:15 139678267578240 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2018-09-06 11:02:15 139678267578240 [Warning] InnoDB: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead; Please refer to https://mariadb.com/kb/en/library/set-transaction/ 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Uses event mutexes 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Using Linux native AIO 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Number of pools: 1 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Using SSE2 crc32 instructions 2018-09-06 11:02:15 139678267578240 [Note] InnoDB: Initializing buffer pool, total size = 84G, instances = 24, chunk size = 128M 2018-09-06 11:02:21 139678267578240 [Note] InnoDB: Completed initialization of buffer pool 2018-09-06 11:02:23 139578186651392 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-09-06 11:02:23 139678267578240 [Note] InnoDB: Highest supported file format is Barracuda. 2018-09-06 11:02:25 139678267578240 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7832653000045 2018-09-06 11:02:33 139678267578240 [Note] InnoDB: Last binlog file '/log/mariadb_log/mysql-bin.000966', position 893341587 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: Setting file '/data/mariadata/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: File '/data/mariadata/data/ibtmp1' size is now 12 MB. 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: Waiting for purge to start 2018-09-06 11:02:43 139678267578240 [Note] InnoDB: 5.7.21 started; log sequence number 7832653000054 2018-09-06 11:02:43 139577675179776 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/data/ib_buffer_pool 2018-09-06 11:02:43 139678267578240 [Note] Plugin 'FEEDBACK' is disabled. 180906 11:02:43 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 2018-09-06 11:02:43 139678267578240 [Note] Semi-sync replication initialized for transactions. 2018-09-06 11:02:43 139678267578240 [Note] Semi-sync replication enabled on the master. 2018-09-06 11:02:43 139678267578240 [Note] Recovering after a crash using /log/mariadb_log/mysql-bin 2018-09-06 11:02:43 139678267578240 [Note] Starting crash recovery... 2018-09-06 11:02:43 139678267578240 [Note] Crash recovery finished. 2018-09-06 11:02:44 139678267578240 [Warning] Failed to create a socket for IPv6 '::': errno: 97. 2018-09-06 11:02:44 139678267578240 [Note] Server socket created on IP: '0.0.0.0'. 2018-09-06 11:02:44 139678266173184 [Note] Event Scheduler: scheduler thread started with id 7 2018-09-06 11:02:44 139678267578240 [Note] /data/mariadb/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 180906 11:43:37 [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.2.14-MariaDB-log key_buffer_size=67108864 read_buffer_size=4194304 max_used_connections=48 max_threads=1025 thread_count=55 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8506085 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ef267412008 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 = 0x7f08cfc84dc8 thread_stack 0x49000 /data/mariadb/bin/mysqld(my_print_stacktrace+0x2b)[0x5644af50442b] /data/mariadb/bin/mysqld(handle_fatal_signal+0x535)[0x5644aefd70b5] /usr/lib64/libpthread.so.0(+0xf5e0)[0x7f09607b75e0] /data/mariadb/bin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x623)[0x5644aeee63d3] /data/mariadb/bin/mysqld(_ZN12With_element20prepare_unreferencedEP3THD+0x84)[0x5644aef6d524] /data/mariadb/bin/mysqld(_ZN11With_clause29prepare_unreferenced_elementsEP3THD+0x33)[0x5644aef6d593] /data/mariadb/bin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0xba4)[0x5644aee97504] /data/mariadb/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x316)[0x5644aeea7c36] /data/mariadb/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d4)[0x5644aeea8d44] sql/sql_union.cc:603(st_select_lex_unit::prepare(THD*, select_result*, unsigned long))[0x5644aed99cb9] sql/sql_cte.cc:964(With_element::prepare_unreferenced(THD*))[0x5644aee584b0] sql/sql_select.cc:891(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5644aee5d62a] sql/sql_parse.cc:6469(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5644aee5f98e] sql/sql_parse.cc:1371(do_command(THD*))[0x5644aee5ff5e] sql/threadpool_common.cc:366(tp_callback(TP_connection*))[0x5644aef57107] sql/threadpool_generic.cc:1604(worker_main(void*))[0x5644aefb0270] /usr/lib64/libpthread.so.0(+0x7e25)[0x7f09607afe25] /usr/lib64/libc.so.6(clone+0x6d)[0x7f095fed334d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ef267459020): is an invalid pointer Connection ID (thread ID): 24 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=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. We think the query pointer is invalid, but we will try to print it anyway. Query: WITH EXT_CUST AS ( SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PCERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT CCUSTSALE.CUST_CD AS CUST_CD FROM PCERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PCERPDB.T_AGL_CUST_SALE CCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT COMMCD.CHR_MNG_ALTI1 AS CUST_CD FROM PWERPDB.T_SYS_COMP_COMMCD_D COMMCD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' UNION ALL SELECT WCUSTSALE.CUST_CD AS CUST_CD FROM PWERPDB.T_SYS_COMMCD_D COMMCD STRAIGHT_JOIN PWERPDB.T_AGL_CUST_SALE WCUSTSALE ON COMMCD.CHR_MNG_ALTI3 = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'CTX_EXT_USER_CUST' AND COMMCD.USE_YN = 'Y' AND COMMCD.CHR_MNG_ALTI2 = '1008536' ), TMP_EMP_CUST AS (SELECT CUST_EMP.CUST_CD FROM pcerpdb.T_AGL_CUST_EMP CUST_EMP WHERE CUST_EMP.CUST_TYPE_CD = '12' AND CUST_EMP.EMP_NO = '1008536' AND ( ( CUST_EMP.ST_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') OR CUST_EMP.END_DT BETWEEN DATE_FORMAT(SYSDATE(),'%Y%m%d') AND DATE_FORMAT(SYSDATE(),'%Y%m%d') ) OR ( DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT OR DATE_FORMAT(SYSDATE(),'%Y%m%d') BETWEEN CUST_EMP.ST_DT AND CUST_EMP.END_DT ) ) UNION ALL SELECT EXT_CUST.CUST_CD FROM EXT_CUST ), TCUST AS ( SELECT TCUST.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_UNITY_CUST_M TCUST ON TMP_EMP_CUST.CUST_CD = TCUST.CUST_CD WHERE (instr(upper(TCUST.CUST_NM), upper('태양')) > 0 or instr(upper(TCUST.CUST_SNM), upper('태양')) > 0 or instr(upper(TCUST.CUST_INIT_NM), upper('태양')) > 0 or instr(upper(TCUST.CUST_CD), upper('태양')) > 0 ) UNION SELECT CCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pcerpdb.T_AGL_CUST_SALE CCUSTSALE ON TMP_EMP_CUST.CUST_CD = CCUSTSALE.CUST_CD STRAIGHT_JOIN pcerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = CCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('태양')) > 0 UNION SELECT WCUSTSALE.CUST_CD FROM TMP_EMP_CUST STRAIGHT_JOIN pwerpdb.T_AGL_CUST_SALE WCUSTSALE ON TMP_EMP_CUST.CUST_CD = WCUSTSALE.CUST_CD STRAIGHT_JOIN pwerpdb.T_SYS_COMP_COMMCD_D COMMCD ON COMMCD.COMM_DTL_CD = WCUSTSALE.AREA_CD WHERE COMMCD.COMM_CD = 'AGL_AREA_CD' AND instr(upper(COMMCD.COMM_DTL_NM), upper('태양')) > 0 ) SELECT * FROM TMP_EMP_CUST 2018-09-06 11:43:46 139717913487232 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2018-09-06 11:43:46 139717913487232 [Warning] InnoDB: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead; Please refer to https://mariadb.com/kb/en/library/set-transaction/ 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Uses event mutexes 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Using Linux native AIO 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Number of pools: 1 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Using SSE2 crc32 instructions 2018-09-06 11:43:46 139717913487232 [Note] InnoDB: Initializing buffer pool, total size = 84G, instances = 24, chunk size = 128M 2018-09-06 11:43:53 139717913487232 [Note] InnoDB: Completed initialization of buffer pool 2018-09-06 11:43:55 139617831212800 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-09-06 11:43:55 139717913487232 [Note] InnoDB: Highest supported file format is Barracuda. 2018-09-06 11:43:57 139717913487232 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7832653000082 2018-09-06 11:44:05 139717913487232 [Note] InnoDB: Last binlog file '/log/mariadb_log/mysql-bin.000966', position 893341587 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: Setting file '/data/mariadata/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: File '/data/mariadata/data/ibtmp1' size is now 12 MB. 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: Waiting for purge to start 2018-09-06 11:44:14 139717913487232 [Note] InnoDB: 5.7.21 started; log sequence number 7832653000091 2018-09-06 11:44:14 139617319741184 [Note] InnoDB: Loading buffer pool(s) from /data/mariadata/data/ib_buffer_pool 2018-09-06 11:44:14 139717913487232 [Note] Plugin 'FEEDBACK' is disabled. 180906 11:44:14 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 2018-09-06 11:44:14 139717913487232 [Note] Semi-sync replication initialized for transactions. 2018-09-06 11:44:14 139717913487232 [Note] Semi-sync replication enabled on the master. 2018-09-06 11:44:14 139717913487232 [Note] Recovering after a crash using /log/mariadb_log/mysql-bin 2018-09-06 11:44:14 139717913487232 [Note] Starting crash recovery... 2018-09-06 11:44:14 139717913487232 [Note] Crash recovery finished. 2018-09-06 11:44:14 139717913487232 [Warning] Failed to create a socket for IPv6 '::': errno: 97. 2018-09-06 11:44:14 139717913487232 [Note] Server socket created on IP: '0.0.0.0'. 2018-09-06 11:44:14 139717912082176 [Note] Event Scheduler: scheduler thread started with id 7 2018-09-06 11:44:14 139717913487232 [Note] /data/mariadb/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server