[CONJ-746] Add option to retry previous transaction when a deadlock is encountered Created: 2019-11-21  Updated: 2023-12-04  Resolved: 2023-12-04

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: 2.4.4
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Diego Dupin
Resolution: Won't Do Votes: 0
Labels: None


 Description   

When MariaDB encounters a deadlock, the suggestion in the error message is to retry the transaction:

ERROR 1213 (40001): Deadlock found when trying to get lock;
try restarting transaction

It might be useful if MariaDB Connector/J could automatically retry a transaction if the server sends a deadlock error when it attempts to commit the transaction.

There should probably be a limit on the number of retries, so that infinite retry loops can't occur.


Generated at Thu Feb 08 03:18:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.