message type 0x44 arrived from server while idle

From: Tomas Berndtsson <tomas(at)nocrew(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: message type 0x44 arrived from server while idle
Date: 2002-11-29 15:13:05
Message-ID: 80isygv27y.fsf@junk.nocrew.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a pretty simple table, log_rir:

id | integer | not null default nextval('"log_rir_id_seq"'::text)
first_time | timestamp with time zone | default ('now'::text)::timestamp(6) with time zone
last_time | timestamp with time zone | default ('now'::text)::timestamp(6) with time zone
facility | text |
message | text |
key | text |
status | text |
counter | integer |

The text fields are quite small, except for the message field, which
can be larger. The others are about 20-40 characters.

Now, the problem occurs when the message field contains a string
larger than about 32000 (I'd guess 32767). From my C application,
using libpq, when I'm selecting from this table, I get:

message type 0x44 arrived from server while idle

However, when I run the same select from psql, it works fine. This is
a Solaris 8 running PostgreSQL 7.2.1. Has anyone seen this, or know
what's causing it. If I just delete the row with the long message
field, the same select works from the application too.

Tomas

Browse pgsql-general by date

  From Date Subject
Next Message Envex Developments 2002-11-29 15:17:36 Determine column name from trigger
Previous Message Envex Developments 2002-11-29 14:51:08 Trigger / Function: Getting column name of UPDATE