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(at)postgresql(dot)org'
> *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(dot)klaver(at)aklaver(dot)com