View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000257 | Pgpool-II | Bug | public | 2016-10-20 20:16 | 2016-10-26 17:45 |
| Reporter | FJ Aleu | Assigned To | t-ishii | ||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Product Version | 3.5.3 | ||||
| Summary | 0000257: Notify not received | ||||
| Description | In our schema, we have 2 machines with pgpool and postgresql server, and App connected to the virtual IP. we have pgpool in replication mode. when we have only one backend attached, the bbdd notifys are received correct, but when we have 2 backends attached, we don´t received the notifications in the App. Is similar to error 00045, but using replication mode, no master&standby. http://www.pgpool.net/mantisbt/view.php?id=45 | ||||
| Steps To Reproduce | 1)attach 2 backends node to pgpool. 2)connect the App to the virtual IP. 3)listen a notify with the App (in qt, use subscribeToNotification function in psql driver. For example: "database.driver->subscribeToNotification("change");) 4)launch a notify, (for example use psql and the command Notify or pg_notify, use the same notifications used in subscribetoNotification. For example #>NOTIFY change; | ||||
| Tags | No tags attached. | ||||
|
|
I have tested with psql and it seems it works in the similar way of PostgreSQL: PostgreSQL case: termimal A: psql -p 11002 test terminal B: psql -p 11002 test terminal A: listen aaa; terminal B: notify aaa; terminal A: listen aaa; NOTIFY Asynchronous notification "aaa" received from server process with PID 4524. Pgpool-II case: termimal A: psql -p 11002 test terminal B: psql -p 11002 test terminal A: listen aaa; terminal B: notify aaa; terminal A: listen aaa; NOTIFY Asynchronous notification "aaa" received from server process with PID 4467. |
|
|
ok, I found the error, it´s in my APP, not int pgpool. Thanks for the assitance |
|
|
Ok issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-10-20 20:16 | FJ Aleu | New Issue | |
| 2016-10-26 11:03 | t-ishii | Assigned To | => t-ishii |
| 2016-10-26 11:03 | t-ishii | Status | new => assigned |
| 2016-10-26 11:09 | t-ishii | Note Added: 0001132 | |
| 2016-10-26 11:09 | t-ishii | Status | assigned => feedback |
| 2016-10-26 17:19 | FJ Aleu | Note Added: 0001135 | |
| 2016-10-26 17:19 | FJ Aleu | Status | feedback => assigned |
| 2016-10-26 17:45 | t-ishii | Note Added: 0001136 | |
| 2016-10-26 17:45 | t-ishii | Status | assigned => closed |
