Database save error

[DarkObscurity]

Description

Describe the bug

In the console I get random transaction errors, they occur randomly and I can't figure out whats wrong. No other plugin in any server of us has issues with the MySQL database. Is this maybe a known issue, or am I missing something? :x

Steps to reproduce the behavior

There are no real steps to reproduce as it happens randomly, sometimes on player join, sometimes randomly during the day, sometimes at server shutdown.. It also sometimes happens multiple times a day.

Screenshots and videos

https://gyazo.com/1a8731b2b4aa9983a9bf0ec28490459e (This is one during shutdown)

Expected behavior

No errors?

Environment

Server

• OS: Ubuntu 18.04.2 LTS (GNU/Linux 4.15.0-50-generic x86_64)
• Java version: OpenJDK Runtime Environment (build 1.8.0_212-8u212-b01-1~deb9u1-b01)

Plugins

[CHAT] Plugins (54): AdvancedOreGen*, AnimatedNames*, AntiAFKPro*, AsyncWorldEdit, Autorank, BannerBoard*, BentoBox, ChatControl, ChatLog*, Citizens, ClearLag*, CMI, DailyRewards*, DeluxeChat, EpicFurnaces*, Essentials, EssentialsSpawn, eZProtector, FeatherBoard*, HyperDrive, LogBlock, LuckPerms, mcMMO, mcMMOAction*, MobFarmManager, Multiverse-Core, Multiverse-NetherPortals, MVdWPlaceholderAPI*, MyCommand*, PinataParty*, PlaceholderAPI, PluginLibrary*, PlugMan*, PremiumVanish, ProtocolLib*, ProtocolSupport, Skellett*, Skript, Skungee*, Spartan, Statscraft*, Statz, TradePlus, TryMe, UltimateRepairing, Vault*, ViaVersion*, VoidGenerator, Votifier, VotingPlugin, WorldBorder, WorldEdit, WorldGuard, WorldGuardExtraFlags

BentoBox setup

BentoBox and Addons

[CHAT] Running PAPER 1.13.2.
[CHAT] BentoBox version: 1.5.3
[CHAT] Loaded Game Worlds:
[CHAT] commands.bentobox.version.game-world
[CHAT] Loaded Addons:
[CHAT] Biomes 1.5.0.0
[CHAT] BSkyBlock 1.5.3-SNAPSHOT
[CHAT] Challenges 0.7.5
[CHAT] Greenhouses 0.0.3-SNAPSHOT
[CHAT] Level 1.5.1-SNAPSHOT
[CHAT] Limits 0.2.0-SNAPSHOT

Configuration

• Database: MYSQL

Additional context

We've also experienced random players losing their progress with their challenges on random intervals and not every player has been affected so far. We where able to restore their progress by manually editing their challenges progress in the admin GUI. I have no idea if that is related to this, but maybe it's usefull information.

[tastybento]

What version of MYSQL server are you running?

[tastybento]

This is a very mysterious error. Googling it shows that others have seen this but there doesn't seem to be concrete guidance on a solution. We need more logs. Attached is a version of 1.6.0 that has a stack trace dump when this error occurs. Can you use this and see if we can grab some logs? It might give more information on why the error is occurring. Take backups before you use this version just in case.

BentoBox-1.6.0-SNAPSHOT-LOCAL.jar.zip

[DarkObscurity]

I'm running MySQL version 5.7.26

and do you maybe have a version with stack trace dump for BentoBox 1.5.3? With that version all addons are running without errors for us :x

[tastybento]

Here you go.
BentoBox-1.5.3-debug-SNAPSHOT-LOCAL.jar.zip

[tastybento]

I think this is related to #805

[DarkObscurity]

Could be, and from what i read it sounds possible, but i've already modified the max connection limit in MySQL and changed the apparmor settings for MySQL aswell to allow a connection limit of 500 and we're not even close to reaching that.

But it does look like bentobox is losing it's database connection.

But I don't fully understand why it returns a message with "received a read-only status from the server"

I'll try the provided jar file as soon as possible, thanks for the help in advance!