Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.3
-
Debian 11
Description
After upgrade from 10.3.4 to 10.11.3, mariabackup gives error on backup prepare stage.
I am doing a partial backup using the --databases='mysql database_mail' argument and tablespace 1296 (database_log) should not be included in the backup.
Also worth noting, if I backup another database (--databases='mysql database_common'), all is well.
There are no errors or warnings during the backup process.
Full log:
mariabackup based on MariaDB server 10.11.3-MariaDB debian-linux-gnu (x86_64) |
[00] 2023-06-05 06:58:50 cd to /backup/ |
[00] 2023-06-05 06:58:50 open files limit requested 0, set to 1048576 |
[00] 2023-06-05 06:58:50 This target seems to be not prepared yet. |
[00] 2023-06-05 06:58:50 mariabackup: using the following InnoDB configuration for recovery: |
[00] 2023-06-05 06:58:50 innodb_data_home_dir = . |
[00] 2023-06-05 06:58:50 innodb_data_file_path = ibdata1:12M:autoextend |
[00] 2023-06-05 06:58:50 innodb_log_group_home_dir = . |
[00] 2023-06-05 06:58:50 InnoDB: Using liburing |
[00] 2023-06-05 06:58:50 Starting InnoDB instance for recovery. |
[00] 2023-06-05 06:58:50 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) |
2023-06-05 6:58:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 |
2023-06-05 6:58:50 0 [Note] InnoDB: Number of transaction pools: 1 |
2023-06-05 6:58:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions |
2023-06-05 6:58:50 0 [Note] InnoDB: Using liburing |
2023-06-05 6:58:50 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB |
2023-06-05 6:58:50 0 [Note] InnoDB: Completed initialization of buffer pool |
2023-06-05 6:58:50 0 [Note] InnoDB: Buffered log writes (block size=4096 bytes) |
2023-06-05 6:58:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6957562626620 |
2023-06-05 6:58:57 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 1296 |
[00] 2023-06-05 06:58:57 mariadb-backup: srv_start() returned 37 (Data structure corruption). |
mariabackup --print-defaults:
--default_storage_engine=InnoDB --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --lc_messages_dir=/usr/share/mysql --lc_messages=en_US --bind-address=0.0.0.0 --skip-external-locking --skip-name-resolve --max_connections=3500 --connect_timeout=5 --wait_timeout=600 --max_allowed_packet=32M --thread_cache_size=256 --sort_buffer_size=8M --bulk_insert_buffer_size=32M --tmp_table_size=64M --max_heap_table_size=64M --log_warnings=2 --slow_query_log=1 --slow_query_log_file=/var/log/mysql/mariadb-slow.log --long_query_time=10 --log_slow_verbosity=query_plan --log_bin=/var/log/mysql/mariadb-bin --log_bin_index=/var/log/mysql/mariadb-bin.index --relay-log=/var/log/mysql/mariadb-relay-bin --relay_log_space_limit=100G --sync_binlog=0 --expire_logs_days=3 --max_binlog_size=100M --query_cache_limit=128K --query_cache_size=512M --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --innodb_force_recovery=0 --slave-skip-errors=1062 --innodb_log_file_size=16G --innodb_buffer_pool_size=16384M --innodb_log_buffer_size=16M --innodb_file_per_table=1 --innodb_open_files=800 --innodb_io_capacity=800 --innodb_flush_method=O_DIRECT --innodb_flush_log_at_trx_commit=0 --binlog-do-db=database_log --region.replicate-do-db=database_log --game_region.replicate-do-db=database_mail --harbor.replicate-do-db=database_common --replicate-ignore-table=database_log.log --server-id=224 --myisam_recover_options=BACKUP --key_buffer_size=128M --myisam_sort_buffer_size=512M --table_open_cache=400 --concurrent_insert=2 --read_buffer_size=2M --read_rnd_buffer_size=1M |
Attachments
Issue Links
- relates to
-
MDEV-14992 BACKUP: in-server backup
- Open
-
MDEV-28870 InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT during crash recovery
- Closed
-
MDEV-30000 make mariadb-backup to force an innodb checkpoint
- Open
-
MDEV-34062 mariadb-backup --backup is extremely slow at copying ib_logfile0
- Closed
-
MDEV-34062 mariadb-backup --backup is extremely slow at copying ib_logfile0
- Closed