Just to add few more words to the queries mentioned below -
_____________________________________________
From: Mitu Verma
Sent: July 15, 2015 11:15 AM
To: 'pgsql-general@postgresql.org'
Subject: RE: unexpected data beyond EOF in block 260 of relation pg_tblspc
Hi team,
kindly help me with the below query-
Below alarm was raised at the system where postgres database was used..
-----------------------------------------------------------------------------------------------------------
BGWPOL22-00:/var/opt/mediation/MMStorage6/Server8/CXC1734739_R8J/storage/logging/ACTIVE# cat AA::80165730a!
1434566795-Server8eBGWPOL22-00!! iThere is a problem with the system environment (memory, disk, etc).
Failed to store log information in the database in AUDIT
ERROR: unexpected data beyond EOF in block 260 of relation pg_tblspc/16388/PG_9.1_201105231/16384/16418
HINT: This has been seen to occur with buggy kernels; consider updating your system.
Failed to transfer a row to the database table auditTrailLogEntry.
-----------------------------------------------------------------------------------------------------------
Entry into the table Is also getting failed due to this.
My question is
1.Under what circumstances the description/information is fulfilled in Error message thrown by postgres, in which it is talking about BUGGY kernel.
i.e in what conditions postgres suggests that ‘this is an issue with buggy kernel’ .
Regards
Mitu