Sonar

Database Locks when two projects are built simultaneously

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.5
  • Fix Version/s: 2.14
  • Component/s: Database, DB Cleaner
  • Labels:
    None
  • Environment:
    Sonar triggered from Hudson builds, running on Linux server
  • Number of attachments :
    2

Description

Since version 2.5 of Sonar, in our Hudson/Sonar continuous integration build environment the following problem occurs:

When two or more builds are created simultaneously and also the Sonar parts of the builds are running in parallel, then these builds regularly lock each other.

For example, if we have a large project being built, which takes a long time, before all the Sonar checks are finished, and we then start the build of a small project, then this build will block in the PurgeDependencies step of the Sonar run, until it gets a timeout or the large build is killed.

See the attached log excerpts for details. A heap dump was triggered for the large project build to be able to see, which threads are locked.

  1. Text File
    large_project_log.txt
    11/Feb/11 8:44 AM
    17 kB
    Christian Loroff
  2. Text File
    small_project_log.txt
    11/Feb/11 8:44 AM
    10 kB
    Christian Loroff

Issue Links

depends upon

New Feature - A new feature of the product, which has yet to be developed. SONAR-2757 Refactor the purge mechanisms to prevent any fullscan SQL requests on snapshots table

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
is depended upon by

Improvement - An improvement or enhancement to an existing feature or task. SONAR-2961 Fail silently when deadlock happens during a purge

  • Critical - Crashes, loss of data, severe memory leak.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
is related to

New Feature - A new feature of the product, which has yet to be developed. SONAR-3043 Do not purge snapshots systematically

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Freddy Mallet made changes -
Field Original Value New Value
Assignee Olivier Gaudin [ ogaudin ]
Olivier Gaudin made changes -
Priority Critical [ 2 ] Major [ 3 ]
Olivier Gaudin made changes -
Status Open [ 1 ] Closed [ 6 ]
Resolution Cannot Reproduce [ 5 ]
Christian Loroff made changes -
Resolution Cannot Reproduce [ 5 ]
Status Closed [ 6 ] Reopened [ 4 ]
Olivier Gaudin made changes -
Link This issue is depended upon by SONAR-2961 [ SONAR-2961 ]
Freddy Mallet made changes -
Link This issue is related to SONAR-3043 [ SONAR-3043 ]
Olivier Gaudin made changes -
Fix Version/s 2.14 [ 18034 ]
Olivier Gaudin made changes -
Assignee Olivier Gaudin [ ogaudin ] Simon Brandhof [ simon.brandhof ]
Simon Brandhof made changes -
Link This issue depends upon SONAR-2757 [ SONAR-2757 ]
Freddy Mallet made changes -
Status Reopened [ 4 ] Closed [ 6 ]
Resolution Fixed [ 1 ]

People

  • Assignee:
    Simon Brandhof
    Reporter:
    Christian Loroff
Vote (10)
Watch (9)

Dates

  • Created:
    Updated:
    Resolved: