[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


More information about the pgpool-general mailing list