Bamboo fails to start when using MySQL after upgrading with AbstractMethodError

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

After restoring Bamboo from a backup or database dump, Bamboo will fail to start and the following appears in the <bamboo-install>/logs/localhost.*.log

10-Mar-2017 15:40:28.606 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class com.atlassian.bamboo.setup.BootstrapLoaderListener
 java.lang.AbstractMethodError: com.mysql.jdbc.JDBC4Connection.getSchema()Ljava/lang/String;
	at com.mchange.v2.c3p0.impl.NewProxyConnection.getSchema(NewProxyConnection.java:1642)
	at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:396)
	at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchema(AbstractDbmsBean.java:387)
	at com.atlassian.bamboo.utils.db.AbstractDbmsBean.isTablePresent(AbstractDbmsBean.java:230)
	at com.atlassian.bamboo.upgrade.tasks.v5_15.UpgradeTask51502UniqueSharedCredentialNames.lambda$doUpgrade$0(UpgradeTask51502UniqueSharedCredentialNames.java:37)
...

Or the following in <bamboo-install>/logs/catalina.out:

2017-06-18 08:00:52,372 ERROR [16-UpgradeTaskBackgroundThread:pool-31-thread-1] [SqlExceptionHelper] Not supported
2017-06-18 08:00:52,376 ERROR [16-UpgradeTaskBackgroundThread:pool-31-thread-1] [AbstractUpgradeManager] org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; error executing work; nested exception is org.hibernate.exception.GenericJDBCException: error executing work
org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; error executing work; nested exception is org.hibernate.exception.GenericJDBCException: error executing work
at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:171)
..
Caused by: java.sql.SQLFeatureNotSupportedException: Not supported
at com.mysql.jdbc.JDBC4Connection.getSchema(JDBC4Connection.java:258)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getSchema(NewProxyConnection.java:1642)
at com.atlassian.bamboo.utils.db.AbstractDbmsBean.getSchemaUncached(AbstractDbmsBean.java:395)

 

The following is also present in <bamboo-install>/logs>/catalina.out however this is a generic message that suggests that the error detail is in the above container log.

10-Mar-2017 15:40:28.621 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
10-Mar-2017 15:40:28.638 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors

Cause

An incompatibility with newer C3P0 libraries and the version of the MySQL JDBC driver that was downloaded for use with Bamboo.

Resolution

Download a more recent version of the MySQL JDBC driver:  https://dev.mysql.com/downloads/connector/j/

At the time of writing this issue presented on Bamboo 5.15.3 with MySQL Java connector 5.1.20 and can be resolved by updating it to 5.1.41. For more information on how to install the MySQL JDBC driver for use with Bamboo please refer to the following documentation: Connect Bamboo to a MySQL database

Last modified on Jul 21, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.