Hi
I got the following errors on a single Sequoia controller with two backend nodes: 009-01-20 09:59:48,302 INFO controller.loadbalancer.RAIDb1 write request 48348 failed: Backend ABDR - BackendWorkerThread for backend 'cluster2' with RAIDb level:1 failed (ERROR: insert or update on table "contactdetails" violates f oreign key constraint "fk5cbbce22494239c6" Detail: Key (emailaddress)=(569596) is not present in table "emailaddress".) Backend ABDR - BackendWorkerThread for backend 'cluster1' with RAIDb level:1 failed (ERROR: insert or update on table "contactdetails" violates f oreign key constraint "fk5cbbce22494239c6" Detail: Key (emailaddress)=(569596) is not present in table "emailaddress".) 2009-01-20 09:59:48,303 INFO virtualdatabase.VirtualDatabaseWorkerThread.ABDR Error during command execution (write request 48348 failed: Backend ABDR - BackendWorkerThread for backend 'cluster2' with RAIDb level:1 failed (ERROR: insert or update on table "contactdetails" violates f oreign key constraint "fk5cbbce22494239c6" Detail: Key (emailaddress)=(569596) is not present in table "emailaddress".) Backend ABDR - BackendWorkerThread for backend 'cluster1' with RAIDb level:1 failed (ERROR: insert or update on table "contactdetails" violates f oreign key constraint "fk5cbbce22494239c6" Detail: Key (emailaddress)=(569596) is not present in table "emailaddress".) It appeared to me that it is a result of previous query not executed on one node before the next query gets executed. This error happens randomly. we managed to repeat this problem only when the server is running under certain load. Also, FYI, WaitForCompletion policy is already set to "all". Any help is appreciated. Tyler
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
