search

atomikos / transactions-essentials

Development repository for next major release of
https://www.atomikos.com/Main/TransactionsEssentials
Other
462 stars 139 forks source link

open transactions increasing size of tmlog #99

Open wmh1108-sas opened 4 years ago

wmh1108-sas commented 4 years ago

We are seeing the size of the tmlogXX.log file constantly growing, sometimes to several gigabytes in size. Eventually, Atomikos winds up bogging down our entire system when it tries to write to this file, due to its size.

Checkpoints are happening because we the tmlog filename is updating but the file size continues to grow. Our application logs aren't indicating any incomplete transactions in ActiveMQ/Postgres so I was wondering if there is a way we could crack open this tmlog file to see which transactions are still pending. Is this possible? Is there a better way to debug this problem?

GuyPardon commented 4 years ago

What version are you using?

wmh1108-sas commented 4 years ago

Our atomikos-utils lib is at version 3.8.

GuyPardon commented 4 years ago

For the 3.8 there is not much we can do: it went out of support a long time ago. If you want to try with a more recent release then we can offer a free trial which includes our log utility to inspect pending contents of the log.

But upgrading would require you to start with a clean logfile. If you are sure there is nothing pending in the resources than you can try that.

What do you think?

wmh1108-sas commented 4 years ago

Thank you, we can give the free trial a shot (although I'm not sure that we're able to simply drop in the new jar without making changes to the surrounding codebase). What are the next steps?

GuyPardon commented 4 years ago

Thanks - you can apply and schedule on-boarding with us here:

https://www.atomikos.com/Main/ExtremeTransactionsFreeTrial