3.2 Traccar, SQLException error

jaimzj9 years ago

Dear Anton,

I am noticing this SQLException error in the log's, does this in anyway affect traccar or its functioning. and what is this error as per you? please advice? also if this can be fixed?

Server version : 3.2
OS : Ubuntu
DB : MySql
GEOCODING Server : Nominatim (Self hosted)

2016-04-20 23:39:16  INFO: [029BED2A] id: 507, time: 2016-04-20 23:36:13, lat: 15.72246, lon: 76.73974, speed: 16.7, course: 200.0
2016-04-20 23:39:16  INFO: [029BED2A] id: 507, time: 2016-04-20 23:36:43, lat: 15.72120, lon: 76.73940, speed: 6.5, course: 163.0
2016-04-20 23:39:16  WARN: Incorrect string value: '\xE0\xB2\xB9\xE0\xB3\x8B...' for column 'address' at row 1 - SQLException (... < QueryBuilder:428 < DataManager:351 < DefaultDataHandler:27 < ...)
2016-04-20 23:39:16  INFO: [029BED2A] id: 507, time: 2016-04-20 23:36:33, lat: 15.72153, lon: 76.73942, speed: 7.0, course: 195.0
Anton Tananaev9 years ago

The issue looks similar to this one:

https://www.traccar.org/forums/topic/mysql-error-change/

jaimzj9 years ago

I am on 3.3 server sorry for the mistake. The version I am using is 3.3

And UTF-8 is already set in wrapper and all said in the above post is done still this error is returned.

Does this error affect, performance of server instance or any other functionality? Can I safely ignore it for now?

Anton Tananaev9 years ago

Those issues don't affect the performance, but it means you are losing some data as it can't be saved in the database.