EFM -switchover error - Mailing list pgsql-admin

From nikhil Kumar
Subject EFM -switchover error
Date
Msg-id CAEXynSs4VZoZhTFTzyvVXBNKGDrUVtvwiYWurN+6XPTV3HfGEg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Dear Team,

I have configured the EFM with the edb-15 environment. initially primary and secondary are in sync. But once the switchover happen timeline is changing and getting the below error. Please give a permanent solution


Before switchover:

image.png

After switchover.
image.png

error log :  [enterprisedb@localhost ~]$ cd /var/log/efm-5.2/
[enterprisedb@localhost efm-5.2]$ ll
total 192
-rw-r--r--. 1 efm efm 196487 Jan 26 20:12 efm.log
[enterprisedb@localhost efm-5.2]$ tail -10 efm.log
Error: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: localhost, 25; timeout 60000;
  nested exception is:
        java.net.ConnectException: Connection refused.
2026-01-26 20:12:31 com.enterprisedb.efm.DBMonitor lambda$watchDB$1 WARN: Database connection is null.
2026-01-26 20:12:34 com.enterprisedb.efm.admin.AdminServerThread processRequest INFO: Admin server received status request.
2026-01-26 20:12:34 com.enterprisedb.efm.admin.AdminServerThread processRequest INFO: Received param: efm
2026-01-26 20:12:34 com.enterprisedb.efm.nodes.EfmNode checkClusterStatus INFO: Sending status message to all nodes: node_status
2026-01-26 20:12:34 com.enterprisedb.efm.nodes.EfmAgent handleStatusCall INFO: responding to db status request with status: Standby%%192.168.75.142%%true%%192.168.75.150%%false
2026-01-26 20:12:34 com.enterprisedb.efm.nodes.EfmNode checkClusterStatus INFO: Status response: EfmStatus{nodeStatusList=[NodeStatus{type='Witness', address=localhost-17356(192.168.75.149)}, NodeStatus{type='Standby', address=localhost-64370(192.168.75.142)}, NodeStatus{type='Primary', address=localhost-39617(192.168.75.148)}]}
2026-01-26 20:12:34 com.enterprisedb.efm.nodes.EfmNode checkClusterStatus INFO: Current internal status: [ total nodes: 3 primary: localhost-39617(192.168.75.148) promoting: null standbys (1): localhost-64370(192.168.75.142)  witnesses (1): localhost-17356(192.168.75.149)  idle nodes (0):  failed (0):  ]

pgsql-admin by date:

Previous
From: Олег Самойлов
Date:
Subject: Re: autoanalyze did not run
Next
From: Олег Самойлов
Date:
Subject: Re: autoanalyze did not run