Hello All,
I have devices were reporting normally on traccar server, then suddenly I am not able to find the new positions in table of tc_positions
I checked the logs and found the below error : Failed to store position - Data truncation: Out of range value for column 'id' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
The below is the lines I am getting in the log:
003300031723b3b15e430100015e25c7ef0000215ceade0f4429a6003a0ef60b002709070405011c01ad01b02700014103331f460027bc
2020-01-20 16:32:36 INFO: [92a8f2ea: ruptela > 94.57.217.241] HEX: 0002640113bc
2020-01-20 16:32:36 WARN: Failed to store position - Data truncation: Out of range value for column 'id' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
2020-01-20 16:32:36 INFO: [92a8f2ea] id: 869867036171843, time: 2020-01-20 16:31:59, lat: 25.61254, lon: 55.97376, speed: 21.1, course: 38.3
2020-01-20 16:32:44 INFO: [92a8f2ea] disconnected
Is there any suggestions ?
Check what the id range is and check what ids you have in the devices table.
I found that we have exceeded the limit of ids in the tc_positions table, we are using INT(11) for the ID column is there any way to increase the limit ?
Yes, change the column type.
Thank you,
I found a record duplicated with the last possible ID "2147483647" so removed then all is working perfectly.
Hello All,
I have devices were reporting normally on traccar server, then suddenly I am not able to find the new positions in table of tc_positions
I checked the logs and found the below error :
Failed to store position - Data truncation: Out of range value for column 'id' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)
The below is the lines I am getting in the log:
Is there any suggestions ?