unexpected data beyond EOF in block 260 of relation pg_tblspc
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?
Regards
Mitu
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi team,
kindly help me with the below query-
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.how alarm 801 is generated and how come the description/information is fulfilled in alarm on which it is talking about BUGGY kernel.
Regards
Mitu
Import Notes
Resolved by subject fallback
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-
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
Import Notes
Resolved by subject fallback
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general