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
        2. atlassian-bamboo-buildmaven2-sql-update.log.gz
          0.6 kB
        3. atlassian-bamboo-createbuildbamboo-sql.log.gz
          339 kB
        4. atlassian-bamboo-createbuildbamboo-sql-update.log.gz
          0.9 kB
        5. bamboo_audit.xls
          999 kB

            [BAM-5456] CAPABILITY and NOTIFICATIONS table access with Empty values causes (Oracle) Deadlock in larger instances

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2016 v1 - Restricted [ 1434837 ] New: JAC Bug Workflow v3 [ 3379363 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Bamboo Workflow 2016 v1 [ 1409056 ] New: Bamboo Workflow 2016 v1 - Restricted [ 1434837 ]
            Marek Went (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2014 v2 [ 610001 ] New: Bamboo Workflow 2016 v1 [ 1409056 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2014 [ 605049 ] New: Bamboo Workflow 2014 v2 [ 610001 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2010 [ 207424 ] New: Bamboo Workflow 2014 [ 605049 ]
            MarkC made changes -
            Fix Version/s New: 2.6 [ 15056 ]
            Marcin Gardias made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: To be reviewed [ 10026 ] New: Resolved [ 5 ]
            Marcin Gardias made changes -
            Remaining Estimate Original: 11h 20m [ 40800 ] New: 11.1h [ 39960 ]
            Time Spent Original: 40m [ 2400 ] New: 0.9h [ 3240 ]
            Ulrich Kuhnhardt [Atlassian] made changes -
            Summary Original: CAPABILITY table access causes (Oracle) Deadlock in larger instances New: CAPABILITY and NOTIFICATIONS table access with Empty values causes (Oracle) Deadlock in larger instances
            Marcin Gardias made changes -
            Status Original: In Progress [ 3 ] New: To be reviewed [ 10026 ]

              mgardias Marcin Gardias
              ukuhnhardt Ulrich Kuhnhardt [Atlassian]
              Affected customers:
              2 This affects my team
              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