ezeiger92 / prism-bukkit Goto Github PK

Lookups fail with an SQL error, with the inspection wand as well as the lookup command.
This was introduced with the latest commit 44eb961 (I built & tested previous commit; works fine).

I don't know exactly what the any_value wrappers are supposed to achieve, so I'm not sure how to fix this.

OS: Arch Linux
Minecraft Server: CraftBukkit version git-Spigot-f6a273b-8ab46ff (MC: 1.13.1) (Implementing API version 1.13.1-R0.1-SNAPSHOT)
SQL Server: mariadb 10.1.36-1
ezeiger92/Prism-Bukkit: 44eb961

[INFO]: [Prism]: Database connection error: FUNCTION prism.any_value does not exist
[WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION prism.any_value does not exist
[WARN]:         at sun.reflect.GeneratedConstructorAccessor79.newInstance(Unknown Source)
[WARN]:         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[WARN]:         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[WARN]:         at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[WARN]:         at com.mysql.jdbc.Util.getInstance(Util.java:408)
[WARN]:         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[WARN]:         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[WARN]:         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[WARN]:         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[WARN]:         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[WARN]:         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[WARN]:         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[WARN]:         at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[WARN]:         at me.botsko.prism.actionlibs.ActionsQuery.lookup(ActionsQuery.java:125)
[WARN]:         at me.botsko.prism.commands.LookupCommand$1.run(LookupCommand.java:69)
[WARN]:         at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftTask.run(CraftTask.java:76)
[WARN]:         at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[WARN]:         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[WARN]:         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[WARN]:         at java.lang.Thread.run(Thread.java:748)

As the title says, are there any 1.9.x, 1.10.x and 1.11.x versions or can you make new branches with these versions? Maybe if it is simple a 1.9.x to 1.13.x compatible version.

When I am trying to enable inspector mode I get this error log

[21:59:13 INFO]: Tjird issued server command: /prism i
[21:59:13 ERROR]: null
org.bukkit.command.CommandException: Unhandled exception executing command 'prism' in plugin Prism v2.1.0-${env.BUILD_NUMBER}
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:46) ~[spigot.jar:git-Paper-1501]
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:151) ~[spigot.jar:git-Paper-1501]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:685) ~[spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.PlayerConnection.handleCommand(PlayerConnection.java:1473) ~[spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:1278) ~[spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:45) ~[spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:5) ~[spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.PlayerConnectionUtils.lambda$ensureMainThread$0(PlayerConnectionUtils.java:14) ~[spigot.jar:git-Paper-1501]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_181]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_181]
at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46) [spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:849) [spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:427) [spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:773) [spigot.jar:git-Paper-1501]
at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:665) [spigot.jar:git-Paper-1501]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_181]
Caused by: java.lang.NullPointerException
at org.bukkit.inventory.ItemStack.(ItemStack.java:98) ~[spigot.jar:git-Paper-1501]
at me.botsko.prism.commands.WandCommand.handle(WandCommand.java:229) ~[?:?]
at me.botsko.prism.commandlibs.Executor.onCommand(Executor.java:104) ~[?:?]
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) ~[spigot.jar:git-Paper-1501]
... 15 more

Prism 1.12 PaperSpigot 1.12.2

Since today, I'm getting console spam worth of 1.9GB of this

20:06:42 Prism]:: Database connection error: '2.157982635E9' in column '1' is outside valid range for the datatype INTEGER.
20:06:42 CONSOLE: WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.157982635E9' in column '1' is outside valid range for the datatype INTEGER.
20:06:42 CONSOLE: WARN]: at sun.reflect.GeneratedConstructorAccessor221.newInstance(Unknown Source)
20:06:42 CONSOLE: WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
20:06:42 CONSOLE: WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7061)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:6339)
20:06:42 CONSOLE: WARN]: at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2509)
20:06:42 CONSOLE: WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:336)
20:06:42 CONSOLE: WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:275)
20:06:42 CONSOLE: WARN]: at me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:37)
20:06:42 CONSOLE: WARN]: at me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:377)
20:06:42 CONSOLE: WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:63)
20:06:42 CONSOLE: WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
20:06:42 CONSOLE: WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
20:06:42 CONSOLE: WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
20:06:42 CONSOLE: WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
20:06:42 CONSOLE: WARN]: at java.lang.Thread.run(Thread.java:745)
20:06:42 CONSOLE: WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.157982636E9' in column '1' is outside valid range for the datatype INTEGER.
20:06:42 CONSOLE: WARN]: at sun.reflect.GeneratedConstructorAccessor221.newInstance(Unknown Source)
20:06:42 CONSOLE: WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
20:06:42 CONSOLE: WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
20:06:43 CONSOLE: WARN]: at me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:275)
20:06:43 CONSOLE: WARN]: at me.botsko.prism.actionlibs.QueueDrain.forceDrainQueue(QueueDrain.java:37)
20:06:43 CONSOLE: WARN]: at me.botsko.prism.Prism.onDisable(Prism.java:1062)
20:06:44 CONSOLE: WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:266)
20:06:44 CONSOLE: WARN]: at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:344)
20:06:44 CONSOLE: WARN]: at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:425)
20:06:44 CONSOLE: WARN]: at com.ryanclancy000.plugman.utilities.Utilities.unloadPlugin(Utilities.java:422)
20:06:44 CONSOLE: WARN]: at com.ryanclancy000.plugman.utilities.Utilities.unloadCommand(Utilities.java:373)
20:06:44 CONSOLE: WARN]: at com.ryanclancy000.plugman.PlugManCommands.onCommand(PlugManCommands.java:72)
20:06:44 CONSOLE: WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
20:06:44 CONSOLE: WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:151)
20:06:44 CONSOLE: WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:685)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.PlayerConnection.handleCommand(PlayerConnection.java:1472)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:1277)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:45)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:5)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.PlayerConnectionUtils.lambda$ensureMainThread$0(PlayerConnectionUtils.java:14)
20:06:44 CONSOLE: WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
20:06:44 CONSOLE: WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:843)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:427)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:767)
20:06:44 CONSOLE: WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:665)
20:06:44 CONSOLE: WARN]: at java.lang.Thread.run(Thread.java:745)

and the DB size is worth of 363GB and I wish not to RESET nor DELETE because I want to keep the history of block edits like 2-4 years... but planning to delete it completely at Sep 16.

Compiled your plugin and using it (will restart if all fails) with plugman and no avail. I'm aware Prism is a huge unsupported plugin but thats the most reliable I ever find in that time when LogBlock couldn't log entities, nor CoreProtect in 2013 so I kept Prism.

Hey, I found your repo from the original Prism fork network and saw you were still actively updating the code. Do you have a space where you are uploading the compiled plugin binaries to? I used Prism in the past and it was (and still is) one of the best rollback system I've ever come to use for Minecraft servers.

I was going to compile it myself but I realized Java required me to have a whole environment together which I do not have access to at the time. Since I saw your last update was pretty much yesterday I'm hoping to hear back from you soon.

Thanks again for maintaining this awesome plugin! 👍

I'm curious if this is a Prism bug or a plugin conflict. When i do an a rollback on the drop action (item-drop also) the results are 0 reversals, x skipped. So i enabled debug and it says that it can't complete the rollback because the player (me) is offline. Below is the debug from the executed command

https://pastebin.com/bmEWeMjV

Running a build compiled against the latest commit at the time: 4bf5221

Thanks for your help!

I used some BONE_MEAL to grow a crop. After I typed a lookup command Prism generates this exception:

>pr l w:world
[11:30:05 WARN]: [Prism] Plugin Prism v2.1.0-${env.BUILD_NUMBER} generated an exception while executing task 2902
java.lang.IllegalArgumentException: Cannot get data for not block BONE_MEAL
	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:191) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at org.bukkit.craftbukkit.v1_13_R1.block.data.CraftBlockData.newData(CraftBlockData.java:420) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at org.bukkit.craftbukkit.v1_13_R1.CraftServer.createBlockData(CraftServer.java:1808) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at org.bukkit.craftbukkit.v1_13_R1.CraftServer.createBlockData(CraftServer.java:1783) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at org.bukkit.Bukkit.createBlockData(Bukkit.java:1185) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at me.botsko.prism.actionlibs.ActionsQuery.lookup(ActionsQuery.java:189) ~[?:?]
	at me.botsko.prism.commands.LookupCommand$1.run(LookupCommand.java:69) ~[?:?]
	at org.bukkit.craftbukkit.v1_13_R1.scheduler.CraftTask.run(CraftTask.java:76) ~[spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at org.bukkit.craftbukkit.v1_13_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52) [spigot-1.13-latest.jar:git-Spigot-69774b3-5e3082c]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]

p.s. Thank you for contributing to this project! So far Prism-Bukkit is the best recording/rollback plugin I have ever found and my server could not lived without it.