servertime Not in Sequence in Positions Table When GT06 Device Reconnects to Network

Tejas Bhatt4 days ago

I am experiencing an issue in my Traccar server where the servertime in the positions table is not in sequence when the GT06 device reconnects to the network after being offline. This is causing inconsistencies in the recorded data.

Here are the configurations I have set:

<entry key='time.override'>serverTime</entry>
<entry key='server.instantAcknowledgement'>true</entry>
<entry key='server.buffering.threshold'>60000</entry>

<entry key='filter.enable'>true</entry>
<entry key='filter.invalid'>true</entry>
<entry key='filter.zero'>true</entry>
<entry key='filter.outdated'>true</entry>
<entry key='filter.relative'>true</entry>

I suspect the issue may be related to the way the serverTime is being applied when buffered data from the device is processed after reconnecting.

Could someone please help me understand why this might be happening and how to resolve the issue? Are there additional settings I should adjust or other factors I should consider?

Thank you!

Screenshot 2025-01-23 045826.png

Anton Tananaev4 days ago

You should check logs for the same period to see what happened.

Tejas Bhatt4 days ago

Thank you for your response. I have checked the logs, and it seems that the old records are being processed after the new records when the GT06 device reconnects to the network. This is causing the servertime in the positions table to appear out of sequence.

Here’s an excerpt from the logs for reference:

2025-01-23 06:08:45  INFO: [T1b97822f: gt06 < 106.209.172.74] 787811010356218603801422000000020017de650d0a
2025-01-23 06:08:45  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805010017ac6b0d0a
2025-01-23 06:08:45  INFO: Event id: 356218603801422, time: 2025-01-23 06:08:45, type: deviceOnline, notifications: 0
2025-01-23 06:08:46  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706082dce0263c74807981a8819143b0194621531002a740100000019a6860d0a
2025-01-23 06:08:46  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220019a94a0d0a
2025-01-23 06:08:46  INFO: queued Thu Jan 23 06:08:45 UTC 2025
2025-01-23 06:08:47  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060814ce0263c8a0079814fb0b14310000000000000000010000000d1c050d0a
2025-01-23 06:08:47  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522000dffef0d0a
2025-01-23 06:08:47  INFO: queued Thu Jan 23 06:08:20 UTC 2025
2025-01-23 06:08:48  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060816ce0263c8dd079815960a14490000000000000000010000000eaed40d0a
2025-01-23 06:08:48  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522000ecd740d0a
2025-01-23 06:08:48  INFO: queued Thu Jan 23 06:08:22 UTC 2025
2025-01-23 06:08:49  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706081ace0263c8fc079816bd0614800000000000000000010000000fae4f0d0a
2025-01-23 06:08:49  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522000fdcfd0d0a
2025-01-23 06:08:49  INFO: queued Thu Jan 23 06:08:26 UTC 2025
2025-01-23 06:08:51  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706081cce0263c8bf079816d40c14d1000000000000000001000000101e040d0a
2025-01-23 06:08:51  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220010348b0d0a
2025-01-23 06:08:51  INFO: queued Thu Jan 23 06:08:28 UTC 2025
2025-01-23 06:08:51  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706081ece0263c834079816f91114b200000000000000000100000011eb0b0d0a
2025-01-23 06:08:51  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001125020d0a
2025-01-23 06:08:51  INFO: queued Thu Jan 23 06:08:30 UTC 2025
2025-01-23 06:08:52  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060822ce0263c76b0798178f0a149d0194621531002a7401000000122efc0d0a
2025-01-23 06:08:52  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001217990d0a
2025-01-23 06:08:52  INFO: queued Thu Jan 23 06:08:34 UTC 2025
2025-01-23 06:08:53  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060828ce0263c670079818bc0c14550194621531002a740100000013e0220d0a
2025-01-23 06:08:53  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001306100d0a
2025-01-23 06:08:53  INFO: queued Thu Jan 23 06:08:40 UTC 2025
2025-01-23 06:08:54  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706082ace0263c6a3079819431214330194621531002a740100000015ac2b0d0a
2025-01-23 06:08:54  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001563260d0a
2025-01-23 06:08:54  INFO: queued Thu Jan 23 06:08:42 UTC 2025
2025-01-23 06:08:55  INFO: [T1b97822f: gt06 < 106.209.172.74] 78780a1346f0048902001a28690d0a
2025-01-23 06:08:55  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780513001a47a30d0a
2025-01-23 06:08:55  INFO: queued null
2025-01-23 06:08:56  INFO: [T1b97822f: gt06 < 106.209.172.74] 79790020940a035621860380142240498051555890008991982405155589034f001b54a30d0a
2025-01-23 06:08:56  INFO: queued null
2025-01-23 06:08:57  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878252619011706082dce0263c6a307981943191433080194621531002a7446f0042c02001c748b0d0a
2025-01-23 06:08:57  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780526001c9d860d0a
2025-01-23 06:08:57  INFO: queued Thu Jan 23 06:08:45 UTC 2025
2025-01-23 06:08:58  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060830cd0263c7d207981c041214400194621531008f8c010000001dd8920d0a
2025-01-23 06:08:58  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001def6e0d0a
2025-01-23 06:08:58  INFO: queued Thu Jan 23 06:08:48 UTC 2025
2025-01-23 06:08:59  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060838cd0263c83f07981ebf06145b0194621531008f8c010000001ee8320d0a
2025-01-23 06:08:59  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001eddf50d0a
2025-01-23 06:08:59  INFO: queued Thu Jan 23 06:08:56 UTC 2025
2025-01-23 06:09:00  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023913cc0263d2fd07981a3a1014e20000000000000000010001001f63340d0a
2025-01-23 06:09:00  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522001fcc7c0d0a
2025-01-23 06:09:00  INFO: queued Thu Jan 23 02:57:19 UTC 2025
2025-01-23 06:09:01  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023917cc0263d25e079819371414f000000000000000000100010020bed80d0a
2025-01-23 06:09:01  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002005080d0a
2025-01-23 06:09:01  INFO: queued Thu Jan 23 02:57:23 UTC 2025
2025-01-23 06:09:02  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023919cc0263d202079818871314e400000000000000000100010021c87b0d0a
2025-01-23 06:09:02  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002114810d0a
2025-01-23 06:09:02  INFO: queued Thu Jan 23 02:57:25 UTC 2025
2025-01-23 06:09:03  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011702391bcc0263d1b0079817b018150000000000000000000100010022546f0d0a
2025-01-23 06:09:03  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220022261a0d0a
2025-01-23 06:09:03  INFO: queued Thu Jan 23 02:57:27 UTC 2025
2025-01-23 06:09:04  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011702392bcc0263cf88079811b71214a5000000000000000001000100230b4d0d0a
2025-01-23 06:09:04  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002337930d0a
2025-01-23 06:09:04  INFO: queued Thu Jan 23 02:57:43 UTC 2025
2025-01-23 06:09:06  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011702393bcc0263c92c079812e11414bd0000000000000000010001002405a60d0a
2025-01-23 06:09:06  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220024432c0d0a
2025-01-23 06:09:06  INFO: queued Thu Jan 23 02:57:59 UTC 2025
2025-01-23 06:09:07  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a01cc0263c8a7079812711314e30000000000000000010001002559ca0d0a
2025-01-23 06:09:07  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002552a50d0a
2025-01-23 06:09:07  INFO: queued Thu Jan 23 02:58:01 UTC 2025
2025-01-23 06:09:08  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a03cc0263c860079811b11314fb00000000000000000100010026fd920d0a
2025-01-23 06:09:08  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220026603e0d0a
2025-01-23 06:09:08  INFO: queued Thu Jan 23 02:58:03 UTC 2025
2025-01-23 06:09:08  INFO: [T1b97822f: gt06 < 106.209.172.74] 78780a1346f004830200271ea10d0a
2025-01-23 06:09:08  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805130027adc50d0a
2025-01-23 06:09:08  INFO: queued null
2025-01-23 06:09:09  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706083acd0263c84507981f3708143f0194621531008f8c0100000028b53e0d0a
2025-01-23 06:09:09  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002889400d0a
2025-01-23 06:09:09  INFO: queued Thu Jan 23 06:08:58 UTC 2025
2025-01-23 06:09:10  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060906cd0263c82e07981fcd0014480194621531008f8c01000000291e5c0d0a
2025-01-23 06:09:10  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002998c90d0a
2025-01-23 06:09:10  INFO: queued Thu Jan 23 06:09:06 UTC 2025
2025-01-23 06:09:13  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a11cc0263c6d907980ac81b15020000000000000000010001002a58f60d0a
2025-01-23 06:09:13  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002aaa520d0a
2025-01-23 06:09:13  INFO: queued Thu Jan 23 02:58:17 UTC 2025
2025-01-23 06:09:14  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a19cc0263c5f1079806f41414f80000000000000000010001002b5dbc0d0a
2025-01-23 06:09:14  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002bbbdb0d0a
2025-01-23 06:09:14  INFO: queued Thu Jan 23 02:58:25 UTC 2025
2025-01-23 06:09:15  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a1dcc0263c574079805f20714c40000000000000000010001002cb4060d0a
2025-01-23 06:09:15  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002ccf640d0a
2025-01-23 06:09:15  INFO: queued Thu Jan 23 02:58:29 UTC 2025
2025-01-23 06:09:16  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a1fcc0263c53c0798060207146c0000000000000000010001002d87070d0a
2025-01-23 06:09:16  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002ddeed0d0a
2025-01-23 06:09:16  INFO: queued Thu Jan 23 02:58:31 UTC 2025
2025-01-23 06:09:17  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a23cc0263c4fb079806db0a14500000000000000000010001002e807d0d0a
2025-01-23 06:09:17  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002eec760d0a
2025-01-23 06:09:17  INFO: queued Thu Jan 23 02:58:35 UTC 2025
2025-01-23 06:09:18  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a25cc0263c4e7079807471114840000000000000000010001002fd2fc0d0a
2025-01-23 06:09:18  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522002ffdff0d0a
2025-01-23 06:09:18  INFO: queued Thu Jan 23 02:58:37 UTC 2025
2025-01-23 06:09:19  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117023a28cc0263c3df079807761614a400000000000000000100010030d85b0d0a
2025-01-23 06:09:19  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003015890d0a
2025-01-23 06:09:19  INFO: queued Thu Jan 23 02:58:40 UTC 2025
2025-01-23 06:09:21  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060026cc0263c3d30798053f0014000000000000000000010001003156de0d0a
2025-01-23 06:09:21  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003104000d0a
2025-01-23 06:09:21  INFO: queued Thu Jan 23 06:00:38 UTC 2025
2025-01-23 06:09:21  INFO: [T1b97822f: gt06 < 106.209.172.74] 78780a1346f0047f020032b9920d0a
2025-01-23 06:09:21  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805130032eae90d0a
2025-01-23 06:09:21  INFO: queued null
2025-01-23 06:09:25  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060208cc0263c38b079808c900140000000000000000000100010034ac9b0d0a
2025-01-23 06:09:25  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003453ad0d0a
2025-01-23 06:09:25  INFO: queued Thu Jan 23 06:02:08 UTC 2025
2025-01-23 06:09:27  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706070ccc0263c4880798059a071532000000000000000001000100350faa0d0a
2025-01-23 06:09:27  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003542240d0a
2025-01-23 06:09:27  INFO: queued Thu Jan 23 06:07:12 UTC 2025
2025-01-23 06:09:27  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060712cc0263c4d10798058300140e0000000000000000010001003639a70d0a
2025-01-23 06:09:27  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003670bf0d0a
2025-01-23 06:09:27  INFO: queued Thu Jan 23 06:07:18 UTC 2025
2025-01-23 06:09:28  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706071acc0263c5390798060e0a144b0000000000000000010001003775c60d0a
2025-01-23 06:09:28  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003761360d0a
2025-01-23 06:09:28  INFO: queued Thu Jan 23 06:07:26 UTC 2025
2025-01-23 06:09:29  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706071ecc0263c54e079806bc0e145f0000000000000000010001003857b70d0a
2025-01-23 06:09:29  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003899c10d0a
2025-01-23 06:09:29  INFO: queued Thu Jan 23 06:07:30 UTC 2025
2025-01-23 06:09:30  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060720cc0263c572079807320c144600000000000000000100010039a4510d0a
2025-01-23 06:09:30  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003988480d0a
2025-01-23 06:09:30  INFO: queued Thu Jan 23 06:07:32 UTC 2025
2025-01-23 06:09:31  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060728cc0263c5bf079809310814650000000000000000010001003a8a3a0d0a
2025-01-23 06:09:31  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003abad30d0a
2025-01-23 06:09:31  INFO: queued Thu Jan 23 06:07:40 UTC 2025
2025-01-23 06:09:32  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706072acc0263c5df0798099c0a14480000000000000000010001003b32060d0a
2025-01-23 06:09:32  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003bab5a0d0a
2025-01-23 06:09:32  INFO: queued Thu Jan 23 06:07:42 UTC 2025
2025-01-23 06:09:33  INFO: [T1b97822f: gt06 < 106.209.172.74] 78780a1346f0047c02003c75210d0a
2025-01-23 06:09:33  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780513003c03970d0a
2025-01-23 06:09:33  INFO: queued null
2025-01-23 06:09:37  INFO: [T1b97822f: gt06 < 106.209.172.74] 7878222219011706072ecc0263c64307980ad710143d0000000000000000010001003e1e4b0d0a
2025-01-23 06:09:37  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003efcf70d0a
2025-01-23 06:09:37  INFO: queued Thu Jan 23 06:07:46 UTC 2025
2025-01-23 06:09:38  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060732cc0263c68c07980c120f14520000000000000000010001003f2a6c0d0a
2025-01-23 06:09:38  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522003fed7e0d0a
2025-01-23 06:09:38  INFO: queued Thu Jan 23 06:07:50 UTC 2025
2025-01-23 06:09:39  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060736cc0263c6f807980d1e0d143d0000000000000000010001004004b10d0a
2025-01-23 06:09:39  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805220040660e0d0a
2025-01-23 06:09:39  INFO: queued Thu Jan 23 06:07:54 UTC 2025
2025-01-23 06:09:40  INFO: [T1b97822f: gt06 < 106.209.172.74] 78782222190117060738cc0263c72507980dcc11145400000000000000000100010041506d0d0a
2025-01-23 06:09:40  INFO: [T1b97822f: gt06 > 106.209.172.74] 78780522004177870d0a
2025-01-23 06:09:40  INFO: queued Thu Jan 23 06:07:56 UTC 2025
2025-01-23 06:09:41  INFO: [T1b97822f: gt06 < 106.209.172.74] 78780a1346f0047a020042a4420d0a
2025-01-23 06:09:41  INFO: [T1b97822f: gt06 > 106.209.172.74] 787805130042996e0d0a
2025-01-23 06:09:41  INFO: queued null
2025-01-23 06:10:00  INFO: released Thu Jan 23 02:57:19 UTC 2025
2025-01-23 06:10:00  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:00, lat: 22.27584, lon: 70.78261, speed: 8.6, course: 226.0
2025-01-23 06:10:01  INFO: released Thu Jan 23 02:57:23 UTC 2025
2025-01-23 06:10:01  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:01, lat: 22.27575, lon: 70.78247, speed: 10.8, course: 240.0
2025-01-23 06:10:02  INFO: released Thu Jan 23 02:57:25 UTC 2025
2025-01-23 06:10:02  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:02, lat: 22.27570, lon: 70.78237, speed: 10.3, course: 228.0
2025-01-23 06:10:03  INFO: released Thu Jan 23 02:57:27 UTC 2025
2025-01-23 06:10:03  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:03, lat: 22.27565, lon: 70.78225, speed: 13.0, course: 256.0
2025-01-23 06:10:04  INFO: released Thu Jan 23 02:57:43 UTC 2025
2025-01-23 06:10:04  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:04, lat: 22.27535, lon: 70.78140, speed: 9.7, course: 165.0
2025-01-23 06:10:06  INFO: released Thu Jan 23 02:57:59 UTC 2025
2025-01-23 06:10:06  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:06, lat: 22.27444, lon: 70.78157, speed: 10.8, course: 189.0
2025-01-23 06:10:07  INFO: released Thu Jan 23 02:58:01 UTC 2025
2025-01-23 06:10:07  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:07, lat: 22.27437, lon: 70.78150, speed: 10.3, course: 227.0
2025-01-23 06:10:08  INFO: released Thu Jan 23 02:58:03 UTC 2025
2025-01-23 06:10:08  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:08, lat: 22.27433, lon: 70.78140, speed: 10.3, course: 251.0
2025-01-23 06:10:13  INFO: released Thu Jan 23 02:58:17 UTC 2025
2025-01-23 06:10:13  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:13, lat: 22.27411, lon: 70.78041, speed: 14.6, course: 258.0
2025-01-23 06:10:14  INFO: released Thu Jan 23 02:58:25 UTC 2025
2025-01-23 06:10:14  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:14, lat: 22.27398, lon: 70.77987, speed: 10.8, course: 248.0
2025-01-23 06:10:15  INFO: released Thu Jan 23 02:58:29 UTC 2025
2025-01-23 06:10:15  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:15, lat: 22.27391, lon: 70.77973, speed: 3.8, course: 196.0
2025-01-23 06:10:16  INFO: released Thu Jan 23 02:58:31 UTC 2025
2025-01-23 06:10:16  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:16, lat: 22.27388, lon: 70.77973, speed: 3.8, course: 108.0
2025-01-23 06:10:17  INFO: released Thu Jan 23 02:58:35 UTC 2025
2025-01-23 06:10:17  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:17, lat: 22.27385, lon: 70.77986, speed: 5.4, course: 80.0
2025-01-23 06:10:18  INFO: released Thu Jan 23 02:58:37 UTC 2025
2025-01-23 06:10:18  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:18, lat: 22.27384, lon: 70.77992, speed: 9.2, course: 132.0
2025-01-23 06:10:19  INFO: released Thu Jan 23 02:58:40 UTC 2025
2025-01-23 06:10:19  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:19, lat: 22.27369, lon: 70.77994, speed: 11.9, course: 164.0
2025-01-23 06:10:21  INFO: released Thu Jan 23 06:00:38 UTC 2025
2025-01-23 06:10:21  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:21, lat: 22.27368, lon: 70.77963, course: 0.0
2025-01-23 06:10:25  INFO: released Thu Jan 23 06:02:08 UTC 2025
2025-01-23 06:10:25  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:25, lat: 22.27364, lon: 70.78013, course: 0.0
2025-01-23 06:10:27  INFO: released Thu Jan 23 06:07:12 UTC 2025
2025-01-23 06:10:27  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:27, lat: 22.27378, lon: 70.77968, speed: 3.8, course: 306.0
2025-01-23 06:10:27  INFO: released Thu Jan 23 06:07:18 UTC 2025
2025-01-23 06:10:27  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:27, lat: 22.27382, lon: 70.77966, course: 14.0
2025-01-23 06:10:28  INFO: released Thu Jan 23 06:07:26 UTC 2025
2025-01-23 06:10:28  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:28, lat: 22.27388, lon: 70.77974, speed: 5.4, course: 75.0
2025-01-23 06:10:29  INFO: released Thu Jan 23 06:07:30 UTC 2025
2025-01-23 06:10:29  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:29, lat: 22.27389, lon: 70.77984, speed: 7.6, course: 95.0
2025-01-23 06:10:30  INFO: released Thu Jan 23 06:07:32 UTC 2025
2025-01-23 06:10:30  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:30, lat: 22.27391, lon: 70.77990, speed: 6.5, course: 70.0
2025-01-23 06:10:31  INFO: released Thu Jan 23 06:07:40 UTC 2025
2025-01-23 06:10:31  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:31, lat: 22.27396, lon: 70.78019, speed: 4.3, course: 101.0
2025-01-23 06:10:32  INFO: released Thu Jan 23 06:07:42 UTC 2025
2025-01-23 06:10:32  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:32, lat: 22.27397, lon: 70.78025, speed: 5.4, course: 72.0
2025-01-23 06:10:37  INFO: released Thu Jan 23 06:07:46 UTC 2025
2025-01-23 06:10:37  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:37, lat: 22.27403, lon: 70.78042, speed: 8.6, course: 61.0
2025-01-23 06:10:38  INFO: released Thu Jan 23 06:07:50 UTC 2025
2025-01-23 06:10:38  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:38, lat: 22.27407, lon: 70.78060, speed: 8.1, course: 82.0
2025-01-23 06:10:39  INFO: released Thu Jan 23 06:07:54 UTC 2025
2025-01-23 06:10:39  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:39, lat: 22.27413, lon: 70.78075, speed: 7.0, course: 61.0
2025-01-23 06:10:40  INFO: released Thu Jan 23 06:07:56 UTC 2025
2025-01-23 06:10:40  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:40, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:40  INFO: released Thu Jan 23 06:08:20 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:47, lat: 22.27436, lon: 70.78186, speed: 5.9, course: 49.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:22 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:48, lat: 22.27440, lon: 70.78195, speed: 5.4, course: 73.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:26 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:49, lat: 22.27442, lon: 70.78211, speed: 3.2, course: 128.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:28 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:51, lat: 22.27438, lon: 70.78213, speed: 6.5, course: 209.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:30 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:51, lat: 22.27430, lon: 70.78215, speed: 9.2, course: 178.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:34 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:52, lat: 22.27419, lon: 70.78223, speed: 5.4, course: 157.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:40 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:53, lat: 22.27405, lon: 70.78240, speed: 6.5, course: 85.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:42 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:54, lat: 22.27408, lon: 70.78247, speed: 9.7, course: 51.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:45 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:46, lat: 22.27417, lon: 70.78265, speed: 13.5, course: 59.0
2025-01-23 06:10:41  INFO: released null
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:55, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:41  INFO: released null
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:56, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:45 UTC 2025
2025-01-23 06:10:41  INFO: Event id: 356218603801422, time: 2025-01-23 06:08:57, type: alarm, notifications: 0
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:57, lat: 22.27408, lon: 70.78247, speed: 13.5, course: 51.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:48 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:58, lat: 22.27425, lon: 70.78286, speed: 9.7, course: 64.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:56 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:08:59, lat: 22.27431, lon: 70.78325, speed: 3.2, course: 91.0
2025-01-23 06:10:41  INFO: released null
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:08, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:08:58 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:09, lat: 22.27431, lon: 70.78332, speed: 4.3, course: 63.0
2025-01-23 06:10:41  INFO: released Thu Jan 23 06:09:06 UTC 2025
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:10, lat: 22.27430, lon: 70.78340, course: 72.0
2025-01-23 06:10:41  INFO: released null
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:21, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:41  INFO: released null
2025-01-23 06:10:41  INFO: [T1b97822f] id: 356218603801422, time: 2025-01-23 06:09:33, lat: 22.27415, lon: 70.78084, speed: 9.2, course: 84.0
2025-01-23 06:10:41  INFO: released null

It seems like the buffered data from the device (collected when it was offline) is sent to the server after newer data, resulting in the sequence issue. However, I am unsure what exactly is causing this behavior or how to resolve it.

Could this be related to my time.override setting (serverTime) or the buffering configuration (server.buffering.threshold)? Are there other parameters I need to adjust, or is there a specific way to handle such cases where old buffered records are received?

I would appreciate any guidance or suggestions on how to ensure that the records are correctly ordered in the positions table.

Thank you for your help!
Screenshot 2025-01-23 061341.png

Anton Tananaev4 days ago

Try removing buffering. In this case buffering is not ideal because your device doesn't always sent the time.

Tejas Bhatt3 days ago

Yes, I have tried it but it doesn't work
In GT06, there is something re-transmition logic.

Is that by default enabled or should I need anything to enable it ?

maani2 days ago

tejas , can you see that your device(for example your vehicle) being online in traccar ?

Tejas Bhatt2 days ago

@manni, at time of no network device was not online.
But it depends time for how long it was not in network