If Traccar isn't reachable on digitalocean

I recently encountered a problem with traccar on digitalocean and solved it.
I just wanted to share my experience.

my problem was that suddenly the traccar sevice was not reachable at all.
as i hadn't changed anything on the server i was not sure what went wrong.

first i checked if ther ports were listeneing in the console with:
ss -plntu
the port 8082 (for traccar) and the portrange 5001 etc (for the devices) where not listening.
after that i found a notice that the mysql database was locked ( as DATABASECHANGELOGLOCK )

to solve this i had to connect to the database and change this

sudo mysql -u root -p (the root password seems to be "root" in this case)
use traccar;
UPDATE traccar.DATABASECHANGELOGLOCK SET LOCKED=FALSE WHERE ID=1;

after closing the mysql console i checked the ports with

ss -plntu

all seemed to be working and active.
traccar is fully operational again.

I had the same problem, due to a power outage, the backup battery could not hold, the power came back and traccar did not start, I checked the Registers part and it had the same detail, After investigating I found the DATABASECHANGELOGLOCK table from the database SQLSERVER and I clear the registry, rebooted the traccar server and it worked without any problem

How do you clear the registry Avlmexico