message contents do not agree with length in message type "T"

From: "Mike" <mike(at)mrhost(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: message contents do not agree with length in message type "T"
Date: 2008-03-11 02:31:51
Message-ID: 069d01c88320$106adc90$314095b0$@ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm using the libpq interface to PostgreSQL (8.3.0) in one of our apps, and
I'm having a sporadic issue with receiving the error message:

--snip--

message contents do not agree with length in message type "T" server sent
data ("D" message) without prior row description ("T" message)

--snip-

It doesn't happen all the time, and doesn't always happen on the same query.

--snip-

2008-03-10 22:09:29 [31010] - csql::query(): PGRES_FATAL_ERROR (message
contents do not agree with length in message type "T" server sent data ("D"
message) without prior row description ("T" message)) query='select
fc_system_end_call(1867,6)'

2008-03-10 21:39:38 [30262] - csql::query(): PGRES_FATAL_ERROR (message
contents do not agree with length in message type "T" server sent data ("D"
message) without prior row description ("T" message)

) query='insert into system_stats (type,subject,stat_value,stat_data) values
(501,0,9.027189,'')'

--snip-

In the first example, fc_system_end_call() is a plpgsql function

Schema | Name | Result data type | Argument data types

--------+--------------------+------------------+---------------------------
--------

public | fc_system_end_call | integer | _call_id integer, _status
integer

in the second example, system_stats is a table like:

Table "public.system_stats"

Column | Type |
Modifiers

------------+-----------------------------+---------------------------------
--------------------------

id | bigint | not null default
nextval('system_stats_id_seq'::regclass)

date | timestamp without time zone | not null default now()

type | smallint | not null

subject | bigint | not null default 0

stat_value | double precision | not null default 0

stat_data | text | not null default ''::text

Indexes:

"system_stats_id_key" UNIQUE, btree (id)

Foreign-key constraints:

"system_stats_type_fkey" FOREIGN KEY (type) REFERENCES
system_stat_types(id) ON UPDATE CASCADE ON DELETE RESTRICT

--snip-

Does anybody have any idea what this message means, and could be the issue
with what I'm doing?

I'm also sporatically getting these messages, and I'm not sure if they're
related or not?

--snip-

message type 0x54 arrived from server while idle

message type 0x44 arrived from server while idle

message type 0x43 arrived from server while idle

message type 0x5a arrived from server while idle

--snip--

Thanks for your time,

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tri Quach 2008-03-11 02:35:48 Relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal
Previous Message Joe Conway 2008-03-11 00:31:07 Re: PostgreSQL and MOLAP ?