Traccar Device Freezing issue
Check netstat to see how many active connection you have.
Like 6000 active connections.
I don't really see anything that would indicate an issue with the service itself.
I also tried my best to identify the issue. Couldn’t it be a caching issue? cause I see the communication between devices but the frontend doesn’t update.
I directly access port 8082 and The websocket also connected.
I can guarantee that because some devices still work.
Is data coming from devices? You see it's stored in the database? You need to trace all the chain and see where the issue is. Is it device not reporting data? Is it failing somewhere in between? Is it just the UI?
for sure Device reporting data cause I see the historical data after I restart the server.
Im outside right now. will check the database and the log as well.
Make sure you check the timestamps and errors.
2024-07-21 03:52:41 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:27, lat: 6.89521, lon: 79.97864, speed: 43.2, course: 191.0
2024-07-21 03:52:42 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:37, lat: 6.89323, lon: 79.97820, speed: 42.7, course: 194.0
2024-07-21 03:52:45 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:05, lat: 7.00889, lon: 79.95865, speed: 42.7, course: 131.0
2024-07-21 03:52:46 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:12, lat: 7.00789, lon: 79.95956, speed: 41.6, course: 143.0
2024-07-21 03:52:47 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:18, lat: 7.00687, lon: 79.96011, speed: 41.0, course: 153.0
2024-07-21 03:52:48 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:24, lat: 7.00572, lon: 79.96053, speed: 42.7, course: 165.0
2024-07-21 03:52:49 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:34, lat: 7.00370, lon: 79.96091, speed: 42.1, course: 170.0
2024-07-21 03:52:50 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:44, lat: 7.00176, lon: 79.96124, speed: 41.0, course: 169.0
2024-07-21 03:52:51 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:42:54, lat: 6.99980, lon: 79.96159, speed: 42.7, course: 170.0
2024-07-21 03:52:52 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:04, lat: 6.99783, lon: 79.96193, speed: 42.7, course: 170.0
2024-07-21 03:52:53 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:37, lat: 6.89323, lon: 79.97820, speed: 42.7, course: 194.0
2024-07-21 03:52:54 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:47, lat: 6.89131, lon: 79.97771, speed: 43.7, course: 193.0
2024-07-21 03:52:57 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:14, lat: 6.99587, lon: 79.96231, speed: 43.2, course: 168.0
2024-07-21 03:52:58 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:24, lat: 6.99390, lon: 79.96278, speed: 43.2, course: 164.0
2024-07-21 03:52:59 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:34, lat: 6.99199, lon: 79.96334, speed: 41.6, course: 162.0
2024-07-21 03:53:00 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:44, lat: 6.99013, lon: 79.96400, speed: 42.1, course: 160.0
2024-07-21 03:53:01 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:43:54, lat: 6.98828, lon: 79.96471, speed: 42.7, course: 157.0
2024-07-21 03:53:02 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:04, lat: 6.98649, lon: 79.96548, speed: 41.0, course: 155.0
2024-07-21 03:53:03 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:14, lat: 6.98475, lon: 79.96630, speed: 41.0, course: 154.0
2024-07-21 03:53:04 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:24, lat: 6.98303, lon: 79.96715, speed: 41.0, course: 154.0
2024-07-21 03:53:05 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:47, lat: 6.89131, lon: 79.97771, speed: 43.7, course: 193.0
2024-07-21 03:53:06 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:52:57, lat: 6.88935, lon: 79.97724, speed: 41.0, course: 192.0
2024-07-21 03:53:08 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:53:07, lat: 6.88739, lon: 79.97690, speed: 41.6, course: 188.0
2024-07-21 03:53:09 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:34, lat: 6.98123, lon: 79.96794, speed: 42.7, course: 157.0
2024-07-21 03:53:10 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:44, lat: 6.97938, lon: 79.96866, speed: 42.1, course: 159.0
2024-07-21 03:53:11 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:44:54, lat: 6.97753, lon: 79.96927, speed: 42.1, course: 161.0
2024-07-21 03:53:12 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:05, lat: 6.97542, lon: 79.97004, speed: 44.3, course: 158.0
2024-07-21 03:53:13 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:15, lat: 6.97352, lon: 79.97081, speed: 43.2, course: 156.0
2024-07-21 03:53:14 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:25, lat: 6.97168, lon: 79.97167, speed: 43.7, course: 153.0
2024-07-21 03:53:15 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:35, lat: 6.96988, lon: 79.97258, speed: 42.1, course: 154.0
2024-07-21 03:53:16 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:45, lat: 6.96805, lon: 79.97336, speed: 40.5, course: 158.0
2024-07-21 03:53:17 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:53:07, lat: 6.88739, lon: 79.97690, speed: 41.6, course: 188.0
2024-07-21 03:53:18 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:53:17, lat: 6.88545, lon: 79.97670, speed: 43.2, course: 184.0
2024-07-21 03:53:19 INFO: [Tb882f27f: gt06 < xxx.104.224.225] 79790020940a0867111062198954413016688877170089940102166888771737014f2c9e0d0a
2024-07-21 03:53:19 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:53:17, lat: 6.88545, lon: 79.97670, speed: 43.2, course: 184.0
2024-07-21 03:53:21 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:45:55, lat: 6.96633, lon: 79.97406, speed: 40.5, course: 158.0
2024-07-21 03:53:22 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:05, lat: 6.96458, lon: 79.97470, speed: 40.5, course: 161.0
2024-07-21 03:53:23 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:15, lat: 6.96277, lon: 79.97527, speed: 40.5, course: 163.0
2024-07-21 03:53:24 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:25, lat: 6.96090, lon: 79.97580, speed: 41.0, course: 165.0
2024-07-21 03:53:25 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:35, lat: 6.95902, lon: 79.97621, speed: 40.5, course: 171.0
2024-07-21 03:53:26 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:45, lat: 6.95715, lon: 79.97642, speed: 41.6, course: 174.0
2024-07-21 03:53:27 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:46:55, lat: 6.95520, lon: 79.97656, speed: 41.0, course: 179.0
2024-07-21 03:53:28 INFO: [Tb882f27f] id: 867111062198954, time: 2024-07-21 03:47:05, lat: 6.95328, lon: 79.97651, speed: 41.6, course: 182.0
2024-07-21 03:54:53 INFO: [T48306b47: gt06 < xxx.104.224.225] 78781101086711106219895400000002016859570d0a
2024-07-21 03:55:33 INFO: [T48306b47: gt06 < xxx.104.224.225] 78781101086711106219895400000002016d0efa0d0a
2024-07-21 03:56:34 INFO: [T876c988b: gt06 < xxx.104.224.225] 78781101086711106219895400000002017483ba0d0a
2024-07-21 03:57:14 INFO: [T876c988b: gt06 < xxx.104.224.225] 787811010867111062198954000000020179585f0d0a
2024-07-21 03:58:30 INFO: Event id: 867111062198954, time: 2024-07-21 03:58:30, type: deviceOffline, notifications: 1
2024-07-21 03:58:45 INFO: [Te503e307: gt06 < xxx.104.224.225] 787811010867111062198954000000020183008a0d0a
2024-07-21 03:58:45 INFO: Event id: 867111062198954, time: 2024-07-21 03:58:45, type: deviceOnline, notifications: 0
2024-07-21 03:59:25 INFO: [Te503e307: gt06 < xxx.104.224.225] 787811010867111062198954000000020188be590d0a
2024-07-21 04:00:56 INFO: [T3ed94ff9: gt06 < xxx.104.224.225] 78781101086711106219895400000002019201820d0a
2024-07-21 04:01:36 INFO: [T3ed94ff9: gt06 < xxx.104.224.225] 787811010867111062198954000000020197562f0d0a
2024-07-21 04:03:07 INFO: [Te644dc86: gt06 < xxx.104.224.225] 7878110108671110621989540000000201a1029a0d0a
2024-07-21 04:03:47 INFO: [Te644dc86: gt06 < xxx.104.224.225] 7878110108671110621989540000000201a676250d0a
2024-07-21 04:05:18 INFO: [Tcf532aea: gt06 < xxx.104.224.225] 7878110108671110621989540000000201b003920d0a
2024-07-21 04:05:58 INFO: [Tcf532aea: gt06 < xxx.104.224.225] 7878110108671110621989540000000201b5543f0d0a
2024-07-21 04:07:30 INFO: [T3fb6bee8: gt06 < xxx.104.224.225] 7878110108671110621989540000000201bffb650d0a
2024-07-21 04:08:11 INFO: [T3fb6bee8: gt06 < xxx.104.224.225] 7878110108671110621989540000000201c436310d0a
2024-07-21 04:09:41 INFO: [Tcc958571: gt06 < xxx.104.224.225] 7878110108671110621989540000000201d060940d0a
2024-07-21 04:10:20 INFO: [Tcc958571: gt06 < xxx.104.224.225] 7878110108671110621989540000000201d1711d0d0a
2024-07-21 04:11:52 INFO: [T5bdafd9f: gt06 < xxx.104.224.225] 7878110108671110621989540000000201d537390d0a
2024-07-21 04:12:31 INFO: [T5bdafd9f: gt06 < xxx.104.224.225] 7878110108671110621989540000000201dacfce0d0a
2024-07-21 04:14:03 INFO: [T6a5f477f: gt06 < xxx.104.224.225] 7878110108671110621989540000000201e1409e0d0a
2024-07-21 04:14:42 INFO: [T6a5f477f: gt06 < xxx.104.224.225] 7878110108671110621989540000000201e506ba0d0a
2024-07-21 04:16:15 INFO: [T011914f6: gt06 < xxx.104.224.225] 7878110108671110621989540000000201efa9e00d0a
2024-07-21 04:16:54 INFO: [T011914f6: gt06 < xxx.104.224.225] 7878110108671110621989540000000201f3730d0d0a
2024-07-21 04:18:20 INFO: [Ta39f25aa: gt06 < xxx.104.231.157] 7878110108671110621989540000000200028cd30d0a
2024-07-21 04:18:21 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:53:17, lat: 6.88545, lon: 79.97670, speed: 43.2, course: 184.0
2024-07-21 04:18:22 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:53:27, lat: 6.88347, lon: 79.97664, speed: 42.7, course: 179.0
2024-07-21 04:18:23 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:53:37, lat: 6.88145, lon: 79.97674, speed: 42.1, course: 175.0
2024-07-21 04:18:24 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:53:47, lat: 6.87946, lon: 79.97698, speed: 42.7, course: 171.0
2024-07-21 04:18:25 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:53:57, lat: 6.87750, lon: 79.97736, speed: 42.1, course: 167.0
2024-07-21 04:18:26 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:54:07, lat: 6.87555, lon: 79.97775, speed: 44.3, course: 169.0
2024-07-21 04:18:27 INFO: [Ta39f25aa] id: 867111062198954, time: 2024-07-21 03:54:17, lat: 6.87357, lon: 79.97808, speed: 41.6, course: 171.0
2024-07-21 04:19:53 INFO: [T2db20f99: gt06 < xxx.104.231.157] 78781101086711106219895400000002001c752c0d0a
2024-07-21 04:20:33 INFO: [T2db20f99: gt06 < xxx.104.231.157] 7878110108671110621989540000000200219f4a0d0a
2024-07-21 04:21:34 INFO: [Te4138bcf: gt06 < xxx.104.231.157] 78781101086711106219895400000002002913020d0a
2024-07-21 04:22:14 INFO: [Te4138bcf: gt06 < xxx.104.231.157] 787811010867111062198954000000020033acd90d0a
2024-07-21 04:23:45 INFO: [T0b4ac54d: gt06 < xxx.104.231.157] 78781101086711106219895400000002003f66b50d0a
2024-07-21 04:24:25 INFO: [T0b4ac54d: gt06 < xxx.104.231.157] 787811010867111062198954000000020044abe10d0a
2024-07-21 04:25:56 INFO: [T00ab1802: gt06 < xxx.104.231.157] 787811010867111062198954000000020050fd440d0a
2024-07-21 04:26:36 INFO: [T00ab1802: gt06 < xxx.104.231.157] 787811010867111062198954000000020054bb600d0a
2024-07-21 04:28:08 INFO: [Td45bdecf: gt06 < xxx.104.231.157] 787811010867111062198954000000020060ccc70d0a
2024-07-21 04:28:47 INFO: [Td45bdecf: gt06 < xxx.104.231.157] 787811010867111062198954000000020066a9f10d0a
2024-07-21 04:30:19 INFO: [Tbf9d4be9: gt06 < xxx.104.231.157] 7878110108671110621989540000000200758beb0d0a
2024-07-21 04:30:58 INFO: [Tbf9d4be9: gt06 < xxx.104.231.157] 78781101086711106219895400000002007941870d0a
2024-07-21 04:32:30 INFO: [T0c201507: gt06 < xxx.104.231.157] 787811010867111062198954000000020088a7810d0a
2024-07-21 04:33:09 INFO: [T0c201507: gt06 < xxx.104.231.157] 78781101086711106219895400000002008b951a0d0a
2024-07-21 04:34:45 INFO: [Tb20b2380: gt06 < xxx.104.231.157] 7878110108671110621989540000000200947d6c0d0a
2024-07-21 04:35:21 INFO: [Tb20b2380: gt06 < xxx.104.231.157] 78781101086711106219895400000002009a94120d0a
2024-07-21 04:36:52 INFO: [T869bf610: gt06 < xxx.104.231.157] 7878110108671110621989540000000200a55d660d0a
2024-07-21 04:37:32 INFO: [T869bf610: gt06 < xxx.104.231.157] 7878110108671110621989540000000200aaa5910d0a
2024-07-21 04:39:03 INFO: [T54efb9f7: gt06 < xxx.104.231.157] 7878110108671110621989540000000200b328d10d0a
2024-07-21 04:39:43 INFO: [T54efb9f7: gt06 < xxx.104.231.157] 7878110108671110621989540000000200b896020d0a
2024-07-21 04:41:15 INFO: [Tf183a340: gt06 < xxx.104.231.157] 7878110108671110621989540000000200c178440d0a
2024-07-21 04:41:54 INFO: [Tf183a340: gt06 < xxx.104.231.157] 7878110108671110621989540000000200c53e600d0a
2024-07-21 04:43:20 INFO: [Tbbb1d717: gt06 < xxx.104.231.191] 7878110108671110621989540000000200028cd30d0a
2024-07-21 04:43:21 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:54:37, lat: 6.86968, lon: 79.97845, speed: 42.1, course: 177.0
2024-07-21 04:43:22 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:54:47, lat: 6.86762, lon: 79.97846, speed: 44.8, course: 180.0
2024-07-21 04:43:23 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:54:58, lat: 6.86534, lon: 79.97838, speed: 43.2, course: 184.0
2024-07-21 04:43:24 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:55:08, lat: 6.86339, lon: 79.97821, speed: 42.1, course: 185.0
2024-07-21 04:43:25 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:55:18, lat: 6.86138, lon: 79.97801, speed: 42.1, course: 186.0
2024-07-21 04:43:26 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:55:28, lat: 6.85942, lon: 79.97787, speed: 43.7, course: 182.0
2024-07-21 04:43:27 INFO: [Tbbb1d717] id: 867111062198954, time: 2024-07-21 03:55:38, lat: 6.85736, lon: 79.97782, speed: 44.8, course: 178.0
2024-07-21 04:44:54 INFO: [T34bd17ae: gt06 < xxx.104.231.191] 78781101086711106219895400000002001833080d0a
2024-07-21 04:45:33 INFO: [T34bd17ae: gt06 < xxx.104.231.191] 78781101086711106219895400000002001d64a50d0a
2024-07-21 04:46:35 INFO: [T2cf8b591: gt06 < xxx.104.231.191] 787811010867111062198954000000020025d96e0d0a
2024-07-21 04:47:15 INFO: [T2cf8b591: gt06 < xxx.104.231.191] 78781101086711106219895400000002002a21990d0a
2024-07-21 04:48:46 INFO: [T417bcbd8: gt06 < xxx.104.231.191] 787811010867111062198954000000020037eafd0d0a
2024-07-21 04:49:25 INFO: [T417bcbd8: gt06 < xxx.104.231.191] 78781101086711106219895400000002003b20910d0a
2024-07-21 04:50:58 INFO: [T05328c7d: gt06 < xxx.104.231.191] 787811010867111062198954000000020045ba680d0a
2024-07-21 04:51:37 INFO: [T05328c7d: gt06 < xxx.104.231.191] 78781101086711106219895400000002004a429f0d0a
2024-07-21 04:53:09 INFO: [Td012fde6: gt06 < xxx.104.231.191] 787811010867111062198954000000020053cfdf0d0a
2024-07-21 04:53:48 INFO: [Td012fde6: gt06 < xxx.104.231.191] 787811010867111062198954000000020058710c0d0a
2024-07-21 04:55:20 INFO: [T42021408: gt06 < xxx.104.231.191] 787811010867111062198954000000020062efd50d0a
2024-07-21 04:55:59 INFO: [T42021408: gt06 < xxx.104.231.191] 787811010867111062198954000000020067b8780d0a
2024-07-21 04:57:31 INFO: [Ta7a22b05: gt06 < xxx.104.231.191] 78781101086711106219895400000002006f34300d0a
2024-07-21 04:58:10 INFO: [Ta7a22b05: gt06 < xxx.104.231.191] 7878110108671110621989540000000200749a620d0a
2024-07-21 04:59:42 INFO: [Tce323d5a: gt06 < xxx.104.231.191] 78781101086711106219895400000002007c162a0d0a
2024-07-21 05:00:22 INFO: [Tce323d5a: gt06 < xxx.104.231.191] 78781101086711106219895400000002007d07a30d0a
2024-07-21 05:01:57 INFO: [T11f3c8c8: gt06 < xxx.104.231.191] 7878110108671110621989540000000200802bc90d0a
2024-07-21 05:02:36 INFO: [T11f3c8c8: gt06 < xxx.104.231.191] 7878110108671110621989540000000200846ded0d0aHey I noticed that the records save on the log with a delay. above is a part of the result from grep 867111062198954 tracker-server.log
you see the device time and the server time. in some cases, more than 1 hour gap.
MariaDB [traccar]> SELECT devicetime, servertime, latitude, longitude, speed, TIMESTAMPDIFF(MINUTE, devicetime, servertime) AS time_difference_minutes FROM tc_positions WHERE deviceid = 10971 ORDER BY id DESC LIMIT 100;
+---------------------+---------------------+--------------------+-------------------+---------+-------------------------+
| devicetime | servertime | latitude | longitude | speed | time_difference_minutes |
+---------------------+---------------------+--------------------+-------------------+---------+-------------------------+
| 2024-07-21 05:22:08 | 2024-07-21 05:22:08 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:21:28 | 2024-07-21 05:21:28 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:18:32 | 2024-07-21 05:18:32 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:06:30 | 2024-07-21 05:18:31 | 6.605961111111111 | 79.95545 | 0 | 12 |
| 2024-07-21 05:06:04 | 2024-07-21 05:18:30 | 6.604945 | 79.95535 | 11.3391 | 12 |
| 2024-07-21 05:06:02 | 2024-07-21 05:18:29 | 6.604828333333334 | 79.95535833333334 | 11.3391 | 12 |
| 2024-07-21 05:06:00 | 2024-07-21 05:18:28 | 6.6047094444444445 | 79.9554038888889 | 14.0389 | 12 |
| 2024-07-21 05:05:56 | 2024-07-21 05:18:27 | 6.6044849999999995 | 79.95549000000001 | 10.2592 | 12 |
| 2024-07-21 05:18:25 | 2024-07-21 05:18:25 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:18:23 | 2024-07-21 05:18:23 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:05:52 | 2024-07-21 05:18:22 | 6.604302777777778 | 79.95558666666668 | 10.7991 | 12 |
| 2024-07-21 05:05:36 | 2024-07-21 05:18:21 | 6.6035305555555555 | 79.95595833333333 | 5.39957 | 12 |
| 2024-07-21 05:05:16 | 2024-07-21 05:18:20 | 6.603428888888889 | 79.95600999999999 | 0 | 13 |
| 2024-07-21 05:05:00 | 2024-07-21 05:18:19 | 6.603026111111111 | 79.95626388888888 | 15.1188 | 13 |
| 2024-07-21 05:04:50 | 2024-07-21 05:18:18 | 6.602460555555556 | 79.95659833333335 | 10.2592 | 13 |
| 2024-07-21 05:04:46 | 2024-07-21 05:18:17 | 6.60229 | 79.95665277777778 | 8.09935 | 13 |
| 2024-07-21 05:04:42 | 2024-07-21 05:18:16 | 6.602173333333334 | 79.95662888888889 | 4.31966 | 13 |
| 2024-07-21 05:04:16 | 2024-07-21 05:18:15 | 6.601794444444445 | 79.95578944444443 | 5.39957 | 13 |
| 2024-07-21 05:18:11 | 2024-07-21 05:18:11 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:04:14 | 2024-07-21 05:18:10 | 6.601766111111111 | 79.95574722222221 | 4.31966 | 13 |
| 2024-07-21 05:04:04 | 2024-07-21 05:18:09 | 6.601719444444445 | 79.95573277777778 | 0 | 14 |
| 2024-07-21 05:03:53 | 2024-07-21 05:18:08 | 6.601086666666667 | 79.95604833333334 | 21.5983 | 14 |
| 2024-07-21 05:03:43 | 2024-07-21 05:18:07 | 6.600211666666667 | 79.95659500000001 | 21.0583 | 14 |
| 2024-07-21 05:03:33 | 2024-07-21 05:18:06 | 6.5993627777777775 | 79.95713444444443 | 20.5184 | 14 |
| 2024-07-21 05:03:23 | 2024-07-21 05:18:05 | 6.598563888888888 | 79.95768666666667 | 19.4385 | 14 |
| 2024-07-21 05:03:11 | 2024-07-21 05:18:04 | 6.597730555555556 | 79.95820222222223 | 18.3585 | 14 |
| 2024-07-21 05:03:01 | 2024-07-21 05:18:03 | 6.596977777777778 | 79.95861611111111 | 18.3585 | 15 |
| 2024-07-21 05:17:59 | 2024-07-21 05:17:59 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 05:02:47 | 2024-07-21 05:17:58 | 6.595890000000001 | 79.95886555555556 | 16.7387 | 15 |
| 2024-07-21 05:02:31 | 2024-07-21 05:17:57 | 6.594792777777777 | 79.95895166666666 | 13.4989 | 15 |
| 2024-07-21 05:02:13 | 2024-07-21 05:17:56 | 6.593748333333334 | 79.95908444444444 | 15.6588 | 15 |
| 2024-07-21 05:01:59 | 2024-07-21 05:17:55 | 6.592638333333333 | 79.95919666666666 | 18.3585 | 15 |
| 2024-07-21 05:01:47 | 2024-07-21 05:17:54 | 6.591550555555555 | 79.95927722222223 | 19.4385 | 16 |
| 2024-07-21 05:01:29 | 2024-07-21 05:17:53 | 6.590357777777778 | 79.95937277777777 | 5.93953 | 16 |
| 2024-07-21 04:59:32 | 2024-07-21 05:17:52 | 6.589293333333333 | 79.95948222222222 | 19.9784 | 18 |
| 2024-07-21 04:59:20 | 2024-07-21 05:17:51 | 6.588156111111111 | 79.95962055555556 | 18.8985 | 18 |
| 2024-07-21 05:17:47 | 2024-07-21 05:17:47 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:59:02 | 2024-07-21 05:17:46 | 6.587051111111111 | 79.9597011111111 | 10.2592 | 18 |
| 2024-07-21 04:58:56 | 2024-07-21 05:17:45 | 6.586768333333333 | 79.95976222222222 | 10.7991 | 18 |
| 2024-07-21 04:58:40 | 2024-07-21 05:17:44 | 6.5861816666666675 | 79.96007444444444 | 9.71923 | 19 |
| 2024-07-21 04:58:32 | 2024-07-21 05:17:43 | 6.585853888888889 | 79.96030777777779 | 8.63931 | 19 |
| 2024-07-21 04:58:16 | 2024-07-21 05:17:42 | 6.585618333333333 | 79.96043499999999 | 0 | 19 |
| 2024-07-21 04:58:02 | 2024-07-21 05:17:41 | 6.5853544444444445 | 79.96051666666666 | 3.23974 | 19 |
| 2024-07-21 04:57:50 | 2024-07-21 05:17:40 | 6.585333888888889 | 79.96065333333334 | 4.31966 | 19 |
| 2024-07-21 04:57:48 | 2024-07-21 05:17:39 | 6.585368333333333 | 79.9606811111111 | 4.85961 | 19 |
| 2024-07-21 05:17:35 | 2024-07-21 05:17:35 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:57:46 | 2024-07-21 05:17:34 | 6.585413888888889 | 79.96068555555556 | 4.85961 | 19 |
| 2024-07-21 04:57:08 | 2024-07-21 05:17:33 | 6.585868333333333 | 79.96038 | 0 | 20 |
| 2024-07-21 04:56:52 | 2024-07-21 05:17:32 | 6.586473333333334 | 79.95986888888889 | 16.1987 | 20 |
| 2024-07-21 04:56:50 | 2024-07-21 05:17:31 | 6.586608333333333 | 79.95980999999999 | 14.5788 | 20 |
| 2024-07-21 04:56:38 | 2024-07-21 05:17:30 | 6.587383333333333 | 79.95970444444444 | 15.6588 | 20 |
| 2024-07-21 04:56:26 | 2024-07-21 05:17:29 | 6.588586111111112 | 79.95960666666667 | 26.4579 | 21 |
| 2024-07-21 04:56:16 | 2024-07-21 05:17:28 | 6.590053888888889 | 79.95948277777778 | 32.9374 | 21 |
| 2024-07-21 04:56:05 | 2024-07-21 05:17:27 | 6.591706666666667 | 79.95934833333334 | 32.3974 | 21 |
| 2024-07-21 05:17:23 | 2024-07-21 05:17:23 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:55:55 | 2024-07-21 05:17:22 | 6.593153888888889 | 79.95919277777777 | 27.5378 | 21 |
| 2024-07-21 04:55:43 | 2024-07-21 05:17:21 | 6.59441888888889 | 79.95908499999999 | 24.2981 | 21 |
| 2024-07-21 04:55:33 | 2024-07-21 05:17:20 | 6.595841666666667 | 79.95895333333334 | 29.6976 | 21 |
| 2024-07-21 04:55:27 | 2024-07-21 05:17:19 | 6.596638888888888 | 79.95882444444445 | 25.378 | 21 |
| 2024-07-21 04:55:17 | 2024-07-21 05:17:18 | 6.597646666666667 | 79.95833555555556 | 21.0583 | 22 |
| 2024-07-21 04:54:59 | 2024-07-21 05:17:17 | 6.5984927777777775 | 79.95781833333332 | 15.1188 | 22 |
| 2024-07-21 04:54:49 | 2024-07-21 05:17:16 | 6.599437777777777 | 79.9571811111111 | 24.2981 | 22 |
| 2024-07-21 04:54:39 | 2024-07-21 05:17:15 | 6.600297777777778 | 79.95658555555556 | 22.1382 | 22 |
| 2024-07-21 05:17:11 | 2024-07-21 05:17:11 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:54:29 | 2024-07-21 05:17:10 | 6.601291666666667 | 79.95598833333332 | 24.838 | 22 |
| 2024-07-21 04:54:19 | 2024-07-21 05:17:09 | 6.602584444444444 | 79.95535222222223 | 32.9374 | 22 |
| 2024-07-21 04:54:09 | 2024-07-21 05:17:08 | 6.604024444444445 | 79.95471166666667 | 32.3974 | 22 |
| 2024-07-21 04:53:59 | 2024-07-21 05:17:07 | 6.605321666666667 | 79.95412722222223 | 27.5378 | 23 |
| 2024-07-21 04:53:49 | 2024-07-21 05:17:06 | 6.6063205555555555 | 79.95367611111111 | 18.8985 | 23 |
| 2024-07-21 04:53:39 | 2024-07-21 05:17:05 | 6.607187777777778 | 79.95326555555556 | 27.5378 | 23 |
| 2024-07-21 04:53:29 | 2024-07-21 05:17:04 | 6.608199444444445 | 79.95276944444446 | 21.5983 | 23 |
| 2024-07-21 04:53:17 | 2024-07-21 05:17:03 | 6.609037222222223 | 79.95227444444444 | 10.2592 | 23 |
| 2024-07-21 05:16:58 | 2024-07-21 05:16:58 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:53:09 | 2024-07-21 05:16:58 | 6.609165555555556 | 79.95220944444443 | 3.23974 | 23 |
| 2024-07-21 04:52:59 | 2024-07-21 05:16:57 | 6.609866666666667 | 79.95171111111112 | 30.2376 | 23 |
| 2024-07-21 04:52:49 | 2024-07-21 05:16:55 | 6.6111466666666665 | 79.950805 | 34.0173 | 24 |
| 2024-07-21 04:52:39 | 2024-07-21 05:16:54 | 6.6123488888888895 | 79.94993444444444 | 29.1577 | 24 |
| 2024-07-21 04:52:28 | 2024-07-21 05:16:53 | 6.6136349999999995 | 79.94918 | 26.4579 | 24 |
| 2024-07-21 04:52:18 | 2024-07-21 05:16:52 | 6.6146022222222225 | 79.94878888888888 | 21.5983 | 24 |
| 2024-07-21 04:52:08 | 2024-07-21 05:16:51 | 6.61562 | 79.94840388888889 | 20.5184 | 24 |
| 2024-07-21 04:51:56 | 2024-07-21 05:16:51 | 6.616562777777777 | 79.94808333333333 | 15.6588 | 24 |
| 2024-07-21 05:16:46 | 2024-07-21 05:16:46 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:51:44 | 2024-07-21 05:16:45 | 6.617547777777777 | 79.94778611111111 | 23.2182 | 25 |
| 2024-07-21 04:51:34 | 2024-07-21 05:16:44 | 6.618763333333333 | 79.94734666666666 | 28.0778 | 25 |
| 2024-07-21 04:51:24 | 2024-07-21 05:16:43 | 6.620018333333333 | 79.94685 | 26.9979 | 25 |
| 2024-07-21 04:51:14 | 2024-07-21 05:16:42 | 6.620961111111112 | 79.94637333333334 | 19.4385 | 25 |
| 2024-07-21 04:51:04 | 2024-07-21 05:16:41 | 6.621814444444444 | 79.94591111111112 | 21.5983 | 25 |
| 2024-07-21 04:50:54 | 2024-07-21 05:16:40 | 6.622586666666667 | 79.94546833333332 | 15.6588 | 25 |
| 2024-07-21 04:50:40 | 2024-07-21 05:16:39 | 6.623401111111111 | 79.94503333333333 | 19.4385 | 25 |
| 2024-07-21 04:50:30 | 2024-07-21 05:16:39 | 6.624269444444445 | 79.94459611111111 | 23.7581 | 26 |
| 2024-07-21 05:16:34 | 2024-07-21 05:16:34 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
| 2024-07-21 04:50:20 | 2024-07-21 05:16:33 | 6.625321666666666 | 79.94421055555556 | 19.4385 | 26 |
| 2024-07-21 04:50:08 | 2024-07-21 05:16:32 | 6.626264444444444 | 79.94397000000001 | 11.3391 | 26 |
| 2024-07-21 04:50:06 | 2024-07-21 05:16:31 | 6.626368333333333 | 79.94395444444444 | 9.17927 | 26 |
| 2024-07-21 04:50:00 | 2024-07-21 05:16:30 | 6.626538333333333 | 79.94391777777777 | 3.7797 | 26 |
| 2024-07-21 04:49:44 | 2024-07-21 05:16:29 | 6.627486666666667 | 79.94365 | 24.2981 | 26 |
| 2024-07-21 04:49:34 | 2024-07-21 05:16:28 | 6.6284922222222225 | 79.943375 | 18.8985 | 26 |
| 2024-07-21 04:49:10 | 2024-07-21 05:16:27 | 6.6294216666666665 | 79.943015 | 0 | 27 |
| 2024-07-21 04:49:00 | 2024-07-21 05:16:27 | 6.630012777777778 | 79.94275 | 27.5378 | 27 |
| 2024-07-21 05:16:22 | 2024-07-21 05:16:22 | 6.605956666666667 | 79.95573611111112 | 0 | 0 |
+---------------------+---------------------+--------------------+-------------------+---------+-------------------------+
100 rows in set (0.056 sec)here is the last 100 records of that device.
Hello, I have exactly the same problem, my devices freeze do not update on the map, but in the demo if the ports work the server receives data and the database is working correctly, but on the map it does not update. I'm on version 6.2, any solution?
I noticed that the server gets the positions with a delay. sometimes more than 30 minutes delay. What about yours?
In previous versions this error was fixed as follows
GPS Device: E0 Time Zone
GPS Server: Time Zone Not configured.
VPS Server: Time Zone (your physical time zone)
Database: VPS Time Zone.
Traccar User: Your actual time zone.
With eo, I solved the issue that they were frozen or reported with different times or timestamps.
Now I don't know what's going on, some devices don't move, they freeze, and if I delete them and add them again, they appear in their real location. But then they freeze again.
When testing the. GPS on another server demo.traccar.org its operation is correct it has no drawbacks. But not on my private vps server.
couldn’t you check last positions from database using an SQL query Like I posted above. like last 100 positions of a freezer device
Hello everyone, the same thing happens to me.
-I use concox devices that work with the gt06 port.
Devices freeze a few hours or days after rebooting the server.
When they freeze and I generate an event report, only constant onLine and offLine events appear. Once I restart the server all data (not received) is received instantly and all frozen devices start working normally.
I recently restarted it so I'll wait for it to happen again to show some data from a frozen device
There must be some system or network issue. If you're able to access, devices should be able too.