Hi Jim,
Sorry for the late reply.
I am using the appia configuration for group communications. I was
having issues with jgroups when I starting really loading the system
with alot of transactions.
Do you have a significant number of writes or manipulating large amount
of data in inserts (like large objects) ?
As I am not a java developer, my knowledge comes from repeated trial
and error. Because my developers cannot reproduce this problem in
their development environment when they go straight to
a postgres data server instead via sequoia, I am left to my own
devices to find a working solution if I am to get to keep my sequoia
configuration for our new production system. I am willing to try
anything to get past this problem. I have DEBUG turned on
everywhere... I have my virtualdatabase configuration set to 30
seconds idle timeout and 10 seconds wait.
Setting to DEBUG mode will significantly slowdown the controller and add
latency to every single query. This might increase lock contention and
induce deadlocks that would not be seen otherwise when accessing
directly the database where lock contention would be much less important.
You should also check in the log if you don't see any warning message
about table names that are not found in the schema. That could lead to
locking conflicts.
Stored procedures could also introduce artificial deadlocks. Do you use any?
I would appreciate any suggestions you could send my way for how to
proceed.
If would be helpful to dump all controller queues the next time you get
a deadlock. You should be able to get a snapshot of running queries and
transactions. We could match the ids with what is in your debug log to
see if anything wrong happened with any of these queries or transactions.
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
