[Pgpool-general] pgpool + transaction

[Tatsuo Ishii]

Are you using protocolVersion=2? It seems to be very old. Is it
possible for you to use protocolVersion=3? What version of PostgreSQL
do you use?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> >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