Plan icon indicating copy to clipboard operation
Plan copied to clipboard

Receiving error message

Open MinecollYT opened this issue 3 years ago • 1 comments

Describe the issue

Not sure, it just displays this error in the console

Exceptions & Other Logs

Console error:

[22:50:55 ERROR]: [Plan] Ran into CompletionException - logged to plugins/Plan/logs/CompletionException-f4ca3abe9b.txt
[22:50:55 ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[22:50:55 ERROR]: [Plan] Error msg: "com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Data truncation: Data too long for column 'join_address' at row 1"

CompletionException-f4ca3abe9b.txt:

f4ca3abe9b - Last occurred: 2022-08-10 Occurrences: 2
---- Context 2 ----
Plan v5.4 build 1722
Paper git-Paper-411 (MC: 1.17.1)
Server v1.17.1-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreJoinAddressTransaction
DB State: OPEN - fatal: false
Error code: 1406
INSERT INTO plan_join_address (join_address) VALUES (LOWER(?))
Unknown SQL Error code

---- Context 1 ----
Plan v5.4 build 1722
Paper git-Paper-411 (MC: 1.17.1)
Server v1.17.1-R0.1-SNAPSHOT

Transaction: class com.djrapitops.plan.storage.database.transactions.events.StoreJoinAddressTransaction
DB State: OPEN - fatal: false
Error code: 1406
INSERT INTO plan_join_address (join_address) VALUES (LOWER(?))
Unknown SQL Error code

---- Stacktrace ----
java.util.concurrent.CompletionException: com.djrapitops.plan.exceptions.database.DBOpException: SQL Failure: Data truncation: Data too long for column 'join_address' at row 1
   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: Data truncation: Data too long for column 'join_address' at row 1
   Plan-5.4-build-1722.jar//com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:148)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:57)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:212)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.events.StoreJoinAddressTransaction.performOperations(StoreJoinAddressTransaction.java:64)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:87)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$2(SQLDB.java:337)
   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:
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'join_address' at row 1
   com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
   com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
   Plan-5.4-build-1722.jar//plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
   Plan-5.4-build-1722.jar//plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.callExecute(ExecStatement.java:72)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:64)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.ExecStatement.execute(ExecStatement.java:55)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.Transaction.execute(Transaction.java:212)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.events.StoreJoinAddressTransaction.performOperations(StoreJoinAddressTransaction.java:64)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.transactions.Transaction.executeTransaction(Transaction.java:87)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.storage.database.SQLDB.lambda$executeTransaction$2(SQLDB.java:337)
   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.4-build-1722.jar//com.djrapitops.plan.storage.database.SQLDB.executeTransaction(SQLDB.java:325)
   Plan-5.4-build-1722.jar//com.djrapitops.plan.gathering.listeners.bukkit.PlayerOnlineListener.onPlayerLogin(PlayerOnlineListener.java:120)
   com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor66.execute(Unknown Source)
   org.bukkit.plugin.EventExecutor.lambda$create$1(EventExecutor.java:69)
   co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:80)
   org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70)
   org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:628)
   net.minecraft.server.players.PlayerList.attemptLogin(PlayerList.java:769)
   net.minecraft.server.network.LoginListener.c(LoginListener.java:176)
   net.minecraft.server.network.LoginListener.tick(LoginListener.java:87)
   net.minecraft.network.NetworkManager.a(NetworkManager.java:546)
   net.minecraft.server.network.ServerConnection.c(ServerConnection.java:201)
   net.minecraft.server.MinecraftServer.b(MinecraftServer.java:1656)
   net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:490)
   net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1483)
   net.minecraft.server.MinecraftServer.x(MinecraftServer.java:1282)
   net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:319)
   java.base/java.lang.Thread.run(Thread.java:833)

Plugin versions

v5.4 build 1722

Additional information

none

MinecollYT avatar Aug 10 '22 20:08 MinecollYT

Try this build https://github.com/plan-player-analytics/Plan/actions/runs/2794035358

AuroraLS3 avatar Aug 11 '22 12:08 AuroraLS3

Looking at the code, this is already fixed

AuroraLS3 avatar Aug 16 '22 17:08 AuroraLS3