Rapidfire Vulcan violations cause Transaction conflicts

[AuroraLS3]

Describe the issue

Multiple violations occurring in quick succession can cause insert to fail

Exceptions & Other Logs

1e4d405ed2 - Last occurred: 2023-07-31 Occurrences: 25
---- Context 5 ----
Plan v5.5 build 2461
Paper git-Paper-550 (MC: 1.19.4)
Server v1.19.4-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_vulcan (uuid, vulcan_movement_violations, vulcan_violations) VALUES (?, ?, ?)
Duplicate key

---- Context 4 ----
Plan v5.5 build 2461
Paper git-Paper-550 (MC: 1.19.4)
Server v1.19.4-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_vulcan (uuid, vulcan_movement_violations, vulcan_violations) VALUES (?, ?, ?)
Duplicate key

---- Context 3 ----
Plan v5.5 build 2461
Paper git-Paper-550 (MC: 1.19.4)
Server v1.19.4-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_vulcan (uuid, vulcan_movement_violations, vulcan_violations) VALUES (?, ?, ?)
Duplicate key

---- Context 2 ----
Plan v5.5 build 2461
Paper git-Paper-550 (MC: 1.19.4)
Server v1.19.4-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_vulcan (uuid, vulcan_movement_violations, vulcan_violations) VALUES (?, ?, ?)
Duplicate key

---- Context 1 ----
Plan v5.5 build 2461
Paper git-Paper-550 (MC: 1.19.4)
Server v1.19.4-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.query.QuerySvc$1
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_vulcan (uuid, vulcan_movement_violations, vulcan_violations) VALUES (?, ?, ?)
Duplicate key

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Duplicate entry '27f29321-5953-4c34-926d-dc90b9e5a07a' for key 'uuid'
   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:1136)
   java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
   java.base/java.lang.Thread.run(Thread.java:833)
Caused by:
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Duplicate entry '27f29321-5953-4c34-926d-dc90b9e5a07a' for key 'uuid'
   Plan-5.5-build-2461.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.queries.QueryAPIExecutable.execute(QueryAPIExecutable.java:48)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:214)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.query.QuerySvc$1.performOperations(QuerySvc.java:90)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:348)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:347)
   java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
   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:833)
Caused by:
java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '27f29321-5953-4c34-926d-dc90b9e5a07a' for key 'uuid'
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
   com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
   Plan-5.5-build-2461.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
   Plan-5.5-build-2461.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
   VulcanPlanAddon-v1.0.1.jar//com.shimincraft.planvulcan.planvulcan.storage.VulcanStorage.lambda$storeViolation$6(VulcanStorage.java:173)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.queries.QueryAPIExecutable.execute(QueryAPIExecutable.java:44)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:214)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.query.QuerySvc$1.performOperations(QuerySvc.java:90)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:348)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.5-build-2461.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
... (16 lines left)

Plugin versions

Additional information