Hi, i'm facing an issue when editing reports on traccar server
when i try to select more than one vehicle and run the report i get communication failure
i've same issue even when selecting only one vehicle for any period of time
report works only for some trackers and only when one vehicle is selected
does anyone have an idea about that behaviour ? thanks
It usually means that report timed out. You should check queries in the database. Maybe you are missing an index of maybe your server is just too slow.
i've only 110 as free ram from 3848
otherwise how can i check queries in the database (i'm using Mysql)
Thanks a lot
There's plenty of information online on how to profile and debug live SQL queries. I would start with running a query manually and checking execution plan.
thanks Anton but the question is why the report works fine when i select only one vehicle and return communication failure when i select more than one for longer period of time ?
Is the answer not obvious? More data = slower report.
i totally agree with you about that point and i'm thinking about increasing the server memory but i find stranger that for some trackers, the report doesn't work and return communication failure even when i select only one and only for the periode of yesterday
on the console developper (chrome) the request doesn't return 200 it still pending, timedout and canceled
same behaiviour on mozilla even after increasing the timeout
Thanks for your insights