OpenSpecimen Gotchas liquibase: Waiting for changelog lock

Tags: OpenSpecimen Summary Gotchas_Category

Diagnosis

1. OpenSpecimen will not start.
2. Check the catalina.out file in the error - usually in /local/{Open Specimen Directory}/app/logs/.
3. If you see lots of lines saying liquibase: Waiting for changelog lock.....

Resolution

1. Log onto the database in MySQL
2. SELECT * FROM DATABASECHANGELOGLOCK; - there should be one row with a value of 1 for the locked column and the details of the lock.
3. To clear the lock run UPDATE DATABASECHANGELOGLOCK SET LOCKED=FALSE, LOCKGRANTED=null, LOCKEDBY=null where ID=1;

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'