Trouble in upgrading from 5.7 to 5.8 or 5.9

Himanshu8 months ago

Good day
I am trying to upgrade traccar from 5.7 to 5.8/5.9 but cpu ulitization of mysql is increasing too high for very long time and then upgradation get crashed. I am suspecting that geofenceids field has shifted in 5.8 version from tc_devices table to tc_position might be issue for this. Since I have very small server and position table has too much data so it is getting crashed during updation.
Can you suggest any other way around to resolve this issue???

Anton Tananaev8 months ago

You are probably right. You can do that migration manually.

Himanshu8 months ago

Thanks for your reply. Can you provide step by step guide to do this migration manually.

Anton Tananaev8 months ago

I cannot. Look at the changelog and do those changes manually.