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

[vhypnus]

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

[GuyPardon]

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

[vhypnus]

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]

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

[GuyPardon]

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