We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

Hikari pool vs mariadb

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Mantosh
Posts: 10
Joined: Thu Aug 29, 2019 5:54 pm

Hikari pool vs mariadb

Post by Mantosh » Thu Jan 16, 2020 8:51 pm

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

User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 6934
Joined: Tue Aug 11, 2009 3:36 am

Re: Hikari pool vs mariadb

Post by Zoey76 » Wed Jan 22, 2020 3:39 am

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.
Using Eclipse 4.14 - OpenJDK11 - MariaDB 10.4 - L2J Server 2.6.1.0

Mantosh
Posts: 10
Joined: Thu Aug 29, 2019 5:54 pm

Re: Hikari pool vs mariadb

Post by Mantosh » 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

User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 6934
Joined: Tue Aug 11, 2009 3:36 am

Re: Hikari pool vs mariadb

Post by Zoey76 » Sat Jan 25, 2020 10:00 pm

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.
Using Eclipse 4.14 - OpenJDK11 - MariaDB 10.4 - L2J Server 2.6.1.0

Mantosh
Posts: 10
Joined: Thu Aug 29, 2019 5:54 pm

Re: Hikari pool vs mariadb

Post by Mantosh » Sun Jan 26, 2020 4:53 pm

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

Mantosh
Posts: 10
Joined: Thu Aug 29, 2019 5:54 pm

Re: Hikari pool vs mariadb

Post by Mantosh » 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!

Post Reply