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.

2 comments
Comment actions Permalink

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
Comment actions Permalink

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.