View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000291 | Pgpool-II | Bug | public | 2017-03-01 04:00 | 2017-05-01 14:57 |
| Reporter | vibin22@gmail.com | Assigned To | t-ishii | ||
| Priority | high | Severity | block | Reproducibility | random |
| Status | closed | Resolution | open | ||
| Platform | linux | OS | Centos 7 | OS Version | Centos 7 |
| Product Version | 3.6.0 | ||||
| Summary | 0000291: ERROR: portal "pgpool_error_portal" does not exist | ||||
| Description | happened to occur the following error ">ERROR: portal "pgpool_error_portal" does not exist" on the primary node, this happens randomly , same tests run successfully one by one, but when run as a batch seeing the following error. | ||||
| Steps To Reproduce | PostgreSQL 9.4 runs on streaming replication mode. one promary and a secondary node Pgpool 2 configured on master-salve mode. attached the pgpool.conf file | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
This happens when the client invokes the db calls wrapped in a db transaction on the pgpool2 proxy, see error logs from postgresql log file PRIMARY server log **************** EST >ERROR: portal "pgpool_error_portal" does not exist < 2017-02-28 14:35:23.402 EST >LOG: duration: 0.019 ms bind S_1: ROLLBACK < 2017-02-28 14:35:23.403 EST >LOG: duration: 0.144 ms execute S_1: ROLLBACK STANDBY server log ***************** EST >LOG: duration: 0.021 ms bind S_1: ROLLBACK < 2017-02-28 14:35:32.023 EST >LOG: duration: 0.015 ms execute S_1: ROLLBACK |
|
|
pgpool_error_portal was created by Pgpool-II. In some cases the message is normal but to make sure I need a pgpool log. Can you pleazse provide it? |
|
|
No response over from the report over 1 month. Item closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-03-01 04:00 | vibin22@gmail.com | New Issue | |
| 2017-03-01 04:01 | vibin22@gmail.com | File Added: pgpool.conf | |
| 2017-03-01 04:39 | vibin22@gmail.com | Note Added: 0001371 | |
| 2017-03-23 09:05 | t-ishii | Assigned To | => t-ishii |
| 2017-03-23 09:05 | t-ishii | Status | new => assigned |
| 2017-03-26 16:19 | t-ishii | Note Added: 0001397 | |
| 2017-03-26 16:19 | t-ishii | Status | assigned => feedback |
| 2017-05-01 14:56 | t-ishii | Note Added: 0001489 | |
| 2017-05-01 14:57 | t-ishii | Status | feedback => closed |
