Unknown SQL #4035
Description
Describe the issue
[09:36:10] [Plan MySQLDB-transaction-thread-1/ERROR]: [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-750b9d1ab3.txt
[09:36:10] [Plan MySQLDB-transaction-thread-1/ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[09:36:10] [Plan MySQLDB-transaction-thread-1/ERROR]: [Plan] Error msg: "com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Record has changed since last read in table 'plan_ping'"
Exceptions & Other Logs
750b9d1ab3 - Last occurred: 2025-03-30 Occurrences: 3
---- Context 3 ----
Plan v5.6 build 2883
Purpur git-Purpur-2062 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT
Transaction: class com.djrapitops.plan.storage.database.transactions.init.RemoveOldSampledDataTransaction
DB State: OPEN - fatal: false
Error code: 1020
DELETE FROM plan_ping WHERE (date<? AND server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1)) OR min_ping<0
Unknown SQL Error code
---- Context 2 ----
Plan v5.6 build 2883
Purpur git-Purpur-2062 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT
Transaction: class com.djrapitops.plan.storage.database.transactions.init.RemoveOldSampledDataTransaction
DB State: OPEN - fatal: false
Error code: 1020
DELETE FROM plan_ping WHERE (date<? AND server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1)) OR min_ping<0
Unknown SQL Error code
---- Context 1 ----
Plan v5.6 build 2883
Purpur git-Purpur-2062 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT
Transaction: class com.djrapitops.plan.storage.database.transactions.init.RemoveOldSampledDataTransaction
DB State: OPEN - fatal: false
Error code: 1020
DELETE FROM plan_ping WHERE (date<? AND server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1)) OR min_ping<0
Unknown SQL Error code
---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Record has changed since last read in table 'plan_ping'
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: SQL Failure: Record has changed since last read in table 'plan_ping'
Plan-5.6-build-2883.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:153)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.init.RemoveOldSampledDataTransaction.performOperations(RemoveOldSampledDataTransaction.java:61)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
Plan-5.6-build-2883.jar//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.SQLException: Record has changed since last read in table 'plan_ping'
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
Plan-5.6-build-2883.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.init.RemoveOldSampledDataTransaction.performOperations(RemoveOldSampledDataTransaction.java:61)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:373)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
Plan-5.6-build-2883.jar//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)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:359)
Plan-5.6-build-2883.jar//com.djrapitops.plan.storage.upkeep.DBCleanTask.run(DBCleanTask.java:107)
Plan-5.6-build-2883.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:1144)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
java.base/java.lang.Thread.run(Thread.java:1583)
Plugin versions
5.6 build 2820
Additional information
Mariadb version 11.7.2