Help, server overload

DeZ5 years ago

Hi

I have a big problem with my traccar server.

The server is overload because i have a query always running

This query which executed by traccar from localhost (my server)

SELECT * FROM tc_positions WHERE deviceId = 23932 AND fixTime BETWEEN '2019-07-01 00:00:00.0' AND '2019-08-01 00:00:00.0' ORDER BY fixTime

It seems this query, from default.xml config file 

    <entry key='database.selectPositions'>
        SELECT * FROM tc_positions WHERE deviceId = :deviceId AND fixTime BETWEEN :from AND :to ORDER BY fixTime
    </entry>

Why this query is executed all time ? and on large period 1 month ?

Can you explain me where this query come from ?

Thank you

Anton Tananaev5 years ago

It's used for reports.

DeZ5 years ago

Hi Anton,

which report ?
Is it internal traccar system ?
Which process fired this report ?

Thanks

Anton Tananaev5 years ago

It's regular reports that users can access from the web app.

DeZ5 years ago

Hi Anton,

It's seems to be strange because this query is executed on all device one by one and on 1 month period.

It is possible that is webservice call in loop ?