Re: A crashing query

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: A crashing query
Date: 2001-03-28 12:44:11
Message-ID: slrn9c3n4r.cec.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mario Jorge Nunes Filipe <mjnf(at)uevora(dot)pt> wrote:
>We're running several PostgreSQL databases in several different servers
>(also with different PG versions :( ).
>
>In one of our on-line systems we connect to the "local" database and a
>"remote" database. The connection to the remote database was always ok,
>without any kind of problems, but yesterday, out of the blue, one of the
>query's (the most important one) started to crash the remote server.

Are you sure you're running a client that's the same PostgreSQL version as
the server?

>this system is a 6.4.2, it was vacuumed and it crashes, violently...
>Does anyone have a clue of why?

Even users running 6.5 are usually advised to upgrade to a 7.x release when
they run into crashes. 6.4 is old.

HTH,
Ray
--
Pinky, Are You Pondering What I'm Pondering?
I think so Brain, but "instant karma" always gets so lumpy.
Pinky and the Brain in "Brainwashed Part 3: Wash Harder"

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Trewern, Ben 2001-03-28 12:50:54 RE: date_part bug?
Previous Message agichen 2001-03-28 12:07:31 pg_dump ERROR .......