Hi,
I tried to use sequoia cluster with my java app. When my java app tries to
make an update on one of the tables of the database backend, both sequoia
controllers display this error:
--------------------------------------------------------------------------------------
ERROR controller.loadbalancer.RAIDb1 write request 9 failed:
Backend System_DB - BackendWorkerThread for backend 'System_DB1' with
RAIDb level:1 failed (ERROR: could not determine data type of parameter
$5)
08:24:48,625 WARN controller.RequestManager.System_DB SQLException while
executing distributed write request write request 9 failed:
Backend System_DB - BackendWorkerThread for backend 'System_DB1' with
RAIDb level:1 failed (ERROR: could not determine data type of parameter
$5)
java.sql.SQLException: write request 9 failed:
Backend System_DB - BackendWorkerThread for backend 'System_DB1' with
RAIDb level:1 failed (ERROR: could not determine data type of parameter
$5)
at
org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:939)
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:925)
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:364)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
08:24:48,691 ERROR continuent.hedera.adapters PullPushAdapter: Error while
reading from channel
java.lang.IllegalArgumentException: java.lang.ClassNotFoundException:
org.postgresql.util.PSQLException
at org.jgroups.Message.getObject(Message.java:269)
at
org.continuent.hedera.channel.JGroupsReliableGroupChannel.receive(JGroupsReliableGroupChannel.java:216)
at
org.continuent.hedera.adapters.PullPushAdapter.run(PullPushAdapter.java:166)
at java.lang.Thread.run(Thread.java:595)
08:24:52,190 ERROR continuent.hedera.adapters PullPushAdapter: Error while
reading from channel
java.lang.IllegalArgumentException: java.lang.ClassNotFoundException:
org.postgresql.util.PSQLException
at org.jgroups.Message.getObject(Message.java:269)
at
org.continuent.hedera.channel.JGroupsReliableGroupChannel.receive(JGroupsReliableGroupChannel.java:216)
at
org.continuent.hedera.adapters.PullPushAdapter.run(PullPushAdapter.java:166)
at java.lang.Thread.run(Thread.java:595)
-------------------------------------------------------------------------------
While I can make Insert, UPDATE and Drop statement successfully using
DBVisualizer.
Please advise and thank you.
Mylein Blanca Uy
Condensed Matter Physics Laboratory
National Institute of Physics
University of the Philippines, Diliman
Quezon City, 1101, Philippines
Sick of deleting your inbox? Yahoo!7 Mail has free unlimited storage.
http://au.docs.yahoo.com/mail/unlimitedstorage.html
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
