Traccar not deleting vehicle

Jesse Techno2 years ago

After removing a vehicle from the Traccar server using the web GUI, I still see the vehicle, it’s track and all its old info but I keep getting an error (seen below).

Map entry <table.71> with key <35> and value null 1/4 (/* key:35 */ 35, 'iPhone Test', 'Deleteme', TIMESTAMP '2022-08-30 09:16:03.414', 3438194, NULL, 'O', NULL, '¡Phone 14 Pro Max', NULL, 'person', FALSE, CAST ('online ' AS CHAR(8)), NULL, NULL) is locked by tx 1 and can not be updated by tx 2 within allocated time interval 2000 ms. 2.0.206/101 - MVStoreException(...< QueryBuilder: 473 < DatabaseStorage:124< BaseObjectResource:120<...)

Any thoughts?

Anton Tananaev2 years ago

Looks like the record is locked in the database.

I keep repeating that people shouldn't use H2 database for anything other than testing.

Jesse Techno2 years ago

I guess I will look up what H2 means.

Anton Tananaev2 years ago

It's the default embedded database.

https://www.h2database.com/