From: | "Burgholzer, Robert (DEQ)" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | diagnosing a db crash - server exit code 2 |
Date: | 2011-09-23 19:02:49 |
Message-ID: | B6C40D17104BEF47B1CB85623CDFAC6357BE26@COVMSGCES-EMB13.cov.virginia.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am trying to get my head around why I keep getting crashes to my PG 8.3.7 database on CentOS - Linux version 2.6.18-164.el5. There are 3 slightly different (I think) circumstances leading to a crash of the database, all related in some way to long running PHP scripts with intensive activity on PG connections.
#1 - execution of an R call via pLR (sometimes this may crash it all by itself)
#2 - execution of a postGIS query (possible)
#3 - random occurences, all related to the same long running PHP scripts
I have read that perhaps hardware and/or system settings may cause this. I believe the system is running i9 processors, that may be set into some sort of virtual multi-threading mode. Thanks for any insight you all can give in tracking this down.
r.b.
Dump transcipt from postgresql log file:
LOG: server process (PID 5978) exited with exit code 2
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
<snip>message repeats 14 times </snip>
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2011-09-23 14:15:04 EDT
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 4AD/CFE63B98
LOG: record with zero length at 4AD/D0063FD8
LOG: redo done at 4AD/D0063FA8
LOG: last completed transaction was at log time 2011-09-23 14:19:45.972521-04
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2011-09-23 19:23:18 | Re: diagnosing a db crash - server exit code 2 |
Previous Message | Hannu Krosing | 2011-09-23 18:26:41 | Re: [pgsql-cluster-hackers] Fwd: Invalid version while creating PostgreSQL 9.1 cluster |