Page 1 of 1

[FIXED] Hikari pool vs mariadb

Posted: Thu Jan 16, 2020 8:51 pm
by 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

Re: Hikari pool vs mariadb

Posted: Wed Jan 22, 2020 3:39 am
by 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.

Re: Hikari pool vs mariadb

Posted: Wed Jan 22, 2020 1:21 pm
by 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

Re: Hikari pool vs mariadb

Posted: Sat Jan 25, 2020 10:00 pm
by Zoey76
Mantosh wrote: Wed Jan 22, 2020 1:21 pm 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.

Re: Hikari pool vs mariadb

Posted: Sun Jan 26, 2020 4:53 pm
by Mantosh
Will do. We have update scheduled for tonight. Thanks again

Re: Hikari pool vs mariadb

Posted: Mon Feb 03, 2020 7:18 pm
by Mantosh
The update resolved the issue. The server has been running for 5 days - no pool errors :) Thanks a lot!

Re: Hikari pool vs mariadb

Posted: Thu Jun 04, 2020 12:57 am
by Zoey76
Mantosh wrote: Mon Feb 03, 2020 7:18 pm 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.