I am forwarding the data from the device to Hyperterminal. But the database always locks the service, I need to work hard to restart, many attempts. I need to use WINDOWS TASK MANAGER to stop the process manually. I need the forwarded data only no need to save. How can I disable the database? Traccar server need to work properly without saving into the database
Log file
2020-03-23 16:34:10 INFO: HikariPool-1 - Starting...
2020-03-23 16:34:28 INFO: HikariPool-1 - Start completed.
2020-03-23 16:35:02 INFO: Clearing database change log checksums
2020-03-23 16:35:08 INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2020-03-23 16:35:08 INFO: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2020-03-23 16:35:08 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:08 INFO: Waiting for changelog lock....
2020-03-23 16:35:19 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:19 INFO: Waiting for changelog lock....
2020-03-23 16:35:29 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:29 INFO: Waiting for changelog lock....
2020-03-23 16:35:39 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:39 INFO: Waiting for changelog lock....
2020-03-23 16:35:49 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:49 INFO: Waiting for changelog lock....
2020-03-23 16:35:59 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:35:59 INFO: Waiting for changelog lock....
2020-03-23 16:36:10 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2020-03-23 16:36:10 INFO: Waiting for changelog lock....
2020-03-23 16:36:20 INFO: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
Database lock means that the process has died or been killed during the database migration. If it happens often, you are doing something wrong. Migration happens on the start. You have to wait for it to complete.
I am testing a new device. That's why I want to disable temporarily. Very hard to write MCU firmware each time that needs 20-30 minutes trying to restart the service. 1-day firmware work will take a week and annoying. The solution is to disable the database temporarily. I don't know how to do it.
It's not possible to disable the database. You can override queries to not write anything into the database, but you still need the database at least for device ids.
I see. Thank you very much.
I am forwarding the data from the device to Hyperterminal. But the database always locks the service, I need to work hard to restart, many attempts. I need to use WINDOWS TASK MANAGER to stop the process manually. I need the forwarded data only no need to save. How can I disable the database? Traccar server need to work properly without saving into the database
Log file