[Pgpool-committers] pgpool - pgpool-II: Query cancel by statement timeout does not generate

User T-ishii t-ishii at pgfoundry.org
Wed Jul 22 05:33:28 UTC 2009


Log Message:
-----------
Query cancel by statement timeout does not generate "kind mismatch"
error any more.
How to reproduce the test case:

Directory connect to PostgreSQL.
T1: BEGIN;
T1: LOCK TABLE t1;

T2: SET statement_timeout TO 5000;
T2: UPDATE t1 SET ...

UPDATE query aborts and error message comes out on T2:
ERROR:  canceling statement due to statement timeout

A side effect of this is, statement timeout works correctly (rather
than statement timeout value * # of node).

Note that to initiate T1 by directory connecting to slave node will not
work (still results in kind mismatch error). But I don't think this could
happend in the real world.

Also refactor error detecting modules (detect_deadlock_error and so on).

Tags:
----
V2_2_STABLE

Modified Files:
--------------
    pgpool-II:
        pool_process_query.c (r1.141.2.9 -> r1.141.2.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c?r1=1.141.2.9&r2=1.141.2.10)
        pool_proto_modules.c (r1.6.2.4 -> r1.6.2.5)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_proto_modules.c?r1=1.6.2.4&r2=1.6.2.5)
        pool_proto_modules.h (r1.1.2.1 -> r1.1.2.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_proto_modules.h?r1=1.1.2.1&r2=1.1.2.2)


More information about the Pgpool-committers mailing list