Database somewhat crashes
Issue #86
duplicate
We regularly have RC's database crushed after a server restart. No matter if its SQLite or MySQL, RC just keeps loading it forever and noone can enter unless we delete database and restart again. Hoped that it was fixed in 2.3.6, but it's actually dont
kicks like that(message was translated in cfg):
[05:01:08] [Server thread/INFO]: Disconnecting com.mojang.authlib.GameProfile@52f4ffc8[id=5096f846-aed4-3e98-93dd-cfed5d765fb2,name=lilonchik2,properties={textures=[com.mojang.authlib.properties.Property@8af24e2]},legacy=false] (/77.245.162.176:43033): [!] Идёт загрузка данных... [05:01:08] [Server thread/INFO]: com.mojang.authlib.GameProfile@52f4ffc8[id=5096f846-aed4-3e98-93dd-cfed5d765fb2,name=lilonchik2,properties={textures=[com.mojang.authlib.properties.Property@8af24e2]},legacy=false] (/77.245.162.176:43033) lost connection: [!] Идёт загрузка данных...
Comments (10)
-
repo owner
-
We were using last build of paper, now using tuinity, so there is no matter what core are we using. Loading is not the only problem. The whole database system works like shit. We have extended worldedit enabled and when a donator with restricted gamemode tries to //set - server laggs to 1TPS for 5-10 seconds, cuz RC causes lags when trying to log every block that is being set.
-
repo owner
You didn’t answer most of my questions. I can’t help you if you don’t help me here.
Could you send me a timings report of when the lag happens?
Do you have a better database system? I’d like to see it.
-
Just started a test server with only WG, WE, CMI and ur plugin installed. Started to //set some prismarine bricks, and server crashed as soon as RC database work occured
-
And i think there is no matter what database system we are using (MariaDB btw) because i crashes no matter if ur on mysql or sqlite
-
repo owner
I’ll test it myself and see if I can reproduce the issue.
-
repo owner
I set 2.8M blocks with FAWE and it indeed crashed on save and loads seemingly forever on startup. This is interesting, because one server owner has over 8 million blocks which loads fine, albeit slowly. I’ll see if I can fix this.
-
repo owner
It seems that it simply loads really slowly, approximately 30k/min in my case. I’ll have to find a way to speed this up.
-
repo owner
I’ll merge database-related issues into one, see
#89. -
repo owner
- changed status to duplicate
Duplicate of
#89. - Log in to comment
Hi!
What version of Spigot are you using? Does the crash occur every time after a server restart? What about a reload? Does it still happen if all other plugins are removed?
You can try disabling
general.loading.delay-loginin the config to allow players into the server even if the database isn’t fully loaded yet and see if creative-placed blocks will drop or not. You can also try using the old loading system by enablinggeneral.loading.use-old-systemin the config to see if that solves the problem.