FATAL ERROR: <time> Was only able to copy log from <seq_no> to <seq_no>, not <seq_no>; try increasing innodb_log_file_size

[00] FATAL ERROR: 2024-02-02 10:16:28 Was only able to copy log from 2825766826 to 2892744515, not 3030682034; try increasing innodb_log_file_size

+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table     | Create Table                                                                                                                                                                                                         |

+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| test_data | CREATE TABLE `test_data` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `data` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=10000015 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci |

+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.000 sec)

MariaDB [testdb]> select * from test_data limit 5;

+----+-----------------------+

| id | data                  |

+----+-----------------------+

|  1 | This is a test string |

|  2 | This is a test string |

|  3 | This is a test string |

|  4 | This is a test string |

|  5 | This is a test string |

+----+-----------------------+

5 rows in set (0.001 sec)

MariaDB [testdb]> select count(*) from test_data;

+----------+

| count(*) |

+----------+

| 10000014 |

+----------+

1 row in set (9.947 sec)

## SESSION 1

MariaDB [testdb]> alter table test_data engine=innodb;

Query OK, 0 rows affected (1 min 2.641 sec)

Records: 0  Duplicates: 0  Warnings: 0

## SESSION 2

mariabackup --backup --target-dir=/backup --user=root --password=root

240202 11:19:36 >> log scanned up to (1948476139)

InnoDB: Last flushed lsn: 1947667398 load_index lsn 1948481497

InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have been flushed to the disk yet.

PXB will not be able to make a consistent backup. Retry the backup operation