Postgres Pro
Downloads
Home   >   mailing lists

pg_ctl promote causes error "could not read block" (PG 9.5.0 and 9.5.4) - Mailing list pgsql-general

From raj 1988
Subject pg_ctl promote causes error "could not read block" (PG 9.5.0 and 9.5.4)
Date
Msg-id CANKk2Ss8dB5S4tL3+rUyr+FHP36AxNr+dOGcXjhFU53np6BeGw@mail.gmail.com
Whole thread Raw
Responses Re: pg_ctl promote causes error "could not read block" (PG 9.5.0 and9.5.4)  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Tree view
Hi there,

we are running into this weird issue of table getting on READ ONLY mode with below error:

ERROR:  could not read block 54 in file "base/<databaseoid>/215619": read only 0 of 8192 bytes

We are facing this whenever we promote a streaming standby using pg_ctl promote command, and this is happing on PG 9.5.0 and 9.5.4 and OEL 6.9

Are we hitting some bug? tried to look around but not able to confirm if we are hitting a bug or not.  For us this is happening consistently on different servers whenever we do pg_ctl promote and then it block WRITE on that table.

As of now we get rid of the error either by doing vacuum full or CTAS, but i am afraid what we will do in case this happens to our few TB tables.


Thanks a lot in advance

-raj

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade
Next
From: Moreno Andreo
Date:
Subject: Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade