|
Hello, Doing some tests on constraints violations, using mysql DB, I've got a ClassNotFoundException about a MySQL Exception class (see below). I've checked the jar in the drivers directory and this class exists in the jar. What's wrong here ? It seems that's appia that generates this exception. Any help should be welcome Gerard Backend MATISSEDB - BackendWorkerThread for backend 'sd02' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) Backend MATISSEDB - BackendWorkerThread for backend 'sd01' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) 09:05:08,428 WARN controller.RequestManager.MATISSEDB SQLException while executing distributed write request write request 489 failed: Backend MATISSEDB - BackendWorkerThread for backend 'sd02' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) Backend MATISSEDB - BackendWorkerThread for backend 'sd01' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) java.sql.SQLException: write request 489 failed: Backend MATISSEDB - BackendWorkerThread for backend 'sd02' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) Backend MATISSEDB - BackendWorkerThread for backend 'sd01' with RAIDb level:1 failed (Cannot delete or update a parent row: a foreign key constraint fails (`matisse/HIERARCHIC_ENTITY`, CONSTRAINT `FKD94E60642AE4E945` FOREIGN KEY (`TYPE_ES`) REFERENCES `TYPE_ES` (`ID`))) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:938) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWriteRequest(RAIDb1.java:343) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteUpdate(RAIDb1.java:249) at org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecuteUpdate(RequestManager.java:915) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:87) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:357) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102) 09:05:08,438 ERROR continuent.hedera.adapters PullPushAdapter: Error while reading from channel org.continuent.appia.core.message.MessageException: Trying to read an unknown object from message. at org.continuent.appia.core.message.Message.popObject(Message.java:1254) at org.continuent.hedera.channel.AppiaReliableGroupChannel.receive(AppiaReliableGroupChannel.java:292) at org.continuent.hedera.adapters.PullPushAdapter.run(PullPushAdapter.java:166) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:585) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1544) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1466) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1699) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1908) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1832) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1908) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1832) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1908) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1832) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348) at org.continuent.appia.core.message.Message.popObject(Message.java:1250) ... 3 more -- Gérard
BUNEL |
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
