When updating the version to 3.1.0, the menu does not open to 1.20.6

[BAD7777]

Hi. I am writing to the chat /axir view (nickname) and no action is taking place. On version 3.0.0. everything works.
Checking version, please wait...
Current Purpur Version: 1.20.6-2233-0d6766e (MC: 1.20.6)
You are running the latest version
Previous: 1.20.6-2232-f1c87e4 (MC: 1.20.6)

[BenceX100]

Are there any errors in the console?

[BAD7777]

I am writing this command and there is no reaction. But before that, mistakes came out.

[AxInventoryRestore-Datastore-thread/ERROR]: [com.artillexstudios.axinventoryrestore.database.impl.Base] An unexpected error occurred while cleaning up!
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:124) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:988) ~[mysql-connector-j-8.3.0.jar:8.3.0]
at AxInventoryRestore-3.1.0.jar/com.artillexstudios.axinventoryrestore.libs.hikari.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[AxInventoryRestore-3.1.0.jar:?]
at AxInventoryRestore-3.1.0.jar/com.artillexstudios.axinventoryrestore.libs.hikari.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[AxInventoryRestore-3.1.0.jar:?]
at AxInventoryRestore-3.1.0.jar/com.artillexstudios.axinventoryrestore.database.impl.Base.cleanup(Base.java:591) ~[AxInventoryRestore-3.1.0.jar:?]
at AxInventoryRestore-3.1.0.jar/com.artillexstudios.axinventoryrestore.AxInventoryRestore.lambda$enable$1(AxInventoryRestore.java:106) ~[AxInventoryRestore-3.1.0.jar:?]
at AxInventoryRestore-3.1.0.jar/com.artillexstudios.axinventoryrestore.libs.axapi.data.ThreadedQueue.run(ThreadedQueue.java:52) ~[AxInventoryRestore-3.1.0.jar:?]
at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]

[BenceX100]

I think the database is locked for some reason, that is probably the reason the issue, maybe if you wait a bit, it will work again

[BAD7777]

Is it possible because of the large number of players? Then should I switch to h2?

[BAD7777]

If I change to compact-database: false, can the problem be solved?

[BAD7777]

Unfortunately, as you said, nothing is happening. You have done something with mysql queries and that is why such problems occur.

[BAD7777]

When using H2, the server experiences significant load, and with MySQL, no queries or backups are being created at all. The plugin no longer delivers any performance benefits. It seems we'll have to completely abandon the plugin, as the prolonged wait for version 1.20.6 and the objectively unoptimized plugin have simply not justified the expectations and anticipation.

[BAD7777]

When using /axir, reload does not change anything in essence. And you only need to restart the server.

[BAD7777]

The problem is solved

ef8a9a1

[BAD7777]

Now the command opens after 30 minutes
/axir view

[AverageGithub]

That's odd, we will try fixing this issue as soon as possible

[AverageGithub]

Could you please provide a link to the spark report that you have previously attached a screenshot from? If you can't find that link it's also fine if you send a link of a fresh report.

[AverageGithub]

This was most likely fixed in the last version, could you try running that?

[anmvc]

When using H2, the server experiences significant load, and with MySQL, no queries or backups are being created at all. The plugin no longer delivers any performance benefits. It seems we'll have to completely abandon the plugin, as the prolonged wait for version 1.20.6 and the objectively unoptimized plugin have simply not justified the expectations and anticipation.

That's still basicly no load at all on H2