Hi Gérard,
I'm currently facing a problem with lock on database.
I do intensive read/write queries and the log report may Lock timeout:
Backend MATISSEDB - BackendWorkerThread for backend 'sd02' with RAIDb
level:1 failed (Lock wait timeout exceeded; try restarting transaction)
This error is reported by MySQL when you have a deadlock.
So that nothing is writen in database.
When doing the same test without sequoia, directly querying MySQL
(5.0.37 under Linux RHEL 4, Connector/J 5.0.5)
I have no problem.
With Sequoia writes are executing more slowly, so you would probably
need a much higher load to find the same deadlock.
So should there be a configuration problem ? I've attached the VDB
configuration
No, this is a problem in your application that you see earlier on with
Sequoia because writes are much slower.
Hope this helps,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
