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

            [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 ]
            Permalink
            Marcin Gardias logged work - 21/Apr/2010 10:00 AM
            • Time Spent:
              14m
               
              <No comment>

            Ulrich Kuhnhardt [Atlassian] added a comment - - edited

            in https://support.atlassian.com/browse/BSP-2836 non-existing Notification Recipients are stored as StringUtils.EMPTY in the NOTIFICATIONS table.

             public String getRecipient()
    {
        return recipient == null ? StringUtils.EMPTY : recipient;
    }

            Ulrich Kuhnhardt [Atlassian] added a comment - - edited in https://support.atlassian.com/browse/BSP-2836 non-existing Notification Recipients are stored as StringUtils.EMPTY in the NOTIFICATIONS table. public String getRecipient() { return recipient == null ? StringUtils.EMPTY : recipient; }

              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