Uploaded image for project: 'AUT (Public Tracker) - Automation for JIRA'
  1. AUT-1166

MySQL default transaction level for Automation for Jira queries is wrong

    Details

    • Links:
      1

      Description

      MySQL by default uses REPEATABLE READ as it's transaction isolation level. Every other DB uses READ COMMITTED.

      We falsely assumed that Jira's DBConnectionManager we use was setting this transaction level, but it turns out this is not the case.

      This can lead to MySQLTransactionRollbackException exceptions due to deadlocks in mysql.

        Attachments

          Activity

            People

            • Assignee:
              admin Andreas Knecht
              Reporter:
              admin Andreas Knecht
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: