Error in Time ( says 2017 ) stopped state update.

mikekgr8 years ago

Dear Sirs,
I have installed traccar version 3.7 at my ubuntu server and for the most of the time is running fine.
Now I noticed a problem: One of my trackers, running protocol gps103 (port 5001), has for an unknown to me reason sent 2017 as a year. Now at the WEB when I click this tracker I don't get recent updates to the State area. I suppose that because all "new" tracker's sending are at 2016 year (of course) the system ignore them... How can resolve this problem???

(This has been happens a couple of times in the past. I Solve the problems in the past, by erasing the tracker and put back on afterwards but doing this I lost all the history of the particular tracker...)

Thanks and Best Regards,
Mike Kranidis

Anton Tananaev8 years ago

I guess it was a device malfunction. You can either re-create device, or manually remove incorrect data from the database.

mikekgr8 years ago

Dear Anton,
thanks for your reply.
If I re-create device shall I lost its history?

In case of "manually remove incorrect data from the database" how can do that? I installed traccar using the build in database

Thanks.

Anton Tananaev8 years ago

If you remove device, you will of course lose the history.

To remove it manually, you should connect to the database using some JDBC tool. Note that you would have to stop the server because only one process can have access to the database.

As a side note, I won't recommend using default embedded database for anything other than testing.

mikekgr8 years ago

Dear Anton,
for simplicity I choose to remove and to re-create the faulty tracker. Now it is ok!

Regarding your recommendation to use external database, is there any good how to to follow (for Ubuntu Linux)? I have MySQL installed in my system that is running traccar server, can I use this MySQL for traccar server as well? Please give me some light!

Thanks and Best Regards,
Mike Kranidis

Anton Tananaev8 years ago

You can use MySQL if you want:

https://www.traccar.org/mysql/