HikariPool-1 - Connection is not available

Jithu4 years ago

Hi,

I am getting this error in my traccar logs.

Update device status error - HikariPool-1 - Connection is not available, request timed out after 43863ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:135 < DataManager:337 < DeviceManager:316 < ...)

I have checked my db connection availability from another server(same time), my other small applications are work fine with traccar db. That means DB server accepts connections, not denying request in DB side. I would like to more investigate this error.
where I can find more detailes of HikariPool issues?, How/where HikariPoolCP settings I can change?

Anton Tananaev4 years ago

I would recommend keeping Traccar and the database on the same machine. I've seen this error before when people separate them.

Jithu4 years ago

Can you tell me how that will help to solve the issue?

If it is same server or different server Data base is a service. If the same service runs in same server or different remote machine how that affect "HikariPool" and if it is in same machine how that resolve the issue?

My question is bit different, how I can figure out the issue and cause. where i can get more log information about HikariPool.

Jithu4 years ago

@Anton Any feedback?

Anton Tananaev4 years ago

Not really. Have you tried my recommendation?

Jithu4 years ago

Yes, Same issue.

But logically that won't solve as per my explanation.

Is any possibility to get more details about error in any logs, I mean the code level logs.
We can enable log levels critical, Waring and its detailed info?

Anton Tananaev4 years ago

It happens even if database is local? Can you please provide access to the server for me to take a look? You can send details to support.

Jithu4 years ago

Yes this is happening when application and DB in same server(I didn't really understood what is the reason if someone use remote db).

where i can find the more log details about this issue, please provide code level logs location.

Unfortunately server details I can share to someone else, this is against our policy that we committed to someone else. we can send log files or necessary config data to you for further debugging

ryanmunene2 years ago

Did you find a solution to this?

Jithu2 years ago

I didn't made any fix for this. But last few months I never faced this issue. Lets see.

We have decoupled systems and maintain data volume properly.