Re: unexpected data beyond EOF in block 260 of relation pg_tblspc

On 07/05/2015 10:15 PM, Mitu Verma wrote:
> Hi,
> 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.
> If this is an issue with the postgres DB or some problem with the kernel?
> Please help by giving some pointers and in what circumstances this issue
> can occur?

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?

> Regards
> Mit

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com