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

Backup failed to restore between 10.11.15, worked 10.11.11-10.11.15

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11.15
    • None
    • None
    • Centos stream 9

    Description

      Backup created on 10.11.11 and correctly always restored with 10.11.15

      Now, update to 10.11.15 on the backup side, and can not restore correctly on restore side with 10.11.15

      mariabackup based on MariaDB server 10.11.15-MariaDB Linux (x86_64)
      [00] 2025-12-14 12:58:56 cd to /var/lib/mysql/20251214/
      [00] 2025-12-14 12:58:56 open files limit requested 0, set to 1024
      [00] FATAL ERROR: 2025-12-14 12:58:56 Can't open backup-my.cnf for reading
      Job for mariadb.service failed because the control process exited with error code.
      See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
      ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/db/mysql.sock' (2)
      ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/db/mysql.sock' (2)

      2025-12-14 12:58:57 0 [Note] Starting MariaDB 10.11.15-MariaDB-log source revision cb0d6dd835023a7162ace471cd047161f205dd58 server_uid a0KDg6OAig3uIsu6hClHQ/Zfmb4= as process 115406
      2025-12-14 12:58:57 0 [Warning] You need to use --log-bin to make --binlog-format work.
      2025-12-14 12:58:57 0 [ERROR] mariadbd: Aria engine: log data error
      last_log_page: (1,0x5a8000) is less than
      checkpoint page: (1,0x5aa000)
      2025-12-14 12:58:57 0 [ERROR] mariadbd: Aria engine: log initialization failed
      2025-12-14 12:58:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
      2025-12-14 12:58:57 0 [Note] InnoDB: innodb_page_size=65536
      2025-12-14 12:58:57 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
      2025-12-14 12:58:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2025-12-14 12:58:57 0 [Note] InnoDB: Number of transaction pools: 1
      2025-12-14 12:58:57 0 [Note] InnoDB: Using AVX512 instructions
      2025-12-14 12:58:57 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
      create_uring failed: falling back to libaio
      2025-12-14 12:58:57 0 [Note] InnoDB: Using Linux native AIO
      2025-12-14 12:58:57 0 [Note] InnoDB: innodb_buffer_pool_size_max=1024m, innodb_buffer_pool_size=1024m
      2025-12-14 12:58:57 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-12-14 12:58:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2025-12-14 12:58:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=133560890432425
      2025-12-14 12:58:58 0 [Note] InnoDB: At LSN: 133560891200692: unable to open file ./rawdata/z_565.ibd for tablespace 24690259

      2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
      2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
      2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
      2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]
      2025-12-14 12:58:58 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=22788774, page number=264]

      2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=53376] log sequence number 133561104170750 is in the future! Current system log sequence number 133560995876495.
      2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=193681] log sequence number 133561109252027 is in the future! Current system log sequence number 133560995876495.
      2025-12-14 12:59:20 0 [Note] InnoDB: Setting file '/var/lib/mysql/db/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2025-12-14 12:59:20 0 [Note] InnoDB: File '/var/lib/mysql/db/ibtmp1' size is now 12.000MiB.
      2025-12-14 12:59:20 0 [Note] InnoDB: log sequence number 133560995876495; transaction id 10589504796
      2025-12-14 12:59:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/db/ib_buffer_pool
      2025-12-14 12:59:20 0 [Note] InnoDB: Cannot open '/var/lib/mysql/db/ib_buffer_pool' for reading: No such file or directory
      2025-12-14 12:59:20 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-12-14 12:59:20 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
      2025-12-14 12:59:20 0 [ERROR] Failed to initialize plugins.
      2025-12-14 12:59:20 0 [ERROR] Aborting

      2025-12-14 12:59:20 0 [Note] Starting MariaDB 10.11.15-MariaDB-log source revision cb0d6dd835023a7162ace471cd047161f205dd58 server_uid a0KDg6OAig3uIsu6hClHQ/Zfmb4= as process 115637
      2025-12-14 12:59:20 0 [Warning] You need to use --log-bin to make --binlog-format work.
      2025-12-14 12:59:20 0 [ERROR] mariadbd: Aria engine: log data error
      last_log_page: (1,0x5a8000) is less than
      checkpoint page: (1,0x5aa000)
      2025-12-14 12:59:20 0 [ERROR] mariadbd: Aria engine: log initialization failed
      2025-12-14 12:59:20 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
      2025-12-14 12:59:20 0 [Note] InnoDB: innodb_page_size=65536
      2025-12-14 12:59:20 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
      2025-12-14 12:59:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2025-12-14 12:59:20 0 [Note] InnoDB: Number of transaction pools: 1
      2025-12-14 12:59:20 0 [Note] InnoDB: Using AVX512 instructions
      2025-12-14 12:59:20 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
      create_uring failed: falling back to libaio
      2025-12-14 12:59:20 0 [Note] InnoDB: Using Linux native AIO
      2025-12-14 12:59:20 0 [Note] InnoDB: innodb_buffer_pool_size_max=1024m, innodb_buffer_pool_size=1024m
      2025-12-14 12:59:20 0 [Note] InnoDB: Completed initialization of buffer pool
      2025-12-14 12:59:20 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2025-12-14 12:59:20 0 [Note] InnoDB: End of log at LSN=133560995876495

      2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=53376] log sequence number 133561104170750 is in the future! Current system log sequence number 133560995876495.
      2025-12-14 12:59:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=193681] log sequence number 133561109252027 is in the future! Current system log sequence number 133560995876495.
      2025-12-14 12:59:20 0 [Note] InnoDB: Setting file '/var/lib/mysql/db/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2025-12-14 12:59:20 0 [Note] InnoDB: File '/var/lib/mysql/db/ibtmp1' size is now 12.000MiB.
      2025-12-14 12:59:20 0 [Note] InnoDB: log sequence number 133560995876495; transaction id 10589504796
      2025-12-14 12:59:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/db/ib_buffer_pool
      2025-12-14 12:59:20 0 [Note] InnoDB: Cannot open '/var/lib/mysql/db/ib_buffer_pool' for reading: No such file or directory
      2025-12-14 12:59:20 0 [Note] Plugin 'FEEDBACK' is disabled.
      2025-12-14 12:59:20 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
      2025-12-14 12:59:20 0 [ERROR] Failed to initialize plugins.
      2025-12-14 12:59:20 0 [ERROR] Aborting

      I set force recovery to = 4 and do mv /var/lib/mysql/db/aria_log.* /var/lib/mysql/db/aria_log.backup_*

      Worked, but a lot of new errors with 10.11.15.

      Attachments

        Activity

          People

            Unassigned Unassigned
            shexphobos Xesh
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.