-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
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)