FabioZumbi12 / Sponge-RankUpper

Plugin to promote players based on requeriments
GNU General Public License v3.0
5 stars 12 forks source link

[BUG] Rankupper H2 Database Corruption #38

Open NLBlacky opened 5 years ago

NLBlacky commented 5 years ago

Note: Jenkins link to Rankupper was invalid (the one given in the bug template) so I confirmed if I was on the latest version with https://ore.spongepowered.org/FabioZumbi12/RankUpper

Describe the bug For an unknown reason our database seems to be getting corrupted with very long lines which makes the plugin crash on startup (see logs provided below this post). It happens since we updated to version 4.0.4 ~3 week ago. Even after rolling back our H2 DB from a backup, the plugin would still not work. Last monday we decided to wipe the database which fixed the issue, but today (and I don't know for how long) we noticed that it was corrupted again. Only solution so far seems to be wiping it.

To Reproduce We're not exactly sure what the trigger is. We haven't been able to find out when exactly it happens, all we know is that it happens since the latest update.

Weirdly enough we've this plugin running on a total of 8 modpacks, and only FTB Sky Odyssey is giving this error. The other modpacks that we run is displayed here: https://ftbservers.com/server/HRPBKjRT/eu-na-pixel-gaming (I hope this link is fine? It was the fastest and provides links to the modpack sites).

Expected behavior I expect the plugin to work, and not having database errors every once in a while.

Screenshots and LOGs Error: https://gist.github.com/NLBlacky/cd427a0848b61e79abf99ca3e64ecdf5

Server and plugins versions (please complete the following information):

Additional context Our playerstats.db.mv and playerstats.db.trace: https://gofile.io/?c=YR0CDs Not sure where to upload this. If you prefer another site, please tell me.

FabioZumbi12 commented 5 years ago

Jenkins is back online, try with build 25.