I have intsalled version 4.10 of traccar,now afer every 5 so seconds the browser reloads,i discovered that every 5 o so seconds there is some change happening i the logs which cause locking of database
this
2020-10-03 22:24:29 INFO: HikariPool-1 - Starting...
2020-10-03 22:24:30 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-10-03 22:24:30 INFO: HikariPool-1 - Start completed.
2020-10-03 22:24:32 INFO: Clearing database change log checksums
2020-10-03 22:24:32 INFO: SELECT COUNT(*) FROM TRACCAR.DATABASECHANGELOGLOCK
and then this after 5 minutes
2020-10-03 22:29:39 INFO: HikariPool-1 - Starting...
2020-10-03 22:29:40 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-10-03 22:29:40 INFO: HikariPool-1 - Start completed.
2020-10-03 22:29:42 INFO: Clearing database change log checksums
2020-10-03 22:29:42 INFO: SELECT COUNT(*) FROM TRACCAR.DATABASECHANGELOGLOCK
2020-10-03 22:29:42 INFO: SELECT COUNT(*) FROM TRACCAR.DATABASECHANGELOGLOCK
2020-10-03 22:29:42 INFO: SELECT `LOCKED` FROM TRACCAR.DATABASECHANGELOGLOCK WHERE ID=1
2020-10-03 22:29:42 INFO: Successfully acquired change log lock
2020-10-03 22:29:42 INFO: SELECT MD5SUM FROM TRACCAR.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT
In crome when this happens websocket fails then /api/devices and /api/positions fails then the browser just reloads its,but in firefox it goes further with get /api/session failing causing the browser to logout,please someone help
You need to figure out why it restarts.
i am on ubuntu 18.04 ram 2gb,mysql 5.7.4, i have unintsalled Traccar version 4.10 and installed version 4.8 and it works fine,i have not yet figured out what is the cause for it to happenn,and oh i said every five seconds but its every five minutes...
Could be something related to systemd watchdog. Check logs.
I have intsalled version 4.10 of traccar,now afer every 5 so seconds the browser reloads,i discovered that every 5 o so seconds there is some change happening i the logs which cause locking of database
this
and then this after 5 minutes
In crome when this happens websocket fails then /api/devices and /api/positions fails then the browser just reloads its,but in firefox it goes further with get /api/session failing causing the browser to logout,please someone help