High Availability and replication.

High Availability and replication.

Hi,
 
I have PMP version 6.0.0 Premium Edition and I am having an issue with replication. When I setup HA it works for some time and then silently stops. When this happens I can see on the slave (not on the master) in the Application log two Event IDs:100.
One says: "Slave: Error 'Table 'passtrixtemp.ptrx_dummyusers' doesn't exist' on query......"
The other one says:

"Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000004' position 3213255"

It looks like the slave hits the invalid query which causes replication to not work anymore. Amazingly, PMP reports that HA connection status is alive.

The only way so far to fix this issue is to setup HA from scratch.

Has anyone seen this issue and found solution to fix it?

 

Thanks,

-Mike 




                  New to ADSelfService Plus?