I recently ran gocd-database-migrator (flags -insert and --progress) on my.
20.4.0 GoCD server with its current H2 database as source and a blank
PostgreSQL instance as target.
My understanding was that running this tool would only write to the target
database with no impact on the source. As this was meant to be a dry run
just to make sure the user on target PostgreSQL instance had the proper
privileges, I did not stop or back up GoCD before running the tool. The
tool ran without error, so I instructed the DBA to delete the target
database, planning to to the real migration later, when all is ready to
actually upgrade to 20.5.0.
I then found plenty database-related errors showing up in the GoCD console;
I restarted the go-server service and it got worse: GoCD is no longer able
to start
go-server-wrapper.log appears to indicate that the update is in progress:
INFO | jvm 1 | 2022/01/17 22:18:33 |
************************************************************************
INFO | jvm 1 | 2022/01/17 22:18:33 | WARNING: Shutting down your
server at this point will lead to a database corruption. Please wait until
the database upgrade completes.
INFO | jvm 1 | 2022/01/17 22:18:33 |
************************************************************************
INFO | jvm 1 | 2022/01/17 22:18:33 | Reading change scripts from
directory /var/lib/go-server/db/h2deltas...
INFO | jvm 1 | 2022/01/17 22:18:33 | dbdeploy v2.11
DEBUG | wrapperp | 2022/01/17 22:18:34 | Send a packet PING : ping 00000152
INFO | jvm 1 | 2022/01/17 22:18:34 | WrapperManager Debug: Received a
packet PING : ping 00000152
INFO | jvm 1 | 2022/01/17 22:18:34 | WrapperManager Debug: Send a
packet PING : ping 00000152
DEBUG | wrapperp | 2022/01/17 22:18:34 | read a packet PING : ping 00000152
INFO | jvm 1 | 2022/01/17 22:18:35 | Unable to create database upgrade
script for database
Is there any way for me to get out of this mess, and bring back my H2
database to the state it was before running the tool? Would emptying the
h2deltas folder do the trick?
Thanks in advance for your help
--
You received this message because you are subscribed to the Google Groups
"go-cd" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/go-cd/785b0a66-c1b7-43b6-b18f-279ff7629bb7n%40googlegroups.com.
