Re:

From: Jeffrey <seesej(at)uswest(dot)net>
To: Teruel Tony <teruel_tony(at)excite(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re:
Date: 2000-04-26 05:48:57
Message-ID: B52BD159.3FC2%seesej@uswest.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had this same problem after a user had cntrl^Z quit from psql several
times in the middle of queries. He then performed a vacuum which locked it
up further. After I removed the lock file I could not perform even the
simplest queries. The only way I fixed it was to drop the db and restore it
from a previous pd_dump.

> From: "Teruel Tony" <teruel_tony(at)excite(dot)com>
> Date: Tue, 25 Apr 2000 13:53:42 -0700 (PDT)
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL]
>
> Hi,
>
> The query is simple:
>
> select count(*) from table;
>
> I have the same error message with almost all queries,
> I'm trying to debug what's new on that table (data)
> because it was working fine..
>
> The version I'm using:
>
> PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66
>
> The table:
>
>
> +----------------------------+----------------------------+------+
> | Field | Type |Length|
> +----------------------------+----------------------------+------+
> | dfoclave | int4 not null | 4 |
> | dfoforo | int4 not null | 4 |
> | dfopadre | int4 | 4 |
> | dfonombre | varchar() | 80 |
> | dfotitulo | varchar() | 80 |
> | dfofecha | timestamp not null | 4 |
> | dfotexto | text | var |
> +----------------------------+----------------------------+------+
>
> On Tue, 25 Apr 2000 15:20:55 -0400, Mike Mascari wrote:
>> Please post the query, the definition of the tables the query is
>> accessing and the version of PostgreSQL you are using. You are
>> tickling a bug. That message means the backend crashed while
>> executing your query. Right off hand I would sugguest testing the
>> same query with 7.0RC1 from ftp.postgresql.org to see if the
>> error still exists in the about-to-be newest release.
>> Hope that helps,
>> Mike Mascari
>
>
> Have an excellent day
> teruel(at)excite(dot)com
> Mexico
>
>
>
>
>
> _______________________________________________________
> Get 100% FREE Internet Access powered by Excite
> Visit http://freelane.excite.com/freeisp
>
>

In response to

  • Re: at 2000-04-25 20:53:42 from Teruel Tony

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2000-04-26 06:03:09 Re: problem with databases
Previous Message Bill Barnes 2000-04-26 05:44:49 kpgsql query executes but does not complete