We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
When running Plan I get this NOT NULL constraint violation occurred error
bbe981e164 - Last occurred: 2024-02-27 Occurrences: 1 ---- Context 1 ---- Plan v5.6 build 2614 Paper git-Paper-381 (MC: 1.20.4) Server v1.20.4-R0.1-SNAPSHOT Report this error. NOT NULL constraint violation occurred. Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction DB State: OPEN - fatal: false Error code: 1048 INSERT INTO plan_world_times (session_id,world_id,user_id,server_id,survival_time,creative_time,adventure_time,spectator_time) VALUES ( (SELECT plan_sessions.id FROM plan_sessions WHERE plan_sessions.user_id=(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1) AND plan_sessions.server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1) AND session_start=? AND session_end=? LIMIT 1),(SELECT plan_worlds.id FROM plan_worlds WHERE world_name=? AND plan_worlds.server_uuid=? LIMIT 1),(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1),(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?, ?, ?, ?) Constraint Violation ---- Stacktrace ---- java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Column 'world_id' cannot be null 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: Column 'world_id' cannot be null Plan-5.6-build-2614.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:152) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.queries.DataStoreQueries.lambda$storeSession$0(DataStoreQueries.java:57) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.storeSession(StoreSessionTransaction.java:60) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.performOperations(StoreSessionTransaction.java:48) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:353) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:352) 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.BatchUpdateException: Column 'world_id' cannot be null com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:223) com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:716) com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:407) com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:799) Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecBatchStatement.callExecute(ExecBatchStatement.java:35) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.queries.DataStoreQueries.lambda$storeSession$0(DataStoreQueries.java:57) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.storeSession(StoreSessionTransaction.java:60) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.performOperations(StoreSessionTransaction.java:48) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:353) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:352) 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: Column 'world_id' cannot be null 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:912) com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1054) com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1003) com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1312) com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchWithMultiValuesClause(ClientPreparedStatement.java:677) com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:407) com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:799) Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) Plan-5.6-build-2614.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecBatchStatement.callExecute(ExecBatchStatement.java:35) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.queries.DataStoreQueries.lambda$storeSession$0(DataStoreQueries.java:57) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:223) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.storeSession(StoreSessionTransaction.java:60) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.events.StoreSessionTransaction.performOperations(StoreSessionTransaction.java:48) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:89) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$4(SQLDB.java:353) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:78) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.DBAccessLock.performDatabaseOperation(DBAccessLock.java:56) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$5(SQLDB.java:352) 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) Plan-5.6-build-2614.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:342) Plan-5.6-build-2614.jar//com.djrapitops.plan.gathering.events.PlayerLeaveEventConsumer.storeFinishedSession(PlayerLeaveEventConsumer.java:99) java.base/java.util.Optional.ifPresent(Optional.java:178) Plan-5.6-build-2614.jar//com.djrapitops.plan.gathering.events.PlayerLeaveEventConsumer.onLeaveGameServer(PlayerLeaveEventConsumer.java:82) Plan-5.6-build-2614.jar//com.djrapitops.plan.gathering.events.PlayerLeaveEventConsumer.onLeaveGameServer(PlayerLeaveEventConsumer.java:71) Plan-5.6-build-2614.jar//com.djrapitops.plan.gathering.listeners.bukkit.PlayerOnlineListener.actOnQuitEvent(PlayerOnlineListener.java:178) Plan-5.6-build-2614.jar//com.djrapitops.plan.gathering.listeners.bukkit.PlayerOnlineListener.onPlayerQuit(PlayerOnlineListener.java:167) com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor201.execute(Unknown Source) org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:77) co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:81) 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:615) net.minecraft.server.players.PlayerList.remove(PlayerList.java:613) net.minecraft.server.players.PlayerList.remove(PlayerList.java:598) net.minecraft.server.network.PlayerConnection.removePlayerFromWorld(PlayerConnection.java:2097) net.minecraft.server.network.PlayerConnection.onDisconnect(PlayerConnection.java:2077) net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2064) net.minecraft.network.NetworkManager.p(NetworkManager.java:837) net.minecraft.server.network.ServerConnection.c(ServerConnection.java:260) net.minecraft.server.MinecraftServer.b(MinecraftServer.java:1747) net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:446) net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1518) net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1214) net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:321) java.base/java.lang.Thread.run(Thread.java:833)
5.6 build 2614
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Describe the issue
When running Plan I get this NOT NULL constraint violation occurred error
Exceptions & Other Logs
Plugin versions
5.6 build 2614
Additional information
The text was updated successfully, but these errors were encountered: