Cant delete object

F1a year ago

Hello,

Im trying to delete some object but traccar refuse to delete them.

Map entry <table.71> with key <88> and value null 1/4 ( /* key:88 */ 88, 'AB 348 AL', '350424069548509', TIMESTAMP '2022-12-16 16:34:54.726', 34870416, 7, '{}', '+355677433598', 'Teltonika FMB920', NULL, NULL, FALSE, CAST('offline ' AS CHAR(8)), NULL, NULL, FALSE, NULL, CAST(0.0 AS DOUBLE PRECISION), FALSE, NULL, NULL) is locked by tx 1 and can not be updated by tx 2 within allocated time interval 2000 ms. [2.1.214/101] - MVStoreException (... < QueryBuilder:473 < DatabaseStorage:124 < BaseObjectResource:120 < ...)

and the it shows : ClosedChannelException (...) and can not log in
I made a restart and then I log in, but still cant delete a object

The resources of server are very good.

Regards
I

Anton Tananaeva year ago

You shouldn't use H2 database for production.

F1a year ago

Any suggestion what to use?

Also, this happened couple of days before.
Everything was ok before that. I deleted objects without problem

Anton Tananaeva year ago

MySQL or any other popular database engine.

F1a year ago

Hello Anton,

I dont run H2 database.

Any suggestion for this problem source??

Anton Tananaeva year ago

The error message suggests that you are. What do you think you're running?