How to diagnose TeamCity / HSQLDB error [S1000][-25] ".data file is modified but .backup file does not exist
We are using a third party tool (TeamCity) that suddenly stopped working and shows a DB key/index type of error in their log files like this:
However, we are unable to simply connect to the HSQLDB database using the blank username (assume that is superuser) and password combed from log. The error is:
[S1000][-25] error in script file line: 342 org.hsqldb.HsqlException: .data file is modified but .backup file does not exist.
I know almost nothing about the HSQLDB so apologize if this is obvious issue.
We never did figure out how to connect to the database. However we were able to resolve the duplicate key issue shown in the screenshot by editing the buildserver.script file.
The .script file is a text file containing SQL commands in it. We surmised that file might be run during startup and noticed that some "insert" commands contained duplicate data.
The duplicate lines (~1000) were removed using NotePad++ by finding distinct lines and assuming that should be correct as the new file and then diffing the old vs new to make sure nothing else was lost as a side effect.
YouTrack started right up after that change.
- How to setup a connection to Sharepoint with enterprise app and client secret
- Connection failure - ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)
- Self Hosted website gets "request timed out" for ONLY one person
- not able to authenticate a com.trilead.ssh2.Connection
- Send document to zoom chat via java program
- typeORM combine next.js can not connect database with error
- AWS multy Lambdas, RDS, Bedrock, Textract, connections
- pytest - mock config[<section_name>] via configparser.ConfigParser() / config.read()
- Docker push use of closed network connection
- Could not recognize my android device on mac
- Why is this socket null?
- Django database connections pool with psycopg2.pool
- Database (database/database.sqlite) does not exist. Database works from artisan tinker
- JSch Algorithm negotiation fail
- How to connect to MySQL from the command line
- Connecting to a SQL database in my project folder using connection string in C#
- Spring and MySQL connections (keeps creating new connections instead using sleeping connections)
- getting [AxiosError: Network Error] when calling the server
- Socket.io not receiving data properly in React and Node JS
- urllib3 connectionpool - Connection pool is full, discarding connection
- Creating an idle timeout in Go?
- Connecting to Redshift server in SAS
- Artificially create a connection timeout error
- How to bypass the message-"your connection is not private" on non-secure page using Selenium?
- JDBC with VSCode class not found
- Get all TCP-connections opened by application using C#
- How can I achieve connection check globally across the flutter application?
- Create server locally with laravel but can not accessed
- How do I get the connection inside of a Spring transaction?
- Nginx keeps hitting connection limit although I only use one connection