Good morning Colleagues, i hope you are all well,
We've migrated recently from 4.15 to 5.6 due to firebase legacy depreciation,
In order to migrate correctly we installed every single version untill it reaches the 5.6 version
Aparently everything was smoothly, however we realized that after 5.6 installed, everytime we create a user or a new device, using a user with over 500 devices something crazy happens, it lockes the database and stops receiving position and freezes for like 20 seconds or more, in the end user or device is not created and we get an error,
After checking the database log, it shows a very big select going on on the table tc_users, and it extend over to geofences,notifications and few others, and once this select is completed, it releases the traccar and return to receive positions,
Does anybody knows any solution? much appreciated
I'm not sure how much support you are going to get for an old version like 5.6 - or were you talking about 6.5 that just got released? I would suggest upgrading to latest 6.5 and see what's happening there.
I would look at indexes on those tables: check that they support the queries without requiring a full table scan.
You could also do the equivalent of an 'Explain Plan' on that particular query directly in the database, depending on what DB you are running.
The problem you're describing is solved in newer versions of Traccar, so you should upgrade further.
By the way, you don't need to install every single version one by one. You can migrate directly.
Thank you colleagues, will give a try with newer version
Good morning Colleagues, i hope you are all well,
We've migrated recently from 4.15 to 5.6 due to firebase legacy depreciation,
In order to migrate correctly we installed every single version untill it reaches the 5.6 version
Aparently everything was smoothly, however we realized that after 5.6 installed, everytime we create a user or a new device, using a user with over 500 devices something crazy happens, it lockes the database and stops receiving position and freezes for like 20 seconds or more, in the end user or device is not created and we get an error,
After checking the database log, it shows a very big select going on on the table tc_users, and it extend over to geofences,notifications and few others, and once this select is completed, it releases the traccar and return to receive positions,
Does anybody knows any solution? much appreciated