HikariPool-1 SQLTransientConnectionException Timeout Issue

Hamza2 years 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 Chandra2 years ago

Share your logs , also.share hosting configuration

Anton Tananaev2 years ago

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

Hamza2 years 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 Tananaev2 years ago

How is this related to timeout?

Hamza2 years 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 Tananaev2 years ago

Yes, it's in your MySQL configuration.