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
Hi Jijo,
Please raise an issue with Atlassian support to get help for this.
Best regards,
Thiago Bomfim
Atlassian Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.