-
Bug
-
Resolution: Fixed
-
Low
-
7.0.2
-
None
-
1
-
Severity 3 - Minor
-
Issue Summary
When Bamboo is upgraded from 6.10.x to 7.0.2 with MSSQL 2012, we get this error
ERROR [localhost-startStop-1] [AbstractUpgradeManager] com.microsoft.sqlserver.jdbc.SQLServerException: The data types ntext and varchar are incompatible in the equal to operator.
Steps to Reproduce
- Upgrade Bamboo 6.10.2 running with SQL Server 2012 to Bamboo 7.0.2
Expected Results
Upgrade happens smoothly.
Actual Results
We get the below exception when Bamboo starts.
atlassian-bamboo.log
2020-03-25 09:25:58,992 ERROR [localhost-startStop-1] [AbstractUpgradeManager] com.microsoft.sqlserver.jdbc.SQLServerException: The data types ntext and varchar are incompatible in the equal to operator. com.microsoft.sqlserver.jdbc.SQLServerException: The data types ntext and varchar are incompatible in the equal to operator. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621) ... ... at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462) at com.atlassian.bamboo.upgrade.tasks.v7_0.UpgradeTask70003ChangeECDirectoryAttributeColumnType.lambda$doUpgrade$0(UpgradeTask70003ChangeECDirectoryAttributeColumnType.java:40) at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:65) at com.atlassian.bamboo.upgrade.tasks.v7_0.UpgradeTask70003ChangeECDirectoryAttributeColumnType.doUpgrade(UpgradeTask70003ChangeECDirectoryAttributeColumnType.java:37) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:182) at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.doUpgrade(BootstrapUpgradeManagerImpl.java:76) at com.atlassian.bamboo.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:286) at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:81) at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:143) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2020-03-25 09:25:59,007 INFO [localhost-startStop-1] [AbstractUpgradeManager] Task 70003 completed successfully. 2020-03-25 09:25:59,007 FATAL [localhost-startStop-1] [DefaultBootstrapManager] Pre-bootstrap upgrade tasks failed com.atlassian.upgrade.UpgradeException: Pre-bootstrap upgrade tasks failed: [Task for build 70003 failed with exception: The data types ntext and varchar are incompatible in the equal to operator.] at com.atlassian.bamboo.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:288) at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:81) at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:143) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2020-03-25 09:25:59,007 INFO [localhost-startStop-1] [lifecycle] Bamboo home directory: E:\Bamboo 2020-03-25 09:25:59,007 INFO [localhost-startStop-1] [lifecycle] Default charset: windows-1252, file name ecoding: Cp1252 2020-03-25 09:25:59,023 INFO [localhost-startStop-1] [UpgradeLauncher] Upgrades not performed since the application has not been set up yet. 2020-03-25 09:25:59,054 INFO [localhost-startStop-1] [CompressingFilter] CompressingFilter has initialized 2020-03-25 09:26:00,101 INFO [localhost-startStop-1] [SpringObjectFactoryProxy] Deferring initialisation of com.atlassian.bamboo.plugin.xwork.SpringObjectFactoryProxy 2020-03-25 09:26:01,179 INFO [localhost-startStop-1] [Dispatchers] Dispatcher org.apache.struts2.dispatcher.Dispatcher initialised 2020-03-25 09:26:01,242 INFO [localhost-startStop-1] [SpringObjectFactoryProxy] Deferring initialisation of com.atlassian.bamboo.plugin.xwork.SpringObjectFactoryProxy 2020-03-25 09:26:02,070 INFO [localhost-startStop-1] [SpringObjectFactoryProxy] Deferring initialisation of com.atlassian.bamboo.plugin.xwork.SpringObjectFactoryProxy 2020-03-25 09:26:02,195 INFO [localhost-startStop-1] [Dispatchers] Dispatcher org.apache.struts2.dispatcher.Dispatcher initialised 2020-03-25 09:26:02,257 INFO [localhost-startStop-1] [SpringObjectFactoryProxy] Deferring initialisation of com.atlassian.bamboo.plugin.xwork.SpringObjectFactoryProxy
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- mentioned in
-
Page Loading...