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 do I get the connection inside of a Spring transaction?
- Nginx keeps hitting connection limit although I only use one connection
- Python [Errno 98] Address already in use
- Could not recognize my android device on mac
- Check if connection was successful using NestJs and Mysql
- Reading SQL-table by pandas raises NotImplementedError
- How can I use keep-alive messages to detect a disconnected user from game app?
- Xiaomi does not connect ws, other mobile phones yes
- Proper way to create connection to db in Typeorm - Nodejs
- ERR_CONNECTION_REFUSED on IIS
- iPhone Simulator - Simulate a slow connection?
- How do I shut down a Node.js http(s) server immediately?
- java.net.ConnectException: Connection refused: connect when retrieving a file
- Python: pyserial timeout doesn't seem to work on connect
- How to fix the org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl@779de014 is closed issue
- Connecting from the outside to oracle in docker container giving issues
- Failed to connect to MySQL at 127.0.0.1 in MySQL Workbench. System error 61
- JSch Algorithm negotiation fail
- How to construct customized ssh connection from ansible playbook
- JSch connection issue: JSchException: Algorithm negotiation fail – Even with JCE installed
- How I link a variable in a sub-agent to a dynamic variable in another sub-agent in Anylogic
- Java Service Using JPA and EclipseLink Must Maintain Resilient Connections to PostgreSQL Database
- Connect Websocket with Poco libraries
- How to open a remote resource with fsockopen and allow_url_fopen disabled, no socket (extension) support, and no cURL support?
- How to determine total number of open/active connections in ms sql server 2005
- Making sure that psycopg2 database connection alive
- How can I check internet connection in Android Q?
- Login to Microsoft SQL Server Error: 18456
- java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
- Web browser as web server