470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

FATAL: Socket command type A unknown

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.

Nov 11 '05 #1
1 1983
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.


Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Marek Baczek Baczyński | last post: by
2 posts views Thread by Droopy | last post: by
2 posts views Thread by Rene Sřrensen | last post: by
reply views Thread by Mangabasi | last post: by
8 posts views Thread by half.italian | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.