# Unable to restore backup via xtrabackup **URL:** \ **Category:** Percona XtraBackup\ **Tags:** mysql\ **Created:** [September 26, 2025, 5:37pm UTC](https://forums.percona.com/t/unable-to-restore-backup-via-xtrabackup/39460 "2025-09-26T17:37:47Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![cosmicOpie](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cosmicopie/32/22224_2.png) [@cosmicOpie](https://forums.percona.com/u/cosmicOpie)\ **Post date:** [September 26, 2025, 5:37pm UTC](https://forums.percona.com/t/unable-to-restore-backup-via-xtrabackup/39460/1 "2025-09-26T17:37:47Z")
I’m trying to restore one of my incremental backup. I applied 4 incremental to my base, but during the 5th one it crashed. ata.ibd2025-09-26T17:24:30.085192-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_new.ibd.delta is 16384 bytes2025-09-26T17:24:30.085291-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_new.ibd.delta to ./reporting/reporting\_homeaway\_data\_new.ibd2025-09-26T17:24:30.086721-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_archives.ibd.delta is 16384 bytes2025-09-26T17:24:30.086790-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_archives.ibd.delta to ./reporting/reporting\_homeaway\_data\_archives.ibd2025-09-26T17:24:30.088262-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_hotel\_data\_archives.ibd.delta is 16384 bytes2025-09-26T17:24:30.088336-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_hotel\_data\_archives.ibd.delta to ./reporting/reporting\_hotel\_data\_archives.ibd2025-09-26T17:24:30.089726-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_hotels.ibd.delta is 16384 bytes2025-09-26T17:24:30.089794-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_hotels.ibd.delta to ./reporting/reporting\_address\_hotels.ibd2025-09-26T17:24:30.091216-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_airbnb\_info.ibd.delta is 16384 bytes2025-09-26T17:24:30.091286-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_airbnb\_info.ibd.delta to ./reporting/reporting\_airbnb\_info.ibd2025-09-26T17:24:30.092716-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_listings.ibd.delta is 16384 bytes2025-09-26T17:24:30.092786-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_listings.ibd.delta to ./reporting/reporting\_address\_listings.ibd2025-09-26T17:24:30.094178-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_new\_archives.ibd.delta is 8192 bytes2025-09-26T17:24:30.094236-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data\_new\_archives.ibd.delta to ./reporting/reporting\_homeaway\_data\_new\_archives.ibd2025-09-26T17:24:30.095504-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data.ibd.delta is 16384 bytes2025-09-26T17:24:30.095564-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_homeaway\_data.ibd.delta to ./reporting/reporting\_homeaway\_data.ibd2025-09-26T17:24:30.097296-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_hotel\_data.ibd.delta is 16384 bytes2025-09-26T17:24:30.097362-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_hotel\_data.ibd.delta to ./reporting/reporting\_hotel\_data.ibd2025-09-26T17:24:30.098774-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_homeaway\_listings.ibd.delta is 16384 bytes2025-09-26T17:24:30.098845-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//reporting/reporting\_address\_homeaway\_listings.ibd.delta to ./reporting/reporting\_address\_homeaway\_listings.ibd2025-09-26T17:24:30.100794-00:00 0 [Note] [MY-011825] [Xtrabackup] page size for /xbackup/incrementals/1758171600\_05//undo\_001.delta is 16384 bytes2025-09-26T17:24:30.102058-00:00 0 [Note] [MY-011825] [Xtrabackup] Applying /xbackup/incrementals/1758171600\_05//undo\_001.delta to ./undo\_0012025-09-26T17:24:31.103580-00:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:2025-09-26T17:24:31.103625-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb\_data\_home\_dir = .2025-09-26T17:24:31.103630-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb\_data\_file\_path = ibdata1:12M:autoextend2025-09-26T17:24:31.103645-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb\_log\_group\_home\_dir = /xbackup/incrementals/1758171600\_05/2025-09-26T17:24:31.103651-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb\_log\_files\_in\_group = 12025-09-26T17:24:31.103655-00:00 0 [Note] [MY-011825] [Xtrabackup] innodb\_log\_file\_size = 175636482025-09-26T17:24:31.103664-00:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.2025-09-26T17:24:31.103669-00:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)2025-09-26T17:24:31.103692-00:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available2025-09-26T17:24:31.103711-00:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes2025-09-26T17:24:31.103715-00:00 0 [Note] [MY-012945] [InnoDB] GCC builtin \_\_atomic\_thread\_fence() is used for memory barrier2025-09-26T17:24:31.103721-00:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.132025-09-26T17:24:31.104305-00:00 0 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.2025-09-26T17:24:31.104601-00:00 0 [Note] [MY-012203] [InnoDB] Directories to scan ‘./’2025-09-26T17:24:31.104664-00:00 0 [Note] [MY-012204] [InnoDB] Scanning ‘./’2025-09-26T17:24:31.266393-00:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 238 files.2025-09-26T17:24:31.267040-00:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M2025-09-26T17:24:31.274526-00:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool2025-09-26T17:24:31.276053-00:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2025-09-26T17:24:31.358537-00:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 112879764219029 in redo log file /xbackup/incrementals/1758171600\_05/#innodb\_redo/#ib\_redo0.2025-09-26T17:24:31.358601-00:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 112870530763541 in the system tablespace does not match the log sequence number 112879764219029 in the redo log files!2025-09-26T17:24:31.358607-00:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!2025-09-26T17:24:31.358611-00:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.2025-09-26T17:24:31.360354-00:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 112879764219188, whereas checkpoint\_lsn = 112879764219029 and start\_lsn = 1128797642188802025-09-26T17:24:31.492414-00:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 1128797694617602025-09-26T17:24:31.632439-00:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 1128797747046402025-09-26T17:24:31.776117-00:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 1128797798335082025-09-26T17:24:31.780643-00:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started…2025-09-26T17:24:31.781151-00:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 113698 redo log records …2025-09-26T17:24:36.299083-00:00 0 [Note] [MY-012533] [InnoDB] 10%2025-09-26T17:24:40.571784-00:00 0 [Note] [MY-012533] [InnoDB] 20%2025-09-26T17:24:43.372836-00:00 0 [Note] [MY-012533] [InnoDB] 30%2025-09-26T17:24:45.396932-00:00 0 [Note] [MY-012533] [InnoDB] 40%2025-09-26T17:24:46.754036-00:00 0 [Note] [MY-012533] [InnoDB] 50%2025-09-26T17:24:47.788369-00:00 0 [Note] [MY-012533] [InnoDB] 60%2025-09-26T17:24:48.666768-00:00 0 [Note] [MY-012533] [InnoDB] 70%2025-09-26T17:24:49.391693-00:00 0 [Note] [MY-012533] [InnoDB] 80%2025-09-26T17:24:49.988120-00:00 0 [Note] [MY-012533] [InnoDB] 90%InnoDB: Assertion failure: page0cur.cc:1206InnoDB: thread 140120355239488InnoDB: We intentionally generate a memory trap.InnoDB: Submit a detailed bug report to [Log in with Atlassian account](https://jira.percona.com/projects/PXB.InnoDB:) If you get repeated assertion failures or crashes, evenInnoDB: immediately after the mysqld startup, there may beInnoDB: corruption in the InnoDB tablespace. Please refer toInnoDB: [http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.htmlInnoDB:](http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.htmlInnoDB:) about forcing recovery.2025-09-26T17:24:51Z UTC - mysqld got signal 6 ;Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.BuildID[sha1]=Thread pointer: 0x0Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong…stack\_bottom = 0 thread\_stack 0x100000xtrabackup(my\_print\_stacktrace(unsigned char const\*, unsigned long)+0x3d) [0x2585b4d]xtrabackup(print\_fatal\_signal(int)+0x393) [0x12c4893]xtrabackup(handle\_fatal\_signal+0x95) [0x12c4975]/lib/x86\_64-linux-gnu/libc.so.6(+0x42520) [0x7f70683ed520]/lib/x86\_64-linux-gnu/libc.so.6(pthread\_kill+0x12c) [0x7f70684419fc]/lib/x86\_64-linux-gnu/libc.so.6(raise+0x16) [0x7f70683ed476]/lib/x86\_64-linux-gnu/libc.so.6(abort+0xd3) [0x7f70683d37f3]xtrabackup(my\_abort()+0xa) [0x257f2da]xtrabackup(ut\_dbg\_assertion\_failed(char const\*, char const\*, unsigned long)+0xf7) [0x17f7f47]xtrabackup(page\_cur\_parse\_insert\_rec(bool, unsigned char const\*, unsigned char const\*, buf\_block\_t\*, dict\_index\_t\*, mtr\_t\*)+0xbb3) [0x16eea53]xtrabackup() [0x16b5b68]xtrabackup(recv\_recover\_page\_func(bool, buf\_block\_t\*)+0x602) [0x16b9242]xtrabackup(buf\_page\_io\_complete(buf\_page\_t\*, bool)+0x3f6) [0x146ad76]xtrabackup(fil\_aio\_wait(unsigned long)+0x152) [0x1560a42]xtrabackup() [0x16d6250]xtrabackup(std::\_State\_impl\ \> \>::\_M\_run()+0xd7) [0x16d4517]xtrabackup() [0x284616f]/lib/x86\_64-linux-gnu/libc.so.6(+0x94ac3) [0x7f706843fac3]/lib/x86\_64-linux-gnu/libc.so.6(clone+0x44) [0x7f70684d0a04] xtrabackup-version:` Percona-XtraBackup-8.0.35-30` MySQL version: `8.0.39` Is there any workaround to apply the next ones, if I can’t apply this failing incremental? ---
**Author:** ![anil.joshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anil.joshi/32/13100_2.png) [@anil.joshi](https://forums.percona.com/u/anil.joshi)\ **Post date:** [October 17, 2025, 3:58am UTC](https://forums.percona.com/t/unable-to-restore-backup-via-xtrabackup/39460/2 "2025-10-17T03:58:07Z")
@cosmicOpie It appears it crashing around some redo log recovery. Did you check if the last incremental backup happen fine ? Do you have any logs of last incremental backup ? `xtrabackup(my_abort()+0xa) [0x257f2da]xtrabackup(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0xf7) [0x17f7f47]xtrabackup(page_cur_parse_insert_rec(bool, unsigned char const*, unsigned char const*, buf_block_t*, dict_index_t*, mtr_t*)+0xbb3) [0x16eea53]xtrabackup()` The below version compatibility shouldn’t be problem as you using PXB 8.0.35 already:- [Percona XtraBackup Version Compatibility and Server Version Checks - Percona XtraBackup](https://docs.percona.com/percona-xtrabackup/8.0/server-backup-version-comparison.html) > xtrabackup-version:` Percona-XtraBackup-8.0.35-30` > MySQL version: `8.0.39` Also, can you please share the commands you are using for preparing backup ?