Hello,
first: I´m new to sequoia.
I just installed version 2.10.3 and 3.0beta2 (with PostgreSQL 8.1), but with
both versions I ran into a deadlock after a few statements (heavy-load, about
20 concurrent threads with transactions, but only simple selects, inserts and
updates). Without sequoia (normal jdbc) the application runs for weeks on the
same system and database without any problems.
Are there any known issues?
I configurad sequoia in RAIDb-1 mode, with only one controller and one database.
--- log (from v2.10.3) ---
2007-01-11 18:05:39,846 INFO sequoia.controller.loadbalancer Deadlock detected
on backend localhost1, aborting transaction 1716
2007-01-11 18:05:39,878 ERROR controller.loadbalancer.RAIDb1 write request 4348
failed:
Backend testdb - BackendWorkerThread for backend 'localhost1' with RAIDb
level:1 failed (Transaction aborted due to deadlock)
2007-01-11 18:05:39,893 WARN controller.RequestManager.testdb SQLException
while executing distributed write request write request 4348 failed:
Backend testdb - BackendWorkerThread for backend 'localhost1' with RAIDb
level:1 failed (Transaction aborted due to deadlock)
java.sql.SQLException: write request 4348 failed:
Backend testdb - BackendWorkerThread for backend 'localhost1' with RAIDb
level:1 failed (Transaction aborted due to deadlock)
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)
2007-01-11 18:05:39,924 WARN controller.RequestManager.testdb Request 4348
failed on controller Member(address=/192.168.0.123:4392, uid=testdb)
(java.sql.SQLException: write request 4348 failed:
Backend testdb - BackendWorkerThread for backend 'localhost1' with RAIDb
level:1 failed (Transaction aborted due to deadlock)
)
------
Thank you
Marc
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
