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
empenoso
(Mike)
July 29, 2019, 11:45am
2
Tell me please, did you solve this problem? I have the exact same mistake.
Nope, I gave up and deleted this buggy plugin. Sorry
empenoso
(Mike)
August 1, 2019, 1:59pm
4
It worked for me. After I registered the MariaDB settings.
This fixed it for me (If you are running Hassio and using MariaDB add-on for Traccar)
Install Portainer
Turn off Protected Mode for Portainer
Open Portainer and go to Settings
Remove all containers under “Hidden”
Go to the containers list and connect to MariaDB’s via console.
Type “mysql” and press enter
Type “USE traccar;” (traccar = traccar database name)
Type “update DATABASECHANGELOGLOCK set locked = 0;”
Type “quit;”
Restart Hassio and see if it works now
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.