250410 18:52:23 mysqld_safe mysqld from pid file /mydata/10/mariadb.pid ended 250410 18:59:16 mysqld_safe Starting mariadbd daemon with databases from /mydata/10/data/ 2025-04-10 18:59:16 0 [Note] Starting MariaDB 10.6.21-MariaDB-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid gMIrqoPrmJ52CK8uHm6MKRUUzmw= as process 61308 2025-04-10 18:59:16 0 [Warning] Could not increase number of max_open_files to more than 65535 (request: 245040) 2025-04-10 18:59:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-04-10 18:59:16 0 [Note] InnoDB: Using transactional memory 2025-04-10 18:59:16 0 [Note] InnoDB: Number of pools: 1 2025-04-10 18:59:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-04-10 18:59:16 0 [Note] InnoDB: Using Linux native AIO 2025-04-10 18:59:16 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2025-04-10 18:59:16 0 [Note] InnoDB: Completed initialization of buffer pool 2025-04-10 18:59:16 0 [Note] InnoDB: Setting log file /mylog/10/innolog/ib_logfile101 size to 1073741824 bytes 2025-04-10 18:59:17 0 [Note] InnoDB: Renaming log file /mylog/10/innolog/ib_logfile101 to /mylog/10/innolog/ib_logfile0 2025-04-10 18:59:17 0 [Note] InnoDB: New log file created, LSN=2668794935237 2025-04-10 18:59:17 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-10 18:59:17 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-10 18:59:17 0 [Note] InnoDB: 128 rollback segments in 2 undo tablespaces are active. 2025-04-10 18:59:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2025-04-10 18:59:17 0 [Note] InnoDB: Setting file '/mydata/10/data/../tmp/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2025-04-10 18:59:17 0 [Note] InnoDB: File '/mydata/10/data/../tmp/ibtmp1' size is now 12 MB. 2025-04-10 18:59:17 0 [Note] InnoDB: 10.6.21 started; log sequence number 0; transaction id 1334230310 2025-04-10 18:59:17 0 [Note] InnoDB: Loading buffer pool(s) from /mydata/10/data/ib_buffer_pool 2025-04-10 18:59:17 0 [Note] InnoDB: Cannot open '/mydata/10/data/ib_buffer_pool' for reading: No such file or directory 2025-04-10 18:59:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/plugin' 2025-04-10 18:59:17 0 [Note] mariadbd: Plugin 'simple_password_check' already installed 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/servers' 2025-04-10 18:59:17 0 [Note] Server socket created on IP: '0.0.0.0'. 2025-04-10 18:59:17 0 [Note] Server socket created on IP: '0.0.0.0'. 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/db' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/proxies_priv' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/roles_mapping' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/global_priv' 2025-04-10 18:59:17 0 [Warning] 'proxies_priv' entry '@% root@nitndb1d' ignored in --skip-name-resolve mode. 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/time_zone_leap_second' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/time_zone_name' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/time_zone' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/time_zone_transition_type' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/time_zone_transition' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/tables_priv' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/columns_priv' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/procs_priv' 2025-04-10 18:59:17 0 [Warning] InnoDB: Double free of page 98333 in file /mylog/10/undo/undo002 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/func' 2025-04-10 18:59:17 0 [Note] Zerofilling moved table: './mysql/event' 2025-04-10 18:59:17 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141). 2025-04-10 18:59:17 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2025-04-10 18:59:17 0 [Note] /maria/10/bin/mariadbd: ready for connections. Version: '10.6.21-MariaDB-log' socket: '/maria/10/etc/maria.sock' port: 2382 Source distribution 2025-04-10 18:59:21 6 [Warning] Access denied for user 'maria'@'localhost' (using password: NO) 2025-04-10 18:59:23 52 [Warning] Access denied for user 'maria'@'localhost' (using password: NO) 2025-04-10 19:00:04 0 [Warning] InnoDB: Double free of page 163877 in file /mylog/10/undo/undo001 2025-04-10 19:00:21 99 [Note] Event Scheduler: scheduler thread started with id 99 2025-04-10 19:00:23 105 [Warning] 'proxies_priv' entry '@% root@nitndb1d' ignored in --skip-name-resolve mode. 2025-04-10 19:02:08 0 [Warning] InnoDB: Double free of page 163843 in file /mylog/10/undo/undo001 2025-04-10 19:03:39 0 [Warning] InnoDB: Double free of page 163865 in file /mylog/10/undo/undo001 2025-04-10 19:03:49 0 [Warning] InnoDB: Double free of page 163888 in file /mylog/10/undo/undo001 2025-04-10 19:03:50 0 [ERROR] InnoDB: File '/mylog/10/undo/undo002' is corrupted 2025-04-10 19:04:19 0 [Warning] InnoDB: Double free of page 163860 in file /mylog/10/undo/undo001 2025-04-10 19:04:27 0 [Warning] InnoDB: Double free of page 163886 in file /mylog/10/undo/undo001 2025-04-10 19:05:00 0 [Warning] InnoDB: Double free of page 98306 in file /mylog/10/undo/undo002 2025-04-10 19:06:40 310 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2025-04-10 19:07:13 0 [Warning] InnoDB: Double free of page 114696 in file /mylog/10/undo/undo002 2025-04-10 19:07:46 0 [Warning] InnoDB: Double free of page 163855 in file /mylog/10/undo/undo001 2025-04-10 19:07:50 0 [Warning] InnoDB: Double free of page 98354 in file /mylog/10/undo/undo002 2025-04-10 19:07:53 0 [Warning] InnoDB: Double free of page 163878 in file /mylog/10/undo/undo001 2025-04-10 19:07:53 0 [Warning] InnoDB: Double free of page 163845 in file /mylog/10/undo/undo001 2025-04-10 19:09:17 0 [Warning] InnoDB: Double free of page 98325 in file /mylog/10/undo/undo002 2025-04-10 19:09:17 0 [Warning] InnoDB: Double free of page 163866 in file /mylog/10/undo/undo001 2025-04-10 19:11:34 0 [Warning] InnoDB: Double free of page 114691 in file /mylog/10/undo/undo002 2025-04-10 19:11:39 391 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2025-04-10 19:11:43 0 [Warning] InnoDB: Double free of page 163873 in file /mylog/10/undo/undo001 2025-04-10 19:14:05 0 [Warning] InnoDB: Double free of page 163850 in file /mylog/10/undo/undo001 2025-04-10 19:14:50 0 [Warning] InnoDB: Double free of page 98357 in file /mylog/10/undo/undo002 2025-04-10 19:16:38 472 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2025-04-10 19:16:53 207 [Warning] Aborted connection 207 to db: 'wmatrixsdb' user: 'wmatrixs' host: '172.23.231.162' (Got timeout reading communication packets) 2025-04-10 19:16:53 191 [Warning] Aborted connection 191 to db: 'wmatrixsdb' user: 'wmatrixs' host: '172.23.231.162' (Got timeout reading communication packets) 2025-04-10 19:16:53 205 [Warning] Aborted connection 205 to db: 'wmatrixsdb' user: 'wmatrixs' host: '172.23.231.162' (Got timeout reading communication packets) 2025-04-10 19:16:53 206 [Warning] Aborted connection 206 to db: 'wmatrixsdb' user: 'wmatrixs' host: '172.23.231.162' (Got timeout reading communication packets) 2025-04-10 19:21:37 614 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2025-04-10 19:26:29 0x7fc46e2e9700 InnoDB: Assertion failure in file /tmp/server/storage/innobase/trx/trx0purge.cc line 270 InnoDB: Failing assertion: flst_add_first(rseg_header, TRX_RSEG + TRX_RSEG_HISTORY, undo_page, uint16_t(undo_header_offset + TRX_UNDO_HISTORY_NODE), rseg->space->free_limit, mtr) == DB_SUCCESS InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mariadbd startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 250410 19:26:29 [ERROR] /maria/10/bin/mariadbd got signal 6 ; Sorry, we probably made a mistake, and this is a bug. Your assistance in bug reporting will enable us to fix this for the next release. To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report a bug on https://jira.mariadb.org/. Please include the information from the server start above, to the end of the information below. Server version: 10.6.21-MariaDB-log source revision: 066e8d6aeabc13242193780341e0f845528105de The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains instructions to obtain a better version of the backtrace below. Following these instructions will help MariaDB developers provide a fix quicker. Attempting backtrace. Include this in the bug report. (note: Retrieving this information may fail) Thread pointer: 0x7fc338033028 stack_bottom = 0x7fc46e2ea000 thread_stack 0x49000 mysys/stacktrace.c:216(my_print_stacktrace)[0x55a8870b20de] sql/signal_handler.cc:230(handle_fatal_signal)[0x55a886bdfb9d] sigaction.c:0(__restore_rt)[0x7fc49659cdd0] /lib64/libc.so.6(gsignal+0x10f)[0x7fc4956cc70f] /lib64/libc.so.6(abort+0x127)[0x7fc4956b6b25] 2025-04-10 19:26:30 0 [Note] /maria/10/bin/mariadbd (initiated by: unknown): Normal shutdown 2025-04-10 19:26:30 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 99 2025-04-10 19:26:30 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2025-04-10 19:26:30 0 [Note] Event Scheduler: Stopped ut/ut0rbt.cc:471(rbt_eject_node(ib_rbt_node_t*, ib_rbt_node_t*) [clone .cold.36])[0x55a886876c13] trx/trx0purge.cc:190(trx_purge_add_undo_to_history(trx_t const*, trx_undo_t*&, mtr_t*))[0x55a8868742a9] bits/atomic_base.h:524(trx_t::commit_low(mtr_t*))[0x55a8868ce90a] trx/trx0trx.cc:1582(trx_t::commit_persist())[0x55a886f9399f] trx/trx0trx.cc:1601(trx_commit_for_mysql(trx_t*))[0x55a886f93aea] handler/ha_innodb.cc:4574(innobase_commit_ordered_2(trx_t*, THD*))[0x55a886e9d125] handler/ha_innodb.cc:4619(innobase_commit_ordered(handlerton*, THD*, bool))[0x55a886e9d1b1] sql/log.cc:9488(TC_LOG::run_commit_ordered(THD*, bool))[0x55a886cdf205] sql/log.cc:8690(MYSQL_BIN_LOG::trx_group_commit_leader(MYSQL_BIN_LOG::group_commit_entry*))[0x55a886ce4b32] sql/log.cc:8274(MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*))[0x55a886ce6c09] sql/log.cc:7855(MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55a886ce715a] sql/log.cc:1825(binlog_flush_cache(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool, bool))[0x55a886ce7249] sql/log.cc:1975(binlog_commit_flush_xid_caches)[0x55a886ce8999] sql/handler.cc:1963(ha_commit_trans(THD*, bool))[0x55a886be4676] sql/transaction.cc:501(trans_commit_stmt(THD*))[0x55a886ad128d] sql/sql_class.h:4564(mysql_execute_command(THD*, bool))[0x55a8869b1ca7] sql/sql_parse.cc:8210(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a8869a184d] sql/sql_parse.cc:1879(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a8869ae3e3] sql/sql_parse.cc:1421(do_command(THD*, bool))[0x55a8869b038d] sql/threadpool_common.cc:439(threadpool_process_request)[0x55a886b6c6e3] sql/threadpool_generic.cc:1551(worker_main(void*))[0x55a886d7b520] perfschema/pfs.cc:2204(pfs_spawn_thread)[0x55a886e0a755] pthread_create.c:0(start_thread)[0x7fc4965922de] /lib64/libc.so.6(clone+0x43)[0x7fc495790e83] Connection ID (thread ID): 139 Status: KILL_SERVER Query (0x7fc338042f90): insert into wp_card_term_trouble_his ( grpco_c , brno , trmno , mach_ip , trouble_dttm , content , dr_dttm ) (select grpco_c , mach_set_brno , mach_set_trmno , '10.25.181.241' , '20250410192321' , '1100|0028|20250410192321|연결|조작중에러|임상수(07071005)||장애복구완료||' , date_format(now(),'%Y%m%d%H%i%s') from wp_mach_inf where chan_type = 'AY' and mach_ip = '10.25.181.241') 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off Writing a core file... Working directory at /mydata/10/data Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 20971520 20971520 bytes Max processes 65535 65535 processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max pending signals 2059875 2059875 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: core Kernel version: Linux version 4.18.0-193.el8.x86_64 (mockbuild@x86-vm-08.build.eng.bos.redhat.com) (gcc version 8.3.1 20191121 (Red Hat 8.3.1-5) (GCC)) #1 SMP Fri Mar 27 14:35:58 UTC 2020 250410 19:26:31 mysqld_safe Number of processes running now: 0 250410 19:26:31 mysqld_safe mysqld restarted 2025-04-10 19:26:31 0 [Note] Starting MariaDB 10.6.21-MariaDB-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid gMIrqoPrmJ52CK8uHm6MKRUUzmw= as process 12144 2025-04-10 19:26:31 0 [Warning] Could not increase number of max_open_files to more than 65535 (request: 245040) 2025-04-10 19:26:31 0 [Note] mariadbd: Aria engine: starting recovery recovered pages: 0% 10% 20% 30% 54% 65% 75% 85% 97% 100% (0.0 seconds); tables to flush: 4 3 2 1 0 (0.0 seconds); 2025-04-10 19:26:31 0 [Note] mariadbd: Aria engine: recovery done 2025-04-10 19:26:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-04-10 19:26:31 0 [Note] InnoDB: Using transactional memory 2025-04-10 19:26:31 0 [Note] InnoDB: Number of pools: 1 2025-04-10 19:26:31 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-04-10 19:26:31 0 [Note] InnoDB: Using Linux native AIO 2025-04-10 19:26:31 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2025-04-10 19:26:31 0 [Note] InnoDB: Completed initialization of buffer pool 2025-04-10 19:26:31 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-10 19:26:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2668794935308,2668794935308 2025-04-10 19:26:31 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-10 19:26:31 0 [Note] InnoDB: Retry with innodb_force_recovery=5 2025-04-10 19:26:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2025-04-10 19:26:31 0 [Note] InnoDB: Starting shutdown... 2025-04-10 19:26:31 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-04-10 19:26:31 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-04-10 19:26:31 0 [Note] mariadbd: Plugin 'simple_password_check' already installed 2025-04-10 19:26:31 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2025-04-10 19:26:31 0 [ERROR] Aborting 250410 19:26:32 mysqld_safe mysqld from pid file /mydata/10/mariadb.pid ended 250411 08:49:18 mysqld_safe Starting mariadbd daemon with databases from /mydata/10/data/ 2025-04-11 8:49:18 0 [Note] Starting MariaDB 10.6.21-MariaDB-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid gMIrqoPrmJ52CK8uHm6MKRUUzmw= as process 3440 2025-04-11 8:49:18 0 [Warning] Could not increase number of max_open_files to more than 65535 (request: 245040) 2025-04-11 8:49:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-04-11 8:49:18 0 [Note] InnoDB: Using transactional memory 2025-04-11 8:49:18 0 [Note] InnoDB: Number of pools: 1 2025-04-11 8:49:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-04-11 8:49:18 0 [Note] InnoDB: Using Linux native AIO 2025-04-11 8:49:18 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2025-04-11 8:49:18 0 [Note] InnoDB: Completed initialization of buffer pool 2025-04-11 8:49:18 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-11 8:49:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2668794935308,2668794935308 2025-04-11 8:49:18 0 [Note] InnoDB: Opened 2 undo tablespaces 2025-04-11 8:49:18 0 [Note] InnoDB: Retry with innodb_force_recovery=5 2025-04-11 8:49:18 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2025-04-11 8:49:18 0 [Note] InnoDB: Starting shutdown... 2025-04-11 8:49:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2025-04-11 8:49:18 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-04-11 8:49:18 0 [Note] mariadbd: Plugin 'simple_password_check' already installed 2025-04-11 8:49:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2025-04-11 8:49:18 0 [ERROR] Aborting 250411 08:49:18 mysqld_safe mysqld from pid file /mydata/10/mariadb.pid ended