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

Bamboo import using a non-trivial export file is very slow when the external database type is MS SQL Server

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 6.3.1
    • Database (MS SQL)
    • None

      Summary

      When using the import feature of Bamboo with a non-trivial export file (many changesets, relevant changesets and test results) the import process is very slow if the database type used is MS SQL Server.

      Environment

      Bamboo 6.3.1
      Database MS SQL server with the Microsoft driver

      Steps to Reproduce

      1. Install a fresh Bamboo 6.3.1 instance with MS SQL server.
      2. During the installation import an exported file that has many changesets (in the order of 100000),
        relevant changesets (in the order of 100000), commits (in the order of 100000), and test results (in the order of millions)

      Expected Results

      The import completes in a reasonable time (in the order of tens of minutes).
      By comparison when using Postgres 9.4 as the external database type the import of the same export file completes in ~45 min.

      Actual Results

      The import takes an unreasonable amount of time to complete (more than 13 days).

      Notes

      Using a different database connector such as JTDS does not change the behavior.

      Workaround

      There is no known workaround.

          Form Name

            [BAM-19726] Bamboo import using a non-trivial export file is very slow when the external database type is MS SQL Server

              Unassigned Unassigned
              abacs Andrei
              Affected customers:
              6 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated: