Bamboo fails to start when using MySQL after upgrading with AbstractMethodError
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 errorsCause
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