Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31410

mariadb-backup prepare crash with InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT

    XMLWordPrintable

Details

    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

          Activity

            People

              marko Marko Mäkelä
              Beshelmek Vladimir Votyakov
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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