Waiting for changelog lock loop

Bishaka Samuel7 years ago
OS : Windows 10
TRACCAR : 3.15-SNAPSHOT

Hello

So my traccar installation failed to start, and after some digging i found the wrapper log stuck in a loop printing

INFO|4904/0|Service traccar|18-01-11 13:23:51|INFO 1/11/18 1:23 PM: liquibase: Waiting for changelog lock....

And after a while it spits out

INFO|4904/0|Service traccar|18-01-11 13:27:51|java.lang.reflect.InvocationTargetException
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|4904/0|Service traccar|18-01-11 13:27:51|Caused by: liquibase.exception.LockException: Could not acquire change log lock.  Currently locked by GHOSTFREAK3000 (169.254.242.122) since 1/11/18 11:53 AM
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:190)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at liquibase.Liquibase.clearCheckSums(Liquibase.java:1335)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:298)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.traccar.database.DataManager.<init>(DataManager.java:87)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.traccar.Context.init(Context.java:333)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	at org.traccar.Main.main(Main.java:35)
INFO|4904/0|Service traccar|18-01-11 13:27:51|	... 6 more
INFO|wrapper|Service traccar|18-01-11 13:27:52|calling onStop

Now, the changelog file in question ./schema/changelog-master.xml isn't locked at all and i've tried restarting the machine, and reinstalling traccar.

Since this is a dev machine, i don't really care about it and just want to know if it's possible to skip this changelog lock step and just get the server up, or is there some other way to fix this?

Anton Tananaev7 years ago

If it's a dev machine you can just re-create database to fix this problem. If you need to keep database, search on forum and GitHub. The problem has been discussed before and there were a few solutions available.

Bishaka Samuel7 years ago

Did a little more digging, found the h2 databasechangelock table.

img

Guessing i should just delete this record right?

Anton Tananaev7 years ago

If you want to learn more about it you should read about Liquibase library, but I would recommend look for solution on forum and GitHub. As I said, it has been discussed several times before.

Bishaka Samuel7 years ago

Deleted the entry, works now.. thanks.

Will checkout that liquibase library documentation if i get another convoluted problem.
mark this as closed.... :)