Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-5456

CAPABILITY and NOTIFICATIONS table access with Empty values causes (Oracle) Deadlock in larger instances

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 2.6 M6, 2.6
    • 2.5.2
    • None
    • None

    Description

      Frequent deadlocks are reported by (Oracle) DB when accessing the capability table.
      Databases wait to actually write (flush) data until someone wants to read it.

      The hibernate session is being flushed and for some reason the capability object is marked as dirty.
      Hibernate issues an update to persist the capability. Not usually a big deal but with a large number of plans and the fact that this is invoked from an event, we could have events that try to lock competing resources.

      Attachments

        Activity

          People

            mgardias Marcin Gardias
            ukuhnhardt Ulrich Kuhnhardt [Atlassian]
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 12h
                12h
                Remaining:
                Time Spent - 0.9h Remaining Estimate - 11.1h
                11.1h
                Logged:
                Time Spent - 0.9h Remaining Estimate - 11.1h
                0.9h