Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-12226

JdbcIO default retry strategy should retry on PostgreSQL deadlock

Details

    • Improvement
    • Status: Resolved
    • P2
    • Resolution: Fixed
    • 2.29.0
    • 2.30.0
    • io-java-jdbc
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              aromanenko Alexey Romanenko
              sveyrie Sylvain VeyriƩ
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h