Error starting Stash after upgrading from Ubuntu 15.10 to Ubuntu 16.4

[Mark_Burke]

Hi,

I am getting the following error after upgrading Ubuntu from 15.10 to 16.4.

Any help you can provide would be great.

Thanks,

Mark

A fatal error has occurred

The following problem occurred which prevents Atlassian Stash from starting correctly:

• The database, as currently configured, is not accessible.

[Mark_Burke]

I think I may have found the problem...

https://confluence.atlassian.com/confkb/confluence-fails-to-start-with-error-unknown-system-variable-storage_engine-using-mysql-5-7-x-789090576.html

Apparently updating to Ubuntu 16.04 updated the version of MySQL Server to 5.7.12

---

Server version: 5.7.12-0ubuntu1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[Mark_Burke]

I found some logging under the application-data/log directory. Could this be something to do with the mysql JDBC driver I am using - mysql-connector-java-5.1.35-bin.jar???

Thanks,

Mark

--

2016-06-16 20:49:18,025 INFO  [spring-startup]  c.a.s.i.server.BuildInfoLogger Starting Stash 3.8.0 (5674caa built on Tue Mar 31 02:25:41 IST 2015)
2016-06-16 20:49:18,030 INFO  [spring-startup]  c.a.s.i.server.BuildInfoLogger JVM: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_40-b25
2016-06-16 20:49:18,043 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /var/local/Stash/application-data
2016-06-16 20:49:20,383 ERROR [spring-startup]  c.j.b.hooks.AbstractConnectionHook Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: null
2016-06-16 20:49:20,397 WARN  [spring-startup]  o.s.w.c.s.XmlWebApplicationContext Exception encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'crowdUserDao' defined in class path resource [crowd-spi-context.xml]: Unsatisfied dependency expressed through constructor argument with index 1 of type [com.atlassian.stash.internal.project.ProjectDao]: : Error creating bean with name 'projectDao' defined in URL [jar:file:/usr/local/Stash/3.8.0/atlassian-stash/WEB-INF/lib/stash-dao-impl-3.8.0.jar!/com/atlassian/stash/internal/project/HibernateProjectDao.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [org.hibernate.SessionFactory]: : Error creating bean with name 'sharedHomeLockAcquirer' defined in class path resource [stash-context.xml]: Cannot resolve reference to bean 'licenseHelper' while setting constructor argument; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'licenseHelper' defined in URL [jar:file:/usr/local/Stash/3.8.0/atlassian-stash/WEB-INF/lib/stash-service-impl-3.8.0.jar!/com/atlassian/stash/internal/license/DefaultLicenseHelper.class]: Unsatisfied dependency expressed through constructor argument with index 2 of type [com.atlassian.stash.internal.server.ApplicationPropertyDao]: : Error creating bean with name 'databaseSupplier': Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/stash?characterEncoding=utf8&useUnicode=true&sessionVariables=storage_engine%3DInnoDB, username = root. Terminating connection pool. Original Exception: ------^M
java.sql.SQLException: Unknown system variable 'storage_engine'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1618)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)
        at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5070)
        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3246)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2283)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:254)
        at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305)
        at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:150)
        at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:112)
        at com.atlassian.stash.internal.hibernate.DelegatingSwappableDataSource.getConnection(DelegatingSwappableDataSource.java:48)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        at com.atlassian.stash.internal.db.DefaultDatabaseSupplier.databaseFor(DefaultDatabaseSupplier.java:189)
        at com.atlassian.stash.internal.db.DefaultDatabaseSupplier.detailsFor(DefaultDatabaseSupplier.java:211)
        at com.atlassian.stash.internal.db.DefaultDatabaseSupplier.access$000(DefaultDatabaseSupplier.java:51)
        at com.atlassian.stash.internal.db.DefaultDatabaseSupplier$1.create(DefaultDatabaseSupplier.java:88)
        at com.atlassian.stash.internal.db.DefaultDatabaseSupplier$1.create(DefaultDatabaseSupplier.java:84)
        at com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:182)