Xtrabackup failure - xbcloud upload failure

MySQL & MariaDB Percona XtraBackup
1

Hello,
I’m looking for help with xtrabackup problem.

the xtrabackup command:

xtrabackup --user=... --password=... --backup  --datadir=/data/mysql/data --stream=xbstream --read-buffer-size=500M --extra-lsndir=/tmp --target-dir=/tmp  | xbcloud put --storage=s3 --s3-access-key=... --s3-secret-key=... --s3-bucket=s3://... --s3-region=us-east-2 --parallel=4 s3://.../mysql-backup-26310-qa-oltp-percona01-a01-20250415_114601

With the following environment:

OS: AlmaLinux release 9.5
MySQL: Ver 8.0.36-28 for Linux on x86_64 (Percona Server (GPL)
xtrabackup: xtrabackup version 8.0.35-32 based on MySQL server 8.0.35
xbcloud: xbcloud Ver 8.0.35-32

I’m running the xtrabackup, which results in error:

....
250421 09:24:17 xbcloud: [0] successfully uploaded chunk: mysql-backup-26310-qa-oltp-percona01-a01-20250415_114601/ib_buffer_pool.00000000000000000000, size: 1255605
250421 09:24:18 xbcloud: Upload failed: backup is incomplete.
Backup doesn't contain last file with prefix xtrabackup_tablespaces in the cloud storage
$

If executed with verbose mode:

* Mark bundle as not supporting multiuse
< HTTP/1.1 200 OK
< x-amz-id-2: tN2j4YOoXoMNhUaGv7q++WadqGO938SGDJk2Oi1E5EypPx+0wno0ZH0MUaL6/9vmnrrhOw5LJHwe0OLyULduz0ojKRsH+kPG6bpNkXUeNmg=
< x-amz-request-id: .....
< Date: Mon, 21 Apr 2025 09:32:24 GMT
< x-amz-bucket-region: us-east-2
< Content-Type: application/xml
< Transfer-Encoding: chunked
< Server: AmazonS3
<
* Connection #1 to host .....us-east-2.amazonaws.com left intact
250421 09:32:23 xbcloud: Upload failed: backup is incomplete.
Backup doesn't contain last file with prefix xtrabackup_tablespaces in the cloud storage
$

Does anybody know what could be the problem? Or give some advise on troubleshooting?

Regards

lk

2

Could you try taking a backup separately and see if that completes, and upload it separately?

3

Hello Yunus,

Yes, the execution of backup completes fine:

2025-04-22T04:41:38.224731-00:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (192742418103) to (192801743311) was copied.
2025-04-22T04:41:38.432894-00:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
4

Thank you again Yanus.
After running the backup, it appeared also that there is not enough disk space at /tmp.
With more disk space, the original xtrabackup with xbcloud started to work.

5

That’s good to hear that the issue was identified.

6

Just want to add that you might want to consider adding --compress to your xtrabackup. This compresses the files with zstd before streaming to cloud/writing to tmp.