Failed to store position

sara tahseen4 years ago

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 ?

Anton Tananaev4 years ago

Check what the id range is and check what ids you have in the devices table.

sara tahseen4 years ago

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 ?

Anton Tananaev4 years ago

Yes, change the column type.

sara tahseen4 years ago

Thank you,
I found a record duplicated with the last possible ID "2147483647" so removed then all is working perfectly.