Received: from nexus.kearneydev.com (IDENT:root@nexus.kearneydev.com [208.136.214.2]) by hub.org (8.9.2/8.9.1) with ESMTP id NAA34953 for ; Fri, 12 Mar 1999 13:55:50 -0500 (EST) (envelope-from secret@kearneydev.com) Received: from kearneydev.com (atu.kearneydev.com [208.136.214.93]) by nexus.kearneydev.com (8.8.5/8.8.5) with ESMTP id NAA17567; Fri, 12 Mar 1999 13:55:29 -0500 Message-ID: <36E96325.F99A51FA@kearneydev.com> Date: Fri, 12 Mar 1999 13:55:33 -0500 From: secret Organization: Kearney Development Co., Inc. X-Mailer: Mozilla 4.5 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@hub.org Subject: Re: [SQL] Re: Very disappointing performance -- All Indexes Ignored. References: <23194.921254251@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > secret writes: > > PostgreSQL is also crashing 1-2 times a day on me, although I have a > > handy perl script to keep it alive now ... > > Details please? 6.4.x has been pretty stable for me, and for most other > people as far as I've heard. If you're getting a backend coredump, > a stack backtrace with gdb or equivalent would be helpful info. > > regards, tom lane I sent in a bug report on it. Would a -d x report be helpful? I included a -d 3 but if a higher level would be better I'll surely include that, basically the server randomly dies with a: ERROR: postmaster: StreamConnection: accept: Invalid argument pmdie 3 (then signals all children to drop dead) And all the postmasters go ZOMBIE. It doesn't core as far as I can tell, it just dies at the invalid argument and brings everything crashing down behind it. Could the ODBC driver be sending something goofy that makes it coke? It's very irregular and I haven't been able to get an ODBC trace yet. I did however find a fun new CREATE VIEW which crashes the backend 100%, it's on the bugs list with a 'method of reproduction' that worked for me 100%, I think it'll probably be an easy fix.(It doesn't zombie all the postmasters like the other one tho) --David