I made some tweaks to MySql and tomcat and the system stayed up for 7 days until yesterday - Monday. Then the usual lock-up. Users who were in stayed working. Others couldn't log in.
This from the jBoss Log
02:11:03,385 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=S15247674//63588, BranchQual=] timed out. status=STATUS_ACTIVE
02:11:32,075 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=xxremovedxx//63589, BranchQual=] timed out. status=STATUS_ACTIVE
02:06:41,448 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=xxremovedxx///156157, BranchQual=] timed out. status=STATUS_ACTIVE
02:06:48,917 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=xxremovedxx///156158, BranchQual=] timed out. status=STATUS_ACTIVE
02:07:16,028 WARN [TransactionImpl] Lock contention, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=xxremovedxx///156157, BranchQual=]
Note [xxremovedxx] is simply me replacing my server identity
Found this post - but not being a jBoss man - need some explanation please
http://community.jboss.org/message/111660#111660