L2JMobius

Classic Interlude Hikari Error in Login Server

arquisoft · 2 · 5639

Offline arquisoft

  • Viscount
  • *****
    • Posts: 321
Hello!

Let me try to explain the problem:

-I run login server (OK)
-I run "gameserver 1" Classic Interlude (OK)
-I run second "gameserver 2" Kamael (OK)
-Both Server runs OK at same time. Server 1 and server 2 in same login.

-But, if i close the login server with the two server running, the login can not conect to any server.
-If i close ONE one them, it auto conects normaly.
-I have the run the second server AGAIN to the login server accept the two servers.

Is there any way the login server auto accept the TWO server after loginserver crash?

PS: I am using:
windows server 2016
MariaDB 10.3.23
Bellsoft-jdk-14


Quote
[10/06 19:07:17] DatabaseFactory: Cound not get a connection. java.sql.SQLException: Too many connections
[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: Too many connections
   at org.mariadb.jdbc.internal.com.read.ReadInitialHandShakePacket.<init>(ReadInitialHandShakePacket.java:92)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:693)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:415)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
   at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:620)
   at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:175)
   at org.mariadb.jdbc.Driver.connect(Driver.java:92)
   at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
   at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
   at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
   at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
   at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
   at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
   at org.l2jmobius.commons.database.DatabaseFactory.getConnection(DatabaseFactory.java:64)
   at org.l2jmobius.loginserver.GameServerTable.loadRegisteredGameServers(GameServerTable.java:119)
   at org.l2jmobius.loginserver.GameServerTable.<init>(GameServerTable.java:68)
   at org.l2jmobius.loginserver.GameServerTable$SingletonHolder.<clinit>(GameServerTable.java:731)
   at org.l2jmobius.loginserver.GameServerTable.getInstance(GameServerTable.java:723)
   at org.l2jmobius.loginserver.LoginServer.<init>(LoginServer.java:103)
   at org.l2jmobius.loginserver.LoginServer.main(LoginServer.java:55)
[10/06 19:07:17] DatabaseFactory: Cound not get a connection. java.sql.SQLException: Too many connections
[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: Too many connections
   at org.mariadb.jdbc.internal.com.read.ReadInitialHandShakePacket.<init>(ReadInitialHandShakePacket.java:92)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:693)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:415)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
   at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:620)
   at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:175)
   at org.mariadb.jdbc.Driver.connect(Driver.java:92)
   at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
   at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
   at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
   at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
   at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
   at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
   at org.l2jmobius.commons.database.DatabaseFactory.getConnection(DatabaseFactory.java:64)
   at org.l2jmobius.loginserver.GameServerTable.loadRegisteredGameServers(GameServerTable.java:119)
   at org.l2jmobius.loginserver.GameServerTable.<init>(GameServerTable.java:68)
   at org.l2jmobius.loginserver.GameServerTable$SingletonHolder.<clinit>(GameServerTable.java:731)
   at org.l2jmobius.loginserver.GameServerTable.getInstance(GameServerTable.java:723)
   at org.l2jmobius.loginserver.LoginServer.<init>(LoginServer.java:103)
   at org.l2jmobius.loginserver.LoginServer.main(LoginServer.java:55)
[10/06 19:07:17] DatabaseFactory: Cound not get a connection. java.sql.SQLException: Too many connections
[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: Too many connections
   at org.mariadb.jdbc.internal.com.read.ReadInitialHandShakePacket.<init>(ReadInitialHandShakePacket.java:92)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:693)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:415)
   at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
   at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:620)
   at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:175)
   at org.mariadb.jdbc.Driver.connect(Driver.java:92)
   at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
   at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
   at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
   at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
   at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
   at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
   at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
   at org.l2jmobius.commons.database.DatabaseFactory.getConnection(DatabaseFactory.java:64)
   at org.l2jmobius.loginserver.GameServerTable.loadRegisteredGameServers(GameServerTable.java:119)
   at org.l2jmobius.loginserver.GameServerTable.<init>(GameServerTable.java:68)
   at org.l2jmobius.loginserver.GameServerTable$SingletonHolder.<clinit>(GameServerTable.java:731)
   at org.l2jmobius.loginserver.GameServerTable.getInstance(GameServerTable.java:723)
   at org.l2jmobius.loginserver.LoginServer.<init>(LoginServer.java:103)
   at org.l2jmobius.loginserver.LoginServer.main(LoginServer.java:55)
[10/06 19:07:17] DatabaseFactory: Cound not get a connection. java.sql.SQLException: Too many connections


Offline jcerutti17

  • Vassal
  • *
    • Posts: 5
Hello, at thi end of the error it says Too many connections.
you should increase the max connections handled by the MariaDB server, just google it and you would be okay.
also you need to check the max connections to db.