search

pgpool / pgpool2

This is the official mirror of git://git.postgresql.org/git/pgpool2.git. Note that this is just a *mirror* - we don't work with pull requests on github. Please subscribe to pgpool-hackers mailing list from our website and submit your patch to this mailing list.
https://www.pgpool.net
Other
305 stars 87 forks source link

failed extended query on pgpool2-4.0.3 #27

Open moguraion opened 5 years ago

moguraion commented 5 years ago

I executed extended query through pgpool ( in stream replication mode ) and pg ( nodejs package ), but got unexpected response 'unable to bind'. I tried execute same extended query directly postgres, then I got a expected response.

Environment

Query

query : SELECT * FROM UserMaster Where email = $1 param: xxx.yyy@email.com

Logs

postgres

DEBUG:  parse <unnamed>: SELECT * FROM UserMaster WHERE email = $1
LOG:  disconnection: session time: 0:00:00.044 user=postgres database=testdb host=192.168.208.1 port=60994
DEBUG:  server process (PID 1598) exited with exit code 0

pgpool

pid 99: LOG:  Bind message from frontend.
pid 99: DETAIL:  portal: "", statement: ""
pid 99: LOCATION:  pool_proto_modules.c:1371
pid 99: FATAL:  unable to bind