From jaltamirano@correolux.com.mx Tue Oct  25 23:28:24 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D7A24DAEAB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 25 Oct 2005 20:28:24 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 67012-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 25 Oct 2005 23:28:21 +0000 (GMT)
Received: from CORREO.correolux.com.mx
	(customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218])
	by svr1.postgresql.org (Postfix) with ESMTP id DCD5CDAEA9
	for <pgsql-sql@postgresql.org>; Tue, 25 Oct 2005 20:28:22 -0300 (ADT)
Received: from 192.168.7.58 ([192.168.7.58]) by correolux.com.mx with
	MailEnable ESMTP; Tue, 25 Oct 2005 18:24:53 -0600
Subject: backend error
From: Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary="=-oadx/e9JhyjNDhYIf11F"
Date: Tue, 25 Oct 2005 18:28:38 -0500
Message-Id: <1130282918.3642.57.camel@Desarrollo>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 (2.0.2-3) 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.095 required=5 tests=[AWL=-0.042,
	FORGED_RCVD_HELO=0.05, HTML_40_50=0.086, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/295
X-Sequence-Number: 23148


--=-oadx/e9JhyjNDhYIf11F
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hello everybody I have a failure making a select in a table the error
that returns is the follow:

Backend message type 0x44 arrived while idle
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

 How can I do to fix the failure?

--=-oadx/e9JhyjNDhYIf11F
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Hello everybody I have a failure making a select in a table the error that returns is the follow:<BR>
<BR>
Backend message type 0x44 arrived while idle<BR>
pqReadData() -- backend closed the channel unexpectedly.<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This probably means the backend terminated abnormally<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; before or while processing the request.<BR>
The connection to the server was lost. Attempting reset: Failed.<BR>
<BR>
 How can I do to fix the failure?
</BODY>
</HTML>

--=-oadx/e9JhyjNDhYIf11F--





From mike@fuhr.org Wed Oct  26 02:51:52 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 84177DAE6B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 25 Oct 2005 23:51:52 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 83269-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 26 Oct 2005 02:51:48 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id A69FADA8FA
	for <pgsql-sql@postgresql.org>; Tue, 25 Oct 2005 23:51:50 -0300 (ADT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j9Q2ppHu003648
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Tue, 25 Oct 2005 20:51:54 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id j9Q2ppZw098797;
	Tue, 25 Oct 2005 20:51:51 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.4/8.13.4/Submit) id j9Q2ppFd098796;
	Tue, 25 Oct 2005 20:51:51 -0600 (MDT) (envelope-from mfuhr)
Date: Tue, 25 Oct 2005 20:51:51 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: backend error
Message-ID: <20051026025150.GA98731@winnie.fuhr.org>
References: <1130282918.3642.57.camel@Desarrollo>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1130282918.3642.57.camel@Desarrollo>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level: 
X-Archive-Number: 200510/300
X-Sequence-Number: 23153

On Tue, Oct 25, 2005 at 06:28:38PM -0500, Judith Altamirano Figueroa wrote:
> Hello everybody I have a failure making a select in a table the error
> that returns is the follow:
> 
> Backend message type 0x44 arrived while idle
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

What version of PostgreSQL are you using?  What operating system
and version?  What's the query?  What appears in the server log
when you get the error?  Did you get a core dump, and if so, can
you get a stack trace from it?

-- 
Michael Fuhr