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.

Sign up for GitHub

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

Jump to bottom

CompletionException with Litebans (SQL error) #3527

Open
bobhenl opened this issue Mar 21, 2024 · 1 comment
Open

CompletionException with Litebans (SQL error) #3527

bobhenl opened this issue Mar 21, 2024 · 1 comment
Labels
Bug Issues that contain unintended behavior DataExtensions Tickets related to DataExtensions

Comments

@bobhenl
Copy link

bobhenl commented Mar 21, 2024

Describe the issue

Hello, I got the error in console and there was that I should report it

Exceptions & Other Logs

[08:09:58] [pool-26-thread-1/INFO]: [AntiCheatReplay] Starting recording of player: seafuture
[08:09:58] [Plan SQLiteDB-transaction-thread-1/INFO]: Updating violation: 39fc67f6-9c2a-3881-8238-284ab6d6d3c4 MOVEMENT_VIOLATION 0
[08:09:58] [Plan SQLiteDB-transaction-thread-1/INFO]: Updating violation: 39fc67f6-9c2a-3881-8238-284ab6d6d3c4 MOVEMENT_VIOLATION 0
[08:09:58] [Plan SQLiteDB-transaction-thread-1/INFO]: Inserting violation: 39fc67f6-9c2a-3881-8238-284ab6d6d3c4 MOVEMENT_VIOLATION 0
[08:09:58] [Plan SQLiteDB-transaction-thread-1/INFO]: Inserting violation: 39fc67f6-9c2a-3881-8238-284ab6d6d3c4 MOVEMENT_VIOLATION 0
[08:09:58] [Plan SQLiteDB-transaction-thread-1/ERROR]: [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-82d37f2caa.txt
[08:09:58] [Plan SQLiteDB-transaction-thread-1/ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[08:09:58] [Plan SQLiteDB-transaction-thread-1/ERROR]: [Plan] What to do: Report this, there is an SQL Constraint Violation.

bed08d4f4b - Last occurred: 2024-03-19 Occurrences: 1
---- Context 1 ----
Plan v5.6 build 2820
Purpur git-Purpur-2062 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report and/or disable Litebans extension in the Plan config.
Litebans
Method:serverKicks
Error code: 0
SELECT name FROM plan_users WHERE (uuid=?)
Unknown SQL Error code

---- Stacktrace ----
com.djrapitops.plan.exceptions.DataExtensionMethodCallException: Litebans.serverKicks errored: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: stmt pointer is closed
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.MethodWrapper.callMethod(MethodWrapper.java:56)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.callMethod(DataValueGatherer.java:322)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$tryToBuildTable$0(DataValueGatherer.java:175)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.builder.BuiltDataValue.getValue(BuiltDataValue.java:48)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.getValue(DataValueGatherer.java:452)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.storeTable(DataValueGatherer.java:528)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$gather$33(DataValueGatherer.java:408)
   java.base/java.util.Optional.ifPresent(Optional.java:178)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.gather(DataValueGatherer.java:408)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.tryToUpdateValues(DataValueGatherer.java:363)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.updateValues(DataValueGatherer.java:351)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:195)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:187)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionServerDataUpdater.run(ExtensionServerDataUpdater.java:51)
   Plan-5.6-build-2820.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)
Caused by:
java.lang.reflect.InvocationTargetException
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.Parameters$ServerParameters.usingOn(Parameters.java:64)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.MethodWrapper.callMethod(MethodWrapper.java:50)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.callMethod(DataValueGatherer.java:322)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$tryToBuildTable$0(DataValueGatherer.java:175)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.builder.BuiltDataValue.getValue(BuiltDataValue.java:48)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.getValue(DataValueGatherer.java:452)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.storeTable(DataValueGatherer.java:528)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$gather$33(DataValueGatherer.java:408)
   java.base/java.util.Optional.ifPresent(Optional.java:178)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.gather(DataValueGatherer.java:408)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.tryToUpdateValues(DataValueGatherer.java:363)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.updateValues(DataValueGatherer.java:351)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:195)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:187)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionServerDataUpdater.run(ExtensionServerDataUpdater.java:51)
   Plan-5.6-build-2820.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)
Caused by:
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: stmt pointer is closed
   Plan-5.6-build-2820.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:64)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$query$2(SQLDB.java:339)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:339)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.query.CommonQueriesImplementation.fetchNameOf(CommonQueriesImplementation.java:83)
   Plan-5.6-build-2820.jar//net.playeranalytics.extension.litebans.LitebansExtension.addRows(LitebansExtension.java:196)
   Plan-5.6-build-2820.jar//net.playeranalytics.extension.litebans.LitebansExtension.serverKicks(LitebansExtension.java:162)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.Parameters$ServerParameters.usingOn(Parameters.java:64)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.MethodWrapper.callMethod(MethodWrapper.java:50)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.callMethod(DataValueGatherer.java:322)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$tryToBuildTable$0(DataValueGatherer.java:175)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.builder.BuiltDataValue.getValue(BuiltDataValue.java:48)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.getValue(DataValueGatherer.java:452)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.storeTable(DataValueGatherer.java:528)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$gather$33(DataValueGatherer.java:408)
   java.base/java.util.Optional.ifPresent(Optional.java:178)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.gather(DataValueGatherer.java:408)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.tryToUpdateValues(DataValueGatherer.java:363)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.updateValues(DataValueGatherer.java:351)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:195)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:187)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionServerDataUpdater.run(ExtensionServerDataUpdater.java:51)
   Plan-5.6-build-2820.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)
Caused by:
java.sql.SQLException: stmt pointer is closed
   org.sqlite.core.SafeStmtPtr.ensureOpen(SafeStmtPtr.java:148)
   org.sqlite.core.SafeStmtPtr.safeRunInt(SafeStmtPtr.java:83)
   org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:48)
   org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:32)
   org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25)
   org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34)
   org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:227)
   org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:207)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeWithConnection(QueryStatement.java:61)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:52)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$query$2(SQLDB.java:339)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:102)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:87)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:339)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.query.CommonQueriesImplementation.fetchNameOf(CommonQueriesImplementation.java:83)
   Plan-5.6-build-2820.jar//net.playeranalytics.extension.litebans.LitebansExtension.addRows(LitebansExtension.java:196)
   Plan-5.6-build-2820.jar//net.playeranalytics.extension.litebans.LitebansExtension.serverKicks(LitebansExtension.java:162)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
   java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   java.base/java.lang.reflect.Method.invoke(Method.java:568)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.Parameters$ServerParameters.usingOn(Parameters.java:64)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.MethodWrapper.callMethod(MethodWrapper.java:50)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.callMethod(DataValueGatherer.java:322)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$tryToBuildTable$0(DataValueGatherer.java:175)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.builder.BuiltDataValue.getValue(BuiltDataValue.java:48)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.getValue(DataValueGatherer.java:452)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.storeTable(DataValueGatherer.java:528)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.lambda$gather$33(DataValueGatherer.java:408)
   java.base/java.util.Optional.ifPresent(Optional.java:178)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.gather(DataValueGatherer.java:408)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.tryToUpdateValues(DataValueGatherer.java:363)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.implementation.providers.gathering.DataValueGatherer.updateValues(DataValueGatherer.java:351)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:195)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionSvc.updateServerValues(ExtensionSvc.java:187)
   Plan-5.6-build-2820.jar//com.djrapitops.plan.extension.ExtensionServerDataUpdater.run(ExtensionServerDataUpdater.java:51)
   Plan-5.6-build-2820.jar//net.playeranalytics.plugin.scheduling.UnscheduledBukkitTask.run(UnscheduledBukkitTask.java:22)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101)
   org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
   com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
   java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:840)

Plugin versions

image

Additional information
@bobhenl bobhenl added the Bug Issues that contain unintended behavior label Mar 21, 2024
@AuroraLS3
Copy link
Collaborator

Did this occur near server shutdown?

@AuroraLS3 AuroraLS3 added the DataExtensions Tickets related to DataExtensions label Mar 21, 2024
@github-project-automation github-project-automation bot moved this to INBOX in Backlog Mar 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug Issues that contain unintended behavior DataExtensions Tickets related to DataExtensions
Projects
Backlog
Status: INBOX
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bobhenl @AuroraLS3