cancel
Showing results for 
Search instead for 
Did you mean: 

Streaming replication probe error in PEM

SOLVED
Level 3 Adventurer

Streaming replication probe error in PEM

Hi All, 

 

I have configured Streaming replication analysis dashboard in PEM for monitoring replication.

 

I am getting below error in worker.log of PEM

 

WARNING: probe execution error (id=45 param={2}): ERROR: column "lag_mb" does not exist
LINE 1: ...on", "xlog_lag_in_segments", "xlog_lag_in_pages", "lag_mb" F...
^
HINT: Perhaps you meant to reference the column "streaming_replication.lag_MB".

 

I did some checking and found that may be the query "streaming replication" probe is running is failing.Any idea how to resolve this?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: Streaming replication probe error in PEM

Hi Nikhil,

 

We assume that, you are using the PEM 7.3 version and you are getting this error after enabling the streaming replication probe.

 

This is identified as a bug in the 7.3 and has been fixed in the 7.4 version, please upgrade the PEM server to 7.4 and let us know in case of any issues/queries.

 

Please refer the below link for PEM upgrade :

 

https://www.enterprisedb.com/docs/en/7.4/PEM_Upgrade_Migration_v7.4/toc.html

 

Regards,

Sudhir

3 REPLIES
Highlighted
EDB Team Member

Re: Streaming replication probe error in PEM

Hi Nikhil,

 

We assume that, you are using the PEM 7.3 version and you are getting this error after enabling the streaming replication probe.

 

This is identified as a bug in the 7.3 and has been fixed in the 7.4 version, please upgrade the PEM server to 7.4 and let us know in case of any issues/queries.

 

Please refer the below link for PEM upgrade :

 

https://www.enterprisedb.com/docs/en/7.4/PEM_Upgrade_Migration_v7.4/toc.html

 

Regards,

Sudhir

Level 3 Adventurer

Re: Streaming replication probe error in PEM

Thanks @slonkar

EDB Team Member

Re: Streaming replication probe error in PEM

Hi Nikhil,

 

Their is a workaround for this on PEM 7.3 version, Just you need to connect to the PEM server and PEM database and you need to run the attached .sql file with name "201808031.sql" and scheduled the probe which will resolve this "lag_MB" error.

 

However this is fixed in PEM 7.4 version as said by Sudhir.

 

Hope this helps you.