error WARN: Failed to store position - Data truncation:

Maxi Cabanillas6 years ago

why this error could help me

WARN: Failed to store position - Data truncation: Out of range value for column 'deviceid' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
Anton Tananaev6 years ago

Device id is too long would be my guess.

Maxi Cabanillas6 years ago

70/5000
an example of the log
where is the file that refers this error

2019-05-06 15:26:48  INFO: [0d2f67b1] id: 864893032067780, time: 2019-05-06 15:26:47, lat: -8.95133, lon: 13.19067, course: 0.0
2019-05-06 15:26:48  INFO: [f5b0a53d: gps103 < 177.221.240.119] HEX: 696d65693a3836383638333032353036393836392c747261636b65722c3139303530363233323634372c2c462c3135323634312e3030302c412c313535362e333538332c532c30343831372e363831332c572c302e30302c302c2c302c302c302e3030252c302c3b
2019-05-06 15:26:48  WARN: Failed to store position - Data truncation: Out of range value for column 'deviceid' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
2019-05-06 15:26:48  INFO: [020b8685] id: 352887075297196, time: 2019-05-06 15:26:46, lat: -15.82482, lon: -48.12360, course: 0.0
...
2019-05-06 15:26:49  INFO: [98c0e763: gt06 > 143.137.105.2] HEX: 78780512008cecc00d0a
2019-05-06 15:26:49  WARN: Failed to store position - Data truncation: Out of range value for column 'deviceid' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
2019-05-06 15:26:49  INFO: [19c937d1] id: 864893031977237, time: 2019-05-06 15:26:47, lat: -7.23478, lon: -35.91832, speed: 0.0, course: 0.0
2019-05-06 15:26:49  WARN: Failed to store position - Data truncation: Out of range value for column 'deviceid' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
2019-05-06 15:26:49  WARN: Failed to store position - Data truncation: Out of range value for column 'deviceid' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
2019-05-06 15:26:49  INFO: [d1592363] id: 358511020024562, time: 2019-05-06 15:26:48, lat: -1.45777, lon: -48.50113, speed: 6.5, course: 326.0
2019-05-06 15:26:49  INFO: [d1a06a65] connected
2019-05-06 15:26:49  INFO: [d1a06a65: m2m < 138.121.198.122] HEX: 474554202f3f69643d3938393637332674696d657374616d703d31353437323336323937266c61743d2d32322e373138393533313634323934333632266c6f6e3d2d34332e34343738383837393135363131332673706565643d302e3438353936312662656172696e673d302e3026616c7469747564653d31312e3026626174743d37342e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420382e302e303b20534d2d473537304d204275696c642f5231364e57290d0a486f73743a2035342e3230302e37302e35303a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid Future filters from device: 937520015317368
2019-05-06 15:26:49  INFO: Position filtered by Invalid filters from device: 937520015317368