Re: backend died - Mailing list pgsql-hackers
From | Brusser, Michael |
---|---|
Subject | Re: backend died |
Date | |
Msg-id | 9150DCE0CCB4D411A7DB00508BB0DBF20B59D00C@msx1am.matrixone.net Whole thread Raw |
In response to | backend died ("Brusser, Michael" <Michael.Brusser@matrixone.com>) |
Responses |
Re: backend died
(Tom Lane <tgl@sss.pgh.pa.us>)
|
List | pgsql-hackers |
<p><font size="2">> "Brusser, Michael" <Michael.Brusser@matrixone.com> writes:</font><br /><font size="2">> >Our customer running Postgres v. 7.3.2 reported a problem, occurring</font><br /><font size="2">> > couple timesa week on three different servers, all on Solaris 9.</font><br /><font size="2">> </font><br /><font size="2">>> 2004-11-13 10:01:06 [10456] DEBUG: child process (pid 19285) was</font><br /><font size="2">> >terminated by signal 10</font><br /><font size="2">> </font><br /><font size="2">> SIGBUS iirc.</font><p><fontsize="2">> > What else should I look at?</font><br /><font size="2">> </font><br /><font size="2">>Find out what query is causing the crash --- enable query </font><br /><font size="2">> logging if you haveno other way. And get a debugger stack trace from the core file</font><br /><font size="2">> that the crashed backendleft behind.</font><br /><font size="2">> regards, tom lane</font><p><font size="2">==================================================</font><br/><font size="2">The log-statements option was alreadyenabled,</font><br /><font size="2">here's what I see prior to the crash:</font><p><font size="2">2004-11-13 09:49:46[10876] DEBUG: StartTransactionCommand</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: statement:SELECT SUM(C0),SUM(C1),SUM(C2),SUM(C3),SUM(C4),SUM(C5),SUM(C6),SUM(C7),SUM(C8),SUM(C9)</font><p><font size="2">,SUM(C10)FROM cache_refreshes</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: query: SELECT SUM(C0),SUM(C1),SUM(C2),SUM(C3),SUM(C4),SUM(C5),SUM(C6),SUM(C7),SUM(C8),SUM(C9),SUM</font><p><fontsize="2">(C10) FROM cache_refreshes</font><br/><font size="2">2004-11-13 09:49:46 [10876] DEBUG: CommitTransactionCommand</font><br /><fontsize="2">2004-11-13 09:49:46 [10876] LOG: statement: SELECT SUM(C0),SUM(C1),SUM(C2),SUM(C3),SUM(C4),SUM(C5),SUM(C6),SUM(C7),SUM(C8),SUM(C9)</font><p><fontsize="2">,SUM(C10) FROM cache_refreshes</font><br/><font size="2">2004-11-13 09:49:46 [10876] DEBUG: StartTransactionCommand</font><br /><fontsize="2">2004-11-13 09:49:46 [10876] LOG: statement: commit</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: query: commit</font><br /><font size="2">2004-11-13 09:49:46 [10876] DEBUG: CommitTransactionCommand</font><br/><font size="2">2004-11-13 09:49:46 [10876] LOG: statement: commit</font><br /><fontsize="2">2004-11-13 09:49:46 [10876] DEBUG: StartTransactionCommand</font><br /><font size="2">2004-11-13 09:49:46[10876] LOG: statement: begin</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: query: begin</font><br/><font size="2">2004-11-13 09:49:46 [10876] DEBUG: CommitTransactionCommand</font><br /><font size="2">2004-11-1309:49:46 [10876] LOG: statement: begin</font><br /><font size="2">2004-11-13 09:49:46 [10876] DEBUG: StartTransactionCommand</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: statement: commit</font><br/><font size="2">2004-11-13 09:49:46 [10876] LOG: query: commit</font><br /><font size="2">2004-11-13 09:49:46[10876] DEBUG: CommitTransactionCommand</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: statement:commit</font><br /><font size="2">2004-11-13 09:49:46 [10876] DEBUG: StartTransactionCommand</font><br /><fontsize="2">2004-11-13 09:49:46 [10876] LOG: statement: begin</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: query: begin</font><br /><font size="2">2004-11-13 09:49:46 [10876] DEBUG: CommitTransactionCommand</font><br/><font size="2">2004-11-13 09:49:46 [10876] LOG: statement: begin</font><br /><fontsize="2">2004-11-13 09:49:46 [10876] DEBUG: StartTransactionCommand</font><br /><font size="2">2004-11-13 09:49:46[10876] LOG: statement: commit</font><br /><font size="2">2004-11-13 09:49:46 [10876] LOG: query: commit</font><br/><font size="2">2004-11-13 09:49:46 [10876] DEBUG: CommitTransactionCommand</font><br /><font size="2">2004-11-1309:49:46 [10876] LOG: statement: commit</font><br /><font size="2">2004-11-13 09:54:21 [10456] DEBUG: child process (pid 19282) exited with exit code 0</font><br /><font size="2">2004-11-13 10:01:06 [10456] DEBUG: child process (pid 19285) was terminated by signal 10</font><br /><font size="2">2004-11-13 10:01:06 [10456] LOG: server process (pid 19285) was terminated by signal 10</font><br /><font size="2">2004-11-13 10:01:06 [10456] LOG: terminating any other active server processes</font><br /><font size="2">2004-11-13 10:01:06 [10456] DEBUG: CleanupProc:sending SIGQUIT to process 10876</font><br /><font size="2">... ... ...</font><p><font size="2">The same app.is running for other customers, seemingly steady...</font><br /><font size="2">I will ask for the core file.</font><br/><font size="2">This is a brand new machine. Is it likely that a bad memory chip may cause this?</font><br/><font size="2">Thank you,</font><br /><font size="2">Mike</font>
pgsql-hackers by date: