ERROR: could not open file "pg_tblspc/ issue with replication setup. - Mailing list pgsql-hackers

From Rajkumar Raghuwanshi
Subject ERROR: could not open file "pg_tblspc/ issue with replication setup.
Date
Msg-id CAKcux6k6AeA1Sd1XzTaeb-o0f0CNZu2+UdHr6OqUfWxh16ocgQ@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: could not open file "pg_tblspc/ issue with replicationsetup.
List pgsql-hackers
Hi,

While testing for a feature I got this tablespace related error while running script.
The Issue is not reproducible everytime, but If I am running the same set of commands after 2-3 runs I am able to reproduce the same error.

--first run - pass
# master slave setup
+ mkdir /tmp/test_bkp/tblsp01
+ ./psql postgres -p 5432 -c 'create tablespace tblsp01 location '\''/tmp/test_bkp/tblsp01'\'';'
CREATE TABLESPACE
+ ./psql postgres -p 5432 -c 'create table test (a text) tablespace tblsp01;'
CREATE TABLE
#cleanup

--next
#master-slave setup
+ mkdir /tmp/test_bkp/tblsp01
+ ./psql postgres -p 5432 -c 'create tablespace tblsp01 location '\''/tmp/test_bkp/tblsp01'\'';'
CREATE TABLESPACE
+ ./psql postgres -p 5432 -c 'create table test (a text) tablespace tblsp01;'
ERROR:  could not open file "pg_tblspc/16384/PG_13_202004074/13530/16388": No such file or directory


Attaching command and script which help to reproduce it.
[edb@localhost bin]$ while sh pg_tblsp_wal.sh; do :; done

Thanks & Regards,
Rajkumar Raghuwanshi
Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Race condition in SyncRepGetSyncStandbysPriority
Next
From: Hamid Akhtar
Date:
Subject: Re: Do we need to handle orphaned prepared transactions in the server?