View Issue Details

IDProjectCategoryView StatusLast Update
0000326pgpoolAdminBugpublic2018-05-01 08:46
Reporteramar Assigned Topengbo  
PriorityhighSeveritycrashReproducibilityalways
Status closedResolutionopen 
PlatformLinuxOSubuntu 
Product Version3.6.0 
Summary0000326: pcp_node_info command error occurred on pgpool admin
DescriptionHello Team,

I am running below version of pgpool and backend nodes are running with 9.4.
pgpool2 3.6.4-1.pgdg14.04+1
libpgpool0 3.6.4-1.pgdg14.04+1

When logged into pgpool admin ui, I see the message : pcp_node_info command error occurred.

I seen few posts and manually it works if I point the location to /var/run/postgresql when running any pcp commands

Looks like the default location is /tmp and it looks for the socket files under /tmp which is causing the issue.

pcp_node_info -h /var/run/postgresql -U postgres -n 0
x.x.x.x 5432 2 0.200000 up

pcp_node_info -U postgres -n 0
ERROR: connection to socket "/tmp/.s.PGSQL.9898" failed with error "No such file or directory"

Could you please help me to fix the issue with pgpool admin ui. I am not able to see the node info and others useful options because of this issue.





Tagspcp commands

Activities

amar

2017-08-08 20:28

reporter  

PCP command error.PNG (41,119 bytes)   
PCP command error.PNG (41,119 bytes)   

pengbo

2017-08-20 23:24

developer   ~0001676

It looks like that you didn't set the correct Pgpool-II version.
Try to set the correct Pgpool-II version by editing "conf/pgmgt.conf.php" file like following.

---
define('_PGPOOL2_VERSION', '3.6');
---

Issue History

Date Modified Username Field Change
2017-08-08 20:28 amar New Issue
2017-08-08 20:28 amar File Added: PCP command error.PNG
2017-08-08 20:28 amar Tag Attached: pcp commands
2017-08-09 08:02 pengbo Assigned To => pengbo
2017-08-09 08:02 pengbo Status new => assigned
2017-08-09 08:02 pengbo Description Updated
2017-08-20 23:24 pengbo Note Added: 0001676
2018-05-01 08:46 pengbo Status assigned => closed