search

atomikos / transactions-essentials

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

A simple select sql with 【The transaction has timed out】 Exception? I do not find the reason. #194

Open vhypnus opened 10 months ago

vhypnus commented 10 months ago

Error querying database. Cause: com.atomikos.jdbc.internal.AtomikosSQLException: The transaction has timed out - try increasing the timeout if needed The error may exist in class path resource [mappers/xxxxx] The error may involve com.admin.cs.infrastructure.mapper.thailand.ThailandSettleControlMapper.selectCanSettleRecord The error occurred while executing a query

for exception source

image

GuyPardon commented 10 months ago

Try the following:

Let me know...

Best

vhypnus commented 10 months ago

Try the following:

  • use release 6.0
  • increase the timeout a lot
  • if it still happens then you may be facing network issues

Let me know...

Best

thank you. online , transaction time out 60 seconds , when case happen ,not found other slow sql or other transaction time out issue.

vhypnus commented 10 months ago

Try the following:

  • use release 6.0
  • increase the timeout a lot
  • if it still happens then you may be facing network issues

Let me know...

Best

i find source code ,exception code below

image

GuyPardon commented 10 months ago

Could be a deadlock if you have 2 or more SQL statements in each transaction...