View Issue Details

IDProjectCategoryView StatusLast Update
0000275Pgpool-IIBugpublic2017-01-06 09:44
Reporteramitkindia Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionopen 
PlatformLinuxOSCentOS 7OS Version7.3.1611
Product Version3.5.5 
Summary0000275: PgPool not starting and showing failed to bind a socket: "/var/run/pgpool/.s.PGSQL.5433"
DescriptionPgPool not starting and showing failed to bind a socket: "/var/run/pgpool/.s.PGSQL.5433"
Steps To ReproduceI created AWS AMI from PgPool instance where PgPool was running, but before creating the AMI I had run "pgpool stop".

After launching new instance using this AWS AMI, when I try to start pgpool I see below errors:

Note: I have cleaned up /var/run/pgpool directory before starting pgpool.

2016-12-28 15:23:55: pid 2114: DEBUG: loading hba configuration
2016-12-28 15:23:55: pid 2114: DETAIL: loading file :"/etc/pgpool-II/pool_hba.conf" for client authentication configuration file
2016-12-28 15:23:55: pid 2114: LOG: Backend status file /var/log/pgpool/pgpool_status discarded
2016-12-28 15:23:55: pid 2114: DEBUG: pool_coninfo_size: num_init_children (20) * max_pool (10) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (136) = 3481600 bytes requested for shared memory
2016-12-28 15:23:55: pid 2114: DEBUG: ProcessInfo: num_init_children (20) * sizeof(ProcessInfo) (32) = 640 bytes requested for shared memory
2016-12-28 15:23:55: pid 2114: DEBUG: Request info are: sizeof(POOL_REQUEST_INFO) 5264 bytes requested for shared memory
2016-12-28 15:23:55: pid 2114: DEBUG: Recovery management area: sizeof(int) 4 bytes requested for shared memory
2016-12-28 15:23:55: pid 2114: FATAL: failed to bind a socket: "/var/run/pgpool/.s.PGSQL.5433"
2016-12-28 15:23:55: pid 2114: DETAIL: bind socket failed with error: "No such file or directory"
Tagspgpool

Activities

amitkindia

2016-12-29 00:54

reporter   ~0001273

Not an issue. Found out that the directory /var/run/pgpool was missing.

t-ishii

2017-01-06 09:44

developer   ~0001284

This issue closed.

Issue History

Date Modified Username Field Change
2016-12-29 00:35 amitkindia New Issue
2016-12-29 00:35 amitkindia Tag Attached: pgpool
2016-12-29 00:54 amitkindia Note Added: 0001273
2017-01-06 09:44 t-ishii Note Added: 0001284
2017-01-06 09:44 t-ishii Status new => closed