traccar not responding

jamel2 years ago

Hey ,
my server was working fine but suddenly the server not responding .
when i check the logs i found this :

2022-07-07 10:18:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:18:16  INFO: [5b55280d: gt06 > 197.8.33.93] HEX: 78780501002a460d0d0a
2022-07-07 10:18:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:18:16  INFO: [cceb05d0: gt06 < 197.4.56.185] HEX: 787811010351510091406945200806410020abd10d0a787811010351510091406945200806410021ba580d0a78781101035151009140694520080641002288c30d0a
2022-07-07 10:18:16  INFO: [cceb05d0: gt06 > 197.4.56.185] HEX: 787805010020e9570d0a
2022-07-07 10:18:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30004ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:18:46  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:18:46  INFO: [5b55280d: gt06 > 197.8.33.93] HEX: 78780501002b57840d0a
2022-07-07 10:18:46  WARN: Event save error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:136 < DataManager:456 < NotificationManager:67 < ...)2022-07-07 10:18:46  WARN: Event save error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:136 < DataManager:456 < NotificationManager:67 < ...)2022-07-07 10:19:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:19:16  INFO: [a0d173dd: teltonika < 102.29.86.130] HEX: 000f333534303138313138373538333738
2022-07-07 10:19:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2022-07-07 10:19:16  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30003ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:131 < DataManager:337 < DeviceManager:335 >2

can anyone help.

Anton Tananaev2 years ago

Looks like you have a problem with your database. It's too slow.

jamel2 years ago

Hey,
Do you have any idea how to fix it ?

Anton Tananaev2 years ago

You need to check your database and see why it's slow. Check running queries. Maybe something is taking too long.

jamel2 years ago

OK