· 6 years ago · Mar 22, 2019, 08:20 AM
1[04:16:14 INFO]: [Plan] MySQL-database connection established.
2[04:16:14 INFO]: WebServer: Certificate KeyStore File not Found: plugins/Plan/Cert.jks
3[04:16:14 INFO]: [Plan] WebServer: No Certificate -> Using HTTP-server for Visualization.
4[04:16:14 INFO]: WebServer: User Authorization Disabled! (Not secure over HTTP)
5[04:16:14 INFO]: [Plan] Webserver running on PORT 8804 (http://plan.swordvale.net:8804)
6[04:16:14 ERROR]: [Plan] Error was caught by com.djrapitops.plan.db.MySQLDB
7java.util.concurrent.CompletionException: com.djrapitops.plan.api.exceptions.database.DBOpException: CreateTablesTransaction failed: SQL Failed: CREATE TABLE IF NOT EXISTS plan_kills (id integer NOT NULL AUTO_INCREMENT, killer_uuid varchar(36) NOT NULL, victim_uuid varchar(36) NOT NULL, server_uuid varchar(36) NOT NULL, weapon varchar(30) NOT NULL, date bigint NOT NULL, session_id integer NOT NULL, PRIMARY KEY (id), FOREIGN KEY(session_id) REFERENCES plan_sessions(id)); REFERENCES command denied to user 'u4_0ILZTT5x4e'@'172.18.0.3' for table 'plan_sessions', additionally Transaction rollback failed: SAVEPOINT 194b0c45_169a478ced0__8000 does not exist
8at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273) ~[?:1.8.0_192]
9at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280) [?:1.8.0_192]
10at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1592) [?:1.8.0_192]
11at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_192]
12at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_192]
13at java.lang.Thread.run(Thread.java:748) [?:1.8.0_192]
14Caused by: com.djrapitops.plan.api.exceptions.database.DBOpException: CreateTablesTransaction failed: SQL Failed: CREATE TABLE IF NOT EXISTS plan_kills (id integer NOT NULL AUTO_INCREMENT, killer_uuid varchar(36) NOT NULL, victim_uuid varchar(36) NOT NULL, server_uuid varchar(36) NOT NULL, weapon varchar(30) NOT NULL, date bigint NOT NULL, session_id integer NOT NULL, PRIMARY KEY (id), FOREIGN KEY(session_id) REFERENCES plan_sessions(id)); REFERENCES command denied to user 'u4_0ILZTT5x4e'@'172.18.0.3' for table 'plan_sessions', additionally Transaction rollback failed: SAVEPOINT 194b0c45_169a478ced0__8000 does not exist
15at com.djrapitops.plan.db.access.transactions.Transaction.manageFailure(Transaction.java:83) ~[?:?]
16at com.djrapitops.plan.db.access.transactions.Transaction.executeTransaction(Transaction.java:70) ~[?:?]
17at com.djrapitops.plan.db.access.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:34) ~[?:?]
18at com.djrapitops.plan.db.SQLDB.lambda$executeTransaction$1(SQLDB.java:222) ~[?:?]
19at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) ~[?:1.8.0_192]
20... 3 more
21Caused by: com.djrapitops.plan.api.exceptions.database.DBOpException: SQL Failed: CREATE TABLE IF NOT EXISTS plan_kills (id integer NOT NULL AUTO_INCREMENT, killer_uuid varchar(36) NOT NULL, victim_uuid varchar(36) NOT NULL, server_uuid varchar(36) NOT NULL, weapon varchar(30) NOT NULL, date bigint NOT NULL, session_id integer NOT NULL, PRIMARY KEY (id), FOREIGN KEY(session_id) REFERENCES plan_sessions(id)); REFERENCES command denied to user 'u4_0ILZTT5x4e'@'172.18.0.3' for table 'plan_sessions'
22at com.djrapitops.plan.api.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
23at com.djrapitops.plan.db.access.ExecStatement.execute(ExecStatement.java:45) ~[?:?]
24at com.djrapitops.plan.db.access.transactions.Transaction.execute(Transaction.java:119) ~[?:?]
25at com.djrapitops.plan.db.access.transactions.Transaction.execute(Transaction.java:123) ~[?:?]
26at com.djrapitops.plan.db.access.transactions.init.CreateTablesTransaction.performOperations(CreateTablesTransaction.java:40) ~[?:?]
27at com.djrapitops.plan.db.access.transactions.Transaction.executeTransaction(Transaction.java:66) ~[?:?]
28at com.djrapitops.plan.db.access.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:34) ~[?:?]
29at com.djrapitops.plan.db.SQLDB.lambda$executeTransaction$1(SQLDB.java:222) ~[?:?]
30at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) ~[?:1.8.0_192]
31... 3 more
32Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'u4_0ILZTT5x4e'@'172.18.0.3' for table 'plan_sessions'
33at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_192]
34at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_192]
35at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_192]
36at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_192]
37at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
38at com.mysql.jdbc.Util.getInstance(Util.java:382) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
39at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
40at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
41at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
42at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
43at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
44at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
45at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
46at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
47at plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[?:?]
48at plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[?:?]
49at com.djrapitops.plan.db.access.ExecStatement.callExecute(ExecStatement.java:62) ~[?:?]
50at com.djrapitops.plan.db.access.ExecStatement.execute(ExecStatement.java:52) ~[?:?]
51at com.djrapitops.plan.db.access.ExecStatement.execute(ExecStatement.java:42) ~[?:?]
52at com.djrapitops.plan.db.access.transactions.Transaction.execute(Transaction.java:119) ~[?:?]
53at com.djrapitops.plan.db.access.transactions.Transaction.execute(Transaction.java:123) ~[?:?]
54at com.djrapitops.plan.db.access.transactions.init.CreateTablesTransaction.performOperations(CreateTablesTransaction.java:40) ~[?:?]
55at com.djrapitops.plan.db.access.transactions.Transaction.executeTransaction(Transaction.java:66) ~[?:?]
56at com.djrapitops.plan.db.access.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:34) ~[?:?]
57at com.djrapitops.plan.db.SQLDB.lambda$executeTransaction$1(SQLDB.java:222) ~[?:?]
58at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) ~[?:1.8.0_192]
59at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_192]
60at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_192]
61at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_192]
62at com.djrapitops.plan.db.SQLDB.executeTransaction(SQLDB.java:218) ~[?:?]
63at com.djrapitops.plan.db.SQLDB.setupDatabase(SQLDB.java:163) ~[?:?]
64at com.djrapitops.plan.db.SQLDB.init(SQLDB.java:97) ~[?:?]
65at com.djrapitops.plan.system.database.DBSystem.enable(DBSystem.java:99) ~[?:?]
66at com.djrapitops.plan.system.database.BukkitDBSystem.enable(BukkitDBSystem.java:66) ~[?:?]
67at com.djrapitops.plan.system.PlanSystem.enableSystems(PlanSystem.java:140) ~[?:?]
68at com.djrapitops.plan.system.PlanSystem.enable(PlanSystem.java:118) ~[?:?]
69at com.djrapitops.plan.Plan.onEnable(Plan.java:53) ~[?:?]
70at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
71at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
72at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:407) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
73at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:359) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
74at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:318) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
75at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:408) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
76at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:372) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
77at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:327) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
78at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:267) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
79at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:563) ~[spigot.jar:git-PaperSpigot-"4c7641d"]
80... 1 more
81[04:16:14 ERROR]: [Plan] Error was caught by com.djrapitops.plan.db.MySQLDB
82java.util.concurrent.CompletionException: com.djrapitops.plan.api.exceptions.database.DBOpException: KillsServerIDPatch failed: SQL Failed: ALTER TABLE plan_kills ADD server_id integer NOT NULL DEFAULT 0; Table 's4_plan.plan_kills' doesn't exist, additionally Transaction rollback failed: SAVEPOINT 194b0c45_169a478ced0__7fff does not exist
83at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273) ~[?:1.8.0_192]
84at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280) [?:1.8.0_192]
85at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1592) [?:1.8.0_192]
86at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_192]
87at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_192]
88at java.lang.Thread.run(Thread.java:748) [?:1.8.0_192]
89Caused by: com.djrapitops.plan.api.exceptions.database.DBOpException: KillsServerIDPatch failed: SQL Failed: ALTER TABLE plan_kills ADD server_id integer NOT NULL DEFAULT 0; Table 's4_plan.plan_kills' doesn't exist, additionally Transaction rollback failed: SAVEPOINT 194b0c45_169a478ced0__7fff does not exist
90at com.djrapitops.plan.db.access.transactions.Transaction.manageFailure(Transaction.java:83) ~[?:?]
91at com.djrapitops.plan.db.access.transactions.Transaction.executeTransaction(Transaction.java:70) ~[?:?]
92at com.djrapitops.plan.db.access.transactions.init.OperationCriticalTransaction.executeTransaction(OperationCriticalTransaction.java:34) ~[?:?]
93at com.djrapitops.plan.db.SQLDB.lambda$executeTransaction$1(SQLDB.java:222) ~[?:?]
94at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) ~[?:1.8.0_192]
95... 3 more