Bambo does not start anymore - missing table

Question

Hi.

Our Bamboo instanace does not start anymore. The exception from the log is:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bamboo.bamboo.supporthealthchecks' doesn't exist
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:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2441)
at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2339)
at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2337)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getColumns(NewProxyDatabaseMetaData.java:3092)
at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.populateTablesWithColumns(InformationExtractorJdbcDatabaseMetaDataImpl.java:350)
... 19 more

The last thing I changed was:

* enable webhocks for Bitbucket
* tested that hook => master build started, branch build queued
* enabled second agent so that branch build can start
* branch build started
* now bambo became unresponsive and I got PROXY ERROR in browser

Steps I did:

Tried to shut down the Windows Service (failed)

Killed the Service and try restart => Bambo did not came up

restarted Servce => Bambo did not came up and logged the exception above

Bambo Version: 6.6.2

Bamboo runs on Windows Server 2012 R2

I never touched DB for Bambo or Jira. I also did no upgrade.

Please help me out.

Thanks a lot

Chris

Daniel Santos_157bm4 · Answer

Hi @kamuffe

I'm really 😃  you found your own way to solve it 
Than you for sharing your solution here. It will certainly help others to move forward.

See you in the next thread!

kamuffe · Answer

Hi.

In the meanwhile I got Bamboo running again.

After several tries there was a table "bamboo.supporthealptchecks".

I deleted it and then Bamboo started again.

The following thread helped me: https://community.atlassian.com/t5/Bamboo-questions/Bamboo-6-5-0-does-not-start-anymore-FATAL-Failed-to-initialise/qaq-p/924627

Thanks a lot.

Chris

Daniel Santos_157bm4 · Answer

Hi @kamuffe

We will need to investigate this one further and given the type issue you are facing we understand that the best channel for troubleshooting it is our support portal.
I've opened a support ticket in your name to report this problem and you should receive a notification about it soon.

I kindly ask you to share the solution to this problem here when that case is resolved.

Thank you!