Update Db

[Mr-Saitam]

Hi, I deleted the extension_groups table. How long would it take to update it again? It adds users randomly. For example, a user is logged in and you don't add them to the table.

[AuroraLS3]

It depends on the implementation of the plugin extension - some of them are only called on player leave and some on player join.

This is because some plugins handle their data differently and it might not be available at all times

[Mr-Saitam]

I understand. I use the luckperms plugin, but even if the user logs in or out, it doesn't add them to the table. Isn't there a way to ensure that the table is updated? I thought it might work when the range is updated, but it didn't.

[AuroraLS3]

There could be errors occurring because the plugin hasn't been tested against deleting tables manually - They can be found from /plugins/Plan/logs

Restarting the plugin should recreate any tables

[Mr-Saitam]

The only problem that appears in the logs is this one, but it is not related. As I said, the extension_groups table was regenerated, but it does not add the users on, it adds users randomly.

11acd8fe5c - Last occurred: 2025-07-03 Occurrences: 7
---- Context 5 ----
Plan v5.6 build 2965
Pufferfish git-Pufferfish-27 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)
Duplicate key

---- Context 4 ----
Plan v5.6 build 2965
Pufferfish git-Pufferfish-27 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)
Duplicate key

---- Context 3 ----
Plan v5.6 build 2965
Pufferfish git-Pufferfish-27 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)
Duplicate key

---- Context 2 ----
Plan v5.6 build 2965
Pufferfish git-Pufferfish-27 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)
Duplicate key

---- Context 1 ----
Plan v5.6 build 2965
Pufferfish git-Pufferfish-27 (MC: 1.20.1)
Server v1.20.1-R0.1-SNAPSHOT

Report this, duplicate key exists in SQL.
Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction
DB State: OPEN - fatal: false
Error code: 1062
INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)
Duplicate key

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Duplicate entry 'f51f1be3-d141-3517-a49d-9c0e8ca2720b' 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:840)
Caused by:
com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Duplicate entry 'f51f1be3-d141-3517-a49d-9c0e8ca2720b' for key 'uuid'
   Plan-5.6-build-2965.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:153)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction.performOperations(StoreAllowlistBounceTransaction.java:60)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:374)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:373)
   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:840)
Caused by:
java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'f51f1be3-d141-3517-a49d-9c0e8ca2720b' for key 'uuid'
   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
   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-2965.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.6-build-2965.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:70)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.events.StoreAllowlistBounceTransaction.performOperations(StoreAllowlistBounceTransaction.java:60)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:374)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:373)
   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:840)
   java.base/java.lang.Thread.getStackTrace(Thread.java:1619)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:360)
   Plan-5.6-build-2965.jar//com.djrapitops.plan.gathering.listeners.bukkit.PlayerOnlineListener.onPlayerLogin(PlayerOnlineListener.java:94)
   com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor725.execute(Unknown Source)
   org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:77)
   co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:77)
   org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70)
   io.papermc.paper.plugin.manager.PaperEventManager.callEvent(PaperEventManager.java:54)
   io.papermc.paper.plugin.manager.PaperPluginManagerImpl.callEvent(PaperPluginManagerImpl.java:126)
   org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:617)
   net.minecraft.server.players.PlayerList.canPlayerLogin(PlayerList.java:755)
   net.minecraft.server.network.LoginListener.d(LoginListener.java:160)
   net.minecraft.server.network.LoginListener.c(LoginListener.java:85)
   net.minecraft.network.NetworkManager.a(NetworkManager.java:602)
   net.minecraft.server.network.ServerConnection.c(ServerConnection.java:234)
   net.minecraft.server.MinecraftServer.b(MinecraftServer.java:1588)
   net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:449)
   net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1395)
   net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1172)
   net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:319)
   java.base/java.lang.Thread.run(Thread.java:840)