View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000754 | Pgpool-II | General | public | 2022-05-19 01:20 | 2022-06-28 10:50 |
| Reporter | gsl23 | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Product Version | 3.7.23 | ||||
| Summary | 0000754: Object not in prerequisite state: 7 ERROR: currval of sequence error | ||||
| Description | Hi ! We got errors like : SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: currval of sequence "name" is not yet defined in this session: INSERT INTO ... on Drupal v. 8.9.20 with pgpool v3.7 and load balance on 3 node patroni cluster. Error doesnt exists without pgpool (and any load balancing). Do you have any expirience with working pgpool with drupal database ? Is pgpool comatible with drupal ? | ||||
| Tags | load balancing, pgpool 3.7.1 | ||||
|
|
Could you show the information below? - the error in Pgpool-II - the executed query - the configuration file pgpool.conf |
|
|
Have you resolved this issue? |
|
|
If your application are using currval, you need to add it to "black_function_list". Doc: https://www.pgpool.net/docs/37/en/html/runtime-config-load-balancing.html#GUC-BLACK-FUNCTION-LIST |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-05-19 01:20 | gsl23 | New Issue | |
| 2022-05-19 01:20 | gsl23 | Tag Attached: load balancing | |
| 2022-05-19 01:20 | gsl23 | Tag Attached: pgpool 3.7.1 | |
| 2022-05-19 09:18 | pengbo | Note Added: 0004035 | |
| 2022-05-19 09:18 | pengbo | Assigned To | => pengbo |
| 2022-05-19 09:18 | pengbo | Status | new => assigned |
| 2022-05-23 13:56 | pengbo | Status | assigned => feedback |
| 2022-06-02 13:51 | administrator | Note Added: 0004052 | |
| 2022-06-28 10:50 | pengbo | Note Added: 0004064 |
