Помогите в чём может быть проблема?

[Blame_M3]

Хроники

1. Chaotic Throne: High Five

Сборка

l2jdev

Собственно вот такая штука идёт при загрузке ГС
Поменял mariadb на MySQL не помогло
Couldn't set characters offline.
java.sql.SQLSyntaxErrorException: No connection available within the specified time (option 'connectTimeout': 30а000 ms)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbPoolDataSource.getConnection(MariaDbPoolDataSource.java:239)
at net.sf.l2j.commons.pool.ConnectionPool.getConnection(ConnectionPool.java:47)
at net.sf.l2j.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:198)
at net.sf.l2j.gameserver.idfactory.IdFactory.<init>(IdFactory.java:35)
at net.sf.l2j.gameserver.idfactory.IdFactory$SingletonHolder.<clinit>(IdFactory.java:320)
at net.sf.l2j.gameserver.idfactory.IdFactory.getInstance(IdFactory.java:315)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:173)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:142)
Caused by: java.sql.SQLSyntaxErrorException: No connection available within the specified time (option 'connectTimeout': 30а000 ms)


Couldn't set characters offline.
java.sql.SQLSyntaxErrorException: No connection available within the specified time (option 'connectTimeout': 30а000 ms)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbPoolDataSource.getConnection(MariaDbPoolDataSource.java:239)
at net.sf.l2j.commons.pool.ConnectionPool.getConnection(ConnectionPool.java:47)
at net.sf.l2j.gameserver.idfactory.IdFactory.setAllCharacterOffline(IdFactory.java:198)
at net.sf.l2j.gameserver.idfactory.IdFactory.<init>(IdFactory.java:35)
at net.sf.l2j.gameserver.idfactory.IdFactory$SingletonHolder.<clinit>(IdFactory.java:320)
at net.sf.l2j.gameserver.idfactory.IdFactory.getInstance(IdFactory.java:315)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:173)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:142)
Caused by: java.sql.SQLSyntaxErrorException: No connection available within the specified time (option 'connectTimeout': 30а000 ms)

 

[gamaleev0071]

option 'connectTimeout': 30а000 ms

 

[gamaleev0071]

у тебя коннект с бд закрываться спустя 30 секунд (настройка mysql такая)

 

[Blame_M3]

у тебя коннект с бд закрываться спустя 30 секунд (настройка mysql такая)

как исправить подскажешь ?

 

[gamaleev0071]

в sql пропиши
SET GLOBAL connect_timeout=28800
SET GLOBAL wait_timeout=28800
SET GLOBAL interactive_timeout=28800
по очереди
до перезагрузки mysql поможет

 

[Blame_M3]

в sql пропиши
SET GLOBAL connect_timeout=28800
SET GLOBAL wait_timeout=28800
SET GLOBAL interactive_timeout=28800
по очереди
до перезагрузки mysql поможет

Спасибо