On Tue, 7 Jun 2011 10:39:18 -0430 Lazaro Rubén García Martinez <[email protected]> wrote:
> Hello, every one in the list, when I conect to pgpool by psql, and stop one > PostgreSQL server, the connection closes, failover is performed but the > transaction executed by pgpool is aborted, but I don't know why the > transaction is aborted if pgpool make failover??? I think that this onluy > occurs using psql. Is this right?? > > Why is the cause of the error?? A hint is written in the source code. /* * Before we tried to minimize restarting pgpool to protect existing * connections from clients to pgpool children. What we did here was, * if children other than master went down, we did not fail over. * This is wrong. Think about following scenario. If someone * accidentally plugs out the network cable, the TCP/IP stack keeps * retrying for long time (typically 2 hours). The only way to stop * the retry is restarting the process. Bottom line is, we need to * restart all children in any case. See pgpool-general list posting * "TCP connections are *not* closed when a backend timeout" on Jul 13 * 2008 for more details. */ -- Toshihiro Kitagawa SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
