Error updating from 7.4 to 8.0

Justin Pounders shared this problem 14 months ago
Resolved

Attempting to update from 7.4 to 8.0, it appeared as though the installer was attempting to do all the steps twice.


Checked the patch log and had the following error:


Installation Error

An error occurred during installation:

liquibase.exception.LockException: Could not acquire change log lock. Currently locked by xxxxxxxx.us-east-2.compute.internal (xxxxxx) since 5/23/19 7:25 PM

liquibase.exception.LockException: Could not acquire change log lock. Currently locked by ip-xxxxxxxx.us-east-2.compute.internal (xxxxxx) since 5/23/19 7:25 PM

at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:230)

at liquibase.Liquibase.update(Liquibase.java:184)

at liquibase.Liquibase.update(Liquibase.java:179)

at com.hof.util.LiquibaseRunner.runLiquibaseUpdate(LiquibaseRunner.java:37)

at com.hof.patch.process.job.LoggedSchemaUpdateJob.run(LoggedSchemaUpdateJob.java:30)

at com.hof.patch.PatchInstaller.runInstallJobs(PatchInstaller.java:467)

at com.hof.patch.cmd.CmdInstaller.install(CmdInstaller.java:147)

at com.hof.patch.cmd.CmdInstaller.main(CmdInstaller.java:36)

at com.hof.patch.PatchInstaller.runCmd(PatchInstaller.java:772)

at com.hof.patch.PatchInstaller.runInstaller(PatchInstaller.java:736)

at com.hof.patch.PatchInstaller.main(PatchInstaller.java:806)

--- Yellowfin Patch Installation Failed ---


Is there anything I can/should do before rolling back the AMI and retrying the update?

Comments (3)

photo
1

Hi Justin,

Thanks for reaching out to support with your issue.

The Change Lock that is referred to in these errors is applied when Yellowfin starts, and should be cleared upon shutdown. As a quick check, please confirm Yellowfin is not running on the system when attempting the upgrade process.

If Yellowfin is indeed not running, and you are still receiving this error, the lock can be removed manually through the DB -

Please make sure your backups are valid before continuing.


DELETE FROM DATABASECHANGELOGLOCK WHERE ID=1; INSERT INTO DATABASECHANGELOGLOCK VALUES (1,false,null,null);

This should allow the lock to be disabled, and the upgrade to proceed as expected. Please let me know how it goes!

Thanks,

Eric

photo
1

Eric,


That did it. We're back up and running.


Thanks!

photo
1

Glad to hear it, Justin!

Happy to help, I'll mark this as Resolved. Have a good one!

Best,

Eric