View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000463 | Pgpool-II | Enhancement | public | 2019-02-06 00:53 | 2019-02-07 22:41 |
| Reporter | jpedersen | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Product Version | 3.7.7 | ||||
| Summary | 0000463: Missing WARN for single server setups | ||||
| Description | Hi, If you have * replication_mode * load_balance_mode * master_slave set to 'on' but only have 1 backend defined there is no WARN in each of these scenarios. | ||||
| Tags | No tags attached. | ||||
|
|
Why do you think WARN should be output? Pgpool-II support RAW mode which has 1 backend defined. |
|
|
F.ex. if you have master_slave = on master_slave_sub_mode = 'stream' sr_check_period = 600 sr_check_user = 'pgbench' sr_check_password = 'pgbench' sr_check_database = 'pgbench' ... but only 1 backend defined then pgpool spend 0000005:0000008% of its time in detect_serialization_error(). I had to read the source in order to figure that I have forgotten to do master_slave = off. |
|
|
That should say "about 8%" |
|
|
Thank you. I understood. Yes. I agree to add WARNING messages for single server setups. I will add this item to TODO list. |
|
|
After we discussed, sometimes backend nodes may get down or we may add new nodes, so we think WARN is not necessary. Also this may make too many WARNING messages in log. |
|
|
INFO would be ok too. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-02-06 00:53 | jpedersen | New Issue | |
| 2019-02-06 09:02 | administrator | Assigned To | => pengbo |
| 2019-02-06 09:02 | administrator | Status | new => assigned |
| 2019-02-06 09:08 | pengbo | Note Added: 0002373 | |
| 2019-02-06 21:24 | jpedersen | Note Added: 0002375 | |
| 2019-02-06 21:25 | jpedersen | Note Added: 0002376 | |
| 2019-02-07 13:44 | pengbo | Note Added: 0002379 | |
| 2019-02-07 17:59 | pengbo | Note Added: 0002381 | |
| 2019-02-07 22:41 | jpedersen | Note Added: 0002382 |
