[Pgpool-general] pgpool + transaction

Fri Mar 13 10:10:01 UTC 2009

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 Евгений Фурманюк <furmanyk.ea at gmail.com>

> >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/20090313/ac4ebea1/attachment-0001.html 