From: secret <secret@kearneydev.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Re: Very disappointing performance -- All Indexes Ignored.
Date: Fri, 12 Mar 1999 13:55:33 -0500
Message-ID: <36E96325.F99A51FA@kearneydev.com> (raw)
References: <23194.921254251@sss.pgh.pa.us>
Tom Lane wrote:
> secret <secret@kearneydev.com> writes:
> > PostgreSQL is also crashing 1-2 times a day on me, although I have a
> > handy perl script to keep it alive now <grin>...
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: secret@kearneydev.com, tgl@sss.pgh.pa.us, pgsql-sql@hub.org
Subject: Re: [SQL] Re: Very disappointing performance -- All Indexes Ignored.
In-Reply-To: <36E96325.F99A51FA@kearneydev.com>
References: <23194.921254251@sss.pgh.pa.us> <36E96325.F99A51FA@kearneydev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox