Atlassian Stash v3.8.0 upgrade failed - The database schema could not be updated.

[Pankaj Gupta]

After upgrading  Atlassian Stash v3.8.0 to Bitbucket v-5.14.0 no longer loading & showing below error -

+++++++++++++++++++++++

A fatal error has occurred

The following problem occurred, which prevents Atlassian Bitbucket from starting:

• The database schema could not be updated. Details about the change that failed can be found in the logs.
  
  It may be necessary to create a ticket to resolve the error. When creating a ticket, please include the exception details from the logs, as well as the database type.

++++++++++++++++++++

Bitbucket error log-

++++++++++++++++++++

2018-09-26 13:22:08,993 ERROR [spring-startup] c.a.j.s.w.s.JohnsonDispatcherServlet SpringMVC dispatcher [springMvc] could not be started
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'crowdAliasDao': Unsatisfied dependency expressed through method 'setSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r3_9/upgrade.xml::STASH-7119-1::jpalacios:
Reason: liquibase.exception.DatabaseException: Table 'sta_deleted_group' already exists [Failed SQL: CREATE TABLE bitbucket.sta_deleted_group (id BIGINT NOT NULL, name VARCHAR(255) NOT NULL COMMENT 'group name', deleted_timestamp DATETIME NOT NULL COMMENT 'deleted date', CONSTRAINT pk_sta_deleted_group PRIMARY KEY (id), CONSTRAINT uq_sta_deleted_group_name UNIQUE (name))]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:667)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at java.lang.Thread.run(Thread.java:748)
... 18 frames trimmed
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r3_9/upgrade.xml::STASH-7119-1::jpalacios:
Reason: liquibase.exception.DatabaseException: Table 'sta_deleted_group' already exists [Failed SQL: CREATE TABLE bitbucket.sta_deleted_group (id BIGINT NOT NULL, name VARCHAR(255) NOT NULL COMMENT 'group name', deleted_timestamp DATETIME NOT NULL COMMENT 'deleted date', CONSTRAINT pk_sta_deleted_group PRIMARY KEY (id), CONSTRAINT uq_sta_deleted_group_name UNIQUE (name))]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1630)
... 5 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r3_9/upgrade.xml::STASH-7119-1::jpalacios:
Reason: liquibase.exception.DatabaseException: Table 'sta_deleted_group' already exists [Failed SQL: CREATE TABLE bitbucket.sta_deleted_group (id BIGINT NOT NULL, name VARCHAR(255) NOT NULL COMMENT 'group name', deleted_timestamp DATETIME NOT NULL COMMENT 'deleted date', CONSTRAINT pk_sta_deleted_group PRIMARY KEY (id), CONSTRAINT uq_sta_deleted_group_name UNIQUE (name))]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
at liquibase.Liquibase.update(Liquibase.java:202)
at liquibase.Liquibase.update(Liquibase.java:179)
at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:317)
at liquibase.database.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:32)
... 5 common frames omitted
Caused by: liquibase.exception.DatabaseException: Table 'sta_deleted_group' already exists [Failed SQL: CREATE TABLE bitbucket.sta_deleted_group (id BIGINT NOT NULL, name VARCHAR(255) NOT NULL COMMENT 'group name', deleted_timestamp DATETIME NOT NULL COMMENT 'deleted date', CONSTRAINT pk_sta_deleted_group PRIMARY KEY (id), CONSTRAINT uq_sta_deleted_group_name UNIQUE (name))]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
... 11 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sta_deleted_group' already exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:907)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:791)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
... 16 common frames omitted

+++++++++++++++++++++++++++++++

I am using MySQL 5.6.

[VICTOR-OSEGHALE]

Hi Pankaj,

Thanks for reaching out here.

It will be helpful, if you describe the process used to perform the upgrade.

Kind Regards,
Victor - Application Support Engineer.

[Pankaj Gupta]

Hi @VICTOR-OSEGHALE,

I am using the installer method to upgrade the Stash by downloading & executing "atlassian-bitbucket-x.x.x-x64.bin" file as suggested in below link.

Link:- https://confluence.atlassian.com/bitbucketserver/bitbucket-server-upgrade-guide-776640551.html

Currently, our Stash server which is running on version "v3.8.0" is working fine. But when we are trying to upgrade it using the above method, it fails. 

Looking forward to your reply.

Regards,

Pankaj Gupta