WARN com.zaxxer.hikari.pool.ProxyLeakTask - Connection leak detection triggered for com.mysql.jdbc.JDBC4Connection@15c236e2

[Oleg]

Description: Emulator freezes after a lot WARN com.zaxxer.hikari.pool.ProxyLeakTask - Connection leak detection triggered for com.mysql.jdbc.JDBC4Connection@15c236e2 errors

Long Descriptions:

Emulator starts throwing same errors and freezes. Happens after ~24h, >150 users online. Any ideas?

[ArcturusThreadFactory-1-4] INFO com.zaxxer.hikari.pool.ProxyLeakTask - Previously reported leaked connection com.mysql.jdbc.JDBC4Connection@15c236e2 was returned to the pool (unleaked)
[HikariPool-1 housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - Connection leak detection triggered for com.mysql.jdbc.JDBC4Connection@15c236e2, stack trace follows
java.lang.Exception: Apparent connection leak detected
        at com.eu.habbo.habbohotel.rooms.Room.loadData(Room.java:312)
        at com.eu.habbo.habbohotel.rooms.RoomManager.loadRoom(RoomManager.java:345)
        at com.eu.habbo.habbohotel.rooms.RoomManager.getGroupRooms(RoomManager.java:1473)
        at com.eu.habbo.habbohotel.navigation.NavigatorUserFilter.getResult(NavigatorUserFilter.java:46)
        at com.eu.habbo.messages.incoming.navigator.RequestNewNavigatorRoomsEvent.handle(RequestNewNavigatorRoomsEvent.java:198)
        at com.eu.habbo.messages.PacketManager.handlePacket(PacketManager.java:174)
        at com.eu.habbo.threading.runnables.ChannelReadHandler.run(ChannelReadHandler.java:27)
        at com.eu.habbo.threading.ThreadPooling$1.run(ThreadPooling.java:54)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:514)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:299)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:138)
        at java.base/java.lang.Thread.run(Thread.java:844)

(one error)

(more errors)

[Oleg]

Error is also triggered in another server parts.

Errors table doesn't tell anything

[Oleg]

And another update:

When I terminate server with ctrl+C, it takes about ~30 mins to shutdown

[Buggyz]

I have this too.. hikari pool connection leaks.!!!

[Oliver]

YES, THIS IS A MAJOR PROBLEM. Thank god someone brought it up, I always forget.

[Oleg]

Now my server is falling every cople hours. This is ridiculous.

Connections info: https://imgur.com/oZJXvdk

[Wesley]

Maybe instead of posting warnings (Thats basically what they are, they are NOT errors), ### post a thread dump. ### AND post a dump of active mysql connections.

Posting errors doesn't mean anything as it already says that it was a warning, that the previous 'leaked' connection was actually returned.

I cannot do anything with this.

[Wesley]

@Oleg Message me on skype / discord and I will check your server if you want.

[Wesley]

Seems to have been resolved in 1.13.0

[Wesley]

Removing version: 1.12.0 (automated comment)