View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000092 | Pgpool-II | Bug | public | 2014-01-16 18:37 | 2014-05-07 21:02 |
| Reporter | harukat | Assigned To | nagata | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Summary | 0000092: 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 Information | debug 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 | ||||
| Tags | No tags attached. | ||||
| 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 |
