Grief Prevention

Grief Prevention

Bukkit Plugins
1M Downloads

Server Hang

msburgess3200 opened this issue · 3 comments

commented

Observed Behavior

I noticed when I restarted the server with a database connection string the server hangs and no connection is made.

Expected Behavior

The database to be created, and not hang.

Reproduction steps

Add a connection string to the config.yml and restart the server.

Stack trace or error log

[13:28:01] [Spigot Watchdog Thread/ERROR]: ------------------------------
[13:28:01] [Spigot Watchdog Thread/ERROR]: The server has stopped responding! This is (probably) not a Spigot bug.
[13:28:01] [Spigot Watchdog Thread/ERROR]: If you see a plugin in the Server thread dump below, then please report it to that author
[13:28:01] [Spigot Watchdog Thread/ERROR]: 	 *Especially* if it looks like HTTP or MySQL operations are occurring
[13:28:01] [Spigot Watchdog Thread/ERROR]: If you see a world save or edit, then it means you did far more than your server can handle at once
[13:28:01] [Spigot Watchdog Thread/ERROR]: 	 If this is the case, consider increasing timeout-time in spigot.yml but note that this will replace the crash with LARGE lag spikes
[13:28:01] [Spigot Watchdog Thread/ERROR]: If you are unsure or still think this is a Spigot bug, please report to https://www.spigotmc.org/
[13:28:01] [Spigot Watchdog Thread/ERROR]: Be sure to include ALL relevant console errors and Minecraft crash reports
[13:28:01] [Spigot Watchdog Thread/ERROR]: Spigot version: 4024-Spigot-c198da2-1617847 (MC: 1.20.4)
[13:28:01] [Spigot Watchdog Thread/ERROR]: ------------------------------
[13:28:01] [Spigot Watchdog Thread/ERROR]: Server thread dump (Look for plugins here before reporting to Spigot!):
[13:28:01] [Spigot Watchdog Thread/ERROR]: ------------------------------
[13:28:01] [Spigot Watchdog Thread/ERROR]: Current Thread: Server thread
[13:28:01] [Spigot Watchdog Thread/ERROR]: 	PID: 47 | Suspended: false | Native: false | State: TIMED_WAITING
[13:28:01] [Spigot Watchdog Thread/ERROR]: 	Stack:
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		[email protected]/java.lang.Thread.sleep(Native Method)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:876)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:810)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:438)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:189)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		platform/[email protected]/java.sql.DriverManager.getConnection(DriverManager.java:683)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		platform/[email protected]/java.sql.DriverManager.getConnection(DriverManager.java:191)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		me.ryanhamshire.GriefPrevention.DatabaseDataStore.refreshDataConnection(DatabaseDataStore.java:639)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		me.ryanhamshire.GriefPrevention.DatabaseDataStore.initialize(DatabaseDataStore.java:92)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		me.ryanhamshire.GriefPrevention.DatabaseDataStore.<init>(DatabaseDataStore.java:84)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		me.ryanhamshire.GriefPrevention.GriefPrevention.onEnable(GriefPrevention.java:290)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:266)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:342)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:480)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.craftbukkit.v1_20_R3.CraftServer.enablePlugin(CraftServer.java:539)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.craftbukkit.v1_20_R3.CraftServer.enablePlugins(CraftServer.java:453)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.craftbukkit.v1_20_R3.CraftServer.reload(CraftServer.java:966)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.Bukkit.reload(Bukkit.java:844)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:27)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:149)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.craftbukkit.v1_20_R3.CraftServer.dispatchCommand(CraftServer.java:875)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		org.bukkit.craftbukkit.v1_20_R3.CraftServer.dispatchServerCommand(CraftServer.java:860)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.dedicated.DedicatedServer.bk(DedicatedServer.java:412)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:388)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1242)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1054)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.MinecraftServer.lambda$0(MinecraftServer.java:304)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		net.minecraft.server.MinecraftServer$$Lambda$6142/0x0000000801667948.run(Unknown Source)
[13:28:01] [Spigot Watchdog Thread/ERROR]: 		[email protected]/java.lang.Thread.run(Thread.java:833)

Server version

>version
[13:39:19] [Server thread/INFO]: This server is running CraftBukkit version 4024-Spigot-c198da2-1617847 (MC: 1.20.4) (Implementing API version 1.20.4-R0.1-SNAPSHOT)

GriefPrevention version

>version GriefPrevention
[13:42:41] [Server thread/INFO]: GriefPrevention version 16.18.1

Configuration

# Default values are perfect for most servers.  If you want to customize and have a question, look for the answer here first: http://dev.bukkit.org/bukkit-plugins/grief-prevention/pages/setup-and-configuration/

GriefPrevention:
  SeaLevelOverrides:
    world: -1
  Claims:
    Mode:
      world: Disabled
    PreventGlobalMonsterEggs: true
    PreventTheft: true
    ProtectCreatures: true
    PreventButtonsSwitches: true
    LockWoodenDoors: false
    LockTrapDoors: false
    LockFenceGates: true
    EnderPearlsRequireAccessTrust: true
    RaidTriggersRequireBuildTrust: true
    ProtectHorses: true
    ProtectDonkeys: true
    ProtectLlamas: true
    InitialBlocks: 100
    Claim Blocks Accrued Per Hour:
      Default: 100
    Max Accrued Claim Blocks:
      Default: 80000
    Accrued Idle Threshold: 0
    AccruedIdlePercent: 0
    AbandonReturnRatio: 1.0
    AutomaticNewPlayerClaimsRadius: 4
    AutomaticNewPlayerClaimsRadiusMinimum: 0
    ExtendIntoGroundDistance: 5
    MinimumWidth: 5
    MinimumArea: 100
    MaximumDepth: -2147483648
    InvestigationTool: STICK
    ModificationTool: GOLDEN_SHOVEL
    Expiration:
      ChestClaimDays: 7
      UnusedClaimDays: 14
      AllClaims:
        DaysInactive: 60
        ExceptWhenOwnerHasTotalClaimBlocks: 10000
        ExceptWhenOwnerHasBonusClaimBlocks: 5000
      AutomaticNatureRestoration:
        SurvivalWorlds: false
    AllowTrappedInAdminClaims: false
    MaximumNumberOfClaimsPerPlayer: 0
    CreationRequiresWorldGuardBuildPermission: true
    VillagerTradingRequiresPermission: true
    CommandsRequiringAccessTrust: /sethome
    DeliverManuals: true
    ManualDeliveryDelaySeconds: 30
    RavagersBreakBlocks: true
    FireSpreadsInClaims: false
    FireDamagesInClaims: false
    LecternReadingRequiresAccessTrust: true
  Spam:
    Enabled: true
    LoginCooldownSeconds: 60
    LoginLogoutNotificationsPerMinute: 5
    ChatSlashCommands: /me;/global;/local
    WhisperSlashCommands: /tell;/pm;/r;/whisper;/msg
    WarningMessage: Please reduce your noise level.  Spammers will be banned.
    BanOffenders: true
    BanMessage: Banned for spam.
    AllowedIpAddresses: 1.2.3.4; 5.6.7.8
    DeathMessageCooldownSeconds: 120
    Logout Message Delay In Seconds: 0
  PvP:
    RulesEnabledInWorld:
      world: true
    ProtectFreshSpawns: true
    PunishLogout: true
    CombatTimeoutSeconds: 15
    AllowCombatItemDrop: false
    BlockedSlashCommands: /home;/vanish;/spawn;/tpa
    ProtectPlayersInLandClaims:
      PlayerOwnedClaims: true
      AdministrativeClaims: true
      AdministrativeSubdivisions: true
    AllowLavaDumpingNearOtherPlayers:
      PvPWorlds: true
      NonPvPWorlds: false
    AllowFlintAndSteelNearOtherPlayers:
      PvPWorlds: true
      NonPvPWorlds: false
    ProtectPetsOutsideLandClaims: false
  Economy:
    ClaimBlocksMaxBonus: 0
    ClaimBlocksPurchaseCost: 0.0
    ClaimBlocksSellValue: 0.0
  ProtectItemsDroppedOnDeath:
    PvPWorlds: false
    NonPvPWorlds: true
  BlockLandClaimExplosions: true
  BlockSurfaceCreeperExplosions: true
  BlockSurfaceOtherExplosions: true
  LimitSkyTrees: true
  LimitTreeGrowth: false
  PistonMovement: CLAIMS_ONLY
  PistonExplosionSound: true
  FireSpreads: false
  FireDestroys: false
  AdminsGetWhispers: true
  AdminsGetSignNotifications: true
  VisualizationAntiCheatCompatMode: false
  SmartBan: true
  Mute New Players Using Banned Words: true
  MaxPlayersPerIpAddress: 3
  SilenceBans: true
  Siege:
    Worlds: []
    BreakableBlocks:
    - GRASS_BLOCK
    - DIRT
    - COBBLESTONE
    - OAK_PLANKS
    - SPRUCE_PLANKS
    - BIRCH_PLANKS
    - JUNGLE_PLANKS
    - ACACIA_PLANKS
    - DARK_OAK_PLANKS
    - SAND
    - GRAVEL
    - GLASS
    - SHORT_GRASS
    - FERN
    - DEAD_BUSH
    - WHITE_WOOL
    - ORANGE_WOOL
    - MAGENTA_WOOL
    - LIGHT_BLUE_WOOL
    - YELLOW_WOOL
    - LIME_WOOL
    - PINK_WOOL
    - GRAY_WOOL
    - LIGHT_GRAY_WOOL
    - CYAN_WOOL
    - PURPLE_WOOL
    - BLUE_WOOL
    - BROWN_WOOL
    - GREEN_WOOL
    - RED_WOOL
    - BLACK_WOOL
    - SNOW
    - GLASS_PANE
    DoorsOpenDelayInSeconds: 300
    CooldownEndInMinutes: 60
  EndermenMoveBlocks: false
  SilverfishBreakBlocks: false
  CreaturesTrampleCrops: false
  RabbitsEatCrops: true
  HardModeZombiesBreakDoors: false
  Database:
    URL: jdbc:mysql://******:3306/*****
    UserName: *****
    Password: *****
  UseBanCommand: false
  BanCommandPattern: ban %name% %reason%
  Advanced:
    fixNegativeClaimblockAmounts: true
    ClaimExpirationCheckRate: 60
    OfflinePlayer_cache_days: 90
  Abridged Logs:
    Days To Keep: 7
    Included Entry Types:
      Social Activity: true
      Suspicious Activity: true
      Administrative Activity: false
      Debug: false
      Muted Chat Messages: false
  ConfigVersion: 1

Plugin list

>pl
[13:43:41] [Server thread/INFO]: Plugins (19): LuckPerms, CMILib, WorldBorder, Vault, SimplePortals, dynmap, Citizens, WorldEdit, Essentials, EssentialsChat, EssentialsGeoIP, EssentialsAntiBuild, Shop, Jobs, XConomy, EssentialsSpawn, GriefPrevention, EssentialsMysqlStorage, MysqlPlayerDataBridge

Running without GriefPrevention

  • I attempted running the server without GriefPrevention installed.
  • The problem does not occur when GriefPrevention is removed from the server.

Running with only GriefPrevention

  • I attempted running only GriefPrevention on the server.
  • The issue still occurs when GriefPrevention is the only plugin running.

Running on a fresh, clean server installation

  • I attempted testing for the issue on a new server.
  • The issue still occurs on a new server.

Using unmodified client

  • I attempted testing for the issue with the vanilla client.
  • The issue still occurs when using the vanilla client.

We appreciate you taking the time to fill out a bug report!

  • I searched for similar issues before submitting this bug report.
commented

An aside: @RoboMWM, I don't appear to have triage rights here now that we're on the new org.

commented

Duplicate of #1169

commented

Weird, they all went to read perms. Thought I double checked upon initial transfer but maybe not. Fixed now.

  • 👍1