Hi Mylein,
Is it possible that you have incompatible or missing PostgreSQL
drivers on your controllers? Group communications serializes types to
move them across the wire; in this case it looks as if
deserialization of an object failed because the class was not available.
Thanks, Robert
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
On Oct 22, 2007, at 6:21 PM, Mylein wrote:
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.getSQLExc
eption(SQLExceptionFactory.java:88)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTask
Completion(RAIDb1.java:939)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWrite
Request(RAIDb1.java:343)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statement
ExecuteUpdate(RAIDb1.java:249)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBa
lanceStatementExecuteUpdate(RequestManager.java:925)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.Distributed
StatementExecuteUpdate.executeScheduledRequest
(DistributedStatementExecuteUpdate.java:87)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.Distributed
Request.handleMessageMultiThreaded(DistributedRequest.java:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDa
tabase.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. Get it now.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
