Bamboo 3.1.4 upgrade results in issues with system.path variable

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 3.2 final, 3.2
    • Affects Version/s: 3.1.4
    • Component/s: Database (Postgresql)
    • None
    • Environment:

      Windows Server 2003

      Upgrade to Bamboo 3.1.4 resulted in any build plans using system.path variable in their build plans on windows build agents, to fail to complete with the error below. This error resulted in the build being 'cancelled' as it could not update the build status. The 'jobs' went through OK .. but the builds were never completing.

      I have confirmed that the system.variable had not changed at all in length or usage from before the upgrade. I have found a workaround to this issue so that my builds can actually complete, by using the %path% instead as that does not get inserted into the database,
      This may be related to the fix for BAM-9067. It looks as though this system.path is being inserted into the database now, and the string is too long.

      Could not save the build results. Data could be in an inconsistent state.
      (org.springframework.dao.DataIntegrityViolationException : Hibernate operation: Could not execute JDBC batch update; SQL []; Batch entry 3 insert into VARIABLE_SUBSTITUTION (VARIABLE_KEY, VARIABLE_VALUE, VARIABLE_TYPE, BUILDRESULTSUMMARY_ID, VARIABLE_SUBSTITUTION_ID) values ('Path', E'C:\\Perl\\site\\bin;C:\\Perl\\bin;C:
      Program Files\\HP\\NCU;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\svn-win32-1.6.6\\bin;C:
      Program Files\\HP
      HP BTO Software\\bin;C:
      Program Files\\HP
      HP BTO Software\\bin\\OpC;C:
      Program Files
      Microsoft SQL Server\\100\\Tools\\Binn\\;C:
      Program Files
      Microsoft SQL Server\\100\\DTS\\Binn\\;C:\\utils;C:\\diab\\5.3.0.0\\WIN32\\bin;C:
      Program Files
      Windows Imaging\\;c:\\diab\\5.3.0.0\\WIN32\\bin;c:
      utils', 'SYSTEM', '68847703', '69044156') was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 3 insert into VARIABLE_SUBSTITUTION (VARIABLE_KEY, VARIABLE_VALUE, VARIABLE_TYPE, BUILDRESULTSUMMARY_ID, VARIABLE_SUBSTITUTION_ID) values ('Path', E'C:\\Perl\\site\\bin;C:\\Perl\\bin;C:
      Program Files\\HP\\NCU;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\svn-win32-1.6.6\\bin;C:
      Program Files\\HP
      HP BTO Software\\bin;C:
      Program Files\\HP
      HP BTO Software\\bin\\OpC;C:
      Program Files
      Microsoft SQL Server\\100\\Tools\\Binn\\;C:
      Program Files
      Microsoft SQL Server\\100\\DTS\\Binn\\;C:\\utils;C:\\diab\\5.3.0.0\\WIN32\\bin;C:
      Program Files
      Windows Imaging\\;c:\\diab\\5.3.0.0\\WIN32\\bin;c:
      utils', 'SYSTEM', '68847703', '69044156') was aborted. Call getNextException to see the cause.)
      (13 Jul 2011, 9:10:44 AM)

            Assignee:
            Marcin Gardias
            Reporter:
            Heather McKinnon
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: