Re: [GENERAL] Odd response from server - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Odd response from server
Date
Msg-id 32318.1487463983@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Odd response from server  (Rui Pacheco <rui.pacheco@gmail.com>)
List pgsql-general
Rui Pacheco <rui.pacheco@gmail.com> writes:
> I’m trying to send a Parse message with the name “my_name” and the statement “select * from departments” and no type
id’s,along with a flush message: 
> 'P','\0','\0','\0','(','m','y','_','n','a','m','e','\0','s','e','l','e','c','t',' ','*',' ','f','r','o','m','
','d','e','p','a','r','t','m','e','n','t','s','\0','\0','\0','\0','\0','\0','H','\0','\0','\0','\x04’

> I get the ParseComplete response AND a FATAL error:

>
'1','\0','\0','\0','\x04','E','\0','\0','\0','T','S','F','A','T','A','L','\0','C','0','8','P','0','1','\0','M','i','n','v','a','l','i','d','
','f','r','o','n','t','e','n','d','','m','e','s','s','a','g','e',' ','t','y','p','e','
','0','\0','F','p','o','s','t','g','r','e','s','.','c','\0','L','4','8','4','\0','R','S','o','c','k','e','t','B','a','c','k','e','n','d','\0','\0’

The server is seeing a valid Parse message and then some junk after it.
I think you're miscomputing the length of the Parse message, or maybe
emitting the wrong amount of data as part of the message, such that
the server isn't lined up to see the 'H' as the next byte after it's
consumed the Parse.

            regards, tom lane


pgsql-general by date:

Previous
From: Rui Pacheco
Date:
Subject: [GENERAL] Odd response from server
Next
From: Sachin Srivastava
Date:
Subject: [GENERAL] No space left on device