Hi Adrian, Following info is available to us - Platfrom : Linux. uname : uname -a Linux BGWPOL22-07 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux Postgres version - 9.1.4 Regards Mitu -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: July 15, 2015 6:26 PM To: Mitu Verma; pgsql-general@xxxxxxxxxxxxxx Subject: Re: unexpected data beyond EOF in block 260 of relation pg_tblspc 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/stora > ge/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
