[pgpool-committers: 527] pgpool: Fix pool_process_query. When other than primary sends packet, p

Tatsuo Ishii ishii at postgresql.org
Fri Jul 20 12:07:36 JST 2012


Fix pool_process_query. When other than primary sends packet, pgpool
tries to terminate session gracefully and hung because now ssl_read
returns EOF, rather than error and triggers failover. For example
[pgpool-general: 766] reported this:

2012-07-17 00:11:03 NZST [15692]: [257-1] ERROR: canceling statement
due to conflict with recovery
2012-07-17 00:11:03 NZST [15692]: [258-1] DETAIL: User query might
have needed to see row versions that must be removed.
2012-07-17 00:11:03 NZST [15692]: [259-1] STATEMENT: <SNIP>
2012-07-17 00:11:03 NZST [15696]: [366-1] FATAL: terminating
connection due to conflict with recovery
2012-07-17 00:11:03 NZST [15696]: [367-1] DETAIL: User query might
have needed to see row versions that must be removed.

In this case pool_process_query should return POOL_ERROR, rather than
POOL_END.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=47fc523769f408320d21192ce10407b2650de106

Modified Files
--------------
pool_process_query.c |    8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)



More information about the pgpool-committers mailing list