7.1.2: Backend message type 0x44 when selecting from a table

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.1.2: Backend message type 0x44 when selecting from a table
Date: 2001-11-19 02:02:15
Message-ID: 3.0.5.32.20011119100215.00a76750@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

(doh, I thought I was running 7.1.3!).

SELECT * from arch_ranks_arch4 ;
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.
!>

Trying to pg_dump the table gives me this:

<snipped>
1526 2001-11-18 07:22:15+08 0 BLANK 0 0
0 0
1414414664 4714-11--2147483624 BC 218103907

\.
ERROR: MemoryContextAlloc: invalid request size 1163153238
PQendcopy: resetting connection
SQL query to dump the contents of Table 'arch_ranks_arch4' did not execute
correctly. After we read all th
e table contents from the backend, PQendcopy() failed. Explanation from
backend: 'ERROR: MemoryContextAll
oc: invalid request size 1163153238
'.
The query was: 'COPY "arch_ranks_arch4" TO stdout;
'.

Another similar table is ok. I have vacuumed - no errors, but the problem
still remained.

These tables have had a lot of updates on them (24/7 every second or so).
Fortunately it's not critical: just test tables.

The type:
CREATE TABLE "arch_ranks_arch4" (
"id" integer,
"updated" timestamp with time zone,
"valid" integer,
"name" text,
"specialty" text,
"status" text,
"ranking" integer,
"power" integer,
"land" integer,
"forts" integer,
"description" text
);

I've truncated the table and it runs ok now.

The server itself hasn't crashed - up for 69 days.

Is it a fixed bug?

Regards,
Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-19 04:18:35 Re: 7.1.2: Backend message type 0x44 when selecting from a table
Previous Message Peter Ondruska 2001-11-18 22:46:20 build fails on Solaris 8 x_86 with Sun compiler