[##MASTER DB 서버##]] 374116 2021-08-25 18:47:54 0 [Note] InnoDB: Rollback of non-prepared transactions completed 374117 2021-08-25 18:47:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 374118 2021-08-25 18:47:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables 374119 2021-08-25 18:47:54 0 [Note] InnoDB: Setting file '/hiware6/dbms/data/datadir/ibtmp1' size to 12 MB. Physically writing the file full; Pleasewait ... 374120 2021-08-25 18:47:54 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374121 2021-08-25 18:47:54 0 [Note] InnoDB: Waiting for purge to start 374122 2021-08-25 18:47:54 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782816143728; transaction id 20058497144 374123 2021-08-25 18:47:54 0 [Note] Plugin 'FEEDBACK' is disabled. 374124 2021-08-25 18:47:54 0 [Note] Recovering after a crash using /hiware6/dbms/log/binary/mysql-bin 374125 2021-08-25 18:47:54 0 [Note] Starting crash recovery... 374126 2021-08-25 18:47:54 0 [Note] InnoDB: Starting recovery for XA transactions... 374127 2021-08-25 18:47:54 0 [Note] InnoDB: Transaction 20058497141 in prepared state after recovery 374128 2021-08-25 18:47:54 0 [Note] InnoDB: Transaction contains changes to 1 rows 374129 2021-08-25 18:47:54 0 [Note] InnoDB: 1 transactions in prepared state after recovery 374130 2021-08-25 18:47:54 0 [Note] Found 1 prepared transaction(s) in InnoDB 374131 2021-08-25 18:47:54 0 [Note] Crash recovery finished. 374132 2021-08-25 18:47:54 0 [Note] Server socket created on IP: '::'. 374133 2021-08-25 18:47:54 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374134 2021-08-25 18:47:54 0 [Note] Reading of all Master_info entries succeded 374135 2021-08-25 18:47:54 0 [Note] Added new Master_info '' to hash table 374136 2021-08-25 18:47:54 0 [Note] /hiware6/dbms/engine/mariadb/bin/mysqld: ready for connections. 374137 Version: '10.3.8-MariaDB-log' socket: '/hiware6/dbms/data/mysql.sock' port: 25317 MariaDB Server 374138 2021-08-25 18:47:55 1 [ERROR] [FATAL] InnoDB: Aborting because of a corrupt database page. 374139 210825 18:47:55 [ERROR] mysqld got signal 6 ; 374140 This could be because you hit a bug. It is also possible that this binary 374141 or one of the libraries it was linked against is corrupt, improperly built, 374142 or misconfigured. This error can also be caused by malfunctioning hardware. 374143 374144 To report this bug, see https://mariadb.com/kb/en/reporting-bugs 374145 374146 We will try our best to scrape up some info that will hopefully help 374147 diagnose the problem, but since we have already crashed, 374148 something is definitely wrong and this may fail. 374149 374150 Server version: 10.3.8-MariaDB-log 374151 key_buffer_size=134217728 374152 read_buffer_size=2097152 374153 max_used_connections=1 374154 max_threads=65537 374155 thread_count=7 374156 It is possible that mysqld could use up to 374157 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 201527789 K bytes of memory 374158 Hope that's ok; if not, decrease some variables in the equation. 374159 374160 Thread pointer: 0x7fbf380009a8 374161 Attempting backtrace. You can use the following information to find out 374162 where mysqld died. If you see no messages after this, something went 374163 terribly wrong... 374164 stack_bottom = 0x7fbf4ef9ed08 thread_stack 0x49000 374165 mysys/stacktrace.c:270(my_print_stacktrace)[0x55a5153ddb1b] 374166 sql/signal_handler.cc:168(handle_fatal_signal)[0x55a514eca7c7] 374165 mysys/stacktrace.c:270(my_print_stacktrace)[0x55a5153ddb1b] 374166 sql/signal_handler.cc:168(handle_fatal_signal)[0x55a514eca7c7] 374167 sigaction.c:0(__restore_rt)[0x7fc81a0435e0] 374168 :0(__GI_raise)[0x7fc818e571f7] 374169 :0(__GI_abort)[0x7fc818e588e8] 374170 ut/ut0ut.cc:767(ib::fatal::~fatal())[0x55a5151b799a] 374171 buf/buf0buf.cc:6226(buf_page_io_complete(buf_page_t*, bool, bool))[0x55a5151f8e11] 374172 buf/buf0rea.cc:227(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool, bool))[0x55a515217170] 374173 :0(buf_read_page(page_id_t const&, page_size_t const&))[0x55a5152184d6] 374174 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x55a5151f6023] 374175 fsp/fsp0fsp.cc:451(fseg_free_step_func(unsigned char*, bool, mtr_t*))[0x55a51527b1d7] 374176 trx/trx0purge.cc:402(trx_purge_truncate_rseg_history(trx_rseg_t&, purge_sys_t::iterator const&))[0x55a515180b11] 374177 :0(trx_purge(unsigned long, bool))[0x55a515187621] 374178 srv/srv0srv.cc:2585(srv_purge_coordinator_thread)[0x55a51516b63c] 374179 pthread_create.c:0(start_thread)[0x7fc81a03be25] 374180 /lib64/libc.so.6(clone+0x6d)[0x7fc818f1a34d] 374181 374182 Trying to get some variables. 374183 Some pointers may be invalid and cause the dump to abort. 374184 Query (0x0): 374185 Connection ID (thread ID): 1 374186 Status: NOT_KILLED 374187 374188 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 374189 374190 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 374191 information that should help you find out what is causing the crash. 374192 2021-08-25 18:47:56 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name'myisam-recover-options' instead. 374193 2021-08-25 18:47:56 0 [Note] InnoDB: Using Linux native AIO 374194 2021-08-25 18:47:56 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 374195 2021-08-25 18:47:56 0 [Note] InnoDB: Uses event mutexes 374196 2021-08-25 18:47:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 374197 2021-08-25 18:47:56 0 [Note] InnoDB: Number of pools: 1 374198 2021-08-25 18:47:56 0 [Note] InnoDB: Using SSE2 crc32 instructions 374199 2021-08-25 18:47:56 0 [Note] InnoDB: Initializing buffer pool, total size = 32G, instances = 8, chunk size = 128M 374200 2021-08-25 18:47:57 0 [Note] InnoDB: Completed initialization of buffer pool 374201 2021-08-25 18:47:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man pageof setpriority(). 374202 2021-08-25 18:47:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18782811967559 374203 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/HUCL.ibd' with space ID 5752706, since the redo log references./DBDIR/HUCL.ibd with space ID 28582. 374204 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/HUCL.ibd' with space ID 5752706, since the redo log references./DBDIR/HUCL.ibd with space ID 5752705. 374252 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752720. 374253 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752720. 374254 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374255 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374256 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374257 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374258 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752722. Another data file called ./DBDIR/CFG_SYS_SVR.ibd exists with the same space ID. 374259 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374260 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752722. Another data file called ./DBDIR/CFG_SYS_SVR.ibd exists with the same space ID. 374261 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374262 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CFG_SYS_SVR.ibd' with space ID 5752722, since the redo log references./DBDIR/CFG_SYS_SVR.ibd with space ID 5752721. 374263 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752722. Another data file called ./DBDIR/CFG_SYS_SVR.ibd exists with the same space ID. 374264 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752722. Another data file called ./DBDIR/CFG_SYS_SVR.ibd exists with the same space ID. 374265 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752723. Another data file called ./DBDIR/HIW_COM_SECUR_NOTI.ibd exists with the same space ID. 374266 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752723. Another data file called ./DBDIR/HIW_COM_SECUR_NOTI.ibd exists with the same space ID. 374267 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752723. Another data file called ./DBDIR/HIW_COM_SECUR_NOTI.ibd exists with the same space ID. 374268 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374269 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374270 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374271 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374272 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374273 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374274 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374275 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374276 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374277 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374276 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374277 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752724. 374278 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374279 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374280 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374281 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374282 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374283 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374284 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374285 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752725. 374286 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374287 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374288 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374289 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374290 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374291 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374292 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374293 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752726. 374294 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374295 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374296 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374297 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374298 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752728. Another data file called ./DBDIR/CLIENT_BMK_TGET.ibd exists with the same space ID. 374299 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374300 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374301 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752728. Another data file called ./DBDIR/CLIENT_BMK_TGET.ibd exists with the same space ID. 374300 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CLIENT_BMK_TGET.ibd' with space ID 5752728, since the redo log references ./DBDIR/CLIENT_BMK_TGET.ibd with space ID 5752727. 374301 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752728. Another data file called ./DBDIR/CLIENT_BMK_TGET.ibd exists with the same space ID. 374302 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-158f9_2cf.ibd' with space ID 5752728. Another data file called ./DBDIR/CLIENT_BMK_TGET.ibd exists with the same space ID. 374303 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 28548. 374304 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374305 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374306 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374307 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374308 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374309 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374310 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374311 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374312 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374313 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374314 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374315 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374316 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374317 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374318 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374319 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374320 2021-08-25 18:47:58 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374321 2021-08-25 18:47:58 0 [Note] InnoDB: Starting final batch to recover 663 pages from redo log. 374322 2021-08-25 18:47:59 0 [Note] InnoDB: Last binlog file '/hiware6/dbms/log/binary/mysql-bin.007895', position 4216 374323 2021-08-25 18:48:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 374324 2021-08-25 18:48:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 374325 2021-08-25 18:48:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables 374326 2021-08-25 18:48:00 0 [Note] InnoDB: Setting file '/hiware6/dbms/data/datadir/ibtmp1' size to 12 MB. Physically writing the file full; Pleasewait ... 374327 2021-08-25 18:48:00 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374328 2021-08-25 18:48:00 0 [Note] InnoDB: Waiting for purge to start 374329 2021-08-25 18:48:00 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782817302990; transaction id 20058497331 374327 2021-08-25 18:48:00 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374328 2021-08-25 18:48:00 0 [Note] InnoDB: Waiting for purge to start 374329 2021-08-25 18:48:00 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782817302990; transaction id 20058497331 374330 2021-08-25 18:48:00 0 [Note] Plugin 'FEEDBACK' is disabled. 374331 2021-08-25 18:48:00 0 [Note] Recovering after a crash using /hiware6/dbms/log/binary/mysql-bin 374332 2021-08-25 18:48:00 0 [Note] Starting crash recovery... 374333 2021-08-25 18:48:00 0 [Note] Crash recovery finished. 374334 2021-08-25 18:48:00 0 [Note] Server socket created on IP: '::'. 374335 2021-08-25 18:48:00 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374336 2021-08-25 18:48:00 0 [Note] Reading of all Master_info entries succeded 374337 2021-08-25 18:48:00 0 [Note] Added new Master_info '' to hash table 374338 2021-08-25 18:48:00 0 [Note] /hiware6/dbms/engine/mariadb/bin/mysqld: ready for connections. 374339 Version: '10.3.8-MariaDB-log' socket: '/hiware6/dbms/data/mysql.sock' port: 25317 MariaDB Server 374340 2021-08-25 18:48:02 1 [ERROR] [FATAL] InnoDB: Aborting because of a corrupt database page. 374341 210825 18:48:02 [ERROR] mysqld got signal 6 ; 374342 This could be because you hit a bug. It is also possible that this binary 374343 or one of the libraries it was linked against is corrupt, improperly built, 374344 or misconfigured. This error can also be caused by malfunctioning hardware. 374345 374346 To report this bug, see https://mariadb.com/kb/en/reporting-bugs 374347 374348 We will try our best to scrape up some info that will hopefully help 374349 diagnose the problem, but since we have already crashed, 374350 something is definitely wrong and this may fail. 374351 374352 Server version: 10.3.8-MariaDB-log 374353 key_buffer_size=134217728 374354 read_buffer_size=2097152 374355 max_used_connections=1 374356 max_threads=65537 374357 thread_count=7 374358 It is possible that mysqld could use up to 374359 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 201527789 K bytes of memory 374360 Hope that's ok; if not, decrease some variables in the equation. 374361 374362 Thread pointer: 0x7f58f40009a8 374363 Attempting backtrace. You can use the following information to find out 374364 where mysqld died. If you see no messages after this, something went 374365 terribly wrong... 374366 stack_bottom = 0x7f5903ffed08 thread_stack 0x49000 374367 /hiware6/dbms/engine/mariadb/bin/mysqld(my_print_stacktrace+0x2b)[0x555c3586ab1b] 374368 mysys/stacktrace.c:270(my_print_stacktrace)[0x555c353577c7] 374369 sigaction.c:0(__restore_rt)[0x7f61d3ae25e0] 374370 :0(__GI_raise)[0x7f61d28f61f7] 374371 :0(__GI_abort)[0x7f61d28f78e8] 374372 ut/ut0ut.cc:767(ib::fatal::~fatal())[0x555c3564499a] 374373 buf/buf0buf.cc:6226(buf_page_io_complete(buf_page_t*, bool, bool))[0x555c35685e11] 374374 buf/buf0rea.cc:227(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool, bool))[0x555c356a4170] 374375 :0(buf_read_page(page_id_t const&, page_size_t const&))[0x555c356a54d6] 374376 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x555c35683023] 374375 :0(buf_read_page(page_id_t const&, page_size_t const&))[0x555c356a54d6] 374376 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x555c35683023] 374377 fsp/fsp0fsp.cc:451(fseg_free_step_func(unsigned char*, bool, mtr_t*))[0x555c357081d7] 374378 trx/trx0purge.cc:402(trx_purge_truncate_rseg_history(trx_rseg_t&, purge_sys_t::iterator const&))[0x555c3560db11] 374379 :0(trx_purge(unsigned long, bool))[0x555c35614621] 374380 srv/srv0srv.cc:2585(srv_purge_coordinator_thread)[0x555c355f863c] 374381 pthread_create.c:0(start_thread)[0x7f61d3adae25] 374382 /lib64/libc.so.6(clone+0x6d)[0x7f61d29b934d] 374383 374384 Trying to get some variables. 374385 Some pointers may be invalid and cause the dump to abort. 374386 Query (0x0): 374387 Connection ID (thread ID): 1 374388 Status: NOT_KILLED 374389 374390 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 374391 374392 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 374393 information that should help you find out what is causing the crash. 374394 2021-08-25 18:48:03 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name'myisam-recover-options' instead. 374395 2021-08-25 18:48:03 0 [Note] InnoDB: Using Linux native AIO 374396 2021-08-25 18:48:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 374397 2021-08-25 18:48:03 0 [Note] InnoDB: Uses event mutexes 374398 2021-08-25 18:48:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 374399 2021-08-25 18:48:03 0 [Note] InnoDB: Number of pools: 1 374400 2021-08-25 18:48:03 0 [Note] InnoDB: Using SSE2 crc32 instructions 374401 2021-08-25 18:48:03 0 [Note] InnoDB: Initializing buffer pool, total size = 32G, instances = 8, chunk size = 128M 374402 2021-08-25 18:48:04 0 [Note] InnoDB: Completed initialization of buffer pool 374403 2021-08-25 18:48:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man pageof setpriority(). 374404 2021-08-25 18:48:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18782817306860 374405 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 28548. 374406 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374407 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374408 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374409 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374410 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374411 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374410 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374411 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374412 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374413 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752761. 374414 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374415 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374416 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374417 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374418 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374419 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374420 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374421 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374422 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374423 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374424 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374425 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/CONN_PWD_FAIL.ibd' with space ID 5752767, since the redo log references ./DBDIR/CONN_PWD_FAIL.ibd with space ID 5752766. 374426 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374427 2021-08-25 18:48:06 0 [Note] InnoDB: Ignoring data file './DBDIR/#sql-21685_c.ibd' with space ID 5752767. Another data file called ./DBDIR/CONN_PWD_FAIL.ibd exists with the same space ID. 374428 2021-08-25 18:48:06 0 [Note] InnoDB: Starting final batch to recover 378 pages from redo log. 374429 2021-08-25 18:48:07 0 [Note] InnoDB: Last binlog file '/hiware6/dbms/log/binary/mysql-bin.007896', position 29914 374430 2021-08-25 18:48:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 374431 2021-08-25 18:48:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 374432 2021-08-25 18:48:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables 374433 2021-08-25 18:48:08 0 [Note] InnoDB: Setting file '/hiware6/dbms/data/datadir/ibtmp1' size to 12 MB. Physically writing the file full; Pleasewait ... 374434 2021-08-25 18:48:08 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374435 2021-08-25 18:48:08 0 [Note] InnoDB: Waiting for purge to start 374436 2021-08-25 18:48:08 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782817350014; transaction id 20058497426 374437 2021-08-25 18:48:08 0 [Note] Plugin 'FEEDBACK' is disabled. 374438 2021-08-25 18:48:08 0 [Note] Recovering after a crash using /hiware6/dbms/log/binary/mysql-bin 374439 2021-08-25 18:48:08 0 [Note] Starting crash recovery... 374440 2021-08-25 18:48:08 0 [Note] Crash recovery finished. 374441 2021-08-25 18:48:08 0 [Note] Server socket created on IP: '::'. 374442 2021-08-25 18:48:08 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374440 2021-08-25 18:48:08 0 [Note] Crash recovery finished. 374441 2021-08-25 18:48:08 0 [Note] Server socket created on IP: '::'. 374442 2021-08-25 18:48:08 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374443 2021-08-25 18:48:08 0 [Note] Reading of all Master_info entries succeded 374444 2021-08-25 18:48:08 0 [Note] Added new Master_info '' to hash table 374445 2021-08-25 18:48:08 0 [Note] /hiware6/dbms/engine/mariadb/bin/mysqld: ready for connections. 374446 Version: '10.3.8-MariaDB-log' socket: '/hiware6/dbms/data/mysql.sock' port: 25317 MariaDB Server 374447 2021-08-25 18:58:54 311 [Note] Deleted Master_info file '/hiware6/dbms/data/datadir/master.info'. 374448 2021-08-25 18:58:54 311 [Note] Deleted Master_info file '/hiware6/dbms/data/datadir/relay-log.info'. 374449 2021-08-25 18:58:54 313 [Note] Start binlog_dump to slave_server(1), pos(, 4) 374450 2021-08-25 18:59:02 322 [Warning] Aborted connection 322 to db: 'unconnected' user: 'root' host: '172.30.1.11' (Got an error reading communication packets) 374451 2021-08-25 18:59:54 1 [ERROR] [FATAL] InnoDB: Aborting because of a corrupt database page. 374452 210825 18:59:54 [ERROR] mysqld got signal 6 ; 374453 This could be because you hit a bug. It is also possible that this binary 374454 or one of the libraries it was linked against is corrupt, improperly built, 374455 or misconfigured. This error can also be caused by malfunctioning hardware. 374456 374457 To report this bug, see https://mariadb.com/kb/en/reporting-bugs 374458 374459 We will try our best to scrape up some info that will hopefully help 374460 diagnose the problem, but since we have already crashed, 374461 something is definitely wrong and this may fail. 374462 374463 Server version: 10.3.8-MariaDB-log 374464 key_buffer_size=134217728 374465 read_buffer_size=2097152 374466 max_used_connections=8 374467 max_threads=65537 374468 thread_count=14 374469 It is possible that mysqld could use up to 374470 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 201527789 K bytes of memory 374471 Hope that's ok; if not, decrease some variables in the equation. 374472 374473 Thread pointer: 0x7fba400009a8 374474 Attempting backtrace. You can use the following information to find out 374475 where mysqld died. If you see no messages after this, something went 374476 terribly wrong... 374477 stack_bottom = 0x7fba4f4b1d08 thread_stack 0x49000 374478 mysys/stacktrace.c:270(my_print_stacktrace)[0x55e4a42d8b1b] 374479 sql/signal_handler.cc:168(handle_fatal_signal)[0x55e4a3dc57c7] 374480 sigaction.c:0(__restore_rt)[0x7fc31b16f5e0] 374481 :0(__GI_raise)[0x7fc319f831f7] 374482 :0(__GI_abort)[0x7fc319f848e8] 374483 ut/ut0ut.cc:767(ib::fatal::~fatal())[0x55e4a40b299a] 374484 buf/buf0buf.cc:6226(buf_page_io_complete(buf_page_t*, bool, bool))[0x55e4a40f3e11] 374485 buf/buf0rea.cc:227(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool, bool))[0x55e4a4112170] 374486 :0(buf_read_page(page_id_t const&, page_size_t const&))[0x55e4a41134d6] 374487 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x55e4a40f1023] 374488 fsp/fsp0fsp.cc:451(fseg_free_step_func(unsigned char*, bool, mtr_t*))[0x55e4a41761d7] 374527 2021-08-25 18:59:59 0 [Note] Starting crash recovery... 374528 2021-08-25 18:59:59 0 [Note] Crash recovery finished. 374529 2021-08-25 19:00:00 0 [Note] Server socket created on IP: '::'. 374530 2021-08-25 19:00:00 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374531 2021-08-25 19:00:00 0 [Note] Reading of all Master_info entries succeded 374532 2021-08-25 19:00:00 0 [Note] Added new Master_info '' to hash table 374533 2021-08-25 19:00:00 0 [Note] /hiware6/dbms/engine/mariadb/bin/mysqld: ready for connections. 374534 Version: '10.3.8-MariaDB-log' socket: '/hiware6/dbms/data/mysql.sock' port: 25317 MariaDB Server 374535 2021-08-25 19:00:55 39 [Note] Start binlog_dump to slave_server(1), pos(mysql-bin.007897, 26492) 374536 2021-08-25 19:01:30 1 [ERROR] [FATAL] InnoDB: Aborting because of a corrupt database page. 374537 210825 19:01:30 [ERROR] mysqld got signal 6 ; 374538 This could be because you hit a bug. It is also possible that this binary 374539 or one of the libraries it was linked against is corrupt, improperly built, 374540 or misconfigured. This error can also be caused by malfunctioning hardware. 374541 374542 To report this bug, see https://mariadb.com/kb/en/reporting-bugs 374543 374544 We will try our best to scrape up some info that will hopefully help 374545 diagnose the problem, but since we have already crashed, 374546 something is definitely wrong and this may fail. 374487 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x55e4a40f1023] 374488 fsp/fsp0fsp.cc:451(fseg_free_step_func(unsigned char*, bool, mtr_t*))[0x55e4a41761d7] 374489 trx/trx0purge.cc:402(trx_purge_truncate_rseg_history(trx_rseg_t&, purge_sys_t::iterator const&))[0x55e4a407bb11] 374490 :0(trx_purge(unsigned long, bool))[0x55e4a4082621] 374491 srv/srv0srv.cc:2585(srv_purge_coordinator_thread)[0x55e4a406663c] 374492 pthread_create.c:0(start_thread)[0x7fc31b167e25] 374493 /lib64/libc.so.6(clone+0x6d)[0x7fc31a04634d] 374494 374495 Trying to get some variables. 374496 Some pointers may be invalid and cause the dump to abort. 374497 Query (0x0): 374498 Connection ID (thread ID): 1 374499 Status: NOT_KILLED 374500 374501 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 374502 374503 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 374504 information that should help you find out what is causing the crash. 374505 2021-08-25 18:59:55 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name'myisam-recover-options' instead. 374506 2021-08-25 18:59:55 0 [Note] InnoDB: Using Linux native AIO 374507 2021-08-25 18:59:55 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 374508 2021-08-25 18:59:55 0 [Note] InnoDB: Uses event mutexes 374509 2021-08-25 18:59:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 374510 2021-08-25 18:59:55 0 [Note] InnoDB: Number of pools: 1 374511 2021-08-25 18:59:55 0 [Note] InnoDB: Using SSE2 crc32 instructions 374512 2021-08-25 18:59:55 0 [Note] InnoDB: Initializing buffer pool, total size = 32G, instances = 8, chunk size = 128M 374513 2021-08-25 18:59:56 0 [Note] InnoDB: Completed initialization of buffer pool 374514 2021-08-25 18:59:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man pageof setpriority(). 374515 2021-08-25 18:59:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18782817402603 374516 2021-08-25 18:59:57 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. 374517 2021-08-25 18:59:58 0 [Note] InnoDB: Last binlog file '/hiware6/dbms/log/binary/mysql-bin.007897', position 26492 374518 2021-08-25 18:59:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 374519 2021-08-25 18:59:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 374520 2021-08-25 18:59:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables 374521 2021-08-25 18:59:59 0 [Note] InnoDB: Setting file '/hiware6/dbms/data/datadir/ibtmp1' size to 12 MB. Physically writing the file full; Pleasewait ... 374522 2021-08-25 18:59:59 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374523 2021-08-25 18:59:59 0 [Note] InnoDB: Waiting for purge to start 374524 2021-08-25 18:59:59 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782817402757; transaction id 20058497449 374525 2021-08-25 18:59:59 0 [Note] Plugin 'FEEDBACK' is disabled. 374526 2021-08-25 18:59:59 0 [Note] Recovering after a crash using /hiware6/dbms/log/binary/mysql-bin 374527 2021-08-25 18:59:59 0 [Note] Starting crash recovery... 374528 2021-08-25 18:59:59 0 [Note] Crash recovery finished. 374529 2021-08-25 19:00:00 0 [Note] Server socket created on IP: '::'. 374547 374548 Server version: 10.3.8-MariaDB-log 374549 key_buffer_size=134217728 374550 read_buffer_size=2097152 374551 max_used_connections=15 374552 max_threads=65537 374553 thread_count=20 374554 It is possible that mysqld could use up to 374555 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 201527789 K bytes of memory 374556 Hope that's ok; if not, decrease some variables in the equation. 374557 374558 Thread pointer: 0x7fb0640009a8 374559 Attempting backtrace. You can use the following information to find out 374560 where mysqld died. If you see no messages after this, something went 374561 terribly wrong... 374562 stack_bottom = 0x7fb073881d08 thread_stack 0x49000 374563 mysys/stacktrace.c:270(my_print_stacktrace)[0x55aee6dcdb1b] 374564 sql/signal_handler.cc:168(handle_fatal_signal)[0x55aee68ba7c7] 374565 sigaction.c:0(__restore_rt)[0x7fb93ee3d5e0] 374566 :0(__GI_raise)[0x7fb93dc511f7] 374567 :0(__GI_abort)[0x7fb93dc528e8] 374568 ut/ut0ut.cc:767(ib::fatal::~fatal())[0x55aee6ba799a] 374569 buf/buf0buf.cc:6226(buf_page_io_complete(buf_page_t*, bool, bool))[0x55aee6be8e11] 374570 buf/buf0rea.cc:227(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, page_id_t const&, page_size_t const&, bool, bool))[0x55aee6c07170] 374571 :0(buf_read_page(page_id_t const&, page_size_t const&))[0x55aee6c084d6] 374572 :0(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*))[0x55aee6be6023] 374573 fsp/fsp0fsp.cc:451(fseg_free_step_func(unsigned char*, bool, mtr_t*))[0x55aee6c6b1d7] 374574 trx/trx0purge.cc:402(trx_purge_truncate_rseg_history(trx_rseg_t&, purge_sys_t::iterator const&))[0x55aee6b70b11] 374575 :0(trx_purge(unsigned long, bool))[0x55aee6b77621] 374576 srv/srv0srv.cc:2585(srv_purge_coordinator_thread)[0x55aee6b5b63c] 374575 :0(trx_purge(unsigned long, bool))[0x55aee6b77621] 374576 srv/srv0srv.cc:2585(srv_purge_coordinator_thread)[0x55aee6b5b63c] 374577 pthread_create.c:0(start_thread)[0x7fb93ee35e25] 374578 /lib64/libc.so.6(clone+0x6d)[0x7fb93dd1434d] 374579 374580 Trying to get some variables. 374581 Some pointers may be invalid and cause the dump to abort. 374582 Query (0x0): 374583 Connection ID (thread ID): 1 374584 Status: NOT_KILLED 374585 374586 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 374587 374588 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 374589 information that should help you find out what is causing the crash. 374590 2021-08-25 19:01:31 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name'myisam-recover-options' instead. 374591 2021-08-25 19:01:31 0 [Note] InnoDB: Using Linux native AIO 374592 2021-08-25 19:01:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 374593 2021-08-25 19:01:31 0 [Note] InnoDB: Uses event mutexes 374594 2021-08-25 19:01:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 374595 2021-08-25 19:01:31 0 [Note] InnoDB: Number of pools: 1 374596 2021-08-25 19:01:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 374597 2021-08-25 19:01:31 0 [Note] InnoDB: Initializing buffer pool, total size = 32G, instances = 8, chunk size = 128M 374598 2021-08-25 19:01:32 0 [Note] InnoDB: Completed initialization of buffer pool 374599 2021-08-25 19:01:32 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man pageof setpriority(). 374600 2021-08-25 19:01:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18782817402775 374601 2021-08-25 19:01:33 0 [Note] InnoDB: Last binlog file '/hiware6/dbms/log/binary/mysql-bin.007897', position 26492 374602 2021-08-25 19:01:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 374603 2021-08-25 19:01:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 374604 2021-08-25 19:01:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables 374605 2021-08-25 19:01:34 0 [Note] InnoDB: Setting file '/hiware6/dbms/data/datadir/ibtmp1' size to 12 MB. Physically writing the file full; Pleasewait ... 374606 2021-08-25 19:01:34 0 [Note] InnoDB: File '/hiware6/dbms/data/datadir/ibtmp1' size is now 12 MB. 374607 2021-08-25 19:01:34 0 [Note] InnoDB: Waiting for purge to start 374608 2021-08-25 19:01:34 0 [Note] InnoDB: 10.3.8 started; log sequence number 18782817402784; transaction id 20058497449 374609 2021-08-25 19:01:34 0 [Note] Plugin 'FEEDBACK' is disabled. 374610 2021-08-25 19:01:34 0 [Note] Recovering after a crash using /hiware6/dbms/log/binary/mysql-bin 374611 2021-08-25 19:01:34 0 [Note] Starting crash recovery... 374612 2021-08-25 19:01:34 0 [Note] Crash recovery finished. 374613 2021-08-25 19:01:34 0 [Note] Server socket created on IP: '::'. 374614 2021-08-25 19:01:34 0 [Warning] 'proxies_priv' entry '@% root@hssecgw1' ignored in --skip-name-resolve mode. 374615 2021-08-25 19:01:34 0 [Note] Reading of all Master_info entries succeded 374616 2021-08-25 19:01:34 0 [Note] Added new Master_info '' to hash table 374617 2021-08-25 19:01:34 0 [Note] /hiware6/dbms/engine/mariadb/bin/mysqld: ready for connections. 374618 Version: '10.3.8-MariaDB-log' socket: '/hiware6/dbms/data/mysql.sock' port: 25317 MariaDB Server