Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-3826

transcation lock time out when creating large review

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Low
    • None
    • 2.3.3
    • None
    • None
    • mysql Ver 14.14 Distrib 5.1.37

    Description

      Crucible's produce too many lock timeout exceptions. This will predominatly occur while someone is creating a very large review

      i found that when i creating a very larg review , it would tell me that transcation lock time out ,and the review can't submit.

      i tried to change the transcation level , i excute "set global transaction isolation level SERIALIZABLE;"

      but i found something in general log

      5905 Query SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE
      ]]]]]100723 17:12:20 5905 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

      the application would set the transcation level by itself ...

      who can tell me how to avoid this error

      however , some guys told me this bug had fixed

      http://jira.atlassian.com/browse/CRUC-3143

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              3fc249931b24 whitepoplar
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: