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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
