On 07/15/2015 02:54 AM, Mitu Verma wrote:
Just to add few more words to the queries mentioned below - _____________________________________________ *From:* Mitu Verma *Sent:* July 15, 2015 11:15 AM *To:* 'pgsql-general@xxxxxxxxxxxxxx' *Subject:* RE: unexpected data beyond EOF in block 260 of relation pg_tblspc Hi team, kindly help me with the below query-
As asked previously: It would be helpful to know more information: 1) OS and version? 2) Postgres version? 3) Kernel version? 4) Storage type? In particular what is the tablespace stored on?
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
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
