Database disable

mc4 years ago

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
Anton Tananaev4 years ago

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.

mc4 years ago

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.

Anton Tananaev4 years ago

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.

mc4 years ago

I see. Thank you very much.