Thread: Re: FATAL: Socket command type A unknown

Re: FATAL: Socket command type A unknown

From
Joseph Shraibman
Date:
Natrually right after I sent this post I found the problem.  The String was
'uAKcXMobT3^@AAAAAAAAA
... which is the old problem with jdbc and embedded 0 charachters.  In
what version of the driver was that fixed?


Joseph Shraibman wrote:
> I'm having a wierd problem with pg 7.3.3
>
> PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
> 20020903 (Red Hat Linux 8.0 3.2-7)
>
> I have a bunch of inserts being done by JDBC.  One of them if causing a
> problem.
>
> LOG:  query: INSERT INTO mailtextlog (mlid,tlog,cdate)
> VALUES(99999933,'Sent via localhost','2003-08-27 11:07:53.701');
> LOG:  query: INSERT INTO mailtextlog (mlid,tlog,cdate)
> VALUES(99999934,'While talking to mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3
> ERROR:  parser: unterminated quoted string at or near "'While talking to
> mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3" at character 59
> FATAL:  Socket command type A unknown
>
>
> Obviously the pg log is not showing the end of the instert I'm sending
> via jdbc.  I'm not sure what the string is supposed to be because it is
> dynamically generated, but it should have been something like the line
> above it.
>


Re: FATAL: Socket command type A unknown

From
Barry Lind
Date:
Joseph,

It should be fixed in the current driver build on jdbc.postgresql.org.

--Barry

Joseph Shraibman wrote:
> Natrually right after I sent this post I found the problem.  The String was
> 'uAKcXMobT3^@AAAAAAAAA
> ... which is the old problem with jdbc and embedded 0 charachters.  In
> what version of the driver was that fixed?
>
>
> Joseph Shraibman wrote:
>
>> I'm having a wierd problem with pg 7.3.3
>>
>> PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
>> 20020903 (Red Hat Linux 8.0 3.2-7)
>>
>> I have a bunch of inserts being done by JDBC.  One of them if causing
>> a problem.
>>
>> LOG:  query: INSERT INTO mailtextlog (mlid,tlog,cdate)
>> VALUES(99999933,'Sent via localhost','2003-08-27 11:07:53.701');
>> LOG:  query: INSERT INTO mailtextlog (mlid,tlog,cdate)
>> VALUES(99999934,'While talking to mx1.lix.aon.at [195.3.86.141]:
>> uAKcXMobT3
>> ERROR:  parser: unterminated quoted string at or near "'While talking
>> to mx1.lix.aon.at [195.3.86.141]: uAKcXMobT3" at character 59
>> FATAL:  Socket command type A unknown
>>
>>
>> Obviously the pg log is not showing the end of the instert I'm sending
>> via jdbc.  I'm not sure what the string is supposed to be because it
>> is dynamically generated, but it should have been something like the
>> line above it.
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>



Re: FATAL: Socket command type A unknown

From
Joseph Shraibman
Date:
Barry Lind wrote:
> Joseph,
>
> It should be fixed in the current driver build on jdbc.postgresql.org.

So only the 7.4 branch has the fix?


Re: FATAL: Socket command type A unknown

From
Barry Lind
Date:
Joseph,

Sorry I wasn't clear, it is fixed in either the latest 7.3 build or the
current dev (i.e. 7.4) build.

--Barry

Joseph Shraibman wrote:
> Barry Lind wrote:
>
>> Joseph,
>>
>> It should be fixed in the current driver build on jdbc.postgresql.org.
>
>
> So only the 7.4 branch has the fix?
>
>