[pgpool-general: 2444] SimpleQuery: Unable to parse the query:

Kristjan Siimson kristjan.siimson at cashongo.co.uk
Fri Jan 17 20:06:45 JST 2014


I have a simple set up where first level pgpool server receives queries
from clients, forwards to second level pgpool servers, which in turn
forwards to Postgres servers.

1* [pgpool] => 1* [pgpool] => 2* [Postgre]
               1* [pgpool] => 2* [Postgre]

If I make a simple "insert into account (1, 1, 0.0, "FRESH ACCOUNT");"
query to the first level pgpool server, then I get this error in the second
level Pg-Pool servers:

2014-01-17 12:35:25 LOG:   pid 3252: SimpleQuery: Unable to parse the
query: "insert into account (1, 1, 0.0, "FRESH ACCOUNT");" from client
10.1.12.30(50410)
2014-01-17 12:35:25 LOG:   pid 3252: pool_send_and_wait: Error or notice
message from backend: : DB node id: 0 backend pid: 9301 statement: insert
into account (1, 1, 0.0, "FRESH ACCOUNT"); message: syntax error at or near
"1"
2014-01-17 12:35:25 LOG:   pid 3252: pool_send_and_wait: Error or notice
message from backend: : DB node id: 1 backend pid: 9161 statement: insert
into account (1, 1, 0.0, "FRESH ACCOUNT"); message: syntax error at or near
"1"
2014-01-17 12:35:32 ERROR: pid 2644: Child process 3252 was terminated by
segmentation fault

>From the order of the messages it seems to me the SimpleQuery runs into
some error on both second level pgpool servers. If I query any second level
pgpool server directly there are no errors.

Is there any specific reason for this failure or how do I go about finding
out what causes this error?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140117/742d6ae8/attachment.htm>


More information about the pgpool-general mailing list