View Issue Details

IDProjectCategoryView StatusLast Update
0000036Pgpool-IIBugpublic2012-12-18 18:14
Reporterthiripalreddy Assigned Tot-ishii  
PriorityurgentSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
PlatformLinux64OSRHELOS Version5.5
Summary0000036: pcp_node_count o/p is hanging after pcp_detach_node
DescriptionI am facing an issue where pgpool services become inactive when i performed pcp_node_count after pcp_detach_node
PgPool Version :-3.1.4 against PG 9.2 on Linux64
Steps To ReproduceMy pgpool is setup successfully where
Master is running on Port=5432
Slave1 is running on Port=5433

Setup a New node and provide information in pgpool.conf file
i.e
Slave2 is running on Port=5434

Attach the node
Performed pcp_attach_node
./pcp_attach_node -d 20 localhost 9898 postgres postgres 2

take the Node count
./pcp_node_count -d 20 localhost 9898 postgres postgres
it is showing 3

Detach the newly created node
./pcp_detach_node -d 20 localhost 9898 postgres postgres 2

again try to perform Node count
./pcp_node_count -d 20 localhost 9898 postgres postgres

it is hanging here and when i saw the pgpool services ,it is showing like this :-

postgres 23766 23613 0 01:42 pts/2 00:00:00 [pgpool] <defunct>
postgres 23812 23613 0 01:43 pts/2 00:00:00 [pgpool] <defunct>
postgres 23813 23613 0 01:43 pts/2 00:00:00 [pgpool] <defunct>
--
--
--
postgres 23814 23613 0 01:43 pts/2 00:00:00 [pgpool] <defunct>
TagsNo tags attached.

Activities

t-ishii

2012-11-20 17:02

developer   ~0000159

I think the bug has already been fixed in 3.1 stable tree. Try:
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_1_STABLE

t-ishii

2012-12-18 18:14

developer   ~0000200

No response from reporter.

Issue History

Date Modified Username Field Change
2012-11-20 16:33 thiripalreddy New Issue
2012-11-20 17:02 t-ishii Note Added: 0000159
2012-11-21 08:18 t-ishii Assigned To => t-ishii
2012-11-21 08:18 t-ishii Status new => assigned
2012-11-26 16:04 t-ishii Status assigned => feedback
2012-12-18 18:14 t-ishii Note Added: 0000200
2012-12-18 18:14 t-ishii Status feedback => closed
2012-12-18 18:14 t-ishii Resolution open => fixed