Traccar does not start anymore

Third party integrations
1

Hello
Traccar was running. Than had a power breakdown and now Hasio starts but Traccar not.
In the error_log of Traccar i see:

2019-03-20 19:07:58  INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2019-03-20 19:07:58  INFO: Waiting for changelog lock....
2019-03-20 19:08:08  INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2019-03-20 19:08:08  INFO: Waiting for changelog lock....

I googled and found this link: https://www.traccar.org/forums/topic/liquibase-waiting-for-changelog-lock/
So I want to update (or if it must be: delete) the database. Can somebody tell me where the database is? I see in the config directory only the database from hassio.

I am using a Raspberry Pi 3.

Thanks for helping
Gilbert

1 Like
2

Tell me please, did you solve this problem? I have the exact same mistake.

3

Nope, I gave up and deleted this buggy plugin. Sorry

4

It worked for me. After I registered the MariaDB settings.

5

This fixed it for me (If you are running Hassio and using MariaDB add-on for Traccar)

  1. Install Portainer
  2. Turn off Protected Mode for Portainer
  3. Open Portainer and go to Settings
  4. Remove all containers under “Hidden”
  5. Go to the containers list and connect to MariaDB’s via console.
  6. Type “mysql” and press enter
  7. Type “USE traccar;” (traccar = traccar database name)
  8. Type “update DATABASECHANGELOGLOCK set locked = 0;”
  9. Type “quit;”

Restart Hassio and see if it works now

6

update DATABASECHANGELOGLOCK set locked = 0; and restart HA didn’t work for me.
I delete addon Traccar, delete DataBase traccar in mysql, install addon traccar.
And didn’t work.
Traccar version: 0.19.0
Home Assistant Core: 2023.5.2
Home Assistant Supervisor: 2023.04.1

This happened after the update Home Assistant 2023.5.2 was installed.

Helped update “Home Assistant”:

wget https://github.com/home-assistant/supervised-installer/releases/latest/download/homeassistant-supervised.deb
dpkg -i homeassistant-supervised.deb

All files, settings and additions remained in place. Didn’t have to reconfigure anything.