View Issue Details

IDProjectCategoryView StatusLast Update
0000309Pgpool-IIBugpublic2017-08-29 09:24
Reportermaxidavid Assigned ToMuhammad Usama  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionopen 
Product Version3.6.2 
Summary0000309: bind socket failed with error: "Address already in use"
DescriptionI know that this issue was already resolved, but I still have it.
I have psql(9.6.1) client on macbook,1 pgpool(3.6.2) and 3 postgres db(9.6.2) instances using streaming replication log.

 I get
May 16 10:03:05 pgpool pgpool[10597]: [3-1] 2017-05-16 10:03:05: pid 10597: FATAL: failed to bind a socket: "/var/run/pgpool/.s.PGSQL.5432"
May 16 10:03:05 pgpool pgpool[10597]: [3-2] 2017-05-16 10:03:05: pid 10597: DETAIL: bind socket failed with error: "Address already in use"
May 16 10:03:05 pgpool systemd[1]: pgpool2.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED

Steps To Reproduce1 connect psql client to pgpool and leave it connected.
2 restart pgpool.
Tagserror

Activities

Muhammad Usama

2017-06-21 21:20

developer   ~0001542

Hi

I have tried with 6.2 and master branches on centos 7 but unable to reproduce the issue.
Can you please provide the pgpool.conf file along with the command you are using to run the pgpool-II (specifically I am interested to know if you are running the pgpool-II in daemon mode ? or as a service )
And also please list the command(s) you are using to for restarting the pgpool-II?

Issue History

Date Modified Username Field Change
2017-05-16 19:42 maxidavid New Issue
2017-05-16 19:42 maxidavid Tag Attached: error
2017-06-13 13:08 t-ishii Assigned To => Muhammad Usama
2017-06-13 13:08 t-ishii Status new => assigned
2017-06-21 21:20 Muhammad Usama Note Added: 0001542
2017-08-29 09:24 pengbo Status assigned => closed