database.updateLatestPosition error

jbosco7 years ago

How could you clean the server cache from time to time?

Anton Tananaev7 years ago

Latest positions can only be cleared by restart.

jbosco7 years ago

And you could not put an improvement to the software, so that the last position of the device that is in cache is the last one that has sent?

Anton Tananaev7 years ago

Not all devices send data in the correct order, so the "latest" one can only be determined by the timestamp.

Parth5 years ago

Hello Anton,

We are using nominatim reverse geocoding deployed on out server and for some position we are getting the error regarding address insert for some device position.

Error in tracker log:

290942552:2019-06-25 07:37:08  INFO: [78fd7d3e] id: 358735070824619, time: 2019-06-25 07:03:58, lat: 26.95621, lon: 79.04813, speed: 8.1, course: 324.0
290942694-2019-06-25 07:37:08  INFO: [78fd7d3e: gt06 > 27.97.137.17] HEX: 787805120000a2a40d0a
290942779-2019-06-25 07:37:08  WARN: Failed to store position - Incorrect string value: '\xC4\x81o, U...' for column 'address' at row 1 - SQLException (... < QueryBuilder:480 < DataManager:458 < DefaultDataHandler:40 < ...)

Data of reverse geo-coding extracted from browser:


<reversegeocode timestamp="Tue, 25 Jun 19 07:57:30 +0000" attribution="Data © OpenStreetMap contributors, ODbL 1.0. http://www.openstreetmap.org/copyright" querystring="&lat=26.95680&lon=79.04763">
<result place_id="2005249" osm_type="way" osm_id="457921312" ref="Agra - Lucknow Expressway" lat="26.9587052936401" lon="79.0482149371535" boundingbox="26.9498775,26.9997809,78.9825029,79.0771195">
Agra - Lucknow Expressway, Saifai, Etāwah, Etawah, Uttar Pradesh, 205264, India
</result>
<addressparts>
<road>Agra - Lucknow Expressway</road>
<village>Saifai</village>
<county>Etāwah</county>
<state_district>Etawah</state_district>
<state>Uttar Pradesh</state>
<postcode>205264</postcode>
<country>India</country>
<country_code>in</country_code>
</addressparts>
</reversegeocode>

My server SQL settings:

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://localhost:3306/traccar?allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
    <entry key='database.user'>root</entry>
    <entry key='database.password'>*********</entry>

Can you help me to resolve the issue?

Thank you.

Anton Tananaev5 years ago

Parth, your issue is completely unrelated to this thread. Also, your problem has been discussed many times in the past, so please use search first before posting any new threads or comments.

Parth5 years ago

Hello Anton,

I apology for posting on the wrong thread. And as you suggested, I have already gone through all of the threads and there is lots of the different approach to try. I failed to figure out the exact solution that is recommended to resolve the issue.

It will help if you can suggest exact solution if possible.

Thanks for the support.

Regards.