SQL error when doing: Taking a connection from the data source

Hi,

I received one error when I am login into the team city which is i listed below, Anybody knows the solution for this..?

Error:

Unexpected exception SQLException/HsqlException: SQL error when doing: Taking a connection from the data source
SQL exception: error in script file line: C:\ProgramData9\JetBrains\TeamCity\system\buildserver 269



SET TABLE PUBLIC.CANCELED_INFO INDEX '4888 0 13'

269 line which is mentioned in error line

Version:

TeamCity version: 9.0.3 (build 32334), data format version 709

OS: Windows 7, User: *****, JRE: 1.7.0_72-b14 Java HotSpot(TM) Server VM (32 bit)

Log file details:

[2015-08-07 12:01:05,761]   INFO -  jetbrains.buildServer.STARTUP - Using database connection URL from the database properties file. The URL is: jdbc:hsqldb:file:$TEAMCITY_SYSTEM_PATH/buildserver
[2015-08-07 12:01:05,761]   INFO -  jetbrains.buildServer.STARTUP - Using internal (HSQL) database
[2015-08-07 12:01:05,761]   INFO -  jetbrains.buildServer.STARTUP - Current stage: Connecting to the database
[2015-08-07 12:01:07,290]   INFO -  jetbrains.buildServer.STARTUP - Current stage: TeamCity server startup error

Thanks

1 comment
Comment actions Permalink

Hello,

It looks like database got corrupted. If you have backup, you need to restore from it. If not, you can only remove database and start without data, but configuration files will be preserved. For this you need to stop server and move files matching wildcard buildserver.* from <TeamCity data directory>/system/ directory to some other place and start server again.

Unfortunately, HSQL2 database is not reliable and that is one of the reasons we recommend to switch to external database.

0

Please sign in to leave a comment.