Problem/Bug World Guard Help - 1.18

Discussion in 'Bukkit Help' started by casperround, Mar 12, 2022.

Thread Status:
Not open for further replies.
  1. Offline

    casperround

    Previously on 1.17 the server was running fine with worldguard and mysql.
    However after updating to 1.18, and updating java to the latest for 1.18 I cannot now connect worldguard to mysql using jbdc.
    The database is working, and I can connect to using mysql-workbench.

    This is the error I get, also the config hasn't changed and is still set to connect via sql

    Code:
    [10:42:45 WARN]: [WorldGuard] Failed to load the region data for 'earth' (periodic attempts will be made to load the data until success)
    com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to migrate database tables
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.initialize(SQLDriver.java:110) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.initialize(SQLRegionDatabase.java:86) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.loadAll(SQLRegionDatabase.java:203) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.RegionManager.load(RegionManager.java:100) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.RegionContainerImpl.createAndLoad(RegionContainerImpl.java:138) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.RegionContainerImpl.load(RegionContainerImpl.java:115) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.bukkit.BukkitRegionContainer.load(BukkitRegionContainer.java:117) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.regions.RegionContainer.loadWorlds(RegionContainer.java:175) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.protection.regions.RegionContainer.reload(RegionContainer.java:97) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.worldguard.commands.WorldGuardCommands.reload(WorldGuardCommands.java:115) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
            at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
            at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
            at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.invokeMethod(CommandsManager.java:525) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:513) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:468) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.execute(CommandsManager.java:406) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onCommand(WorldGuardPlugin.java:278) ~[worldguard-bukkit-7.0.6-dist.jar:?]
            at com.sk89q.bukkit.util.DynamicPluginCommand.execute(DynamicPluginCommand.java:55) ~[worldedit-bukkit-7.2.9.jar:?]
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:159) ~[paper-api-1.18.2-R0.1-SNAPSHOT.jar:?]
            at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:905) ~[paper-1.18.2.jar:git-Paper-231]
            at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchServerCommand(CraftServer.java:868) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:510) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:484) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1458) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1227) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:317) ~[paper-1.18.2.jar:git-Paper-231]
            at java.lang.Thread.run(Thread.java:833) ~[?:?]
    Caused by: java.sql.SQLException: Failed to get a SQL connection due to an error
     
  2. Offline

    timtower Administrator Administrator Moderator

  3. Offline

    casperround

  4. Offline

    timtower Administrator Administrator Moderator

    Post a new log then
     
  5. Offline

    casperround

    Code:
    [13:18:11 WARN]: [WorldGuard] Failed to migrate
    com.sk89q.worldguard.protection.managers.migration.MigrationException: Migration failed because the process of getting a list of all the worlds to migrate failed
            at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:65) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.regions.RegionContainer.migrate(RegionContainer.java:160) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.commands.region.RegionCommands.migrateDB(RegionCommands.java:1039) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
            at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
            at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
            at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.invokeMethod(CommandsManager.java:525) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:513) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:468) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.minecraft.util.commands.CommandsManager.execute(CommandsManager.java:406) ~[worldedit-bukkit-7.2.9.jar:?]
            at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onCommand(WorldGuardPlugin.java:276) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.bukkit.util.DynamicPluginCommand.execute(DynamicPluginCommand.java:55) ~[worldedit-bukkit-7.2.9.jar:?]
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:159) ~[paper-api-1.18.2-R0.1-SNAPSHOT.jar:?]
            at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:905) ~[paper-1.18.2.jar:git-Paper-231]
            at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchServerCommand(CraftServer.java:868) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:510) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:484) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1458) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1227) ~[paper-1.18.2.jar:git-Paper-231]
            at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:317) ~[paper-1.18.2.jar:git-Paper-231]
            at java.lang.Thread.run(Thread.java:833) ~[?:?]
    Caused by: com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to fetch list of worlds
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:94) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            ... 21 more
    Caused by: java.sql.SQLException: Failed to get a SQL connection due to an error
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getConnection(SQLDriver.java:250) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:86) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            ... 21 more
    Caused by: java.util.concurrent.ExecutionException: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
            at java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:?]
            at java.util.concurrent.FutureTask.get(FutureTask.java:205) ~[?:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getConnection(SQLDriver.java:246) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:86) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            ... 21 more
    Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
            at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.27.jar:8.0.27]
            at java.sql.DriverManager.getConnection(DriverManager.java:681) ~[java.sql:?]
            at java.sql.DriverManager.getConnection(DriverManager.java:229) ~[java.sql:?]
            at com.sk89q.worldguard.util.sql.DataSourceConfig.getConnection(DataSourceConfig.java:141) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver$1.call(SQLDriver.java:241) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver$1.call(SQLDriver.java:238) ~[worldguard-bukkit-7.0.7-dist.jar:?]
            at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
            ... 1 more
    Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
     
  6. Offline

    timtower Administrator Administrator Moderator

    Can you connect by hand?
     
Thread Status:
Not open for further replies.

Share This Page