View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000307 | Pgpool-II | Bug | public | 2017-04-27 22:45 | 2017-06-26 16:22 |
| Reporter | eldad | Assigned To | t-ishii | ||
| Priority | high | Severity | crash | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Product Version | 3.4.7 | ||||
| Summary | 0000307: pgpool failed after pool_check_fd call failed with an error "Interrupted system call" | ||||
| Description | We had a strange situation when pgpool shutdown itself after encounter pool_check_fd call failed with an error "Interrupted system call" pgpool trigger failover with empty hostname and -1 for new master host: /etc/pgpool-II/failover_stream.sh 1 ptast001ppdb13 -1 "" 1 the failover was donw by the passive pgpool node. the Postgres DB was ok during that time and replication is fine. see attached log file for more info. | ||||
| Steps To Reproduce | NA | ||||
| Additional Information | 2 RHEL 6.3 with Postgres 3.3 and pgpool 3.4.7 | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
How failover script gets executed is depending on what you set to failover_command of pgpool.conf. Also Pgpool-II 3.4.7 is outdated version. The latest version is 3.4.11. Please upgrade. BTW, there's no such a version PostgreSQL 3.3. What's the actual version? |
|
|
Thanks for your answer. the command we use for failover is /etc/pgpool-II/failover_stream.sh %d %h %m %H %P what we saw in the log was : 2017-04-26 16:14:39: pid 30971: LOG: execute command: /etc/pgpool-II/failover_stream.sh 1 ptast001ppdb13 -1 "" 1 so %m %H were empty. Our postgres version is 9.3.3 Let me know if you need more info. Regards, Eldad |
|
|
Please let me know if you still see the problem with Pgpool-II 3.4.11. |
|
|
Hi, I hae plans to upgrade postgres to 9.6 and pgpool to latest 3.6 . Is it a known problem that has been fixed before? I didn't fully understand what happened there so I can't even try to reproduce it. Thanks, Eldad |
|
|
I suspect: https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=1e8c434b37d1c24e11b54b4fe2f2d4c964ba6861 |
|
|
No feedback for 1 month. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-04-27 22:45 | eldad | New Issue | |
| 2017-04-27 22:45 | eldad | File Added: node0.txt | |
| 2017-05-01 14:55 | t-ishii | Note Added: 0001488 | |
| 2017-05-01 14:56 | t-ishii | Assigned To | => t-ishii |
| 2017-05-01 14:56 | t-ishii | Status | new => feedback |
| 2017-05-03 16:17 | eldad | Note Added: 0001490 | |
| 2017-05-03 16:17 | eldad | Status | feedback => assigned |
| 2017-05-09 15:24 | t-ishii | Note Added: 0001500 | |
| 2017-05-09 15:24 | t-ishii | Status | assigned => feedback |
| 2017-05-14 20:33 | eldad | Note Added: 0001507 | |
| 2017-05-14 20:33 | eldad | Status | feedback => assigned |
| 2017-05-18 17:41 | t-ishii | Note Added: 0001518 | |
| 2017-05-18 17:52 | t-ishii | Status | assigned => feedback |
| 2017-06-26 16:22 | t-ishii | Note Added: 0001546 | |
| 2017-06-26 16:22 | t-ishii | Status | feedback => closed |
