HikariPool-1 SQLTransientConnectionException Timeout Issue

Hamza 2 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 Chandra 2 years ago

Share your logs , also.share hosting configuration

Anton Tananaev 2 years ago

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

Hamza 2 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 Tananaev 2 years ago

How is this related to timeout?

Hamza 2 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 Tananaev 2 years ago

Yes, it's in your MySQL configuration.