[
https://issues.apache.org/jira/browse/BEAM-12226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexey Romanenko reassigned BEAM-12226:
---------------------------------------
Assignee: Alexey Romanenko
> JdbcIO default retry strategy should retry on PostgreSQL deadlock
> -----------------------------------------------------------------
>
> Key: BEAM-12226
> URL: https://issues.apache.org/jira/browse/BEAM-12226
> Project: Beam
> Issue Type: Improvement
> Components: io-java-jdbc
> Affects Versions: 2.29.0
> Reporter: Sylvain Veyrié
> Assignee: Alexey Romanenko
> Priority: P2
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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|https://www.postgresql.org/docs/13/errcodes-appendix.html].
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
