Repeated Transaction Timeouts
benwalstrum Apr 23, 2004 10:41 AMHi everyone!
I am recieving a bunch of messages like the following in my server.log:
2004-04-22 14:04:05,437 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208545, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:06,765 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208549, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:07,125 WARN [org.jboss.tm.TransactionImpl] Lock contention, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208549, BranchQual=] 2004-04-22 14:04:08,296 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208553, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:09,156 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208557, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:10,609 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208561, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:11,593 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208565, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:12,234 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208569, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:12,515 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208573, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:16,781 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208577, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:19,750 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208581, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:20,093 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208585, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:23,140 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208589, BranchQual=] timed out. status=STATUS_ACTIVE 2004-04-22 14:04:23,390 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=40125dial//208593, BranchQual=] timed out. status=STATUS_ACTIVE
Our client is using JBoss 3.2.1 on Windows 2000.
What is not shown in the log snippet above is that the server was running just fine immediately preceding these statements. These errors occur fairly repetitively for the next hour and all major processing seems to have stopped. The end users reported that they were no longer able to use the system.
I have looked through the forums and haven't seen anything to really explain this situation. A lot of the posts that I have seen seem to relate this to an OutOfMemoryException, though I have not seen one in my logs. It seems that this comes very much out of the blue.
A lot of responses to posts of this nature always say that the transactions are timing out because they are running to long. I'm not going to say that is not happening, but the problem I see is that the same type of code execution had been happening for hours on end before these exceptions occured.
So here are some general questions I have about the situation, with any help greatly appreciated:
-Is there anything in 3.2.3/3.2.4 that would help with this situation?
-Does increasing memory help?
-Would this be most likely caused by a problem in my database driver (I'm using Firebird/Jaybird JCA)?
-Are there any configuration tweaks that can be done in order to tweak JBoss so that these errors are less likely to occur
Thank you in advance for your responses.
Regards,
Ben