LuckPerms

LuckPerms

41.4k Downloads

Mysql timeout

artur9010 opened this issue ยท 4 comments

commented

Description

Hey, i'm getting timeouts on luckperms mysql connections after update from 1.16 to 1.18. Latest lp, other plugins connects fine.
Server running on 1.16 with that same config and luckperms version connects fine.

Last packet sent to mysql from minecraft container:
image
image

mysql 8.0.23 running inside k8s/docker
mysql client from minecraft container connects fine to mysql database in another container

All mysql settings, firewall, privileges, password etc are correct.

Reproduction Steps

I do not know how to reproduce, it just happens :/

Expected Behaviour

Do not timeout

Server Details

git-Paper-357 (MC: 1.18.2)

LuckPerms Version

LuckPerms v5.4.26

Logs and Configs

https://gist.github.com/artur9010/7b3b2a9b852a815b2d986e647e862705

Extra Details

No response

commented

Welp, looks like luckperms can't connect in 5s after update. Increased timeout from 5 to 10s and now works fine, weird.

commented

same for me. Is it possible to fix?
Tbh start time is important :/

commented

image
As you can see, there is a gap on network between last luckperms mysql query (response is instant), after it it doing something and trying to connect to redis after 4 seconds. It resolves redis dns instantly, connects and subscribes.
After that it still doing something for few more seconds and runs mysql queries like

SELECT name FROM `luckperms_groups`

also those requests are instant.

commented

You can configure the connection timeout in the LP config.yml -- data.pool-settings.connection-timeout