Uploaded image for project: 'Sentry (Retired)'
  1. Sentry (Retired)
  2. SENTRY-1534

Oracle supports serializable instead of repeatable-read

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.8.0, 2.0.0
    • 1.8.0, 2.0.0
    • Sentry
    • None

    Description

      The fix for SENTRY-1486 changed the default transaction isolation level from read-committed to repeatable-read. Unfortunately Oracle doesn't support it and Datanucleus doesn't handle this properly (it thinks that it is supported). For Oracle the consistency level should be set to "serializable" With the current setting (repeatable-read") Sentry doesn't work with Oracle.

      Attachments

        1. SENTRY-1534.003.patch
          5 kB
          Alex Kolbasov
        2. SENTRY-1534.001-sentry-ha-redesign.patch
          4 kB
          Hao Hao

        Issue Links

          is broken by

          Bug - A problem which impairs or prevents the functions of the product. SENTRY-1486 Sentry should use repeatable-read consistency level

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link Code Review

          Web Link Data Concurrency and Consistency

          Web Link Oracle Documentation

          Activity

            People

              akolb Alex Kolbasov
              akolb Alex Kolbasov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: