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/27 14:55:00 UTC

[jira] [Assigned] (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: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)