Server stopped working

Nikola Joksimović4 months ago

Hello. Thank you for all the help I got by now, but I'm afraid I need some help again.
I cannot access the Traccar server anymore. Typing in localhost:8082 just returns blank page now on the PC where the server is installed. No access from local network either.

In Windows services, when I try to stop the traccar service, it's stopping indefinitely long, never finishing the process of stopping. When I force stop it using taskkill / pid /f in cmd and start it again, nothing changes.

This message in log file keeps repeating:

2024-07-03 13:59:19 ERROR: HikariPool-1 - Error thrown while acquiring connection from data source - Invalid chunk id 0 [2.2.224/6] - MVStoreException (...)

Digging trough the logs, before this message started repeating (literally just this message is now in the logs for days, not a single different message) I found some other warning and error messsages, and they all contain this "invalid chunk". Examples:

2024-07-03 12:39:29  WARN: Find device error - Invalid chunk id 0 [2.2.224/6] - MVStoreException (...)

When server is starting:

2024-07-03 12:40:51  WARN: Failed to restore the auto commit to true
2024-07-03 12:40:51 ERROR: Main method error - Invalid chunk id 0 [2.2.224/6] - MVStoreException (...)
2024-07-03 12:40:51  WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@457c9034 threw the following exception - Invalid chunk id 0 [2.2.224/6] - MVStoreException (...)

Thank you in advance for any help you can provide.

Anton Tananaev4 months ago

It seems like your database got corrupted. I keep repeating that people shouldn't use H2 database for production. This is why.

Nikola Joksimović4 months ago

What would be the best solution for this?

I don't know how to use different databases for traccar, so I just kept default settings when I installed it.

I need to put the system back to work as soon as possible, can you please help me with that?

I have 30+ trackers logged to the system, so if I can avoid clean reinstall that would be great. If not, well, what needs to be done- needs to be done.

Anton Tananaev4 months ago

H2 has some recovery tools available. You can try that.

Nikola Joksimović4 months ago

Thank you for the help. Just in case, what would be my second/third option if this doesn't work? I need to get the traccar up and running asap, and I don't really have experience with databases.

Nikola Joksimović4 months ago

UPDATE:

On my test server I managed to change the database from H2 to MySQL. Came to realization that, if I am not able to fix H2, I will have to do the complete setup of accounts and devices all over again. It's kind of obvious to be honest, just didn't cross my mind at all.

Since H2 is not to be used in a long run anyway, I've decided to start the painful process. Thanks for all your help.

Just a side note, I'm keeping everything basic in MySQL, so if there is any important settings that need to be changed in it (to be stable for 30+ devices for extended period of time), please let me know.

Anton Tananaev4 months ago

Default setup should be enough for a small number of devices.