[Bug Report]: [20:52:21 WARN] [org.mariadb.jdbc.message.server.ErrorPacket]: `Error: 1142-42000: SELECT command denied to user 'mc_user'@'localhost' for table 'user_variables_by_thread'`

[ChefMC]

LibertyBans Version

LibertyBans_Release-1.1.0-RC1

I have confirmed that ...

• [X] LibertyBans is up to date
• [X] No similar issue has been reported

Platform

Velocity

Description

Percona MySQL 8:

[20:52:21 WARN] [org.mariadb.jdbc.message.server.ErrorPacket]: Error: 1142-42000: SELECT command denied to user 'mc_bignet'@'localhost' for table 'user_variables_by_thread'

Full log:

[20:52:21 INFO] [libertybans]: No addons detected
[20:52:21 INFO] [space.arim.libertybans.core.addon.AddonLoader]: No addons loaded
[20:52:21 INFO] [space.arim.libertybans.core.AbstractBaseFoundation]: Conducting start phase...
[20:52:21 INFO] [com.zaxxer.hikari.HikariDataSource]: LibertyBansPool-MySQL - Starting...
[20:52:21 INFO] [com.zaxxer.hikari.pool.HikariPool]: LibertyBansPool-MySQL - Added connection org.mariadb.jdbc.Connection@20cae351
[20:52:21 INFO] [com.zaxxer.hikari.HikariDataSource]: LibertyBansPool-MySQL - Start completed.
[20:52:21 INFO] [org.flywaydb.core.internal.license.VersionPrinter]: Flyway Community Edition 8.2.0 by Redgate
[20:52:21 INFO] [org.flywaydb.core.internal.database.base.BaseDatabaseType]: Database: jdbc:mariadb://localhost/mc_bignet (MySQL 8.0)
[20:52:21 WARN] [org.mariadb.jdbc.message.server.ErrorPacket]: Error: 1142-42000: SELECT command denied to user 'mc_bignet'@'localhost' for table 'user_variables_by_thread'
[20:52:22 INFO] [org.flywaydb.core.internal.command.DbValidate]: Successfully validated 15 migrations (execution time 00:00.028s)
[20:52:22 INFO] [org.flywaydb.core.internal.command.DbMigrate]: Current version of schema `mc_bignet`: 38
[20:52:22 INFO] [org.flywaydb.core.internal.command.DbMigrate]: Schema `mc_bignet` is up to date. No migration necessary.
[20:52:22 INFO] [space.arim.libertybans.core.AbstractBaseFoundation]: Finished start phase in 0,404 seconds

[ChefMC]

Even after deletion of all LiberyBans tables and views

[A248]

One of our libraries, Flyway, attempts to work with this table for reasons that are irrelevant to LibertyBans. This message is safe to ignore, because Flyway purposefully catches the error and handles it. The functionality that Flyway disables as a result of the error is not necessary for LibertyBans to work properly, and it never will be, since cleaning up local variables is doubly handled by our connection pool.