Database failed to open

[Doonplex]

Describe the issue

Anytime I start my server it shows a failed message for plan. What's weird is it worked when I had my proxy off but the moment I turned my proxy on and restarted it, got the same message.

Exceptions & Other Logs

f944058923 - Last occurred: 2026-03-04 Occurrences: 4
---- Context 4 ----
Plan v5.7 build 3247
Paper 1.21.4-232-12d8fe0 (MC: 1.21.4)
Server v1.21.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch
DB State: CLOSED - fatal: true
Error code: 1040
SELECT COUNT(*) as c FROM plan_join_address WHERE INSTR(join_address, CHAR(0)) FOR UPDATE
Unknown SQL Error code

---- Context 3 ----
Plan v5.7 build 3247
Paper 1.21.4-232-12d8fe0 (MC: 1.21.4)
Server v1.21.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch
DB State: CLOSED - fatal: true
Error code: 1040
SELECT COUNT(*) as c FROM plan_join_address WHERE INSTR(join_address, CHAR(0)) FOR UPDATE
Unknown SQL Error code

---- Context 2 ----
Plan v5.7 build 3247
Paper 1.21.4-232-12d8fe0 (MC: 1.21.4)
Server v1.21.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch
DB State: CLOSED - fatal: true
Error code: 1040
SELECT COUNT(*) as c FROM plan_join_address WHERE INSTR(join_address, CHAR(0)) FOR UPDATE
Unknown SQL Error code

---- Context 1 ----
Plan v5.7 build 3247
Paper 1.21.4-232-12d8fe0 (MC: 1.21.4)
Server v1.21.4-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch
DB State: CLOSED - fatal: true
Error code: 1040
SELECT COUNT(*) as c FROM plan_join_address WHERE INSTR(join_address, CHAR(0)) FOR UPDATE
Unknown SQL Error code

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch failed to execute and database could not be opened: SQL Failure: Plan Connection Pool-1 - Connection is not available, request timed out after 30000ms (total=1, active=1, idle=0, waiting=0)
java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1770)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
com.djrapitops.plan.exceptions.database.FatalDBException: com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch failed to execute and database could not be opened: SQL Failure: Plan Connection Pool-1 - Connection is not available, request timed out after 30000ms (total=1, active=1, idle=0, waiting=0)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:41)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:327)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:326)
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
java.sql.SQLTransientConnectionException: Plan Connection Pool-1 - Connection is not available, request timed out after 30000ms (total=1, active=1, idle=0, waiting=0)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:714)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:184)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:142)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.MySQLDB.getConnection(MySQLDB.java:223)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$query$2(SQLDB.java:293)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:293)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.Database.queryOptional(Database.java:63)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch.lambda$hasBadAddressIds$3(BadJoinAddressDataCorrectionPatch.java:120)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$queryWithinTransaction$3(SQLDB.java:297)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:96)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:91)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.queryWithinTransaction(SQLDB.java:297)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.Transaction.query(Transaction.java:228)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch.hasBadAddressIds(BadJoinAddressDataCorrectionPatch.java:120)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.patches.BadJoinAddressDataCorrectionPatch.hasBeenApplied(BadJoinAddressDataCorrectionPatch.java:46)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.patches.Patch.shouldBeExecuted(Patch.java:54)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:81)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:36)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:327)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:61)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:326)
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
java.base/java.lang.Thread.run(Thread.java:1583)
Caused by:
java.sql.SQLNonTransientConnectionException: Connection exception, SQL-server rejected establishment of SQL-connection, message from server: "Too many connections"
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:837)
com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:420)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:144)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:373)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:210)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:488)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:752)
Plan-5.7-build-3247.jar//plan.com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:731)
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
java.base/java.lang.Thread.run(Thread.java:1583)
java.base/java.lang.Thread.getStackTrace(Thread.java:2450)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:313)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.setupDatabase(SQLDB.java:218)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.SQLDB.init(SQLDB.java:168)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.DBSystem.enable(DBSystem.java:103)
Plan-5.7-build-3247.jar//com.djrapitops.plan.storage.database.BukkitDBSystem.enable(BukkitDBSystem.java:54)
Plan-5.7-build-3247.jar//com.djrapitops.plan.PlanSystem.enableSystems(PlanSystem.java:189)
Plan-5.7-build-3247.jar//com.djrapitops.plan.PlanSystem.enableOtherThanCommands(PlanSystem.java:146)
Plan-5.7-build-3247.jar//com.djrapitops.plan.PlanSystem.enable(PlanSystem.java:184)
Plan-5.7-build-3247.jar//com.djrapitops.plan.Plan.onEnable(Plan.java:94)
org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:280)
io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202)
io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109)
org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520)
org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:658)
org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:607)
net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:743)
net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:488)
net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:322)
net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1163)
net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:310)
java.base/java.lang.Thread.run(Thread.java:1583)

### Plugin versions
5.7 build 3247

### Additional information
<!-- Any additional information, context, what was attempted, etc -->

[AuroraLS3]

It says that connection to the mysql database was not available in the pool with total 1 connection. I recommend increasing Database.MySQL.Max_connections if you have it set to 1, it is not enough.

Alternatively the database is too far away from the server physically, or under too heavy load during the enable

[Doonplex]

I have it set to 8 and I have my own dedicated server so the database base is on the same server computer.

[AuroraLS3]

Sorry I missed this in the exception log

SQLNonTransientConnectionException: Connection exception, SQL-server rejected establishment of SQL-connection, message from server: "Too many connections"

You need to increase max_connections in the mysql configuration file, or reduce the total amount of connections all plugins use

[Doonplex]

So either add more max connections to the config for the proxy? just for clarification, how would I lower the amount of connections?

[AuroraLS3]

You need to add more connections to my.cnf of the mysql/Mariadb https://stackoverflow.com/a/19991390

Reducing connections from plugins usually involves similar to what I mentioned (Reducing Database.MySQL.Max_connections in Plan config and similar settings in other plugins)

[Doonplex]

Okay I will try tomorrow, thank you so much