Recently there's a strange MySQL error on my server.
If you query a method that has no idea why it is called, the log is spammed (26,000 lines) and ultimately crashes.
Incidentally, this is about a Minecraft server that runs with CloudNet & Spigot.
Even if it is. It is unimportant:
Java: 8
Javac: 8
Here is an extract from the log:
It goes on like this - 26,000 lines until the server crashes.
Here is the method that is returned as an error:
public static integer getGameFFACoinBoost1 (String uuid) throws SQLException {
int i = 0;
if (playerExistsFFA (uuid)) {PreparedStatement stat = MySQL.connection.prepareStatement ("SELECT CoinBoost1 FROM GameFFA WHERE UUID =?"); stat.setString (1, uuid); ResultSet result = stat.executeQuery (); if (result.first ()) {i = result.getInt ("CoinBoost1"); } stat.close (); } else {setupPlayerFFA (uuid); getGameFFACoinBoost1 (uuid); }
return i;
}
I really don't know what's that again.
Maybe someone of you has a clue.
If further information is required, please contact us.
Please also provide us with the error message (please via pastebin) so that we can help you.
PS: I'm blind and have not seen the link xD
Have you checked whether the setupPlayerFFA function works?
If it has a problem and does not create an entry in the GameFFA table with the appropriate UUID, you have an endless loop.
If playerExistsFFA has a problem and would always return false, you would have the same problem
I'll check that out soon, thanks.
I'm sorry, I couldn't get back to you earlier. So, the setupPlayer method works. Just like the playerExists method.
Is it perhaps because the database connection was closed again? Sometimes I have too many connections there. But then that's usually there too. And no stack overflow.