No data is stored in DB

Rodolfo Monge6 years ago
2019-04-29 11:57:19  INFO: [8359a2ca] id: 286701, time: 1963-08-08 05:28:55, lat: 13.72688, lon: -89.61972, speed: 2.1, course: 357.0, accuracy: 10.0
2019-04-29 11:57:20 DEBUG: [8359a2ca: 5055 < 216.230.133.69] HEX: 504f5354202f3f69643d3238363730312674696d657374616d703d2d323031393631383630266c61743d31332e37323638383236266c6f6e3d2d38392e363139373233392673706565643d322e303438393035363934393830313434352662656172696e673d31312e3026616c7469747564653d3432312e332661636375726163793d31302e3026626174743d37332e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b20504834303033204275696c642f4e524439304d290d0a486f73743a20677073747261636b657273762e636f6d3a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2019-04-29 11:57:20 DEBUG: [8359a2ca: 5055 > 216.230.133.69] HEX: 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2019-04-29 11:57:20  WARN: Data truncation: Incorrect datetime value: '1963-08-08 05:29:00' for column 'devicetime' at row 1 - MysqlDataTruncation (... < QueryBuilder:477 < DataManager:453 < DefaultDataHandler:27 < ...)
2019-04-29 11:57:20  INFO: [8359a2ca] id: 286701, time: 1963-08-08 05:29:00, lat: 13.72688, lon: -89.61972, speed: 2.0, course: 11.0, accuracy: 10.0
2019-04-29 11:57:28 DEBUG: [8359a2ca: 5055 < 216.230.133.69] HEX: 504f5354202f3f69643d3238363730312674696d657374616d703d2d323031393631383535266c61743d31332e37323638383235266c6f6e3d2d38392e363139373330322673706565643d332e313938323932303939313434393335332662656172696e673d3334362e3026616c7469747564653d3432352e302661636375726163793d31302e3026626174743d37332e3020485454502f312e310d0a436f6e74656e742d547970653a206170706c69636174696f6e2f782d7777772d666f726d2d75726c656e636f6465640d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420372e303b20504834303033204275696c642f4e524439304d290d0a486f73743a20677073747261636b657273762e636f6d3a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2019-04-29 11:57:28 DEBUG: [8359a2ca: 5055 > 216.230.133.69] HEX: 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2019-04-29 11:57:28  WARN: Data truncation: Incorrect datetime value: '1963-08-08 05:29:05' for column 'devicetime' at row 1 - MysqlDataTruncation (... < QueryBuilder:477 < DataManager:453 < DefaultDataHandler:27 < ...)

Any idea why traccar is no saving data?

Anton Tananaev6 years ago

Because the time is invalid.

Rodolfo Monge6 years ago

Thanks Anton.
Do you know how to fix this issue?
My traccar was working fine until April 6 and began to show those error messages.

Anton Tananaev6 years ago

Probably related to this:

https://www.energy.gov/oe/articles/april-2019-global-positioning-system-gps-week-number-rollover

Rodolfo Monge6 years ago

Thanks for your help.
I will update my traccar server.

Anton Tananaev6 years ago

Not sure how updating server would help.

Rodolfo Monge6 years ago

Any idea how to solve this defect?

Piotr6 years ago

Ask your tracker manufacturer for firmware update or make a patch for traccar server against your broken devices.

Rodolfo Monge6 years ago

Updating to version 5.18 of Traccar Hidden Client solve the problem.

Thanks for your help.

Now.
I have other problem...
How to do a massive update for 3,000 devices?