Re: insufficient data left in message
| От | Dave Cramer |
|---|---|
| Тема | Re: insufficient data left in message |
| Дата | |
| Msg-id | 60545B06-894C-4DA7-BEAD-E2377BAE1EE4@fastcrypt.com обсуждение исходный текст |
| Ответ на | Re: insufficient data left in message (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: insufficient data left in message
|
| Список | pgsql-hackers |
More questions....
Feb 21 10:22:52 db02a postgres[31111]: [742-1] user=mocospace_user,db=jnj LOG: duration: 0.088 ms execute S_3: select * from user_profile
,user_profile_access where
Feb 21 10:22:52 db02a postgres[31111]: [742-2] user_profile.uid=user_profile_access.uid and user_profile.uid=$1 and isactive=$2
Feb 21 10:22:52 db02a postgres[31111]: [742-3] user=mocospace_user,db=jnj DETAIL: parameters: $1 = '1450984', $2 = 't'
Feb 21 10:22:52 db02a postgres[31111]: [743-1] user=mocospace_user,db=jnj ERROR: insufficient data left in message
,user_profile_access where
Feb 21 10:22:52 db02a postgres[31111]: [742-2] user_profile.uid=user_profile_access.uid and user_profile.uid=$1 and isactive=$2
Feb 21 10:22:52 db02a postgres[31111]: [742-3] user=mocospace_user,db=jnj DETAIL: parameters: $1 = '1450984', $2 = 't'
Feb 21 10:22:52 db02a postgres[31111]: [743-1] user=mocospace_user,db=jnj ERROR: insufficient data left in message
Feb 21 10:22:52 db02a postgres[31111]: [743-2] user=mocospace_user,db=jnj STATEMENT: select * from user_profile,user_profile_access where
Feb 21 10:22:52 db02a postgres[31111]: [743-3] user_profile.uid=user_profile_access.uid and user_profile.uid=$1 and isactive=$2
Feb 21 10:22:52 db02a postgres[31111]: [743-3] user_profile.uid=user_profile_access.uid and user_profile.uid=$1 and isactive=$2
12:25
Feb 21 10:22:52 db02a postgres[31111]: [744-1] user=mocospace_user,db=jnj FATAL: invalid frontend message type 105Is this all the same error, just logged twice or is this two connections instances ?
Dave
On 21-Feb-08, at 10:39 AM, Tom Lane wrote:
Dave Cramer <pg@fastcrypt.com> writes:This is a postgresql 8.2.5 backend. connected to a jdbc client.2008-02-21 06:12:30 EST [18880] 10.21.0.21 ERROR: insufficient dataleft in message
AFAIK this means that the frontend sent an invalidly-formatted message.
There's some chance that the message was OK and the backend's message
parsing code is at fault, but I'd suspect the former first.So the question is: how to go about debugging this ?
Put a sniffer on the TCP session, or change the ERROR to a PANIC
and dig around in the core dump to see what the message was?
Also it might be worth updating to the latest JDBC driver, if you're
not on it already, just in case this is an already-fixed bug.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
В списке pgsql-hackers по дате отправления: