2025-01-15T18:28:18.290478+08:00 29 [ERROR] [MY-013183] [InnoDB] Assertion failure: ha_innodb.cc:11452:strlen(m_remote_path) != 0 thread 139669050046208
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
2025-01-15T10:28:18Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=67b52db9f80b893285eaddb89e675c867d952b4d
Thread pointer: 0x7f06440af360
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 = 7f073c1d2bd0 thread_stack 0x100000
/u01/app/testm1intt1/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x214ac31]
/u01/app/testm1intt1/usr/sbin/mysqld(print_fatal_signal(int)+0x2a2) [0x1005072]
/u01/app/testm1intt1/usr/sbin/mysqld(my_server_abort()+0x75) [0x10052b5]
/u01/app/testm1intt1/usr/sbin/mysqld(my_abort()+0xe) [0x2144abe]
/u01/app/testm1intt1/usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x309) [0x239a439]
/u01/app/testm1intt1/usr/sbin/mysqld(create_table_info_t::create_table_def(dd::Table const*, dd::Table const*)+0x139c) [0x219dabc]
/u01/app/testm1intt1/usr/sbin/mysqld(create_table_info_t::create_table(dd::Table const*, dd::Table const*)+0x244) [0x21a48c4]
/u01/app/testm1intt1/usr/sbin/mysqld(int innobase_basic_ddl::create_impl<dd::Table>(THD*, char const*, TABLE*, HA_CREATE_INFO*, dd::Table*, bool, bool, bool, unsigned int, unsigned int, dd::Table const*)+0x21b) [0x21a52fb]
/u01/app/testm1intt1/usr/sbin/mysqld(innobase_truncate<dd::Table>::truncate()+0x291) [0x21b1701]
/u01/app/testm1intt1/usr/sbin/mysqld(innobase_truncate<dd::Table>::exec()+0xe8) [0x21b19b8]
/u01/app/testm1intt1/usr/sbin/mysqld(ha_innobase::truncate_impl(char const*, TABLE*, dd::Table*)+0x2ee) [0x21b1e9e]
/u01/app/testm1intt1/usr/sbin/mysqld(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, bool, bool, dd::Table*)+0x55d) [0x111b4bd]
/u01/app/testm1intt1/usr/sbin/mysqld(Sql_cmd_truncate_table::truncate_base(THD*, Table_ref*)+0x7ba) [0x13a38ea]
/u01/app/testm1intt1/usr/sbin/mysqld(Sql_cmd_truncate_table::execute(THD*)+0x55) [0x13a4065]
/u01/app/testm1intt1/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xb06) [0xe95026]
/u01/app/testm1intt1/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x51b) [0xe9882b]
/u01/app/testm1intt1/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2396) [0xe9b1b6]
/u01/app/testm1intt1/usr/sbin/mysqld(do_command(THD*)+0x21e) [0xe9bdfe]
/u01/app/testm1intt1/usr/sbin/mysqld() [0xff5288]
/u01/app/testm1intt1/usr/sbin/mysqld() [0x286cf84]
/lib64/libpthread.so.0(+0x81ca) [0x7f0764e801ca]
/lib64/libc.so.6(clone+0x43) [0x7f07632118d3]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f064408bc90): TRUNCATE TABLE s_applicant
Connection ID (thread ID): 29
Status: NOT_KILLED

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.
2025-01-15T18:28:18.290479+08:00 0 [System] [MY-013951] [Server] 2025-01-15T10:28:18Z UTC - mysqld got signal 6 ;
2025-01-15T18:28:18.290480+08:00 0 [System] [MY-013951] [Server] Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
2025-01-15T18:28:18.290481+08:00 0 [System] [MY-013951] [Server] BuildID[sha1]=67b52db9f80b893285eaddb89e675c867d952b4d
2025-01-15T18:28:18.290482+08:00 0 [System] [MY-013951] [Server] Thread pointer: 0x7f06440af360
2025-01-15T18:28:18.290483+08:00 0 [System] [MY-013951] [Server] Attempting backtrace. You can use the following information to find out
2025-01-15T18:28:18.290484+08:00 0 [System] [MY-013951] [Server] where mysqld died. If you see no messages after this, something went
2025-01-15T18:28:18.290485+08:00 0 [System] [MY-013951] [Server] terribly wrong...
2025-01-15T18:28:18.290486+08:00 0 [System] [MY-013951] [Server] stack_bottom = 7f073c1d2bd0 thread_stack 0x100000
2025-01-15T18:28:18.290487+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x214ac31]
2025-01-15T18:28:18.290488+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(print_fatal_signal(int)+0x2a2) [0x1005072]
2025-01-15T18:28:18.290489+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(my_server_abort()+0x75) [0x10052b5]
2025-01-15T18:28:18.290490+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(my_abort()+0xe) [0x2144abe]
2025-01-15T18:28:18.290491+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x309) [0x239a439]
2025-01-15T18:28:18.290492+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(create_table_info_t::create_table_def(dd::Table const*, dd::Table const*)+0x139c) [0x219dabc]
2025-01-15T18:28:18.290493+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(create_table_info_t::create_table(dd::Table const*, dd::Table const*)+0x244) [0x21a48c4]
2025-01-15T18:28:18.290494+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(int innobase_basic_ddl::create_impl<dd::Table>(THD*, char const*, TABLE*, HA_CREATE_INFO*, dd::Table*, bool, bool, bool, unsigned int, unsigned int, dd::Table const*)+0x21b) [0x21a52fb]
2025-01-15T18:28:18.290495+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(innobase_truncate<dd::Table>::truncate()+0x291) [0x21b1701]
2025-01-15T18:28:18.290496+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(innobase_truncate<dd::Table>::exec()+0xe8) [0x21b19b8]
2025-01-15T18:28:18.290497+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(ha_innobase::truncate_impl(char const*, TABLE*, dd::Table*)+0x2ee) [0x21b1e9e]
2025-01-15T18:28:18.290498+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, bool, bool, dd::Table*)+0x55d) [0x111b4bd]
2025-01-15T18:28:18.290499+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(Sql_cmd_truncate_table::truncate_base(THD*, Table_ref*)+0x7ba) [0x13a38ea]
2025-01-15T18:28:18.290500+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(Sql_cmd_truncate_table::execute(THD*)+0x55) [0x13a4065]
2025-01-15T18:28:18.290501+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xb06) [0xe95026]
2025-01-15T18:28:18.290502+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x51b) [0xe9882b]
2025-01-15T18:28:18.290503+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2396) [0xe9b1b6]
2025-01-15T18:28:18.290504+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld(do_command(THD*)+0x21e) [0xe9bdfe]
2025-01-15T18:28:18.290505+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld() [0xff5288]
2025-01-15T18:28:18.290506+08:00 0 [System] [MY-013951] [Server] /u01/app/testm1intt1/usr/sbin/mysqld() [0x286cf84]
2025-01-15T18:28:18.290507+08:00 0 [System] [MY-013951] [Server] /lib64/libpthread.so.0(+0x81ca) [0x7f0764e801ca]
2025-01-15T18:28:18.290508+08:00 0 [System] [MY-013951] [Server] /lib64/libc.so.6(clone+0x43) [0x7f07632118d3]
2025-01-15T18:28:18.290509+08:00 0 [System] [MY-013951] [Server] Trying to get some variables.
2025-01-15T18:28:18.290510+08:00 0 [System] [MY-013951] [Server] Some pointers may be invalid and cause the dump to abort.
2025-01-15T18:28:18.290511+08:00 0 [System] [MY-013951] [Server] Query (7f064408bc90): TRUNCATE TABLE s_applicant
2025-01-15T18:28:18.290512+08:00 0 [System] [MY-013951] [Server] Connection ID (thread ID): 29
2025-01-15T18:28:18.290513+08:00 0 [System] [MY-013951] [Server] Status: NOT_KILLED
2025-01-15T18:28:18.290514+08:00 0 [System] [MY-013951] [Server] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
2025-01-15T18:28:18.290515+08:00 0 [System] [MY-013951] [Server] information that should help you find out what is causing the crash.
2025-01-15T18:28:36.685480+08:00 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2025-01-15T18:28:36.685562+08:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
2025-01-15T18:28:36.685571+08:00 0 [Warning] [MY-011069] [Server] The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
2025-01-15T18:28:36.685583+08:00 0 [Warning] [MY-011069] [Server] The syntax '--character-set-client-handshake' is deprecated and will be removed in a future release.
2025-01-15T18:28:36.687739+08:00 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2025-01-15T18:28:36.687792+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=67b52db9f80b893285eaddb89e675c867d952b4d
2025-01-15T18:28:36.687799+08:00 0 [Note] [MY-010949] [Server] Basedir set to /u01/app/8.0.40/usr/.
2025-01-15T18:28:36.687812+08:00 0 [System] [MY-010116] [Server] /u01/app/testm1intt1/usr/sbin/mysqld (mysqld 8.0.40) starting as process 2135937
2025-01-15T18:28:36.697126+08:00 0 [System] [MY-013951] [Server] A backtrace was processed and added to the main error-log in the appropriate format.
2025-01-15T18:28:36.713072+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2025-01-15T18:28:36.713161+08:00 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2025-01-15T18:28:36.713417+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2025-01-15T18:28:36.713507+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2025-01-15T18:28:36.713538+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2025-01-15T18:28:36.713551+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2025-01-15T18:28:36.713613+08:00 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled.
2025-01-15T18:28:36.715301+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-01-15T18:28:36.715355+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2025-01-15T18:28:36.715473+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2025-01-15T18:28:36.715502+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2025-01-15T18:28:36.715513+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2025-01-15T18:28:36.715539+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
2025-01-15T18:28:36.719165+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2025-01-15T18:28:36.719932+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2025-01-15T18:28:36.720013+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2025-01-15T18:28:36.743671+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 290 files.
2025-01-15T18:28:36.744595+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 2.000000G, instances = 8, chunk size =128.000000M
2025-01-15T18:28:36.830232+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2025-01-15T18:28:36.841412+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-01-15T18:28:36.842443+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2025-01-15T18:28:36.844094+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2025-01-15T18:28:36.863117+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2025-01-15T18:28:36.863152+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2025-01-15T18:28:36.863243+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2025-01-15T18:28:36.863323+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2025-01-15T18:28:36.906787+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 12145212312 in redo log file /u01/mydata/testm1intt1/#innodb_redo/#ib_redo314.
2025-01-15T18:28:36.906900+08:00 1 [Note] [MY-012560] [InnoDB] The log sequence number 12103368091 in the system tablespace does not match the log sequence number 12145212312 in the redo log files!
2025-01-15T18:28:36.906920+08:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2025-01-15T18:28:36.906932+08:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2025-01-15T18:28:36.909970+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 12145211923, whereas checkpoint_lsn = 12145212312 and start_lsn = 12145211904
2025-01-15T18:28:36.910006+08:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 12145215280
2025-01-15T18:28:36.917366+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2025-01-15T18:28:36.918328+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 19 redo log records ...
2025-01-15T18:28:36.925762+08:00 1 [Note] [MY-012533] [InnoDB] 100%
2025-01-15T18:28:37.425904+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2025-01-15T18:28:37.533395+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undotbs/undo_001'.
2025-01-15T18:28:37.533705+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undotbs/undo_002'.
2025-01-15T18:28:37.534587+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2025-01-15T18:28:37.534630+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 19875425
2025-01-15T18:28:37.540560+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2025-01-15T18:28:37.540603+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 5975 ms.
2025-01-15T18:28:37.540632+08:00 1 [Note] [MY-014016] [InnoDB] Transaction ID: 19875420 found for resurrecting inserts
2025-01-15T18:28:37.540665+08:00 1 [Note] [MY-014018] [InnoDB] Identified table ID: 5 to acquire lock
2025-01-15T18:28:37.540682+08:00 1 [Note] [MY-014021] [InnoDB] Total records resurrected: 2 - Total pages read: 0 - Total tables acquired: 1
2025-01-15T18:28:37.540693+08:00 1 [Note] [MY-014022] [InnoDB] Resurrected 1 transactions doing inserts.
2025-01-15T18:28:37.540706+08:00 1 [Note] [MY-014017] [InnoDB] Transaction ID: 19875420 found for resurrecting updates
2025-01-15T18:28:37.540726+08:00 1 [Note] [MY-014018] [InnoDB] Identified table ID: 31 to acquire lock
2025-01-15T18:28:37.540737+08:00 1 [Note] [MY-014018] [InnoDB] Identified table ID: 30 to acquire lock
2025-01-15T18:28:37.540752+08:00 1 [Note] [MY-014021] [InnoDB] Total records resurrected: 3 - Total pages read: 0 - Total tables acquired: 2
2025-01-15T18:28:37.540764+08:00 1 [Note] [MY-014023] [InnoDB] Resurrected 1 transactions doing updates.
2025-01-15T18:28:37.540790+08:00 1 [Note] [MY-013023] [InnoDB] 1 transaction(s) which must be rolled back or cleaned up in total 5 row operations to undo
2025-01-15T18:28:37.540804+08:00 1 [Note] [MY-013024] [InnoDB] Trx id counter is 19875841
2025-01-15T18:28:37.542661+08:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2025-01-15T18:28:37.542692+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2025-01-15T18:28:37.542998+08:00 1 [Note] [MY-012265] [InnoDB] Setting file '/u01/mydata/testm1intt1/ibtmp1' size to 512 MB. Physically writing the file full; Please wait ...
2025-01-15T18:28:37.562846+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 10%
2025-01-15T18:28:37.582581+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 20%
2025-01-15T18:28:37.600968+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 30%
2025-01-15T18:28:37.618700+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 40%
2025-01-15T18:28:37.636132+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 50%
2025-01-15T18:28:37.653459+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 60%
2025-01-15T18:28:37.670479+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 70%
2025-01-15T18:28:37.687938+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 80%
2025-01-15T18:28:37.706659+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 90%
2025-01-15T18:28:37.724402+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/testm1intt1/ibtmp1 size to 512 MB. Progress : 100%
2025-01-15T18:28:37.920213+08:00 1 [Note] [MY-012266] [InnoDB] File '/u01/mydata/testm1intt1/ibtmp1' size is now 512 MB.
2025-01-15T18:28:37.920599+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'/u01/mydata/mytmp/testm1intt1/innodb_temp/'
2025-01-15T18:28:37.938449+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2025-01-15T18:28:37.938753+08:00 1 [Note] [MY-012976] [InnoDB] 8.0.40 started; log sequence number 12145215343
2025-01-15T18:28:37.938888+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-01-15T18:28:37.945197+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2025-01-15T18:28:38.016233+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2025-01-15T18:28:38.283902+08:00 1 [Note] [MY-012355] [InnoDB] Tablespace 3282, name 'ttdsbtse1/s_applicant', unable to open file './ttdsbtse1/s_applicant.ibd' - Cannot open a file
2025-01-15T18:28:38.295542+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 292 tablespaces. Validated 291. Found 284 moved. Found 1 missing.
2025-01-15T18:28:38.295600+08:00 1 [Note] [MY-014019] [InnoDB] Acquired lock on table ID: 5, name: mysql/innodb_ddl_log
2025-01-15T18:28:38.295627+08:00 1 [Note] [MY-014019] [InnoDB] Acquired lock on table ID: 30, name: mysql/tablespace_files
2025-01-15T18:28:38.295640+08:00 1 [Note] [MY-014019] [InnoDB] Acquired lock on table ID: 31, name: mysql/tablespaces
2025-01-15T18:28:38.295659+08:00 1 [Note] [MY-013011] [InnoDB] Rolling back trx with id 19875420, 5 rows to undo
2025-01-15T18:28:38.296396+08:00 1 [Note] [MY-013012] [InnoDB] Rollback of trx with id 19875420 completed
2025-01-15T18:28:38.829280+08:00 1 [Note] [MY-012173] [InnoDB] Committed : 284
2025-01-15T18:28:38.871761+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2025-01-15T18:28:38.893121+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2025-01-15T18:28:38.895012+08:00 0 [Note] [MY-010855] [Server] Recovering after a crash using /u01/myarch/testm1intt1/mysql-bin
2025-01-15T18:28:38.895058+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2025-01-15T18:28:38.901800+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2025-01-15T18:28:38.901838+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2025-01-15T18:28:38.901852+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
2025-01-15T18:28:38.920523+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2025-01-15T18:28:38.924374+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2025-01-15T18:28:38.925146+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /u01/mydata/testm1intt1/ib_buffer_pool
2025-01-15T18:28:38.933284+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 250115 18:28:38
2025-01-15T18:28:38.933668+08:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2025-01-15T18:28:38.991264+08:00 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-01-15T18:28:38.991780+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-01-15T18:28:38.992832+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-01-15T18:28:38.992878+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-01-15T18:28:38.993175+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2025-01-15T18:28:38.993438+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2025-01-15T18:28:38.993831+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '10.123.118.101'; port: 19306
2025-01-15T18:28:38.993866+08:00 0 [Note] [MY-010264] [Server]   - '10.123.118.101' resolves to '10.123.118.101';
2025-01-15T18:28:38.993972+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '10.123.118.101'.
2025-01-15T18:28:39.010900+08:00 0 [Note] [MY-011025] [Repl] Failed to start replica threads for channel ''.
2025-01-15T18:28:39.012477+08:00 0 [System] [MY-010931] [Server] /u01/app/testm1intt1/usr/sbin/mysqld: ready for connections. Version: '8.0.40'  socket: '/u01/mydata/testm1intt1/mysql.sock'  port: 19306  MySQL Community Server - GPL.