Help, server overload

DeZ 6 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 Tananaev 6 years ago

It's used for reports.

DeZ 6 years ago

Hi Anton,

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

Thanks

Anton Tananaev 6 years ago

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

DeZ 6 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 ?