Minecraft server crashes due to MySQL?

Br
- in Servers
5

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.

Ap

Please also provide us with the error message (please via pastebin) so that we can help you.

Ap

PS: I'm blind and have not seen the link xD

Sh

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

Br

I'll check that out soon, thanks.

Br

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.