Postgres Pro
Downloads
Home   >   mailing lists

WARNING: could not write block 27094490 of base/56972584/56980980 - Mailing list pgsql-admin

From Naveen Kumar
Subject WARNING: could not write block 27094490 of base/56972584/56980980
Date
Msg-id CADk76jrhyUrcErsHp4i8g16yD-pCjawxD7Sg9ap0hzQQVroQNQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hello Experts,

What could be the reason for bellow error?  

Not allowing to do any operation on other databases in the cluster. Not even allowing to connect to database and  We are not seeing this error on secondary node. 

WARNING:  could not write block 27094490 of base/56972584/56980980
DETAIL:  Multiple failures --- write error might be permanent.
ERROR:  could not open file "base/56972584/56980980.69" (target block 27094490): previous segment is only 6449 blocks
CONTEXT:  writing block 27094490 of relation base/56972584/56980980



Thanks & Regards,
Naveen M

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977
Next
From: "Ghiurea, Isabella"
Date:
Subject: find objects stored on a specific tablespace