View Issue Details

IDProjectCategoryView StatusLast Update
0000092Pgpool-IIBugpublic2014-05-07 21:02
ReporterharukatAssigned Tonagata 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version 
Target VersionFixed in Version 
Summary0000092: enbugs pgpool-II 3.3.2 at JDBC by statement.executeUpdate(simple_dml)
Description
The following java code causes
"ERROR: unnamed prepared statement does not exist"
through pgpool-II 3.3.2 with simple connection_cache mode.

      :
   String sql = "INSERT INTO t VALUES ('1', 'a', 'X');";
   Statement statement = connection.createStatement();
   statement.executeUpdate(sql);
      :

Even if I change JDBC driver, error happen equally.
 (I try 9.0-802.jdbc4, 9.2-1002.jdbc4 and 9.3-1100.jdbc4)

In pgpool-II 3.3.1, error does not occer.
Additional Informationdebug log sample:

2014-01-16 17:59:07 DEBUG: pid 27860: pool_set_query_in_progress: done
2014-01-16 17:59:07 DEBUG: pid 27860: wait_for_query_response: waiting for backend 0 completing the query
2014-01-16 17:59:07 DEBUG: pid 27860: read_kind_from_backend: kind: 1 from 0 th backend
2014-01-16 17:59:07 DEBUG: pid 27860: read_kind_from_backend: read kind from 0 th backend 1 NUM_BACKENDS: 1
2014-01-16 17:59:07 DEBUG: pid 27860: ProcessBackendResponse: kind from backend: 1
2014-01-16 17:59:07 DEBUG: pid 27860: pool_add_sent_message: prepared statement "" already exists
2014-01-16 17:59:07 DEBUG: pid 27860: can_query_context_destroy: query context 0x186fb20 is still used. query:SET extra_float_digits = 3
2014-01-16 17:59:07 DEBUG: pid 27860: can_query_context_destroy: query context 0x186fb20 is still used. query:SET extra_float_digits = 3
2014-01-16 17:59:07 DEBUG: pid 27860: can_query_context_destroy: query context 0x186fb20 is still used for 2 times.
2014-01-16 17:59:07 DEBUG: pid 27860: pool_set_command_success: done
2014-01-16 17:59:07 DEBUG: pid 27860: pool_unset_query_in_progress: done
2014-01-16 17:59:07 DEBUG: pid 27860: ProcessFrontendResponse: kind from frontend B(42)
2014-01-16 17:59:07 DEBUG: pid 27860: pool_unset_doing_extended_query_message: done
2014-01-16 17:59:07 DEBUG: pid 27860: pool_set_doing_extended_query_message: done
2014-01-16 17:59:07 DEBUG: pid 27860: pool_set_query_in_progress: done
2014-01-16 17:59:07 DEBUG: pid 27860: Bind: checking strict query
2014-01-16 17:59:07 DEBUG: pid 27860: Bind: strict query
2014-01-16 17:59:07 DEBUG: pid 27860: do_command: Query: BEGIN
2014-01-16 17:59:07 DEBUG: pid 27860: wait_for_query_response: waiting for backend 0 completing the query
2014-01-16 17:59:07 DEBUG: pid 27860: detect_error: kind: C
2014-01-16 17:59:07 DEBUG: pid 27860: do_command: kind: C
2014-01-16 17:59:07 DEBUG: pid 27860: len:a000000
2014-01-16 17:59:07 DEBUG: pid 27860: do_command: kind: Z
2014-01-16 17:59:07 DEBUG: pid 27860: do_command: transaction state: T
2014-01-16 17:59:07 DEBUG: pid 27860: pool_unset_writing_transaction: done
2014-01-16 17:59:07 DEBUG: pid 27860: Bind: checking insert lock
2014-01-16 17:59:07 DEBUG: pid 27860: get_insert_command_table_name: extracted table name: "t"
2014-01-16 17:59:07 DEBUG: pid 27860: Bind: waiting for master completing the query
2014-01-16 17:59:07 DEBUG: pid 27860: wait_for_query_response: waiting for backend 0 completing the query
2014-01-16 17:59:07 LOG: pid 27860: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 28128 statement: I
NSERT INTO t VALUES ('2', 'b', 'X') message: unnamed prepared statement does not exist
2014-01-16 17:59:07 DEBUG: pid 27860: read_kind_from_backend: kind: E from 0 th backend
TagsNo tags attached.

Activities

harukat

2014-01-16 20:00

developer   ~0000384

This problem occer at raw mode (replication_mode = off).

Issue History

Date Modified Username Field Change
2014-01-16 18:37 harukat New Issue
2014-01-16 20:00 harukat Note Added: 0000384
2014-01-17 15:10 nagata Assigned To => nagata
2014-01-17 15:10 nagata Status new => assigned
2014-01-19 12:01 t-ishii Changeset attached => pgpool2 master 05a29228
2014-01-19 13:01 t-ishii Changeset attached => pgpool2 master 1c18d626
2014-01-19 13:01 t-ishii Changeset attached => pgpool2 V3_1_STABLE debe11ad
2014-01-19 13:01 t-ishii Changeset attached => pgpool2 V3_0_STABLE 5348f703
2014-01-20 10:43 nagata Status assigned => closed
2014-01-20 10:43 nagata Resolution open => fixed
2014-05-07 21:02 t-ishii Changeset attached => pgpool2 master 2dc5d0c1
2014-05-07 21:02 t-ishii Changeset attached => pgpool2 master 290880f4