Bamboo upgrade fails with "Unsupported version of PostgreSQL"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
While attempting to upgrade Bamboo to a newer version, the upgrade fails, and an error message similar to the one below can be seen in the <bamboo-home>/logs/atlassian-bamboo.log file:
Unsupported version of PostgreSQL: [PostgreSQL] 9.5.0 (9.5.24)Environment
All supported versions of Bamboo, connected to a PostgreSQL database.
Diagnosis
The following error can be seen in the <bamboo-home>/logs/atlassian-bamboo.log file. Please note that the PostgreSQL version mentioned in the error might be different on your case.
13-Jul-2022 18:50:24.419 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
13-Jul-2022 18:50:29.119 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext
13-Jul-2022 18:50:32.532 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [com.atlassian.bamboo.ww2.actions.setup.BambooContextLoaderListener]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reloadableBeanFactories' defined in class path resource [applicationContextPlugin.xml]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creati$
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'hibernateConfig' threw exception; nested exception is java.lang.IllegalStateException: Unsupported version of PostgreSQL: [PostgreSQL] 9.5.0 (9.5.24)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:537\)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335\)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234\)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333\)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213\)
[...]
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.config.internalTransactionAdvisor': Cannot resolve reference to bean 'org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0' while setting bean property 'transac$Cause
This happens when the Bamboo version you're upgrading to doesn't support the PostgreSQL database version you're using.
Solution
Upgrade your PostgreSQL database to a version supported by the Bamboo version you're upgrading to:
- Check the Supported Platforms documentation for the version you're upgrading to. There's a drop-down menu so you can select the versions.
- Head to the Databases section and check the PostgreSQL versions supported by Bamboo. For example:
Upgrade your PostgreSQL database to one of the versions that's supported by your new Bamboo version. Upgrade guides can be found in PostgreSQL's official documentation.
Please make sure to back up your database prior to following any of the steps from the article.
Once the data has been migrated to the newer version, Bamboo needs to be told to look into the upgraded database. Steps for that are available in this article.
Backup and edit the <Bamboo-Home>/bamboo.cfg.xml file, changing the following properties to reflect the new database:Database URL:
<property name="hibernate.connection.url">DATABASE_URL</property>Username & password for database access:
<property name="hibernate.connection.password">YOUR_PASSWORD</property> <property name="hibernate.connection.username">YOUR_USERNAME</property>
- You can then start Bamboo and proceed with the upgrade.