HikariPool Spam

Hello Sponge Community.

I have currently been experiencing increased issues with a certain line that keeps repeating over and over in the fml-latest-log.log. This line happens 3 to up to 7 times per minute so far, and normally increases with the more players that are online. I am not a public server yet, so I reckon it would be much worse if I was.

Here is an extract of the logs: http://pastebin.com/ZHXhyZ8Z .
I do realize that I am running an outdated version of SpongeForge, though it was working fine as it until now. If it is a SpongeForge/Forge issue, I will update to whatever is recommended from your comments. Note that I am also running Pixelmon, known to cause issues with Sponge. Though doubt it is the case now (optimistic here).

Plugins List - with forge-1.8.9-11.15.1.1808-universal.jar:

  • EconomyLite-v2.0.5.jar
  • EnjinMinecraftForgePlugin-1.8.9-NuVotifierSponge.jar
  • EssentialsCmds-8.1.0.jar
  • Evs-Ivs-1.8.9-4.1.0-universal.jar
  • Kits-1.7.4.jar
  • mysql-connector-java-5.1.21.jar
  • NBTEdit-1.8.9-1.0.jar
  • PermissionsEx-Sponge.jar
  • PixelExtras-1.8.9-2.1.0-universal.jar
  • Pixelmon-1.8.9-4.2.5-univeral.jar
  • PixelmonEconomyBridge-1.1.1.jar
  • Polis-2.6.1.jar
  • spongeforge-1.8.9-1808-4.1.0-BETA-1282.jar
  • worldedit-forge-mc1.8.9-6.1.1.jar

Thank you for your help.

Looks normal to me. They’re just debug messages.

I have to say I’ve never seen those messages in my console…

They are related to the SQL service. Most of my plugins utilize H2 so I see them messages quite frequently.

They aren’t in the console, since they are debug messages, they only show up in the server’s log file. They messages are telling how many pools are open.

1 Like

My issue here is that often enough, I see these before the server times out - as I have said, they keep appearing in larger numbers before all players are kicked. Are they harmless in terms of memory?
If it is not affecting my server’s performance, I dont know what else it could be…

One of your plugins could be accessing the database in the main server thread, preventing anything from happening on the server until the database access finishes.

The time outs also may be unrelated to database connections.

Alright, seems that my testing sessions are still in order. Will check it out, and come back. Thanks Flibio.

1 Like

I found this out, could it be connected to EconomyLite? Seems to close connections then spams again, then closes and spams out again…

I’ve just tested on a server with just EconomyLite loaded, and saw no HikariPool debug messages, except on server startup and shutdown. I was spamming the balance command and repeatedly changing balances, yet saw nothing. Is it possible run your server with just EconomyLite?

I will try it - for reference, I was not even changing balances and all. I’ll let you know when I am done.

It is now only saying:
[00:53:27] [Server thread/DEBUG] [FML/]: Gathering id map for writing to world save ObliqueMain
over and over, no sign of HikariPool so far.

So there are no HikariPool messages with just EconomyLite installed?

Edit: I’ve left my test server running for some time, and I get the HikariPool debug messages about every minute or so. It shouldn’t be causing any server timeouts.

1 Like

Indeed. I will be re-adding the plugins one by one, but this is fine for now.