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 logError: 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.