[MDEV-36309] The log was only scanned up to *, while the current LSN at the time of the latest checkpoint * was * - Jira

Details

Type: Bug
Status: Needs Feedback (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11.10
Fix Version/s: None
Component/s: Storage Engine - InnoDB
Labels:
None
Environment:
Cloudlinux 9.4

Description

Hello,

Since updating to 10.11.10, we haven't hit `Missing FILE_CHECKPOINT` for a while, but we've run into a redo log issue jumping LSN after something making it hit max_connection count and getting signal 11:

Mar 14 08:42:16 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:42:16 0 [Note] InnoDB: Truncated .//undo001

Mar 14 08:42:16 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:42:16 0 [Note] InnoDB: Starting to truncate .//undo002

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: 250314  8:56:14 [ERROR] mysqld got signal 11 ;

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Sorry, we probably made a mistake, and this is a bug.

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Your assistance in bug reporting will enable us to fix this for the next release.

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: We will try our best to scrape up some info that will hopefully help

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: diagnose the problem, but since we have already crashed,

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: something is definitely wrong and this may fail.

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Server version: 10.11.10-MariaDB source revision: 3d0fb150289716ca75cd64d62823cf715ee47646

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: key_buffer_size=2147483648

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: read_buffer_size=4194304

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: max_used_connections=2001

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: max_threads=2002

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: thread_count=2001

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: It is possible that mysqld could use up to

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 18551062 K  bytes of memory

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Hope that's ok; if not, decrease some variables in the equation.

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Thread pointer: 0x7ef22ee3ed58

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: Attempting backtrace. You can use the following information to find out

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: where mysqld died. If you see no messages after this, something went

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: terribly wrong...

Mar 14 08:56:14 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:56:14 0 [Note] /srv/mariadb101110/usr/sbin/mariadbd (initiated by: unknown): Normal shutdown

Mar 14 08:56:20 uk-fast-web1732 mariadbd[1230235]: stack_bottom = 0x7ef910c00000 thread_stack 0x49000

Mar 14 08:56:32 uk-fast-web1732 mariadbd[1230235]: /srv/mariadb101110/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x557b57fcebee]

Mar 14 08:56:35 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:56:35 0 [Warning] /srv/mariadb101110/usr/sbin/mariadbd: Thread 276545663 (user : 'u279') did not exit

Mar 14 08:56:35 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:56:35 0 [Warning] /srv/mariadb101110/usr/sbin/mariadbd: Thread 276545658 (user : 'u585') did not exit

Mar 14 08:56:35 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:56:35 0 [Warning] /srv/mariadb101110/usr/sbin/mariadbd: Thread 276545650 (user : 'u196) did not exit

Mar 14 08:56:35 uk-fast-web1732 mariadbd[1230235]: 2025-03-14  8:56:35 0 [Warning] /srv/mariadb101110/usr/sbin/mariadbd: Thread 276545644 (user : 'u346') did not exit

.....

Mar 14 08:56:36 uk-fast-web1732 mariadbd[1230235]: /srv/mariadb101110/usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x557b57a938d8]

Mar 14 08:56:43 uk-fast-web1732 mariadbd[1230235]: /lib64/libc.so.6(+0x3e6f0)[0x7f111863e6f0]

Mar 14 08:58:12 uk-fast-web1732 systemd[1]: mariadb.service: Main process exited, code=dumped, status=11/SEGV

Mar 14 08:58:12 uk-fast-web1732 systemd[1]: mariadb.service: Failed with result 'core-dump'.

Mar 14 08:58:17 uk-fast-web1732 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.

Mar 14 08:58:17 uk-fast-web1732 systemd[1]: Stopped MariaDB database server.

Mar 14 08:58:17 uk-fast-web1732 systemd[1]: Starting MariaDB database server...

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [ERROR] feedback plugin: failed to retrieve the MAC address

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note] Starting MariaDB 10.11.10-MariaDB source revision 3d0fb150289716ca75cd64d62823cf715ee47646 server_uid unknown as process 2153522

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note] RocksDB: 2 column families found

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note] RocksDB: Column Families at start:

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]   cf=default

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]     write_buffer_size=67108864

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]     target_file_size_base=67108864

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]   cf=__system__

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]     write_buffer_size=67108864

Mar 14 08:58:18 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:18 0 [Note]     target_file_size_base=67108864

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] RocksDB: Table_store: loaded DDL data for 751 tables

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] MyRocks storage engine plugin has been successfully initialized.

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] mariadbd: Aria engine: starting recovery

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: tables to flush: 6 5 4 3 2 1 0

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]:  (0.0 seconds);

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] mariadbd: Aria engine: recovery done

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Number of transaction pools: 1

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Using AVX512 instructions

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Using Linux native AIO

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Initializing buffer pool, total size = 50.199GiB, chunk size = 0.784GiB

Mar 14 08:58:46 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:46 0 [Note] InnoDB: Completed initialization of buffer pool

Mar 14 08:58:47 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:47 0 [Note] InnoDB: Buffered log writes (block size=4096 bytes)

Mar 14 08:58:47 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:47 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer

Mar 14 08:58:47 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=202761402158754

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] InnoDB: End of log at LSN=202762386894310

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] InnoDB: The log was only scanned up to 202762386894310, while the current LSN at the time of the latest checkpoint 202761402158754 was 202763082156746!

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] InnoDB: Starting shutdown...

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] Plugin 'FEEDBACK' is disabled.

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'cgroup' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_CFSTATS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_DBSTATS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_PERF_CONTEXT' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_PERF_CONTEXT_GLOBAL' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_CF_OPTIONS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_COMPACTION_STATS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_GLOBAL_INFO' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_DDL' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_SST_PROPS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_INDEX_FILE_MAP' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_LOCKS' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_TRX' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] mariadbd: Plugin 'ROCKSDB_DEADLOCK' already installed

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] Unknown/unsupported storage engine: InnoDB

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] Aborting

Seems the most important part is the following:

Mar 14 08:58:47 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=202761402158754

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [Note] InnoDB: End of log at LSN=202762386894310

Mar 14 08:58:49 uk-fast-web1732 mariadbd[2153522]: 2025-03-14  8:58:49 0 [ERROR] InnoDB: The log was only scanned up to 202762386894310, while the current LSN at the time of the latest checkpoint 202761402158754 was 202763082156746!

After this only innodb_force_recovery=6 got instance started. We had dump and reimport on a fresh datadir to continue operations. Unfortunately, a lot of tables were had missing data due to:

Mar 14 09:13:38 uk-fast-web1732 mariadbd[2602182]: 2025-03-14  9:13:38 117 [ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

Three days prior, another server ran into a similar issue as well, hit connection limit and got SIG 11'd :

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: 250311  7:41:50 [ERROR] mysqld got signal 11 ;

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Sorry, we probably made a mistake, and this is a bug.

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Your assistance in bug reporting will enable us to fix this for the next release.

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: We will try our best to scrape up some info that will hopefully help

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: diagnose the problem, but since we have already crashed,

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: something is definitely wrong and this may fail.

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Server version: 10.11.10-MariaDB source revision: 3d0fb150289716ca75cd64d62823cf715ee47646

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: key_buffer_size=2147483648

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: read_buffer_size=4194304

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: max_used_connections=2001

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: max_threads=2002

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: thread_count=2001

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: It is possible that mysqld could use up to

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 18551062 K  bytes of memory

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Hope that's ok; if not, decrease some variables in the equation.

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Thread pointer: 0x7f6bfd708d18

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: Attempting backtrace. You can use the following information to find out

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: where mysqld died. If you see no messages after this, something went

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: terribly wrong...

Mar 11 07:41:50 in-mum-web1118 kernel: [2116370.061280] traps: mariadbd[3376701] general protection fault ip:55de9468d4d9 sp:7f7108bedc30 error:0 in mariadbd[55de93f77000+1776000]

Mar 11 07:41:50 in-mum-web1118 mariadbd[6396]: stack_bottom = 0x7f7530943000 thread_stack 0x49000

Mar 11 07:41:50 in-mum-web1118 kernel: traps: mariadbd[3376701] general protection fault ip:55de9468d4d9 sp:7f7108bedc30 error:0 in mariadbd[55de93f77000+1776000]

Mar 11 07:42:15 in-mum-web1118 systemd-coredump[3461186]: Process 6396 (mariadbd) of user 991 dumped core.#012#012Stack trace of thread 3376701:#012#0  0x000055de9468d4d9 _Z16buf_page_get_low9page_id_tm14rw_lock_type_tP11buf_block_tmP5mtr_tP7dberr_tb (/srv/mariadb101110/usr/sbin/mariadbd)#012#012Stack trace of thread 13030:#012#0  0x00007f938b83c41d n/a (n/a)

Mar 11 07:42:35 in-mum-web1118 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV

Mar 11 07:42:35 in-mum-web1118 systemd[1]: mariadb.service: Failed with result 'signal'.

Mar 11 07:42:40 in-mum-web1118 systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.

Mar 11 07:42:40 in-mum-web1118 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [ERROR] feedback plugin: failed to retrieve the MAC address

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note] Starting MariaDB 10.11.10-MariaDB source revision 3d0fb150289716ca75cd64d62823cf715ee47646 server_uid unknown as process 3491886

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note] RocksDB: 2 column families found

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note] RocksDB: Column Families at start:

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]   cf=default

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]     write_buffer_size=67108864

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]     target_file_size_base=67108864

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]   cf=__system__

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]     write_buffer_size=67108864

Mar 11 07:42:41 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:42:41 0 [Note]     target_file_size_base=67108864

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] RocksDB: Table_store: loaded DDL data for 301 tables

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] MyRocks storage engine plugin has been successfully initialized.

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] mariadbd: Aria engine: starting recovery

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: recovered pages: 0% 10% 21% 32% 43% 54% 65% 75% 86% 100% (0.0 seconds); tables to flush: 5 4 3 2 1 0

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: (0.0 seconds);

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] mariadbd: Aria engine: recovery done

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Number of transaction pools: 1

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Using Linux native AIO

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Initializing buffer pool, total size = 50.300GiB, chunk size = 0.786GiB

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Completed initialization of buffer pool

Mar 11 07:44:23 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:23 0 [Note] InnoDB: Buffered log writes (block size=4096 bytes)

Mar 11 07:44:24 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=468213467786054

Mar 11 07:44:28 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:28 0 [Note] InnoDB: End of log at LSN=468215159901757

Mar 11 07:44:28 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:28 0 [ERROR] InnoDB: The log was only scanned up to 468215159901757, while the current LSN at the time of the latest checkpoint 468213467786054 was 468215228276818!

Mar 11 07:44:28 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

Mar 11 07:44:28 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:28 0 [Note] InnoDB: Starting shutdown...

Mar 11 07:44:28 in-mum-web1118 mariadbd[3491886]: 2025-03-11  7:44:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Do you have any ideas? Was there a way to recover them without data loss? We have retained datadir of web1732 if there is anything you would like us to check. Thanks.

Regards,
Arnas

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

web1118.png
188 kB
2025-03-17 16:13
web1732.png
57 kB
2025-03-17 16:18
web1792.png
120 kB
2025-03-17 16:25

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Arnas Klova

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-03-17 12:27

Updated:: 2025-03-17 16:51

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

The log was only scanned up to , while the current LSN at the time of the latest checkpoint was *

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration