Unlock standalone Airsonic database
Written by pmd - - no commentsIf your airsonic is stucked for some reasons such as Liquibase Update Failed and Waiting for changelog lock...
liquibase.exception.LockException: Could not acquire change log lock. Currently locked by 192.168.254.200 (192.168.254.200) since 18/11/18 16:39
- Stop Airsonic for sure :
sudo service airsonic stop
- Read logs
/var/airsonic/airsonic.log
:nano /var/airsonic/airsonic.log - Backup your database folder
/var/airsonic/db
:sudo cp /var/airsonic/db /var/airsonic/db_backup - Edit
/var/airsonic/db/airsonic.script
:sudo nano /var/airsonic/db/airsonic.script- remove all lines where you can find DATABASECHANGELOGLOCK by example :
- CREATE MEMORY TABLE DATABASECHANGELOGLOCK.....
- INSERT INTO DATABASECHANGELOGLOCK VALUES(1,TRUE,'2018-11-18 16:39:56.266000000','192.168.254.200 (192.168.254.200)')
- remove all lines where you can find DATABASECHANGELOGLOCK by example :
- Save file.
- Start Airsonic :
sudo service airsonic start
- Check Airsonic status :
sudo service airsonic status
If you wanna reset your Airsonic music server, just delete the database /var/airsonic/db ...