BUG #17685: pg_rewind: error: unexpected result while fetching remote files: ERROR: could not open file ".s.PGS

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 1726002692(at)qq(dot)com
Subject: BUG #17685: pg_rewind: error: unexpected result while fetching remote files: ERROR: could not open file ".s.PGS
Date: 2022-11-11 12:22:10
Message-ID: 17685-2456943edafec3e7@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17685
Logged by: 强 魏
Email address: 1726002692(at)qq(dot)com
PostgreSQL version: 15.1
Operating system: Centos 7.6
Description:

unix_socket_directories=".,/tmp" or unix_socket_directories='.'

pg_rewind will be error:pg_rewind: error: unexpected result while fetching
remote files: ERROR: could not open file ".s.PGSQL.5433" for reading:
没有那个设备或地址

[pg15(at)PG02 pg151]$ pg_rewind --target-pgdata=/pgdata/pg151
--source-server="host=192.168.247.100 port=5433 user=postgres password=root
dbname=postgres" -R -n
pg_rewind: servers diverged at WAL location 0/300000D8 on timeline 8
pg_rewind: rewinding from last common checkpoint at 0/30000028 on timeline
8
pg_rewind: error: unexpected result while fetching remote files: ERROR:
could not open file ".s.PGSQL.5433" for reading: 没有那个设备或地址

unix_socket_directories='/tmp' pg_rewind is ok

[pg15(at)PG02 pg151]$ pg_rewind --target-pgdata=/pgdata/pg151
--source-server="host=192.168.247.100 port=5433 user=postgres password=root
dbname=postgres" -R
pg_rewind: servers diverged at WAL location 0/300000D8 on timeline 8
pg_rewind: rewinding from last common checkpoint at 0/30000028 on timeline
8
pg_rewind: Done!

Browse pgsql-bugs by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-11-11 14:50:40 Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Previous Message PG Bug reporting form 2022-11-11 10:51:20 BUG #17684: pg_rewind ---could not receive data from WAL stream: ERROR: requested WAL segment 00000005000000000