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
>
>
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 |