Seems like the things I’m struggling with are silly but I’ve already tried so much that I don’t even have any solutions left in my head. I’m working on TRUNK-5304 which is ‘Upgrade from 1.10.6 to 1.11.8 fails because of inconsistent changeset’.
I was able to reproduce the bug thanks to mentors’ help. Right now I’m trying to modify changesets to solve it. I’ve already tried just deleting bad changesets’ code (sadly it doesn’t work like this ), deleting the preconditions which actually cause an error, adding <validCheckSum> tag with those checksums which maven gives, replacing <insert> tag with <dropTable> but none of it worked. Seems like the thing has to be somewhere in preconditions, but could you direct me what I should focus on to fix it?
In Talk thread people say I only have to delete the changesets from the liquibasechangelog table, but I have no idea how to do it and Google doesn’t help
I’m looking for the way to solve problem at all. But yes, right now the thing which I don’t understand is where “liquibasechangelog” table is located and how I can modify it
I ran the standalone version. On ‘Database Changes’ page I could see that these changesets are marked as ALREADY_RAN. However, I still don’t get what can I do with this information
I’ve accessed MySQL and now I can see what liquibasechangelog table looks like. As far as I understand, there are two ways to delete these bad changesets from it:
Delete them locally through MySQL command line which doesn’t make sense when solving a problem globally
Create a new changeset that would delete them
But I’m not sure whether this just-created changeset should be in 1.10.x branch or 1.11.x or both. Do I understand the thing correctly at all?