[pgpool-general: 6224] PGPOOL Error with DEALLOCATE

Kumar, Virendra Virendra.Kumar at guycarp.com
Thu Sep 6 02:14:10 JST 2018

Hi PGPOOL Developers,

When we run a simple deallocate command using pgpool as loadbalancer in master-slave mode while the connection is on standby server we are getting below error. I read it somewhere that it is fixed but surprisingly this is not the case. We are using pgpool 3.7.1:
ap_sit_db=# PREPARE usrrptplan (int) AS select count(*) from ap.site_exposure_p1;
ap_sit_db=# select * from pg_prepared_statements;
    name    |                               statement                               |         prepare_time          | parameter_types | from_sql
usrrptplan | PREPARE usrrptplan (int) AS select count(*) from ap.site_exposure_p1; | 2018-09-04 12:12:28.449465-05 | {integer}       | t
(1 row)

ap_sit_db=# EXECUTE usrrptplan(2);
(1 row)

ap_sit_db=# DEALLOCATE usrrptplan;
WARNING:  packet kind of backend 1 ['E'] does not match with master/majority nodes packet kind ['C']
FATAL:  failed to read kind from backend
DETAIL:  kind mismatch among backends. Possible last query was: "DEALLOCATE usrrptplan;" kind details are: 0[C] 1[E: prepared statement "usrrptplan" does not ex
HINT:  check data consistency among db nodes
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.



This message is intended only for the use of the addressee and may contain

If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180905/c39a5eff/attachment.html>

More information about the pgpool-general mailing list