search

plan-player-analytics / Plan

Player Analytics plugin for Minecraft Server platforms - View player activity of your server with ease. :calendar:
https://www.spigotmc.org/resources/plan-player-analytics.32536/
GNU Lesser General Public License v3.0
827 stars 167 forks source link

CompletionException with Litebans (SQL error) #3527

Open bobhenl opened 3 months ago

bobhenl commented 3 months ago

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

AuroraLS3 commented 3 months ago

Did this occur near server shutdown?