View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000590 | Pgpool-II | General | public | 2020-02-28 19:33 | 2020-03-02 11:20 |
| Reporter | yangjuexi | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Platform | linux | OS | redhat | OS Version | 7 |
| Product Version | 4.1.0 | ||||
| Summary | 0000590: sonarqube uses jdbc driver to connect to pgpool-II failed | ||||
| Description | Hi guys，i get some problems that i cant fix and i want to get some help here. Here are environment information: I have a postgresql-10.11 cluster with 3 nodes and a pgpool-ii cluster with 3 nodes,and ,they are on the same servers. pg version 10.11 pgpool-ii version 4.1.0 cluster ip : node 0 : 10.194.15.134 node 1 : 10.194.15.135 node 2 : 10.194.15.136 vip : 10.194.15.137 spnarqube ip : 10.194.13.230 Here my problems: the cluster seems work correctly.But if i use sonarqube to connect to the primary node of postgresql directly,it works well.but if i use sonarqube to connect to the pgpool-II with vip ,it seems connections has been built,but no sql execute success.Also ,the same connection property works when i test on navicat.Is anything wrong with my conf file? i have no idea with this problem Here are part of the log (i will attach the log file and pgpool.conf below): 2020-02-28 17:20:15: pid 9711: LOG: new connection received 2020-02-28 17:20:15: pid 9711: DETAIL: connecting host=10.194.13.230 port=46802 2020-02-28 17:20:15: pid 9711: DEBUG: reading startup packet 2020-02-28 17:20:15: pid 9711: DETAIL: Protocol Major: 3 Minor: 0 database: sonar user: postgres 2020-02-28 17:20:15: pid 9711: LOG: md5 authentication successful with frontend 2020-02-28 17:20:15: pid 9711: DEBUG: creating new connection to backend 2020-02-28 17:20:15: pid 9711: DETAIL: connecting 0 backend 2020-02-28 17:20:15: pid 9711: DEBUG: creating new connection to backend 2020-02-28 17:20:15: pid 9711: DETAIL: connecting 1 backend 2020-02-28 17:20:15: pid 9711: DEBUG: creating new connection to backend 2020-02-28 17:20:15: pid 9711: DETAIL: connecting 2 backend 2020-02-28 17:20:15: pid 9711: DEBUG: authentication backend 2020-02-28 17:20:15: pid 9711: DETAIL: auth kind:0 2020-02-28 17:20:15: pid 9711: DEBUG: process parameter status 2020-02-28 17:20:15: pid 9711: DETAIL: backend:0 name:"application_name" value:"" 2020-02-28 17:20:15: pid 9711: DEBUG: process parameter status 2020-02-28 17:20:15: pid 9711: DETAIL: backend:1 name:"application_name" value:"" 2020-02-28 17:20:15: pid 9711: DEBUG: process parameter status 2020-02-28 17:20:15: pid 9711: DETAIL: backend:2 name:"application_name" value:"" 2020-02-28 17:20:15: pid 9711: LOG: DB node id: 0 backend pid: 11371 statement: SELECT version() 2020-02-28 17:20:15: pid 9711: DEBUG: memcache encode key 2020-02-28 17:20:15: pid 9711: DETAIL: username: "postgres" database_name: "sonar" 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: memcache encode key 2020-02-28 17:20:15: pid 9711: DETAIL: query: "SELECT version()" 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: memcache encode key 2020-02-28 17:20:15: pid 9711: DETAIL: `postgresSELECT version()sonar' -> `803f3947f7b49c23e56c4a0c4520e990' 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: fetching from cache storage 2020-02-28 17:20:15: pid 9711: DETAIL: search key "803f3947f7b49c23e56c4a0c4520e990" 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: fetching from cache storage 2020-02-28 17:20:15: pid 9711: DETAIL: cache not found on shared memory 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: not hit local relation cache and query cache 2020-02-28 17:20:15: pid 9711: DETAIL: query:SELECT version() 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: do_query: extended:1 query:"SELECT version()" 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: commiting relation cache to cache storage 2020-02-28 17:20:15: pid 9711: DETAIL: Query="SELECT version()" 2020-02-28 17:20:15: pid 9711: CONTEXT: while searching system catalog, When relcache is missed 2020-02-28 17:20:15: pid 9711: DEBUG: memcache encode key | ||||
| Tags | pgpool, pgpool-II | ||||
|
|
|
|
|
It seems you turn on both streaming replication mode and native replication mode. replication_mode = on master_slave_mode = on master_slave_sub_mode = 'stream' I guess what you want to use is the streaming replication mode. If so, then you should turn off replication_mode. i.e. replication_mode = off. |
|
|
It works! Thank you for you help! |
|
|
You are welcome. I am going mark this issue as "resolved". |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-02-28 19:33 | yangjuexi | New Issue | |
| 2020-02-28 19:33 | yangjuexi | File Added: pgpool.conf | |
| 2020-02-28 19:33 | yangjuexi | File Added: pgpool.log | |
| 2020-02-28 19:34 | yangjuexi | Tag Attached: pgpool | |
| 2020-02-28 19:34 | yangjuexi | Tag Attached: pgpool-II | |
| 2020-02-29 19:31 | t-ishii | Note Added: 0003233 | |
| 2020-03-02 11:01 | yangjuexi | Note Added: 0003234 | |
| 2020-03-02 11:20 | t-ishii | Note Added: 0003235 | |
| 2020-03-02 11:20 | t-ishii | Assigned To | => t-ishii |
| 2020-03-02 11:20 | t-ishii | Status | new => resolved |
| 2020-03-02 11:20 | t-ishii | Description Updated |
