You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Alexey Romanenko (Jira)" <ji...@apache.org> on 2021/04/26 15:47:01 UTC

[jira] [Commented] (BEAM-12226) JdbcIO default retry strategy should retry on PostgreSQL deadlock

    [ https://issues.apache.org/jira/browse/BEAM-12226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17332522#comment-17332522 ] 

Alexey Romanenko commented on BEAM-12226:
-----------------------------------------

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: sdk-java-core
>    Affects Versions: 2.29.0
>            Reporter: Sylvain Veyrié
>            Priority: P2
>
> 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)