Postgresql, sql client and I/O exceptions

From: Paul Maddock <paul(dot)maddock(at)spidasoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql, sql client and I/O exceptions
Date: 2013-07-18 14:20:07
Message-ID: CAB6o7F5GRBPYkt_D0MgfkyhvJiryyfK0__K+Y9=Po7RNTBL6LQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am having trouble with postgresql connection.

I am using squirrel sql client to write sql code for data qc'ing. On many
occasions this has happened. It closes my connection on my client and
stops my sql transaction.

There are roughly 3 million records in the database I am editing.

Version of Postgresql:
psql (PostgreSQL) 9.2.4

JDBC for squirrel sql client:
postgresql-9.2-1003.jdbc4.jar

--------------------------------------
*syslog*
276 Jul 18 09:10:08 test-minapps kernel: [173502.656976] postgres[15212]:
segfault at 7f4c34e8a44e ip 00007f4c02d13605 sp 00007fff92ba69f0 error 4 in
postgres[7f4c02c86000+54e000]
277 Jul 18 09:10:12 test-minapps lsassd[1136]: 0x7f1607fff700:Error code
40286 occurred during attempt 0 of a ldap search. Retrying.

*postgresql log*
*"""
2013-07-18 09:10:24 EDT LOG: terminating any other active server processes
2013-07-18 09:10:24 EDT WARNING: terminating connection because of crash
of another server process
2013-07-18 09:10:24 EDT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
"""
*
** ~20**

2013-07-18 09:10:26 EDT LOG: all server processes terminated;
reinitializing
2013-07-18 09:10:28 EDT LOG: database system was interrupted; last known
up at 2013-07-18 09:03:54 EDT
2013-07-18 09:10:28 EDT LOG: database system was not properly shut down;
automatic recovery in progress
2013-07-18 09:10:28 EDT LOG: redo starts at 39/BBAE7D60
2013-07-18 09:10:29 EDT LOG: record with zero length at 39/BD17A7D8
2013-07-18 09:10:29 EDT LOG: redo done at 39/BD17A7A8
2013-07-18 09:10:29 EDT LOG: last completed transaction was at log time
2013-07-18 09:10:10.968978-04
2013-07-18 09:11:08 EDT LOG: database system is ready to accept connections

*
*squirrel sql log*
Error: An I/O error occured while sending to the backend. SQLState: 08006
ErrorCode: 0
-------------------------------------

I'm researching the issue myself, but if you might know the cause it would
help me tremendously.

--
Paul Anthony Maddock

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-07-18 15:02:37 Re: Postgresql, sql client and I/O exceptions
Previous Message Tim Kane 2013-07-18 14:15:57 Hot Standby and Foreign Tables