Details
Description
Hello,
in data center 1, there are 4 nodes:
3 node galera cluster -> async slave
From the async slave I'm trying to create a new slave in DC2 that will then form a new galera cluster with 2 more nodes.
cd /var/lib/mysql
|
ssh slave-server 'mariabackup --backup --stream=xbstream --parallel=4' | mbstream -x --parallel=4
|
...
|
[00] 2024-02-26 03:25:59 MySQL binlog position: filename 'mysqld-bin.003284', position '666302125', GTID of the last change '0-8-18213972007'
|
[00] 2024-02-26 03:25:59 Streaming backup-my.cnf
|
[00] 2024-02-26 03:25:59 ...done
|
[00] 2024-02-26 03:25:59 Streaming xtrabackup_info
|
[00] 2024-02-26 03:25:59 ...done
|
[00] 2024-02-26 03:25:59 Redo log (from LSN 31507622579405 to 31508457792375) was copied.
|
[00] 2024-02-26 03:25:59 completed OK!
|
# mariabackup --prepare --use-memory=40G --target-dir=/var/lib/mysql
|
mariabackup based on MariaDB server 10.6.14-MariaDB Linux (x86_64)
|
[00] 2024-02-26 08:34:36 cd to /var/lib/mysql/
|
[00] 2024-02-26 08:34:36 open files limit requested 0, set to 1024
|
[00] 2024-02-26 08:34:36 This target seems to be not prepared yet.
|
[00] 2024-02-26 08:34:36 mariabackup: using the following InnoDB configuration for recovery:
|
[00] 2024-02-26 08:34:36 innodb_data_home_dir = .
|
[00] 2024-02-26 08:34:36 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2024-02-26 08:34:36 innodb_log_group_home_dir = .
|
[00] 2024-02-26 08:34:36 InnoDB: Using liburing
|
[00] 2024-02-26 08:34:36 Starting InnoDB instance for recovery.
|
[00] 2024-02-26 08:34:36 mariabackup: Using 42949672960 bytes for buffer pool (set by --use-memory parameter)
|
2024-02-26 8:34:36 0 [Note] InnoDB: Compressed tables use zlib 1.3
|
2024-02-26 8:34:36 0 [Note] InnoDB: Using transactional memory
|
2024-02-26 8:34:36 0 [Note] InnoDB: Number of pools: 1
|
2024-02-26 8:34:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2024-02-26 8:34:36 0 [Note] InnoDB: Using liburing
|
2024-02-26 8:34:36 0 [Note] InnoDB: Initializing buffer pool, total size = 42949672960, chunk size = 42949672960
|
2024-02-26 8:34:36 0 [Note] InnoDB: Completed initialization of buffer pool
|
2024-02-26 8:34:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=31507622579405,31507622976800
|
2024-02-26 8:34:48 0 [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size; last checkpoint LSN=31507622579405, current LSN=31508457793604. Shutdown is in progress.
|
2024-02-26 8:34:48 0 [Note] InnoDB: Starting final batch to recover 237985 pages from redo log.
|
2024-02-26 8:34:51 0 [Note] InnoDB: To recover: 174243 pages from log
|
2024-02-26 8:35:00 0 [Note] InnoDB: Last binlog file './mysqld-bin.003284', position 666209873
|
[00] 2024-02-26 08:35:01 Last binlog file ./mysqld-bin.003284, position 666209873
|
[00] 2024-02-26 08:35:01 mariabackup: Recovered WSREP position: 2430d56f-1879-11e8-9a58-defae87a2441:6397994274
|
 |
[00] 2024-02-26 08:35:02 completed OK!
|
Then the node is started and it works ok, but this line troubles me:
2024-02-26 8:34:48 0 [ERROR] InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size; last checkpoint LSN=31507622579405, current LSN=31508457793604. Shutdown is in progress.
|
Is this expected? All I could find to this was: https://jira.mariadb.org/browse/MDEV-29982
I've tried MariaDB 10.6.14 and 10.6.17, same error, multiple times.
Thank you!
Attachments
Issue Links
- is caused by
-
MDEV-17458 Unable to Start Galera Node
- Closed