Symptoms

Node was removed from QMail cluster. All QMail tasks started to fail with the following output message:

Host #207 does not exist.

core.log error is:

DBG [... QmailCluster ]: [ QmailCluster::HostOpsPerformer::perform] ===> ENTRY
DBG [... pau ]: c.p.p.s.d.e.DBServiceBean ' SELECT operation_host_id FROM cqmail_configurations WHERE config_id =  ?'. Parameters: [1] [sqlpid: 31076]
...
DBG [... pau ]: c.p.p.tracer exit by exception: com.parallels.pa.service.host.ejb.HostMngmtBean.getHostByIdPlesk.ErrorHandling.HostManager.InvalidHostID: Host #207 does not exist.
    at com.parallels.pa.service.host.ejb.HostMngmtBean.getHostById(HostMngmtBean.java:916)
    at com.parallels.pa.service.host.ejb.HostMngmtBean.processHostOps(HostMngmtBean.java:527)

Cause

The operation_host_id property was not updated in a proper way in case two nodes are removed from QMail cluster simultaneously.

This behavior has been addressed to Odin Development team as software-related issue #POA-114806: "Value of 'operation_host_id' field (in 'cqmail_configurations' table) is updated incorrectly after node removal".

Resolution

Contact pta@odin.com or TAM to trace the status of the issue.

Workaround: contact Odin Technical Support to apply internal workaround.

Internal content

Link on internal Article