[Pgpool-general] pgpool + transaction

[Евгений Фурманюк]

>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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090304/501d6df7/attachment.html