tc_positions id field int4 reached max value

Don2 years ago

Hi All,

I run Traccar with Postgresql, I saw id field in tc_positions table has reached the max int4 value (2147483647)..
any body please help, what should I do?

Don2 years ago

Hi All,

does the newest version of Traccar (traccar-linux-64-5.3.zip) have also update the field size of id field from int4 to int8? if so, does it automatically updated when upgrading?

need advice.

many thanks

greendays2 years ago

Master from a few days ago had int4 as the data type for tc_positions.id. You can manually change the type. The java code supports int8.