Bamboo returns error when shippedWithBamboo has null values
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Problem
Elastic Bamboo errors are pushed to UI when null values are in shipped_with_bamboo column.
1
2
3
4
2015-11-16 16:55:06,471 INFO [localhost-startStop-1] [ElasticImageConfigurationManagerImpl] Checking if stock EC2 images need updating...
2015-11-16 16:55:06,534 INFO [localhost-startStop-1] [DefaultErrorHandler] Recording an error: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl.shippedWithBamboo; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl.shippedWithBamboo
2015-11-16 16:55:06,540 ERROR [localhost-startStop-1] [BambooContainer] Unable to update elastic configuration.
org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl.shippedWithBamboo; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.agent.elastic.server.ElasticImageConfigurationImpl.shippedWithBambooCause
The root cause of this issue is that the elastic_image table has a column {{shipped_with_bamboo}} which can only accept an integer value. If that column has a null value, Bamboo pushes the error to Bamboo UI. You can check this by running the command below:
1
SELECT name,ami_image_id,shipped_with_bamboo FROM elastic_image;Resolution
⚠️ Backup database before making any modifications
Stop Bamboo
Run:
1UPDATE elastic_image SET shipped_with_bamboo = 0 WHERE shipped_with_bamboo IS NULL;Start Bamboo
Was this helpful?