On Thu, Dec 16, 2021 at 9:26 PM Neha Sharma <neha.sha...@enterprisedb.com> wrote: > > Hi, > > While testing the v8 patches in a hot-standby setup, it was observed the > master is crashing with the below error; > > 2021-12-16 19:32:47.757 +04 [101483] PANIC: could not fsync file > "pg_tblspc/16385/PG_15_202112111/16386/16391": No such file or directory > 2021-12-16 19:32:48.917 +04 [101482] LOG: checkpointer process (PID 101483) > was terminated by signal 6: Aborted > > Parameters configured at master: > wal_level = hot_standby > max_wal_senders = 3 > hot_standby = on > max_standby_streaming_delay= -1 > wal_consistency_checking='all' > max_wal_size= 10GB > checkpoint_timeout= 1d > log_min_messages=debug1 > > Test Case: > create tablespace tab1 location > '/home/edb/PGsources/postgresql/inst/bin/test1'; > create tablespace tab location '/home/edb/PGsources/postgresql/inst/bin/test'; > create database test tablespace tab; > \c test > create table t( a int PRIMARY KEY,b text); > CREATE OR REPLACE FUNCTION large_val() RETURNS TEXT LANGUAGE SQL AS 'select > array_agg(md5(g::text))::text from generate_series(1, 256) g'; > insert into t values (generate_series(1,100000), large_val()); > alter table t set tablespace tab1 ; > \c postgres > create database test1 template test; > \c test1 > alter table t set tablespace tab; > \c postgres > alter database test1 set tablespace tab1; > > --cancel the below command > alter database test1 set tablespace pg_default; --press ctrl+c > \c test1 > alter table t set tablespace tab1; > > > Log file attached for reference.
Seems like this is an existing issue and I am able to reproduce on the PostgreSQL head as well [1] [1] https://www.postgresql.org/message-id/CAFiTN-szX%3DayO80EnSWonBu1YMZrpOr9V0R3BzHBSjMrMPAeMg%40mail.gmail.com -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
