Re: [GENERAL] Odd response from server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Odd response from server
Дата
Msg-id 32318.1487463983@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] Odd response from server  (Rui Pacheco <rui.pacheco@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Rui Pacheco
Дата:
Сообщение: [GENERAL] Odd response from server
Следующее
От: Sachin Srivastava
Дата:
Сообщение: [GENERAL] No space left on device