HikariPool-1 SQLTransientConnectionException Timeout Issue

Hamzaa year ago

I'm encountering an intermittent issue with my Traccar application where I receive a connection timeout error, as shown in the screenshot below:

Description text

The error message indicates that the connection request to the database timed out after approximately 30 seconds. Interestingly, the issue seems to resolve itself after about 5 minutes.

I would greatly appreciate any guidance or solutions from the community to address this issue effectively.

Thank you in advance for your assistance and support.

Ashok Chandraa year ago

Share your logs , also.share hosting configuration

Anton Tananaeva year ago

This error indicates that your database connection timeout is too short. Increase it.

Hamzaa year ago

Thank you for the response,

<entry key='database.maxPoolSize'>50</entry>

Through increase this. it will fix?
And how much should I increase it?

Anton Tananaeva year ago

How is this related to timeout?

Hamzaa year ago

Okay, if this is incorrect, please let me know where I need to make adjustments. Is it in the mysql.conf.d file?

Anton Tananaeva year ago

Yes, it's in your MySQL configuration.