<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><body><p>Hi PGPOOL TEAM,<br>I have strange behavior of pgpool after failover.<br><br>My pgpool-pg cluster is:<br>2xPgpool 4.1, 2xPG 12.1 (streaming replication)<br><br>PGpool conf:<br><br># - Concurrent session and pool size -<br>num_init_children = 600<br> # Number of concurrent sessions allowed<br> # (change requires restart)<br>max_pool = 5<br> # Number of connection pool caches per connection<br> # (change requires restart)<br># - Life time -<br><br>child_life_time = 1080<br><br> # Pool exits after being idle for this many seconds<br>child_max_connections = 2900<br> # Pool exits after receiving that many connections<br> # 0 means no exit<br><br>connection_life_time = 840<br> # Connection to backend closes after being idle for this many seconds<br> # 0 means no close<br>client_idle_limit = 600<br><br>After failover from master ip .. 72 (node 0) to new master ip ..73 (node 1) and rebuild old master to new slave there were strange behavior of connections and transactions. <br>Before failover there were about 1500 connections per backend.<br> After failover and rebuild slave there were almost 3000 connections per backend and many of connections to databases were on max level of Pgpool num_init_children parameter.<br><br>Also on new slave I've got many warnings from transations "WARNING: there is no transaction in progress" like PGPOOL send sql COMMIT; to slave.<br><br>I had to make failover again to state before last failover because I was afraid of this situation. Logs looks normal but there was something wrong with closing connections to backends and this abnormal behavior of transations.<br>Please look on screenshot from connections graph. Its shot from last failover where was bad state to normal state (master ip ..73 node 1 to new master ip ..72 node 0).<br>Do You know something about problems with connections after failover?<br><br><a href="http://pgpool1.png" target="_blank">pgpool1.png</a> is graph all of connections to backend moment of last failover to normal state<br><a href="http://pgpool3.png" target="_blank">pgpool3.png</a> is graph from one of databases moment of last failover to normal state<br data-mce-bogus="1"><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style> <br><br><div class="public_gallery_body">Zobacz galerię obrazków z wiadomości- <a href="http://zdjecia.interia.pl/galeria,gcsi,9B8E4291E4BF14EFACA58A04A3373A48FF5CD4DE" style="color:#318fcd; text-decoration: none" target="_blank">kliknij link</a><br><br><a class="public_gallery_body_img" href="http://zdjecia.interia.pl/galeria,gcsi,9B8E4291E4BF14EFACA58A04A3373A48FF5CD4DE" target="_blank"><img src="cid:public_gallery_preview"></a></div><br><br>--<br>Pozdrawiam
<br>Radosław Szczygieł</public_gallery_body></p></body></html>