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

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

      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.

        1. atlassian-bamboo-buildmaven2-sql.log.gz
          581 kB
          Krystian Brazulewicz
        2. atlassian-bamboo-buildmaven2-sql-update.log.gz
          0.6 kB
          Krystian Brazulewicz
        3. atlassian-bamboo-createbuildbamboo-sql.log.gz
          339 kB
          Krystian Brazulewicz
        4. atlassian-bamboo-createbuildbamboo-sql-update.log.gz
          0.9 kB
          Krystian Brazulewicz
        5. bamboo_audit.xls
          999 kB
          Qualcomm Support

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

                Created:
                Updated:
                Resolved:

                  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