[Xtrabackup] innodb_init(): Error occured

MySQL & MariaDB Percona XtraBackup
1

What I do wrong ?
Backup:

    xtrabackup --backup --compress --stream=xbstream --target-dir=./  | ssh root@remote.server "xbstream -x --decompress -C /dest/folder"

Prepare on the destination host:

    xtrabackup --prepare --target-dir=./

But I get:

    2022-06-28T14:12:11.458411-04:00 0 [Note] [MY-012533] [InnoDB] 90%
    2022-06-28T14:12:15.829400-04:00 0 [Note] [MY-012533] [InnoDB] 100%
    2022-06-28T14:12:18.186453-04:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
    2022-06-28T14:12:18.297460-04:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
    2022-06-28T14:12:18.297886-04:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
    2022-06-28T14:12:18.298392-04:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
    2022-06-28T14:12:18.298444-04:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 6092270861
    2022-06-28T14:12:18.319456-04:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
    2022-06-28T14:12:18.319510-04:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 21066 ms.
    2022-06-28T14:12:18.319738-04:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
    2022-06-28T14:12:18.319799-04:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2022-06-28T14:12:18.406817-04:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
    2022-06-28T14:12:18.407014-04:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
    2022-06-28T14:12:18.450901-04:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
    2022-06-28T14:12:18.451350-04:00 0 [Note] [MY-012976] [InnoDB] 8.0.28 started; log sequence number 6031192309697
    2022-06-28T14:12:18.451347-04:00 0 [Note] [MY-011953] [InnoDB] Page cleaner took 780782ms to flush 0 and evict 0 pages
    2022-06-28T14:12:18.453203-04:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 62383 for sys/sys_config, old maximum was 0
    2022-06-28T14:12:23.105017-04:00 0 [ERROR] [MY-011825] [Xtrabackup] innodb_init(): Error occured

And nothing works.

1 Like
2

What is the xtrabackup version and MySQL versions you are working with?

1 Like
3

Xtrabackup versions are exact the same (xtrabackup version 8.0.28-21 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 78878e9b608). But I don’t have mysql on the destination host

1 Like
4

I have not been able to recreate your problem. Have you tried to create the backup then copy to the destination, then prepare it?

1 Like
5

yes it works, but unfortunately I don’t enough space to do like this

1 Like
6

I am sure you checked, but I was wondering did you run out of disk space when you hit this error:

2022-06-28T14:12:23.105017-04:00 0 [ERROR] [MY-011825] [Xtrabackup] innodb_init(): Error occurred

1 Like
7

I don’t know why, but looks like it works now,
I’ve downgraded xtrabckup to percona-xtrabackup-80-8.0.11-1.el7
on both servers, and everything is ok now.

1 Like