PostgreSQL 8.3.1. With protocolVersion=3 in log: 2009-03-05 09:44:23 LOG: pid 6527: statement: ABORT 2009-03-05 09:44:23 LOG: pid 6527: statement: RESET ALL 2009-03-05 09:44:23 LOG: pid 6527: statement: SET SESSION AUTHORIZATION DEFAULT 2009-03-05 09:44:23 LOG: pid 6527: statement: DEALLOCATE "S_1" 2009-03-05 09:44:26 LOG: pid 6497: connection received: host=172.22.244.110 port=49393 2009-03-05 09:44:26 LOG: pid 6497: statement: RESET ALL 2009-03-05 09:44:26 LOG: pid 6497: statement: SET SESSION AUTHORIZATION DEFAULT 2009-03-05 09:44:26 LOG: pid 6497: read_kind_from_backend: parameter name: is_superuser value: off 2009-03-05 09:44:26 LOG: pid 6497: read_kind_from_backend: parameter name: session_authorization value: nmuser 2009-03-05 09:44:26 LOG: pid 6497: read_kind_from_backend: parameter name: is_superuser value: off 2009-03-05 09:44:26 LOG: pid 6497: read_kind_from_backend: parameter name: session_authorization value: nmuser 2009-03-05 09:44:26 LOG: pid 6497: statement: DEALLOCATE "S_1" 2009-03-05 09:44:26 LOG: pid 6497: statement: DEALLOCATE "S_2"
It seems like pgpool can't parse statements and send statements to all nodes to parse and bind (without balancing). 2009/3/4 Евгений Фурманюк <[email protected]> > >I use pgpool 2.2(last version by February 28, 2009) for jdbc java > application. AutoCommit true mode is not suitable, because our application > uses transactions. > >If AutoCommit is set false, we get an error when COMMIT. Please, tell how > we can use pgpool in this case? > > > >Thnx. > > If I set protocolVersion=2 in connection url and AutoCommit=false than I > have error when first executed statement is SELECT. > If first execute statement is UPDATE or INSERT then all work correctly. > > 2009-03-04 10:19:00 LOG: pid 21451: statement: BEGIN;select nextval > ('task_view_history_id_seq') > 2009-03-04 10:19:00 LOG: pid 21451: statement: insert into > task_view_history (iduser, idobject, timeMark, id) values (5977, 18833, > E'2009-03-04 10:18:44.268000 +03:00:00', 295188) > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read2: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: do_query: error while reading rest of > message > 2009-03-04 10:19:00 ERROR: pid 21451: need_insert_lock: do_query failed > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: pool_read: EOF encountered with > backend > 2009-03-04 10:19:00 ERROR: pid 21451: read_kind_from_backend: failed to > read kind from 0 th backend > 2009-03-04 10:19:00 LOG: pid 21451: do_child: exits with status 1 due to > error > 2009-03-04 10:19:00 ERROR: pid 21451: pool_flush_it: write failed (Broken > pipe) offset: 0 wlen: 1 > 2009-03-04 10:19:15 LOG: pid 21570: ProcessFrontendResponse: failed to > read kind from frontend. frontend abnormally exited > 2009-03-04 10:19:15 LOG: pid 21570: statement: ABORT > 2009-03-04 10:19:15 LOG: pid 21570: statement: RESET ALL > 2009-03-04 10:19:15 LOG: pid 21570: statement: SET SESSION AUTHORIZATION > DEFAULT > 2009-03-04 10:19:56 LOG: pid 24672: pgpool successfully started > 2009-03-04 10:20:27 LOG: pid 24706: connection received: > host=172.22.244.110 port=62361 > 2009-03-04 10:20:27 LOG: pid 24706: statement: set datestyle = 'ISO'; > select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then > 'UNKNOWN' else getdatabaseencoding() end > 2009-03-04 10:20:27 LOG: pid 24706: statement: begin; set autocommit = > on; set client_encoding = 'UNICODE'; SET extra_float_digits=2; commit > 2009-03-04 10:20:27 LOG: pid 24706: statement: select > current_setting('standard_conforming_strings') > 2009-03-04 10:20:27 LOG: pid 24706: statement: BEGIN;insert into "user" > (name) values ('555') > 2009-03-04 10:20:27 LOG: pid 24706: statement: select count(*) from task > 2009-03-04 10:20:27 LOG: pid 24706: statement: update task set > "name"='333' where id=18833 > 2009-03-04 10:20:27 LOG: pid 24706: statement: COMMIT > 2009-03-04 10:20:27 LOG: pid 24706: statement: RESET ALL > 2009-03-04 10:20:27 LOG: pid 24706: statement: SET SESSION AUTHORIZATION > DEFAULT > 2009-03-04 10:20:49 LOG: pid 24706: connection received: > host=172.22.244.110 port=62364 > 2009-03-04 10:20:49 LOG: pid 24706: statement: set datestyle = 'ISO'; > select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then > 'UNKNOWN' else getdatabaseencoding() end > 2009-03-04 10:20:49 LOG: pid 24706: statement: begin; set autocommit = > on; set client_encoding = 'UNICODE'; SET extra_float_digits=2; commit > 2009-03-04 10:20:49 LOG: pid 24706: statement: select > current_setting('standard_conforming_strings') > 2009-03-04 10:20:49 LOG: pid 24706: statement: BEGIN;select count(*) from > task > 2009-03-04 10:20:49 LOG: pid 24706: statement: insert into "user" (name) > values ('555') > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read2: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: do_query: error while reading rest of > message > 2009-03-04 10:20:49 ERROR: pid 24706: need_insert_lock: do_query failed > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: pool_read: EOF encountered with > backend > 2009-03-04 10:20:49 ERROR: pid 24706: read_kind_from_backend: failed to > read kind from 0 th backend > 2009-03-04 10:20:49 LOG: pid 24706: do_child: exits with status 1 due to > error > 2009-03-04 10:20:49 ERROR: pid 24706: pool_flush_it: write failed (Broken > pipe) offset: 0 wlen: 1 > > >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
