[Pgpool-committers] pgpool - pgpool-II: Add pool_set_timeout() to control pool_check_fd()'s

User T-ishii t-ishii at pgfoundry.org
Mon Jul 20 12:06:26 UTC 2009


Log Message:
-----------
Add pool_set_timeout() to control pool_check_fd()'s behavior.
This can be used for various places.
The first user is reset_backend() to fix following scenario:
Do COPY_FROM(for example pgbench -i)
Cancel pgbench
pgpool waits for response from backend while sending reset queries and
hang.
Backend waits for data coming from pgpool forever.

BTW, I don't think PostgreSQL's befaviro for COPY_FROM is quite
correct since the doc stats:"Receipt of any other non-copy message
type constitutes an error that will abort the copy-in state as
described above"
If my understanding correct, COPY_FROM should abort copy-in state
if it receives ABORT (issued in reset_backend).
It seems PostgreSQL is not implemented as stated in the doc...

Modified Files:
--------------
    pgpool-II:
        pool.h (r1.36 -> r1.37)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool.h?r1=1.36&r2=1.37)
        pool_process_query.c (r1.146 -> r1.147)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c?r1=1.146&r2=1.147)


More information about the Pgpool-committers mailing list