Слишком много соединений к БД от AuthMeBungee

WinstonCode

WinstonCode

winston.php
Пользователь
Сообщения
156
Решения
1
Добрый день, появилась проблема несколько нестандартного характера.
Для фикса обхода авторизации, установил плагин AuthMeBungee, после чего случается следующее:

В случае если я запускаю сервера с разницей меньше минуты (если поочерёдно, то всё нормально), на сервере-авторизации вылетает следующая ошибка, учитывая что раньше всё было нормально.

Код: 
[11:40:04] [Server thread/INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[11:40:04] [Server thread/WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[11:40:05] [Server thread/WARN]: [Server thread] ERROR fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[11:40:05] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at java.lang.reflect.Constructor.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at java.lang.reflect.Constructor.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:167)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:175)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:76)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:67)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:245)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:145)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
[11:40:05] [Server thread/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
[11:40:05] [Server thread/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:422)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:383)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:338)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
[11:40:05] [Server thread/WARN]:     at java.lang.Thread.run(Unknown Source)
[11:40:05] [Server thread/WARN]: [AuthMe] Can't initialize the MySQL database: [MySQLNonTransientConnectionException]: Too many connections
[11:40:05] [Server thread/WARN]: [AuthMe] Please check your database settings in the config.yml file!
[11:40:05] [Server thread/WARN]: [AuthMe] Could not create data source: [MySQLNonTransientConnectionException]: Too many connections
[11:40:05] [Server thread/WARN]: [AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[11:40:05] [Server thread/WARN]: java.lang.IllegalStateException: Error during initialization of data source
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:52)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:245)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:145)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[11:40:05] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403)
[11:40:05] [Server thread/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:381)
[11:40:05] [Server thread/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:330)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:422)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:383)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:338)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272)
[11:40:05] [Server thread/WARN]:     at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545)
[11:40:05] [Server thread/WARN]:     at java.lang.Thread.run(Unknown Source)
[11:40:05] [Server thread/WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at java.lang.reflect.Constructor.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.getInstance(Util.java:408)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:40:05] [Server thread/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at java.lang.reflect.Constructor.newInstance(Unknown Source)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
[11:40:05] [Server thread/WARN]:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:167)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:175)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:76)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:67)
[11:40:05] [Server thread/WARN]:     at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[11:40:05] [Server thread/WARN]:     ... 19 more
[11:40:05] [Server thread/WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[11:40:05] [Server thread/INFO]: [AuthMe] Waiting for 0 tasks to finish
[11:40:05] [Server thread/INFO]: [AuthMe] AuthMe 5.6.0-SNAPSHOT-b2385 disabled!


Исходя из ошибки, идёт слишком много запросов в БД, но дело в том что раньше то такого не было.
И ладно бы просто поочерёдно запускать, эту же ошибку выдаёт при перезагрузке через reload. Что можно с этим сделать? Заранее спасибо.

Креплю конфиг AuthMeBungee.
 

Вложения

  • config.yml
    1 KB · Просмотры: 5
Сортировка по дате Сортировка по голосам
Войдите или зарегистрируйтесь для ответа.
Назад
Сверху Снизу