During the creation of some data on the production server by our backend, an unexpected error occurred and some data became inaccessible. Currently, a fix is being found for the error, but the flawed data is still on the server, causing some trouble. This can easily be fixed by setting some data to
NULL. Our backend uses the Spring framework and Liquibase to update the schema when necessary. Our production server is maintained by a different company and is unaccessible for us (the developers). The other company wants us to write an entry for the Liquibase XML file to fix this.
The question is: do we change the XML file, run a query normally or is there anything else we can do? The reason I'm asking this is because we feel like this is not the way Liquibase should be used. (It's not a database schema change.)
Note: we are running more than just the production environment, so by adding the query to the Liquibase XML file, it will run on all environments.