silen72
commented
2 years ago Upon closer inspection on the server log I have noticed more entries that might be of interest. These entries originate from Gringotts - without Gringotts they are gone.
System Info: Java 17 (OpenJDK 64-Bit Server VM 17.0.1+12-39) Host: Windows 10 10.0 (amd64) Loading libraries, please wait... [18:41:53 INFO]: Environment: authHost='https://authserver.mojang.com', accountsHost='https://api.mojang.com', sessionHost='https://sessionserver.mojang.com', servicesHost='https://api.minecraftservices.com', name='PROD' [18:41:54 INFO]: Reloading ResourceManager: Default, bukkit [18:41:55 INFO]: Loaded 7 recipes [18:41:56 INFO]: Starting minecraft server version 1.17.1 [18:41:56 INFO]: Loading properties [18:41:56 INFO]: This server is running Paper version git-Paper-399 (MC: 1.17.1) (Implementing API version 1.17.1-R0.1-SNAPSHOT) (Git: d4318a6 on ver/1.17.1) [18:41:56 INFO]: Server Ping Player Sample Count: 12 [18:41:56 INFO]: Using 4 threads for Netty based IO [18:41:56 INFO]: Default game type: SURVIVAL [18:41:56 INFO]: Generating keypair [18:41:56 INFO]: Starting Minecraft server on *:25565 [18:41:56 INFO]: Using default channel type [18:41:56 INFO]: Paper: Using Java 11 compression from Velocity. [18:41:56 INFO]: Paper: Using Java cipher from Velocity. [18:41:57 ERROR]: [com.avaje.ebean.config.PropertyMapLoader] ebean.properties not found [18:41:57 INFO]: [com.avaje.ebeaninternal.server.lib.sql.DataSourcePool] DataSourcePool [Gringotts] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20] [18:41:57 INFO]: [com.avaje.ebeaninternal.server.subclass.SubClassManager] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader] [18:41:57 INFO]: [com.avaje.ebeaninternal.server.deploy.BeanDescriptorManager] Entities enhanced[0] subclassed[2] [18:41:57 INFO]: [CoreProtect] Loading CoreProtect v20.1 [18:41:57 INFO]: [Gringotts] Loading Gringotts v2.12.2
MCMDEV
Describe the bug
I have a server (Paper, MC:1.16.5) with quite a few plugins. CoreProtect (19.5) is configured to use a MySQL database (version 8.0.22). One of the other plugins is Gringotts v2.12.2. This works well.
Currently I'm trying to upgrade my server to Paper, MC:1.17.1 (git-Paper-399). For this, I have also upgraded CoreProtect (to 20.1) - Gringotts is already the current version. I have also switched to Java 17 (OpenJDK 64-Bit Server VM 17.0.1+12-39). With this configuration, CoreProtect fails to connect to the database:
[20:52:55 INFO]: [CoreProtect] Unable to connect to MySQL server. [20:52:55 WARN]: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/minecraft?useUnicode=true&characterEncoding=utf-8&connectTimeout=10000&useSSL=false&allowPublicKeyRetrieval=true&useCursorFetch=true&useLocalSessionState=true&rewriteBatchedStatements=true&maintainTimeStats=false [20:52:55 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:706) [20:52:55 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229) [20:52:55 WARN]: at CoreProtect-20.1.jar//net.coreprotect.database.Database.getConnection(Database.java:143) [20:52:55 WARN]: at CoreProtect-20.1.jar//net.coreprotect.database.Database.createDatabaseTables(Database.java:320) [20:52:55 WARN]: at CoreProtect-20.1.jar//net.coreprotect.config.ConfigHandler.loadDatabase(ConfigHandler.java:205) [20:52:55 WARN]: at CoreProtect-20.1.jar//net.coreprotect.config.ConfigHandler.performInitialization(ConfigHandler.java:367) [20:52:55 WARN]: at CoreProtect-20.1.jar//net.coreprotect.CoreProtect.onEnable(CoreProtect.java:71) [20:52:55 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264) [20:52:55 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:370) [20:52:55 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:500) [20:52:55 WARN]: at org.bukkit.craftbukkit.v1_17_R1.CraftServer.enablePlugin(CraftServer.java:561) [20:52:55 WARN]: at org.bukkit.craftbukkit.v1_17_R1.CraftServer.enablePlugins(CraftServer.java:475) [20:52:55 WARN]: at net.minecraft.server.MinecraftServer.loadWorld(MinecraftServer.java:733) [20:52:55 WARN]: at net.minecraft.server.dedicated.DedicatedServer.init(DedicatedServer.java:317) [20:52:55 WARN]: at net.minecraft.server.MinecraftServer.x(MinecraftServer.java:1220) [20:52:55 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:319) [20:52:55 WARN]: at java.base/java.lang.Thread.run(Thread.java:833)
For troubleshooting I have disabled all plugins but CoreProtect. After a restart, CoreProtect was back to normal; it successfully connected to my MySQL server. I have then reenabled one plugin after another. What I found out is, that as soon as I have Gringotts and CoreProtect both active, CoreProtect fails to connect.
I do not know if this is rather an issue with CoreProtect or with Gringotts, so I decided to file an issue with both plugins.
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Activating the Gringotts plugin does not interfere with CoreProtect. CoreProtect can still access its configured MySQL server when Gringotts is also activated.
Screenshots
No screenshots, it's all in the servers log.
Desktop (please complete the following information):
Additional context
Also filed this as an issue with CoreProtect, see https://github.com/PlayPro/CoreProtect/issues/117
Maybe this is valuable info: when shutting down the server, there are warnings caused by gingotts that also seem database related:
[20:55:45 INFO]: Closing Server [20:55:52 WARN]: java.lang.IllegalStateException: zip file closed [20:55:52 WARN]: at java.base/java.util.zip.ZipFile.ensureOpen(ZipFile.java:831) [20:55:52 WARN]: at java.base/java.util.zip.ZipFile.getEntry(ZipFile.java:330) [20:55:52 WARN]: at java.base/java.util.jar.JarFile.getEntry(JarFile.java:518) [20:55:52 WARN]: at java.base/java.util.jar.JarFile.getJarEntry(JarFile.java:473) [20:55:52 WARN]: at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:163) [20:55:52 WARN]: at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:587) [20:55:52 WARN]: at org.bukkit.plugin.java.PluginClassLoader.loadClass0(PluginClassLoader.java:108) [20:55:52 WARN]: at org.bukkit.plugin.java.PluginClassLoader.loadClass(PluginClassLoader.java:103) [20:55:52 WARN]: at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520) [20:55:52 WARN]: at gringotts-2.12.2.jar//com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.createStatus(PooledConnectionQueue.java:125) [20:55:52 WARN]: at gringotts-2.12.2.jar//com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.shutdown(PooledConnectionQueue.java:354) [20:55:52 WARN]: at gringotts-2.12.2.jar//com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.shutdown(DataSourcePool.java:689) [20:55:52 WARN]: at gringotts-2.12.2.jar//com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.shutdown(DataSourceManager.java:170)