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

User T-ishii t-ishii at pgfoundry.org
Wed May 27 02:01:46 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...

Tags:
----
V2_2_STABLE

Modified Files:
--------------
    pgpool-II:
        pool.h (r1.36 -> r1.36.2.1)
        (http%3A%2F%2Fcvs.pgfoundry.org%2Fcgi-bin%2Fcvsweb.cgi%2Fpgpool%2Fpgpool-II%2Fpool.h%3Fr1%3D1.36%26r2%3D1.36.2.1)
        pool_process_query.c (r1.141.2.4 -> r1.141.2.5)
        (http%3A%2F%2Fcvs.pgfoundry.org%2Fcgi-bin%2Fcvsweb.cgi%2Fpgpool%2Fpgpool-II%2Fpool_process_query.c%3Fr1%3D1.141.2.4%26r2%3D1.141.2.5)


More information about the Pgpool-committers mailing list