BungeeCord MySQL Error
Closed this issue ยท 11 comments
Im just setting up a small BungeeCord Network on my localhost using one spigot server and one bungeecord server. I have typed the MySQL information into both servers. When i create a database and start the proxy i get this error:
https://pastebin.com/PsJAc5rX
Im using LuckPerms 4.3.60
Seems to be related to this commit.
I'm not really sure what to do to fix it though. Could revert I guess?
I now switched on version 4.3.61 and it it doesn't occur currently on that version. Maybe it fixed itself?
Errors goes away after creating all tables, meaning after restart it will "fix" it self. Changing that version did not effect it. try truncating whole db and error will come back
I too have this same issue.... If database is empty, issue exists when new tables are generated. After tables are generated, upon a reboot of the server, the console will no longer show the severe issues. Shutting down server, then dropping all tables on DB, booting server back up will result in the issue surfacing again.
Also, I am experiencing this on the BungeeCord server (haven't tested this on main servers just yet).
Lastly - I've confirmed this issue is not present on this version:
Will hopefully be fixed by c4154c0
Would one of you guys mind dropping your DBs again and testing using the latest version?
https://ci.lucko.me/job/LuckPerms/839/
Dropped my DB tables, tested with your latest version and the issue seems to be corrected. Here's the console output (no errors):
Are there any where clauses for the permission column? Because if so there definitely should be an index.
I think a fulltext Index could work here.
There are some lookups by permission, but they are only for the /lp search, /lp group <g> listmembers and bulkupdate commands.
Not really worth having an index for imo.