[BEAM-12226] JdbcIO default retry strategy should retry on PostgreSQL deadlock

• Type: Improvement
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Affects Version/s: 2.29.0
• Fix Version/s: 2.30.0
• Component/s: io-java-jdbc
• Assignee: Alexey Romanenko
• Reporter: Sylvain Veyrié
• Created: 26/Apr/21 15:29
• Updated: 27/Apr/21 14:54
• Resolved: 27/Apr/21 14:54

Description

The DefaultRetryStrategy on JdbcIO retries if the error code is 40001 (deadlock detected).

For some reason PostgreSQL uses code 40P01 instead (40001 being serialization_failure). see PostgreSQL documentation.

It would be great if the DefaultRetryStrategy would return true ("please retry") with this specific additional code.

(tested with 2.28.0 and 2.29.0 master)

I can provide a PR.

Issue Links

• links to: GitHub Pull Request #14646