Can someone please help me with this HSQLDB error?

An error was encountered during TeamCity server startup

Unexpected exception SQLException: SQL error when doing: Connecting to HSQL
SQL exception: File input/output error

jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Connecting to HSQL
SQL exception: File input/output error
   at org.hsqldb.jdbc.Util.sqlException(Util.java:63)
   at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
   at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
   at jetbrains.buildServer.serverSide.db.jdbcLoader.JdbcDataSource.getConnection(JdbcDataSource.java:47)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:219)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:545)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.tryToUseDB(TeamCityDispatcherServlet.java:24)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performOneAttempt(TeamCityDispatcherServlet.java:325)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performSequentialAttempts(TeamCityDispatcherServlet.java:426)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$100(TeamCityDispatcherServlet.java:187)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$3.run(TeamCityDispatcherServlet.java:3)
   at java.lang.Thread.run(Thread.java:619)
caused by: java.sql.SQLException: File input/output error
   at org.hsqldb.jdbc.Util.sqlException(Util.java:63)
   at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
   at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
   at jetbrains.buildServer.serverSide.db.jdbcLoader.JdbcDataSource.getConnection(JdbcDataSource.java:47)
   at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.connect(TeamCityDatabaseManager.java:219)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.setupAndConnectToDB(TeamCityDispatcherServlet.java:545)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.tryToUseDB(TeamCityDispatcherServlet.java:24)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performOneAttempt(TeamCityDispatcherServlet.java:325)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.performSequentialAttempts(TeamCityDispatcherServlet.java:426)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet.access$100(TeamCityDispatcherServlet.java:187)
   at jetbrains.buildServer.rootDispatcher.TeamCityDispatcherServlet$3.run(TeamCityDispatcherServlet.java:3)
   at java.lang.Thread.run(Thread.java:619)

----------------------------------------------------------------------------------------------------------------

I have a back up and I tried restoring the server from the back up. And got this error.

Failed: Failed to SHUTDOWN COMPACT HSQL database: File input/output error
SQL exception: File input/output error
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Failed to SHUTDOWN COMPACT HSQL database: File input/output error
SQL exception: File input/output error
        at jetbrains.buildServer.serverSide.db.HSQLDBSpecific.shutdownHSQL(HSQLDBSpecific.java:116)
        at jetbrains.buildServer.serverSide.maintenance.BackupRestoreRunner.mainMain(BackupRestoreRunner.java:290)
        at jetbrains.buildServer.serverSide.maintenance.BackupRestoreRunner.main(BackupRestoreRunner.java:207)
Caused by: java.sql.SQLException: File input/output error
        at org.hsqldb.jdbc.Util.sqlException(Util.java:63)
        at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2430)
        at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
        at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
        at jetbrains.buildServer.serverSide.db.jdbcLoader.JdbcDataSource.getConnection(JdbcDataSource.java:47)
        at jetbrains.buildServer.serverSide.db.HSQLDBSpecific.shutdownHSQL(HSQLDBSpecific.java:100)
        ... 2 more
Done.

I know I'm meant to use an external database, but I need to look at the TeamCity

Server page once before we migrate to Oracle.

0
2 comments

I've done what the other posts have suggested but it doesn't work.

I don't need my artifacts, just need my build configurations. Is it

worthwhile reinstalling TeamCity and then doing a back up?

Regards

0

Hello,

sorry for delay.

It looks like TeamCity server has no access to the database file or the file is corrupted.

How did you do backup and restore - using the maintainDB tool or copying files? Had you shut TeamCity server downb before backup?
What kind operating system do you use - windows or linux?
How do you start TeamCity server - by windows service, by the batch file?

--
Leonid Bushuev

0

Please sign in to leave a comment.