On 07/16/2015 01:18 AM, M Tarkeshwar Rao wrote:
Hi all, We have a table name auditTrailLogEntry where we were not able to able to insert in auditTrailLogEntry table. we have reindex the table and insertion issue has been resolved . we executed following command: *_Audit tail insertion issue. _* INSERT INTO auditTrailLogEntry (event, inNodeID, inNodeName, sourceID, inTime, outNodeID, outNodeName, destinationID, outTime, bytes, cdrs, tableIndex, noOfSubfilesInFile, recordSequenceNumberList ) VALUES (68, NULL, NULL, E'proc_PGWDiskCollectorGroup1_0_1434566783_1027213', E'2015-06-17 11:46:32.224', E'3434', E'PGW ACC MVNE2 Raw', E'DEPCF003.2015-06-1711-41-06.8493.BGWP21S5M2P1.000328122', E'2015-06-17 11:46:33.790', 39193, 78, 952 *_Got following error messages_* 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. The SQL statement to execute was: INSERT INTO auditTrailLogEntry (event, inNodeID, inNodeName, sourceID, inTime, outNodeID, outNodeName, destinationID, outTime, bytes, cdrs, tableIndex, noOfSubfilesInFile, recordSequenceNumberList ) VALUES (68, NULL, NULL, E'proc_PGWDiskCollectorGroup1_0_1434566783_1027213', E'2015-06-17 11:46:32.224', E'3434', E'PGW ACC MVNE2 Raw', E'DEPCF003.2015-06-1711-41-06.8493.BGWP21S5M2P1.000328122', E'2015-06-17 11:46:33.790', 39193, 78, 952
Just to be clear this is a duplicate of this thread?: http://www.postgresql.org/message-id/84BC7AB0D621A74893EC9C9E151293B0226D8ED1@xxxxxxxxxxxxxxxxxxxxxx
*Can you please suggest following:* ---------------------------------------------- a. How can we prevent "This has been seen to occur with buggy kernels; consider updating your system" alarm ? b. how can resolve "This has been seen to occur with buggy kernels; consider updating your system" alarm ? Regards Tarkeshwar
-- 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
