Can someone please help me with this HSQLDB error? Follow
An error was encountered during TeamCity server startup
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.
Please sign in to leave a comment.
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
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