cancel
Showing results for 
Search instead for 
Did you mean: 

EFM Status in streaming replication dashborad on PEM not shown

SOLVED
Gold Adventurer

EFM Status in streaming replication dashborad on PEM not shown

Hi all, iam testing PEM 7.5 to visualizate (monitoring) the EFM(3.3) status in streaming replication dashborad and get the following error:

 

efm_error.png

 

and can't see node status info

 

 

and my configuration is

EFM Cluster Name: efm

EFM Installation Path: /usr/edb/efm-3.3/bin

 

efm_advanced_conf.png

efm_probe.png

my EFM(3.3) status with running the cli  is : 

efm_status.png

 

 

i got the information about streaming replication:

 

efm_sr_analysis.png

 

 

my version  PEM is 7.5

 

efm_PEM_version.png

 

 

iam missing something?

 

regards 

1 ACCEPTED SOLUTION

Accepted Solutions
EDB Team Member

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi, asotolongo,

 

The PEM 7.6 is released, below is the link for the technical alert :

 

Technical Update for EDB Postgres Enterprise Manager® (PEM) 7.6

 

Your issue is resolved via case "826397".

20 REPLIES 20
Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @asotolongo

 

We are working on this issue. Meanwhile, Is It possible for you to share logs from /var/log/pem/agent.log and /var/log/pem/worker.log?

Apart from It, output of following queries would be more helpful to see If data is there or not.

 

1. select * from pemdata.efm_cluster_info ;

2. select * from pemdata.efm_cluster_node_status ;

 

Thanks,

Ninad

Gold Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @nshah

the logs containt this:

 

/var/log/pem/worker.log

 

...

Wed Dec 19 08:50:17 2018 WARNING: probe execution error (id=59 param={2}): Failed to parse EFM json file
Wed Dec 19 08:50:18 2018 WARNING: probe execution error (id=58 param={2}): Failed to parse EFM json file
Wed Dec 19 08:57:16 2018 WARNING: EFM Installation path 'efm' does not exists
Wed Dec 19 08:57:18 2018 WARNING: probe execution error (id=59 param={2}): Failed to parse EFM json file

...

I try to execute Replace Cluister Master

this log don't exists: 

/var/log/pem/agent.log

 

 

and the query result: 

efm_cluster_info.png

 

efm_cluster_node_info.png

 

regards

 

 

Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @asotolongo

 

Thank you for your response. We are able to see issue with probe execution. Probe execution is failing here and hence not able to get data for EFM.

We will work on this issue and get back to you on same.

 

Thanks,

Ninad

Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @asotolongo

 

Is It possible to share output of command "/usr/edb/efm-3.3/bin/efm cluster-status-json efm"?

 

Thanks,

Ninad Shah

Gold Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

hi @nshah  thanks for response, here is the output of command :

 

/usr/edb/efm-3.3/bin/efm cluster-status-json efm
{"nodes":{"192.168.0.31":{"type":"Master","agent":"UP","db":"UP","vip":"192.168.0.40","vip_active":true,"xlog":"0\/18ABE9B0","xloginfo":""},"192.168.0.32":{"type":"Standby","agent":"UP","db":"UP","vip":"192.168.0.40","vip_active":false,"xlog":"0\/18ABE9B0","xloginfo":""},"192.168.0.33":{"type":"Standby","agent":"UP","db":"UP","vip":"192.168.0.40","vip_active":false,"xlog":"0\/18ABE9B0","xloginfo":""}},"allowednodes":["192.168.0.31","192.168.0.32","192.168.0.33"],"membershipcoordinator":"192.168.0.31","failoverpriority":["192.168.0.32","192.168.0.33"],"minimumstandbys":0,"missingnodes":[],"messages":[]}

regards

Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

HI @asotolongo

 

Is PEM agent running on same version(7.5) or It's running on different version?

 

Thanks,

Ninad

Highlighted
Gold Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

hi @nshah

 

pem_agent_version.png

Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @asotolongo

 

We are working on the issue. We will get back to you as soon as We get updates.

 

Thanks,

Ninad

Silver Adventurer

Re: EFM Status in streaming replication dashborad on PEM not shown

Hi @asotolongo

 

This is an update to the issue. We have reproduced the issue and We have escalated this issue to our development team.

We will get back to you once We receive response from Development team

 

Thanks,

Ninad