How to remove lock DATABASECHANGELOGLOCK Default H2 Database

Anton Tananaev10 months 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ölder10 months 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.

biro5 months 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 Tananaev5 months ago

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