I'm getting below error while starting Stash with DB migration [Upgrade], Can someone help me please?

[Jijo John]

I'm getting below error while starting Stash with DB migration [Upgrade], Can someone help me?

2014-10-08 06:07:40,185 INFO  [spring-startup]  c.a.s.i.server.BuildInfoLogger Starting Stash 3.3.1 (8a349b6 built on Tue Sep 23 07:05:25 UTC 2014)

2014-10-08 06:07:40,196 INFO  [spring-startup]  c.a.s.i.server.BuildInfoLogger JVM: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.7.0_60-b19

2014-10-08 06:07:40,228 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /data/stash/stash-home

2014-10-08 06:07:46,239 ERROR [spring-startup]  liquibase Change Set liquibase/r3_2/upgrade.xml::STASHDEV-3320-1::bturner failed.  Error: Error executing SQL CREATE TABLE `stash4`.`sta_shared_lob` (`id` BIGINT NOT NULL, `lob_data` LONGTEXT NOT NULL, CONSTRAINT `pk_sta_shared_lob` PRIMARY KEY (`id`)): Table 'sta_shared_lob' already exists

liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `stash4`.`sta_shared_lob` (`id` BIGINT NOT NULL, `lob_data` LONGTEXT NOT NULL, CONSTRAINT `pk_sta_shared_lob` PRIMARY KEY (`id`)): Table 'sta_shared_lob' already exists

        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) ~[JdbcExecutor.class:na]

        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) ~[JdbcExecutor.class:na]

        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091) ~[AbstractDatabase.class:na]

        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075) ~[AbstractDatabase.class:na]

        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ~[ChangeSet.class:na]

        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) [UpdateVisitor.class:na]

        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) [ChangeLogIterator.class:na]

        at liquibase.Liquibase.update(Liquibase.java:114) [Liquibase.class:na]

        at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:262) [SpringLiquibase.class:na]

        at liquibase.database.DefaultingSchemaLiquibase.performUpdate(DefaultingSchemaLiquibase.java:119) [DefaultingSchemaLiquibase.class:na]

        at liquibase.database.DefaultingSchemaLiquibase.afterPropertiesSet(DefaultingSchemaLiquibase.java:74) [DefaultingSchemaLiquibase.class:na]

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760) [AbstractApplicationContext.class:4.0.6.RELEASE]

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) [AbstractApplicationContext.class:4.0.6.RELEASE]

        at javax.servlet.GenericServlet.init(GenericServlet.java:158) [servlet-api.jar:3.1.FR]

        at java.lang.Thread.run(Thread.java:745) [na:1.7.0_60]

        ... 115 frames trimmed

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sta_shared_lob' already exists

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_60]

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.Util.getInstance(Util.java:381) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) ~[mysql-connector-java-5.1.10.jar:na]

        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) ~[mysql-connector-java-5.1.10.jar:na]

        at com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:300) ~[StatementHandle.class:0.7.1.RELEASE]

        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) ~[JdbcExecutor$1ExecuteStatementCallback.class:na]

        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[JdbcExecutor.class:na]

        ... 15 common frames omitted

[ThiagoBomfim]

Hi Jijo,

Please raise an issue with Atlassian support to get help for this.

Best regards,
Thiago Bomfim
Atlassian Support