How to remove lock DATABASECHANGELOGLOCK Default H2 Database

Anton Tananaeva year ago

Maybe this:

https://www.traccar.org/forums/topic/h2-database-manipulation-says-the-database-is-read-only/

I don't really know the answer, but you can Google it. There are a bunch of thread about this issue.

Daniel Höldera year ago

Thank you, Anton. Tha was the solution. I started the shell as admin:

sudo java -cp lib/h2*.jar org.h2.tools.Shell -url "jdbc:h2:/opt/traccar/data/database" -driver org.h2.Driver -user sa

Then, it worked.

biroa year ago

Hello @Anton
I facing same problem

Just i have 3 questions
What is the best value LOCKED field, 0 or 1 ?
Is that dangerouse to set it at 0 everytime?
Why itself change the value ?

Thanks

Anton Tananaeva year ago

Have you read this thread? I believe it answers most of your questions already.