Pg_basebackup error: COPY stream ended before last file was finished14 on Citus worker
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Hi all,
I use PostgreSQL 15.6 and Citus 12.1
I try to set up replication on worker node with pg_basebackup like this:
` /usr/pgsql-15/bin/pg_basebackup -D /pgsql/15/data -Fp -R -X stream -c fast -C -S citusrepslot -P -h primary_ip -p 5432 -U replicauser `
But I hot error like this:
`pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 47D/380000D8 on timeline 1
pg_basebackup: starting background WAL receiver
pg_basebackup: created replication slot "citusrepslot"
pg_basebackup: error: COPY stream ended before last file was finished14 )
pg_basebackup: removing contents of data directory "/pgsql/15/data"
`
In the same time, primary logs like this:
` > ERROR: invalid segment number 0 in file "insert_select_1_109835.data"
> STATEMENT: BASE_BACKUP ( LABEL 'pg_basebackup base backup', PROGRESS, CHECKPOINT 'fast', WAIT 0, MANIFEST 'yes', TARGET 'client')
`
I have 4 citus worker. I dont have any problem 3 of them. But I cannot create replication in 1 worker.
Is there any idea? Thank you.
Contributor guide
Assessment
This issue has not been assessed yet.