# Xtrabackup fails when creating backup

**URL:** <https://forums.percona.com/t/xtrabackup-fails-when-creating-backup/31307>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [June 28, 2024, 2:43pm UTC](https://forums.percona.com/t/xtrabackup-fails-when-creating-backup/31307 "2024-06-28T14:43:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CosmicOppai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cosmicoppai/32/14210_2.png) [@CosmicOppai](https://forums.percona.com/u/CosmicOppai)\
**Post date:** [June 28, 2024, 2:43pm UTC](https://forums.percona.com/t/xtrabackup-fails-when-creating-backup/31307/1 "2024-06-28T14:43:33Z")

</div>

We’re taking a periodic volume snapshot of our database. We decided to store these backups somewhere else also for debugging purpose as the volume snapshots are in rolling window.  
We’re attaching this snapshot volume in some machine and running the xtrabackup utility for the backup. But we encounter this following error quite often:

```auto
2024-06-28T13:08:53.497700-00:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (259520894871145)
2024-06-28T13:08:54.497917-00:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (259520894871145)
2024-06-28T13:08:55.182241-00:00 6 [Warning] [MY-012637] [InnoDB] 10485760 bytes should have been read. Only 3932160 bytes read. Retrying for the remaining bytes.
2024-06-28T13:08:55.186227-00:00 6 [Warning] [MY-012638] [InnoDB] Retry attempts for reading partial data failed.
2024-06-28T13:08:55.194663-00:00 6 [ERROR] [MY-011825] [Xtrabackup] xtrabackup_copy_datafile() failed
2024-06-28T13:08:55.194694-00:00 6 [ERROR] [MY-011825] [Xtrabackup] failed to copy datafile ./scrape_history/scraped_history_airbnb_los.ibd
2024-06-28T13:08:55.498167-00:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (259520894871145)
2024-06-28 13:08:56 [ERROR]: xbu-wsdbh -- (/mnt/xbu-wsdbh-wsdbh-mysql-hourly-11828/mysql): Incremental backup failed.

```

---

<div class="post-metadata">

**Author:** ![CosmicOppai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cosmicoppai/32/14210_2.png) [@CosmicOppai](https://forums.percona.com/u/CosmicOppai)\
**Post date:** [June 28, 2024, 2:45pm UTC](https://forums.percona.com/t/xtrabackup-fails-when-creating-backup/31307/2 "2024-06-28T14:45:10Z")

</div>

The following commands we run for full and inc backup respectively:

```auto
xtrabackup --backup --host="${DB_HOST}" --user="${DB_USER}" --password="${DB_PASS}" --target-dir=${TARGET_DIR}/"${base_dir}" --strict --parallel=$CPUS

```

```auto
xtrabackup --backup --host="${DB_HOST}" --user="${DB_USER}" --password="${DB_PASS}" --target-dir="$TARGET_DIR/$curr_hr" --strict --incremental-lsn="$last_successful_backup_lsn" --parallel=$CPUS

```

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [June 28, 2024, 6:51pm UTC](https://forums.percona.com/t/xtrabackup-fails-when-creating-backup/31307/3 "2024-06-28T18:51:38Z")

</div>

Are any DDLs taking place during the backup?
