position id issue : int reach max value mysql

DeZ5 years ago

Hi,

I have big trouble with TRACCAR this morning.

ID of tc_positions table reach max value of int mysql field (2147483647)

Im going to modify the field to BIGINT.

Can you tell me if TRACCAR service will support BIGINT ?

Thanks

Anton Tananaev5 years ago

Traccar supports long value for IDs.

DeZ5 years ago

Hi Anton,

Thanks

So i migrate id column in bigint(20) type and also column positionid of tc_events, tc_devices

Plz include this change to next version of traccar.

Have a good day

Bye

Martin4 years ago

Hi DeZ,

Can you please describe that how you managed to do the transformation from int to bigint?

DeZ4 years ago

Hi Martin

I do all with traccar service turned off

You need to rename tc_positions table in other name and recreate new table position with bigint for id column

And then modify column type of positionid in tc_events and tc_devices

After you move, i do it day by day, data from old tc_positions table in new tc_positions table, if you need it.

See beelow thread explain this

https://stackoverflow.com/questions/15277804/replace-identity-column-from-int-to-bigint/15277985#15277985

Martin4 years ago

Thanks for your reply. We will surely give it a try.