What makes you think it's wrong?
These positions are out of chronological sequence.
If you look at the history based on "devicetime" it is ok, but if you look at it based on "fixtime" it is out of sequence.
You only provided one data point, so I'm not sure what sequence you are talking about.
Hello Anton,
+-----------+---------------------+---------------------+---------------------+
| id | servertime | devicetime | fixtime |
+-----------+---------------------+---------------------+---------------------+
| 234945386 | 2021-05-12 09:47:56 | 2021-05-12 09:47:56 | 2021-05-12 06:16:25 |
| 234945414 | 2021-05-12 09:47:58 | 2021-05-12 09:47:58 | 2021-05-12 06:16:25 |
| 234945744 | 2021-05-12 09:48:28 | 2021-05-12 09:48:26 | 2021-05-12 09:48:26 |
| 234946040 | 2021-05-12 09:48:58 | 2021-05-12 09:48:56 | 2021-05-12 09:48:56 |
| 234946337 | 2021-05-12 09:49:28 | 2021-05-12 09:49:26 | 2021-05-12 09:49:26 |
| 234946684 | 2021-05-12 09:49:58 | 2021-05-12 09:49:56 | 2021-05-12 09:49:56 |
| 234947001 | 2021-05-12 09:50:28 | 2021-05-12 09:50:26 | 2021-05-12 09:50:26 |
| 234947343 | 2021-05-12 09:50:58 | 2021-05-12 09:50:56 | 2021-05-12 09:50:56 |
| 234947662 | 2021-05-12 09:51:28 | 2021-05-12 09:51:26 | 2021-05-12 09:51:26 |
| 234947996 | 2021-05-12 09:51:58 | 2021-05-12 09:51:56 | 2021-05-12 09:51:56 |
+-----------+---------------------+---------------------+---------------------+
See 10 records on the same device.
Only the first two have this divergence.
It probably means that your device didn't have a GPS fix and reported last known location. Or it didn't report any location and server used last location. Very common situation.
Hello Anton,
If the device did not have a GPS position, it means that it was invalid, right?
I would like to discard these invalid positions, can you help me?
+-----------+---------------------+---------------------+---------------------+
| id | servertime | devicetime | fixtime |
+-----------+---------------------+---------------------+---------------------+
| 234854461 | 2021-05-12 06:12:30 | 2021-05-12 06:12:25 | 2021-05-12 06:12:25 |
| 234854637 | 2021-05-12 06:12:57 | 2021-05-12 06:12:55 | 2021-05-12 06:12:55 |
| 234854798 | 2021-05-12 06:13:27 | 2021-05-12 06:13:25 | 2021-05-12 06:13:25 |
| 234854973 | 2021-05-12 06:13:57 | 2021-05-12 06:13:55 | 2021-05-12 06:13:55 |
| 234855144 | 2021-05-12 06:14:27 | 2021-05-12 06:14:25 | 2021-05-12 06:14:25 |
| 234855326 | 2021-05-12 06:14:57 | 2021-05-12 06:14:55 | 2021-05-12 06:14:55 |
| 234855528 | 2021-05-12 06:15:27 | 2021-05-12 06:15:25 | 2021-05-12 06:15:25 |
| 234855705 | 2021-05-12 06:15:57 | 2021-05-12 06:15:55 | 2021-05-12 06:15:55 |
| 234855873 | 2021-05-12 06:16:27 | 2021-05-12 06:16:25 | 2021-05-12 06:16:25 |
*| 234945386 | 2021-05-12 09:47:56 | 2021-05-12 09:47:56 | 2021-05-12 06:16:25 |*
*| 234945414 | 2021-05-12 09:47:58 | 2021-05-12 09:47:58 | 2021-05-12 06:16:25 |*
| 234945744 | 2021-05-12 09:48:28 | 2021-05-12 09:48:26 | 2021-05-12 09:48:26 |
| 234946040 | 2021-05-12 09:48:58 | 2021-05-12 09:48:56 | 2021-05-12 09:48:56 |
| 234946337 | 2021-05-12 09:49:28 | 2021-05-12 09:49:26 | 2021-05-12 09:49:26 |
| 234946684 | 2021-05-12 09:49:58 | 2021-05-12 09:49:56 | 2021-05-12 09:49:56 |
| 234947001 | 2021-05-12 09:50:28 | 2021-05-12 09:50:26 | 2021-05-12 09:50:26 |
| 234947343 | 2021-05-12 09:50:58 | 2021-05-12 09:50:56 | 2021-05-12 09:50:56 |
| 234947662 | 2021-05-12 09:51:28 | 2021-05-12 09:51:26 | 2021-05-12 09:51:26 |
| 234947996 | 2021-05-12 09:51:58 | 2021-05-12 09:51:56 | 2021-05-12 09:51:56 |
| 234948274 | 2021-05-12 09:52:23 | 2021-05-12 09:52:20 | 2021-05-12 09:52:20 |
+-----------+---------------------+---------------------+---------------------+
I searched for positions before and after the one in question, note that only they are out of sequence.
If the device did not have a GPS position, it means that it was invalid, right?
No, it does not. But you can filter those out by duplicate filter.
Hello. It is possible to make a correction in traccar confg.
if devicetime and servertime are different from fixtime. fixtime = servertime?
No, it's not possible to configure something like that in the config.
Dear Anton,
In Mysql Traccar sometimes records the following times:
the only thing that is wrong is "fixtime".
I use GPS103 and all set to UTC 0.
What can be happening?
This happens occasionally, can you help me?
Traccar 4.10.