View Issue Details

IDProjectCategoryView StatusLast Update
0000463Pgpool-IIEnhancementpublic2019-02-07 22:41
ReporterjpedersenAssigned Topengbo 
PrioritynormalSeverityminorReproducibilityhave not tried
Status assignedResolutionopen 
Product Version3.7.7 
Target VersionFixed in Version 
Summary0000463: Missing WARN for single server setups
DescriptionHi,

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.
TagsNo tags attached.

Activities

pengbo

2019-02-06 09:08

developer   ~0002373

Why do you think WARN should be output?
Pgpool-II support RAW mode which has 1 backend defined.

jpedersen

2019-02-06 21:24

reporter   ~0002375

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.

jpedersen

2019-02-06 21:25

reporter   ~0002376

That should say "about 8%"

pengbo

2019-02-07 13:44

developer   ~0002379

Thank you. I understood.
Yes. I agree to add WARNING messages for single server setups.

I will add this item to TODO list.

pengbo

2019-02-07 17:59

developer   ~0002381

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.

jpedersen

2019-02-07 22:41

reporter   ~0002382

INFO would be ok too.

Issue History

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