Thread:

From
Teruel Tony
Date:
Hi,

I'm having this message when trying to perform
 a query.. someone knows what do I have to do to
fix it?

Thanks


pqReadData() -- backend closed the channel unexpectedly.
    This probably means the backend terminated abnormally
    before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.  Terminating.


Have an excellent day
teruel@excite.com
Mexico





_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp


Re:

From
Mike Mascari
Date:
Teruel Tony wrote:
>
> Hi,
>
> I'm having this message when trying to perform
>  a query.. someone knows what do I have to do to
> fix it?
>
> Thanks
>
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
>
> Have an excellent day
> teruel@excite.com
> Mexico

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

Re:

From
Ed Loehr
Date:
Teruel Tony wrote:
>
> I'm having this message when trying to perform
>  a query.. someone knows what do I have to do to
> fix it?
>
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.

What is the query?  What version of pgsql?  What does your server log say?

Regards,
Ed Loehr

Re:

From
Teruel Tony
Date:
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@excite.com
Mexico





_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp


Re:

From
Mike Mascari
Date:
Teruel Tony wrote:
>
> 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 |
> +----------------------------+----------------------------+------+
>

Just a wild shot, of course - but perhaps an index or relation
file is corrupted. Unless the table is unusually large, I don't
see how the backend could die on this one. Perhaps you could
peform a manual COPY, drop and recreate the table and its indexes
and COPY the data back in.

Hope that helps,

Mike Mascari

Re:

From
Jeffrey
Date:
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@excite.com>
> Date: Tue, 25 Apr 2000 13:53:42 -0700 (PDT)
> To: pgsql-general@postgresql.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@excite.com
> Mexico
>
>
>
>
>
> _______________________________________________________
> Get 100% FREE Internet Access powered by Excite
> Visit http://freelane.excite.com/freeisp
>
>