Migration from 16.1.0 to 21.2.0 corrupted my h2db

15 views

Skip to first unread message

Nandha Kumar

unread,

Apr 27, 2021, 5:01:02 AM4/27/21

to go-cd

Hello,

I have my list of runs and the directories in the place. I have upgraded from 16.1.0 to 21.2.0

and after starting the go-server it was throwing plenty of errors. So I reverted back to 16.1.0 and even there it is throwing the below error. When looking at the chats they say the H2db got corrupted, is there a mechanism to retrieve it ? having the files / directories that I have run in the machine.

04-20 04:44:42 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: Table "PIPELINES" not found; SQL statement:
SELECT name FROM pipelines WHERE locked = true [42102-168]

Thanks in advance...

Ashwanth Kumar

unread,

Apr 27, 2021, 5:18:00 AM4/27/21

to go...@googlegroups.com

Only way to recover is to use a backup. I'm hoping you took a backup before attempting the upgrade.

If not, I would recommend going back to 21.2.0 and solve the issues.

PS: Also as a general rule, it is not recommended doing an upgrade across 5+ years of release.

Thanks,

--
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 go-cd+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/b18d12e6-b869-47c2-8c60-67f4385b6fd9n%40googlegroups.com.