HikariPool-1 SQLTransientConnectionException Timeout Issue

Hamza6 months 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 Chandra6 months ago

Share your logs , also.share hosting configuration

Anton Tananaev6 months ago

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

Hamza6 months 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 Tananaev6 months ago

How is this related to timeout?

Hamza6 months 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 Tananaev6 months ago

Yes, it's in your MySQL configuration.