Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in console CompletionException #3879

Open
Funnytom118 opened this issue Dec 11, 2024 · 1 comment
Open

Error in console CompletionException #3879

Funnytom118 opened this issue Dec 11, 2024 · 1 comment
Labels
Bug Issues that contain unintended behavior

Comments

@Funnytom118
Copy link

Describe the issue

Erorr in console:

19:22:10 [SEVERE] [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-82d37f2caa.txt
19:22:10 [SEVERE] [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
19:22:10 [SEVERE] [Plan] Error msg: "com.djrapitops.plan.exceptions.database.DBOpException: PingStoreTransaction initialization failed: Plan Connection Pool-1 - Connection is not available, request timed out after 30038ms (total=2, active=0, idle=2, waiting=0)"

Exceptions & Other Logs

82d37f2caa - Last occurred: 2024-12-11 Occurrences: 1
---- Context 1 ----
Plan v5.6 build 2883
BungeeCord git:BungeeCord-Bootstrap:1.21-R0.1-SNAPSHOT:acb85e3:1871
Server vgit:BungeeCord-Bootstrap:1.21-R0.1-SNAPSHOT:acb85e3:1871

Transaction: class com.djrapitops.plan.storage.database.transactions.events.PingStoreTransaction
DB State: OPEN - fatal: false

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: PingStoreTransaction initialization failed: Plan Connection Pool-1 - Connection is not available, request timed out after 30038ms (total=2, active=0, idle=2, 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.DBOpException: PingStoreTransaction initialization failed: Plan Connection Pool-1 - Connection is not available, request timed out after 30038ms (total=2, active=0, idle=2, waiting=0)
   com.djrapitops.plan.storage.database.transactions.Transaction.initializeConnection(Transaction.java:181)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:83)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   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 30038ms (total=2, active=0, idle=2, waiting=0)
   plan.com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:686)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:179)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:144)
   plan.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99)
   com.djrapitops.plan.storage.database.MySQLDB.getConnection(MySQLDB.java:212)
   com.djrapitops.plan.storage.database.transactions.Transaction.initializeConnection(Transaction.java:179)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:83)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   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: No operations allowed after connection closed.
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:81)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:55)
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:65)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
   com.mysql.cj.jdbc.ConnectionImpl.setNetworkTimeout(ConnectionImpl.java:2650)
   plan.com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:562)
   plan.com.zaxxer.hikari.pool.PoolBase.isConnectionDead(PoolBase.java:169)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:168)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:144)
   plan.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99)
   com.djrapitops.plan.storage.database.MySQLDB.getConnection(MySQLDB.java:212)
   com.djrapitops.plan.storage.database.transactions.Transaction.initializeConnection(Transaction.java:179)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:83)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   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:
com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed.
   java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
   java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
   java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:95)
   com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:140)
   com.mysql.cj.NativeSession.checkClosed(NativeSession.java:915)
   com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:586)
   com.mysql.cj.jdbc.ConnectionImpl.setNetworkTimeout(ConnectionImpl.java:2646)
   plan.com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:562)
   plan.com.zaxxer.hikari.pool.PoolBase.isConnectionDead(PoolBase.java:169)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:168)
   plan.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:144)
   plan.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99)
   com.djrapitops.plan.storage.database.MySQLDB.getConnection(MySQLDB.java:212)
   com.djrapitops.plan.storage.database.transactions.Transaction.initializeConnection(Transaction.java:179)
   com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:83)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:372)
   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)
   java.base/java.lang.Thread.getStackTrace(Thread.java:2450)
   com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:359)
   com.djrapitops.plan.gathering.timed.BungeePingCounter.run(BungeePingCounter.java:108)
   net.md_5.bungee.scheduler.BungeeTask.run(BungeeTask.java:63)
   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)

Plugin versions

Latest

Additional information

@Funnytom118 Funnytom118 added the Bug Issues that contain unintended behavior label Dec 11, 2024
@AuroraLS3
Copy link
Collaborator

Your mysql server ran out of connections. Either increase max_connections in mysql.cnf or decrease Max_Connections in Plan config(s)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Issues that contain unintended behavior
Projects
None yet
Development

No branches or pull requests

2 participants