Problem

Occasionally traccar stops working and does not show device positions, after login via www only blank page. After restarting the add-on everything is back to normal. Below is a fragment of the traccar add-on log before restart:

2023-08-31 18:04:41  INFO: [redacted] connected
2023-08-31 18:04:42  INFO: [redacted: gt06 < IP redacted] {redacted}
2023-08-31 18:04:52  INFO: [redacted] disconnected
2023-08-31 18:04:55  WARN: Find device error - HikariPool-1 - Connection is not available, request timed out after 30000ms. - SQLTransientConnectionException (... < QueryBuilder:67 < *:140 < DatabaseStorage:72 < Storage:49 < ...)
2023-08-31 18:04:55  WARN: Unknown device - {IMEI redacted} (IP redacted)
2023-08-31 18:05:00  INFO: [redacted] connected
2023-08-31 18:05:00  INFO: [redacted: gt06 < IP redacted] {redacted}
2023-08-31 18:05:12  WARN: Find device error - HikariPool-1 - Connection is not available, request timed out after 30000ms. - SQLTransientConnectionException (... < QueryBuilder:67 < *:140 < DatabaseStorage:72 < Storage:49 < ...)
2023-08-31 18:05:12  WARN: Unknown device - {IMEI redacted} (IP redacted)
2023-08-31 18:05:16  WARN: Scheduled reports error - HikariPool-1 - Connection is not available, request timed out after 30000ms. - SQLTransientConnectionException (... < QueryBuilder:67 < *:140 < DatabaseStorage:72 < TaskReports:76 < ...)
2023-08-31 18:05:25  INFO: [redacted] disconnected
2023-08-31 18:05:30  WARN: Find device error - HikariPool-1 - Connection is not available, request timed out after 30000ms. - SQLTransientConnectionException (... < QueryBuilder:67 < *:140 < DatabaseStorage:72 < Storage:49 < ...)
2023-08-31 18:05:30  WARN: Unknown device - {IMEI redacted} (IP redacted)

After restart log:

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service base-addon-banner: starting
-----------------------------------------------------------
 Add-on: Traccar
 Modern GPS Tracking Platform
-----------------------------------------------------------
 Add-on version: 0.20.0
 You are running the latest version of this add-on.
 System: Home Assistant OS 10.5  (amd64 / qemux86-64)
 Home Assistant Core: 2023.8.4
 Home Assistant Supervisor: 2023.08.1
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums or the Discord chat.
-----------------------------------------------------------
s6-rc: info: service base-addon-banner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service base-addon-log-level: starting
s6-rc: info: service fix-attrs successfully started
Log level is set to INFO
s6-rc: info: service base-addon-log-level successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/mysql.sh
cont-init: info: /etc/cont-init.d/mysql.sh exited 0
cont-init: info: running /etc/cont-init.d/nginx.sh
cont-init: info: /etc/cont-init.d/nginx.sh exited 0
cont-init: info: running /etc/cont-init.d/traccar.sh
cont-init: info: /etc/cont-init.d/traccar.sh exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun nginx (no readiness notification)
services-up: info: copying legacy longrun traccar (no readiness notification)
s6-rc: info: service legacy-services successfully started
[20:10:58] INFO: Starting Traccar server...
2023-08-31 20:11:05  INFO: Operating system name: Linux version: 6.1.45 architecture: amd64
2023-08-31 20:11:06  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Alpine version: 11.0.19+7-alpine-r1
2023-08-31 20:11:06  INFO: Memory limit heap: 512mb non-heap: 0mb
2023-08-31 20:11:06  INFO: Character encoding: UTF-8 charset: UTF-8
2023-08-31 20:11:06  INFO: Version: 5.8
2023-08-31 20:11:06  INFO: Starting server...
2023-08-31 20:11:07  INFO: HikariPool-1 - Starting...
2023-08-31 20:11:10  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@4bf324f9
2023-08-31 20:11:10  INFO: HikariPool-1 - Start completed.
2023-08-31 20:11:11  INFO: Clearing database change log checksums
2023-08-31 20:11:12  INFO: Successfully acquired change log lock
2023-08-31 20:11:12  INFO: Successfully released change log lock
2023-08-31 20:11:13  INFO: Successfully acquired change log lock
2023-08-31 20:11:21  INFO: Reading from traccar.DATABASECHANGELOG
2023-08-31 20:11:23  INFO: Reading from traccar.DATABASECHANGELOG
Database is up to date, no changesets to execute
2023-08-31 20:11:23  INFO: Reading from traccar.DATABASECHANGELOG
2023-08-31 20:11:23  INFO: UPDATE SUMMARY
2023-08-31 20:11:23  INFO: Run:                          0
2023-08-31 20:11:23  INFO: Previously run:              43
2023-08-31 20:11:23  INFO: Filtered out:                 0
2023-08-31 20:11:23  INFO: -------------------------------
2023-08-31 20:11:23  INFO: Total change sets:           43
UPDATE SUMMARY
Run:                          0
Previously run:              43
Filtered out:                 0
-------------------------------
Total change sets:           43
2023-08-31 20:11:23  INFO: Update summary generated
2023-08-31 20:11:23  INFO: Successfully released change log lock
2023-08-31 20:11:23  INFO: Successfully released change log lock
2023-08-31 20:11:23  INFO: Command execution complete
2023-08-31 20:11:31  INFO: jetty-10.0.15; built: 2023-04-11T17:25:14.480Z; git: 68017dbd00236bb7e187330d7585a059610f661d; jvm 11.0.19+7-alpine-r1
2023-08-31 20:11:31  INFO: Started o.t.w.@4e50ae56{/,null,AVAILABLE}
2023-08-31 20:11:31  INFO: Session workerName=node0
[20:11:32] INFO: Starting NGinx server...
2023-08-31 20:11:35  WARN: JAXBContext implementation could not be found. WADL feature is disabled.
2023-08-31 20:11:39  INFO: Started o.e.j.s.ServletContextHandler@4af0c50{/,null,AVAILABLE}
2023-08-31 20:11:39  INFO: Started ServerConnector@1c84d80a{HTTP/1.1, (http/1.1)}{localhost:18682}
2023-08-31 20:11:39  INFO: Started Server@7272ee51{STARTING}[10.0.15,sto=0] @40728ms
2023-08-31 20:11:39  WARN: No systemd support - Unable to load library 'systemd':
Error loading shared library libsystemd.so: No such file or directory
Error loading shared library libsystemd.so: No such file or directory
Native library (linux-x86-64/libsystemd.so) not found in resource path (tracker-server.jar) - UnsatisfiedLinkError (... < TaskHealthCheck:49 < <gener:-1 < *:-1 < ... < ScheduleManager:46 < ...)
2023-08-31 20:11:40  INFO: [redacted] connected

System Information

version	core-2023.8.4
installation_type	Home Assistant OS
dev	false
hassio	true
docker	true
user	root
virtualenv	false
python_version	3.11.4
os_name	Linux
os_version	6.1.45
arch	x86_64
timezone	Europe/Warsaw
config_dir	/config

Home Assistant Community Store

GitHub API	ok
GitHub Content	ok
GitHub Web	ok
GitHub API Calls Remaining	5000
Installed Version	1.32.1
Stage	running
Available Repositories	1340
Downloaded Repositories	14

Airly

can_reach_server	ok
requests_remaining	27
requests_per_day	100

Home Assistant Cloud

logged_in	false
can_reach_cert_server	ok
can_reach_cloud_auth	ok
can_reach_cloud	ok

Home Assistant Supervisor

host_os	Home Assistant OS 10.5
update_channel	stable
supervisor_version	supervisor-2023.08.1
agent_version	1.5.1
docker_version	23.0.6
disk_total	62.3 GB
disk_used	22.0 GB
healthy	true
supported	true
board	ova
supervisor_api	ok
version_api	ok
installed_addons	MariaDB (2.6.1), Node-RED (14.4.5), Mosquitto broker (6.2.1), Zigbee2mqtt (1.18.1-1), NGINX Home Assistant SSL proxy (3.5.0), Duck DNS (1.15.0), File editor (5.6.0), Rhasspy Assistant (2.5.11), Alsa & PulseAudio Fix (3.4.1), Traccar (0.20.0), Samba Backup (5.2.0), MPD (1.7.2), Samba share with features (10.0.2.2), Signal Messenger (0.67.1), MaryTTS (1.5.2), motionEye (0.19.1), ESPHome (2023.8.2), Cloudflared (4.2.5), Epic Games Free (f7d1dfdacc198aaada2ea2b69a7cbe3478cb6579-2022-12-26), TooGoodToGo Home Assistant MQTT Bridge (2.5.1.2), Baikal (0.9.3), phpMyAdmin (0.8.7), Nginx Proxy Manager (0.12.3), Terminal & SSH (9.7.1), Log Viewer (0.15.1), Network UPS Tools (0.12.0), Tailscale (0.11.1), Wmbusmeters (W-MBus to MQTT) (1.14.0), HassOS SSH port 22222 Configurator (0.9.1a), SQLite Web (3.9.2), ZeroTier One (0.17.0), rtl_433 (0.4.0), rtl_433 MQTT Auto Discovery (0.6.0), InfluxDB (4.7.0), Grafana (9.0.3)

Dashboards

dashboards	1
resources	8
views	14
mode	storage

Recorder

oldest_recorder_run	13 sierpnia 2023 18:53
current_recorder_run	27 sierpnia 2023 15:28
database_engine	mysql
database_version	10.5.19