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