View Issue Details

IDProjectCategoryView StatusLast Update
0000590Pgpool-II[All Projects] Generalpublic2020-03-02 11:20
ReporteryangjuexiAssigned Tot-ishii 
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionopen 
PlatformlinuxOSredhatOS Version7
Product Version4.1.0 
Target VersionFixed in Version 
Summary0000590: sonarqube uses jdbc driver to connect to pgpool-II failed
DescriptionHi 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


Tagspgpool, pgpool-II

Activities

yangjuexi

2020-02-28 19:33

reporter  

pgpool.log (1,473,563 bytes)
pgpool.conf (44,024 bytes)

t-ishii

2020-02-29 19:31

developer   ~0003233

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.

yangjuexi

2020-03-02 11:01

reporter   ~0003234

It works! Thank you for you help!

t-ishii

2020-03-02 11:20

developer   ~0003235

You are welcome. I am going mark this issue as "resolved".

Issue History

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 View Revisions