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

Upgrade task 1831 will fail for every instance using a Case-Sensitive DB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 2.7 beta2, 2.7
    • None
    • Database (MS SQL)
    • None

    • Problem observerd in a MS SQL instance using Latin1_General_BIN Colation

      Upgrade task 1831 will fail for every instance using a Case-Sensitive.

      INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] -----------------------------------------------------------------------------------
INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] Running upgrade task 1831 : Setting null build_completed_date fields to build_date.
INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] -----------------------------------------------------------------------------------
INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 INFO [WrapperSimpleAppMain] [UpgradeTask1831FixNullBuildCompleted] Unable to determine whether to run: Setting null build_completed_date fields to build_date.
INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 INFO [WrapperSimpleAppMain] [AbstractStatementUpgradeTask] Executing SQL: update BUILDRESULTSUMMARY set build_completed_date = build_date where build_completed_date is null
INFO   | jvm 1    | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 ERROR [WrapperSimpleAppMain] [AbstractStatementUpgradeTask] Unable to run update BUILDRESULTSUMMARY set build_completed_date = build_date where build_completed_date is null : Invalid column name 'build_completed_date'.
INFO   | jvm 1    | 2010/10/13 02:40:08 | java.sql.SQLException: Invalid column name 'build_completed_date'.
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
INFO   | jvm 1    | 2010/10/13 02:40:08 | 	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

      Immediate Workaround
      1. Run the upgrade steps and allow Bamboo to execute until the problem with Task 1831 happen.
      2. Shutdown Bamboo.
      3. Open file <Bamboo-Home>/bamboo.cfg.xml and change the buildNumber to 1831. Then, restart the new Bamboo instance.

            [BAM-7057] Upgrade task 1831 will fail for every instance using a Case-Sensitive DB

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2016 v1 - Restricted [ 1435934 ] New: JAC Bug Workflow v3 [ 3379659 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Bamboo Workflow 2016 v1 [ 1408717 ] New: Bamboo Workflow 2016 v1 - Restricted [ 1435934 ]
            Marek Went (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2014 v2 [ 609406 ] New: Bamboo Workflow 2016 v1 [ 1408717 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2014 [ 601445 ] New: Bamboo Workflow 2014 v2 [ 609406 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2010 [ 235484 ] New: Bamboo Workflow 2014 [ 601445 ]
            Krystian Brazulewicz made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: To be reviewed [ 10026 ] New: Resolved [ 5 ]
            Krystian Brazulewicz made changes -
            Status Original: In Progress [ 3 ] New: To be reviewed [ 10026 ]
            Krystian Brazulewicz made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Krystian Brazulewicz made changes -
            Assignee New: Krystian Brazulewicz [ kbrazulewicz ]
            MarkC made changes -
            Internal Priority New: 1. Highest

              kbrazulewicz Krystian Brazulewicz
              rbattaglin Renan Battaglin
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: