BedWars1058 icon indicating copy to clipboard operation
BedWars1058 copied to clipboard

mysql no connect

Open akillamrck opened this issue 1 year ago • 4 comments

server 1.8.8 paper BedWars1058 - OpenSource 23.3

[06:16:39] [Server thread/ERROR]: Error occurred while enabling BedWars1058 v23.3 (Is it up to date?) com.andrei1058.bedwars.libs.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Unknown system variable 'tx_isolation' at com.andrei1058.bedwars.libs.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.HikariPool.checkFailFast(HikariPool.java:575) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.HikariPool.(HikariPool.java:100) ~[?:?] at com.andrei1058.bedwars.libs.hikari.HikariDataSource.(HikariDataSource.java:81) ~[?:?] at com.andrei1058.bedwars.database.MySQL.connect(MySQL.java:105) ~[?:?] at com.andrei1058.bedwars.BedWars.onEnable(BedWars.java:395) ~[?:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[patched_1.8.8.jar:git-PaperSpigot-445] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) [patched_1.8.8.jar:git-PaperSpigot-445] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:407) [patched_1.8.8.jar:git-PaperSpigot-445] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:359) [patched_1.8.8.jar:git-PaperSpigot-445] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:318) [patched_1.8.8.jar:git-PaperSpigot-445] at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:203) [patched_1.8.8.jar:git-PaperSpigot-445] at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:563) [patched_1.8.8.jar:git-PaperSpigot-445] at java.lang.Thread.run(Thread.java:829) [?:?] Caused by: java.sql.SQLException: Unknown system variable 'tx_isolation' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.mysql.jdbc.ConnectionImpl.getTransactionIsolation(ConnectionImpl.java:3198) ~[patched_1.8.8.jar:git-PaperSpigot-445] at com.andrei1058.bedwars.libs.hikari.pool.PoolBase.checkDefaultIsolation(PoolBase.java:480) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:443) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.PoolBase.setupConnection(PoolBase.java:411) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[?:?] at com.andrei1058.bedwars.libs.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[?:?] ... 12 more

akillamrck avatar Mar 27 '23 10:03 akillamrck

i have same problem too.

hamza-cskn avatar Apr 13 '23 19:04 hamza-cskn

You can try it with MySQL version 5.7

xiaozhu52055 avatar Aug 03 '23 09:08 xiaozhu52055

I have the same problem on BW1058 version v23.3 too

WitheredWinter avatar Feb 24 '24 07:02 WitheredWinter

this still happens on BW1058 v23.12.2 while using Paper1.8.8 and JDK11

WitheredWinter avatar Feb 24 '24 07:02 WitheredWinter