Cant delete object

F1 3 years 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 Tananaev 3 years ago

You shouldn't use H2 database for production.

F1 3 years ago

Any suggestion what to use?

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

Anton Tananaev 3 years ago

MySQL or any other popular database engine.

F1 3 years ago

Hello Anton,

I dont run H2 database.

Any suggestion for this problem source??

Anton Tananaev 3 years ago

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