Обсуждение: 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.klaver@aklaver.com

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@postgresql.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.klaver@aklaver.com

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@aklaver.com]
Sent: July 15, 2015 6:26 PM
To: Mitu Verma; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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@postgresql.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/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@aklaver.com