[FIXED] Hikari pool vs mariadb

[Mantosh]

Hello, fellow l2j lovers!

We have a development environment set up running on openjdk:11.0.2-jdk and mariadb:10.4. Sometime after the server is running for about half an hour or so, I get a group of these messages:

Code: Select all

PoolBase: HikariPool-1 - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@****** (Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.

Maybe someone has encountered this before? Or knows what is causing it?

Thank You

[Zoey76]

Hi you can read about it here https://github.com/brettwooldridge/HikariCP/issues/1403

Please run on your MariaDB instance:

Code: Select all

SHOW SESSION VARIABLES LIKE "wait_timeout";

I just pushed dependency l2j-server-commons:2.6.2.0 you can change it manually on your game and login server and check if that helps.

[Mantosh]

I've encountered that topic while doing my research too. Thank you for confirming my suspicions. And thanks for the commons update! You're awesome

[Zoey76]

I've encountered that topic while doing my research too. Thank you for confirming my suspicions. And thanks for the commons update! You're awesome

Let us know if the changes work, I couldn't reproduce the issue, but is something common y MySQL/MariaDB.

[Mantosh]

Will do. We have update scheduled for tonight. Thanks again

[Mantosh]

The update resolved the issue. The server has been running for 5 days - no pool errors Thanks a lot!

[Zoey76]

The update resolved the issue. The server has been running for 5 days - no pool errors Thanks a lot!

I'm glad it worked fine, thanks.