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