search

postgrespro / pg_probackup

Backup and recovery manager for PostgreSQL
https://postgrespro.github.io/pg_probackup/
Other
712 stars 86 forks source link

Backup failed (the value of segment_size is greater than 2G) #609

Open qiuwenhuifx opened 1 year ago

qiuwenhuifx commented 1 year ago 
pgsql@n97-16-026:~$ pg_probackup -V
pg_probackup 2.5.12 (PostgreSQL 15.4)
pgsql@n97-16-026:~$

INFO: Backup files are synced, time elapsed: 0
INFO: Validating backup RZW6OO
ERROR: Cannot seek block 261889 of "/data00/pgsql/backup/backups/pg_5436/RZW6OO/database/base/16393/16440.1": Invalid argument
ERROR: Data files validation failed
pgsql@n97-16-066:$ du -sh /data00/pgsql/backup/backups/pg_5436/RZW6OO/database/base/16393/16440.1
2.4G /data00/pgsql/backup/backups/pg_5436/RZW6OO/database/base/16393/16440.1
pgsql@n97-16-066:$

I see there is a pull patch to fix this bug:(https://github.com/postgrespro/pg_probackup/pull/510),What is a very robust reason not to fix this bug
jianyang1982 commented 1 year ago

I also meet this bug ,use 2.5.12, my one datafile is large then 9GB,backup failed. so sad，please fix it as soon as possible. info bellow : [postgres@pgmaster2 ~]$ pg_probackup --version pg_probackup 2.5.12 (PostgreSQL 9.6.24)

ERROR: Cannot seek block 800240 of "/paic/pgbackup/mhisdrgs/pgrman/backups/mhisdrgs/S1JPEW/database/base/16411/17093": Invalid argument ERROR: Data files validation failed

fukanchik commented 1 year ago

We do not have access to a postgres with 2GB segments. Your patches are welcome!

jianyang1982 commented 1 year ago

my postgresql version is 9.6.2 ，pg_probackup complie it with error ‘connect.h’，so i use 9.6.24 complied it instead。when I complie posgresql 9.6.2 ，I use --with-segsize=10 ，so the largest file is 10GB. You can use this parameter，and file data file large than that，maybe can repeat this bug。Thank you。