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
Highlighted
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".

View solution in original post

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

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

Gold Adventurer

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

hi @nshah thanks for  response , i will wait your update!!!

 

 

Regards

Silver Adventurer

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

HI @asotolongo

 

Is It possible for you to send woker.log file with debug2 log level? One may set log level in agent.cfg file as parameter log_level.

 

Thanks,

Ninad

Gold Adventurer

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

hi @nshah, here a video with example:

video

 

and the logs is here

 

 

let know if you can view or download both file

 

Regards 

 

Tags (1)
Silver Adventurer

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

Hi @asotolongo

 

Thank you for detail. Our development team wanted to confirm If issue occurring at your end is same as the one reproduced by me. If there is any code level difference to be taken care here.

 

We will let you know once We received any solution or requirement from our Development team.

 

Thanks,

Ninad

Silver Adventurer

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

HI @asotolongo

 

We heard back from our development team. PEM statistics for EFM is dependent on command "efm cluster-status-json efm". Here from 3.2 to 3.3, there are some changes in command output. And, PEM is not able to parse output in new format. This issue is lodged as a bug(PEM-1610) in our system and solution will be available in PEM 7.6.

Presently, PEM 7.6 release date is tentatively set to Jan-09-2019.

 

Hope this may help you.

 

Thanks,

Ninad

Gold Adventurer

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

hi @nshah, thanks for  your feedback, i will wait the update PEM 7.6

 

Regards

Silver Adventurer

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

Hi @asotolongo

 

Thank you for your response. Would you like to keep this issue open till availability of PEM 7.6?

 

Thanks,

Ninad Shah

Gold Adventurer

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

@nshah i prefer keep this issue open until PEM 7.6!

 

regards

Highlighted
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".

View solution in original post

Gold Adventurer

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

hi @chaitalirs i will test,

And I comment you

 

thanks

Gold Adventurer

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

hi @chaitalirs @nshah  pem 7.6 resolve the problem, 

 

pem7.6.png

 

thanks