Title: ALTRAN OUEST
Just to give more information, the Sequoia version is 2.10.6,
MySQL version is 5.0.37
and MySQL JDBC driver is mysql-connector 5.0.5
Gérard BUNEL a écrit :
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
*Chef de Projet
____________________________________________________________________
Technopôle Brest Iroise
Site du Vernis – CS 23866
29238 Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com <http://www.altran.com>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Gérard
BUNEL
Chef
de Projet
____________________________________________________________________
Technopôle
Brest Iroise
Site du Vernis – CS 23866
29238
Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com
|
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
