InventoryRollbackPlus: Communications link failure

[JorisvD01]

Bug description:

Console spamming this error when players are online, playing normally. I doesn't seem related to joins / leaves, just happens randomly

Server details:

• This server is running Paper version git-Paper-399 (MC: 1.20.4) (Implementing API version 1.20.4-R0.1-SNAPSHOT) (Git: b03f255)
• v1.6.16

How to reproduce:

N/A

What was expected:

N/A

Screenshots, logs & other:

https://pastebin.com/VJRQDiSM

Additional info:

Having this issue on multiple servers, all connected to different databases

[sennby]

same

[TechnicallyCoded]

For anyone stumbling on this: Caused by: java.net.SocketTimeoutException: Read timed out is technical jargon for "I have not received a reply from the database server". Most likely due to one (or more) of the following:

• Firewall settings blocking connections
• An incorrect IP provided in the config (connecting to the wrong server)
• A connection hiccup between the MC server and the DB server, causing the connection to drop
• Some DB servers will terminate open connections after a certain amount of time in a way that is hard (impossible?) for the default MySQL driver to recover from.

The only change I could make is not use your default MySQL driver and bundle my own (this could lead to better reconnection attempts, or better information about the issue, or both). This was already discussed in a discord channel, so I am not going to re-state everything but it is a possibility I am exploring. It would make IRP much heavier to download, which I don't really love.

If you have any other questions please make a new issue. I am locking this as a reference for people that are looking for a series of possible solutions.