[
https://issues.apache.org/jira/browse/BEAM-12226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17332522#comment-17332522
]
Alexey Romanenko edited comment on BEAM-12226 at 4/27/21, 2:53 PM:
-------------------------------------------------------------------
Would it work for other RDBMS as well?
PRs are always welcome!
was (Author: aromanenko):
Would it work for other RDMS as well?
PRs are always wlecome!
> 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é
> 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)
