· 6 years ago · Oct 23, 2019, 02:54 AM
1> [22:50:38 ERROR]: [WorldGuard] Migration of schema `minecraft_wg` to version 1 failed! Please restore backups and roll back database and code!
2> [22:50:38 WARN]: [WorldGuard] Failed to load the region data for 'world' (periodic attempts will be made to load the data until success)
3com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to migrate tables
4at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:187) ~[worldguard-6.2.jar:?]
5at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.initialize(SQLDriver.java:108) ~[worldguard-6.2.jar:?]
6at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.initialize(SQLRegionDatabase.java:86) ~[worldguard-6.2.jar:?]
7at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.loadAll(SQLRegionDatabase.java:203) ~[worldguard-6.2.jar:?]
8at com.sk89q.worldguard.protection.managers.RegionManager.load(RegionManager.java:94) ~[worldguard-6.2.jar:?]
9at com.sk89q.worldguard.protection.managers.RegionContainerImpl.createAndLoad(RegionContainerImpl.java:129) ~[worldguard-6.2.jar:?]
10at com.sk89q.worldguard.protection.managers.RegionContainerImpl.load(RegionContainerImpl.java:106) [worldguard-6.2.jar:?]
11at com.sk89q.worldguard.bukkit.RegionContainer.load(RegionContainer.java:193) [worldguard-6.2.jar:?]
12at com.sk89q.worldguard.bukkit.RegionContainer.loadWorlds(RegionContainer.java:157) [worldguard-6.2.jar:?]
13at com.sk89q.worldguard.bukkit.RegionContainer.initialize(RegionContainer.java:93) [worldguard-6.2.jar:?]
14at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:213) [worldguard-6.2.jar:?]
15at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [server.jar:git-Spigot-21fe707-e1ebe52]
16at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [server.jar:git-Spigot-21fe707-e1ebe52]
17at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [server.jar:git-Spigot-21fe707-e1ebe52]
18at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [server.jar:git-Spigot-21fe707-e1ebe52]
19at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [server.jar:git-Spigot-21fe707-e1ebe52]
20at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [server.jar:git-Spigot-21fe707-e1ebe52]
21at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [server.jar:git-Spigot-21fe707-e1ebe52]
22at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [server.jar:git-Spigot-21fe707-e1ebe52]
23at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [server.jar:git-Spigot-21fe707-e1ebe52]
24at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [server.jar:git-Spigot-21fe707-e1ebe52]
25at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
26Caused by: com.sk89q.worldguard.internal.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error executing statement at line 34: CREATE TABLE IF NOT EXISTS `ServSurvivalregion` (
27`id` VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL ,
28`world_id` INT(10) UNSIGNED NOT NULL ,
29`type` ENUM('cuboid','poly2d','global') CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL ,
30`priority` SMALLINT(6) NOT NULL DEFAULT '0' ,
31`parent` VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL ,
32PRIMARY KEY (`id`, `world_id`) ,
33INDEX `fk_region_world` (`world_id` ASC) ,
34INDEX `parent` (`parent` ASC) ,
35CONSTRAINT `fk_ServSurvivalregion_world1`
36FOREIGN KEY (`world_id` )
37REFERENCES `ServSurvivalworld` (`id` )
38ON DELETE CASCADE
39ON UPDATE CASCADE,
40CONSTRAINT `ServSurvivalparent`
41FOREIGN KEY (`parent` )
42REFERENCES `ServSurvivalregion` (`id` )
43ON DELETE SET NULL
44ON UPDATE CASCADE)
45ENGINE = InnoDB
46DEFAULT CHARACTER SET = utf8
47COLLATE = utf8_bin
48at com.sk89q.worldguard.internal.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:91) ~[worldguard-6.2.jar:?]
49at com.sk89q.worldguard.internal.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73) ~[worldguard-6.2.jar:?]
50at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287) ~[worldguard-6.2.jar:?]
51at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285) ~[worldguard-6.2.jar:?]
52at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
53at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285) ~[worldguard-6.2.jar:?]
54at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) ~[worldguard-6.2.jar:?]
55at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) ~[worldguard-6.2.jar:?]
56at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
57at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
58at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
59at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:864) ~[worldguard-6.2.jar:?]
60at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:811) ~[worldguard-6.2.jar:?]
61at com.sk89q.worldguard.internal.flywaydb.core.Flyway.execute(Flyway.java:1171) ~[worldguard-6.2.jar:?]
62at com.sk89q.worldguard.internal.flywaydb.core.Flyway.migrate(Flyway.java:811) ~[worldguard-6.2.jar:?]
63at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:185) ~[worldguard-6.2.jar:?]
64... 21 more
65Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'minecraft'@'ns105023.ip-147-135-30.us' for table 'ServSurvivalworld'
66at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_222]
67at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_222]
68at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_222]
69at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_222]
70at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[server.jar:git-Spigot-21fe707-e1ebe52]
71at com.mysql.jdbc.Util.getInstance(Util.java:382) ~[server.jar:git-Spigot-21fe707-e1ebe52]
72at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[server.jar:git-Spigot-21fe707-e1ebe52]
73at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[server.jar:git-Spigot-21fe707-e1ebe52]
74at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[server.jar:git-Spigot-21fe707-e1ebe52]
75at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) ~[server.jar:git-Spigot-21fe707-e1ebe52]
76at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) ~[server.jar:git-Spigot-21fe707-e1ebe52]
77at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) ~[server.jar:git-Spigot-21fe707-e1ebe52]
78at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570) ~[server.jar:git-Spigot-21fe707-e1ebe52]
79at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779) ~[server.jar:git-Spigot-21fe707-e1ebe52]
80at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622) ~[server.jar:git-Spigot-21fe707-e1ebe52]
81at com.sk89q.worldguard.internal.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:235) ~[worldguard-6.2.jar:?]
82at com.sk89q.worldguard.internal.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:89) ~[worldguard-6.2.jar:?]
83at com.sk89q.worldguard.internal.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73) ~[worldguard-6.2.jar:?]
84at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287) ~[worldguard-6.2.jar:?]
85at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285) ~[worldguard-6.2.jar:?]
86at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
87at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285) ~[worldguard-6.2.jar:?]
88at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) ~[worldguard-6.2.jar:?]
89at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) ~[worldguard-6.2.jar:?]
90at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
91at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
92at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
93at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:864) ~[worldguard-6.2.jar:?]
94at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:811) ~[worldguard-6.2.jar:?]
95at com.sk89q.worldguard.internal.flywaydb.core.Flyway.execute(Flyway.java:1171) ~[worldguard-6.2.jar:?]
96at com.sk89q.worldguard.internal.flywaydb.core.Flyway.migrate(Flyway.java:811) ~[worldguard-6.2.jar:?]
97at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:185) ~[worldguard-6.2.jar:?]
98... 21 more
99> [22:50:38 INFO]: [WorldGuard] Database: jdbc:mysql://206.81.10.54:3306/minecraft_wg (MySQL 5.7)
100> [22:50:38 INFO]: [WorldGuard] Current version of schema `minecraft_wg`: 1
101> [22:50:38 WARN]: [WorldGuard] Failed to load the region data for 'world_nether' (periodic attempts will be made to load the data until success)
102com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to migrate tables
103at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:187) ~[worldguard-6.2.jar:?]
104at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.initialize(SQLDriver.java:108) ~[worldguard-6.2.jar:?]
105at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.initialize(SQLRegionDatabase.java:86) ~[worldguard-6.2.jar:?]
106at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.loadAll(SQLRegionDatabase.java:203) ~[worldguard-6.2.jar:?]
107at com.sk89q.worldguard.protection.managers.RegionManager.load(RegionManager.java:94) ~[worldguard-6.2.jar:?]
108at com.sk89q.worldguard.protection.managers.RegionContainerImpl.createAndLoad(RegionContainerImpl.java:129) ~[worldguard-6.2.jar:?]
109at com.sk89q.worldguard.protection.managers.RegionContainerImpl.load(RegionContainerImpl.java:106) [worldguard-6.2.jar:?]
110at com.sk89q.worldguard.bukkit.RegionContainer.load(RegionContainer.java:193) [worldguard-6.2.jar:?]
111at com.sk89q.worldguard.bukkit.RegionContainer.loadWorlds(RegionContainer.java:157) [worldguard-6.2.jar:?]
112at com.sk89q.worldguard.bukkit.RegionContainer.initialize(RegionContainer.java:93) [worldguard-6.2.jar:?]
113at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:213) [worldguard-6.2.jar:?]
114at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [server.jar:git-Spigot-21fe707-e1ebe52]
115at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [server.jar:git-Spigot-21fe707-e1ebe52]
116at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [server.jar:git-Spigot-21fe707-e1ebe52]
117at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [server.jar:git-Spigot-21fe707-e1ebe52]
118at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [server.jar:git-Spigot-21fe707-e1ebe52]
119at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [server.jar:git-Spigot-21fe707-e1ebe52]
120at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [server.jar:git-Spigot-21fe707-e1ebe52]
121at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [server.jar:git-Spigot-21fe707-e1ebe52]
122at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [server.jar:git-Spigot-21fe707-e1ebe52]
123at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [server.jar:git-Spigot-21fe707-e1ebe52]
124at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
125Caused by: com.sk89q.worldguard.internal.flywaydb.core.api.FlywayException: Schema `minecraft_wg` contains a failed migration to version 1 !
126at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:196) ~[worldguard-6.2.jar:?]
127at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
128at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
129at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
130at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:864) ~[worldguard-6.2.jar:?]
131at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:811) ~[worldguard-6.2.jar:?]
132at com.sk89q.worldguard.internal.flywaydb.core.Flyway.execute(Flyway.java:1171) ~[worldguard-6.2.jar:?]
133at com.sk89q.worldguard.internal.flywaydb.core.Flyway.migrate(Flyway.java:811) ~[worldguard-6.2.jar:?]
134at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:185) ~[worldguard-6.2.jar:?]
135... 21 more
136> [22:50:38 INFO]: [WorldGuard] Database: jdbc:mysql://206.81.10.54:3306/minecraft_wg (MySQL 5.7)
137> [22:50:39 INFO]: [WorldGuard] Current version of schema `minecraft_wg`: 1
138> [22:50:39 WARN]: [WorldGuard] Failed to load the region data for 'world_the_end' (periodic attempts will be made to load the data until success)
139com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to migrate tables
140at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:187) ~[worldguard-6.2.jar:?]
141at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.initialize(SQLDriver.java:108) ~[worldguard-6.2.jar:?]
142at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.initialize(SQLRegionDatabase.java:86) ~[worldguard-6.2.jar:?]
143at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.loadAll(SQLRegionDatabase.java:203) ~[worldguard-6.2.jar:?]
144at com.sk89q.worldguard.protection.managers.RegionManager.load(RegionManager.java:94) ~[worldguard-6.2.jar:?]
145at com.sk89q.worldguard.protection.managers.RegionContainerImpl.createAndLoad(RegionContainerImpl.java:129) ~[worldguard-6.2.jar:?]
146at com.sk89q.worldguard.protection.managers.RegionContainerImpl.load(RegionContainerImpl.java:106) [worldguard-6.2.jar:?]
147at com.sk89q.worldguard.bukkit.RegionContainer.load(RegionContainer.java:193) [worldguard-6.2.jar:?]
148at com.sk89q.worldguard.bukkit.RegionContainer.loadWorlds(RegionContainer.java:157) [worldguard-6.2.jar:?]
149at com.sk89q.worldguard.bukkit.RegionContainer.initialize(RegionContainer.java:93) [worldguard-6.2.jar:?]
150at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onEnable(WorldGuardPlugin.java:213) [worldguard-6.2.jar:?]
151at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [server.jar:git-Spigot-21fe707-e1ebe52]
152at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [server.jar:git-Spigot-21fe707-e1ebe52]
153at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [server.jar:git-Spigot-21fe707-e1ebe52]
154at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [server.jar:git-Spigot-21fe707-e1ebe52]
155at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [server.jar:git-Spigot-21fe707-e1ebe52]
156at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [server.jar:git-Spigot-21fe707-e1ebe52]
157at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [server.jar:git-Spigot-21fe707-e1ebe52]
158at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [server.jar:git-Spigot-21fe707-e1ebe52]
159at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [server.jar:git-Spigot-21fe707-e1ebe52]
160at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [server.jar:git-Spigot-21fe707-e1ebe52]
161at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
162Caused by: com.sk89q.worldguard.internal.flywaydb.core.api.FlywayException: Schema `minecraft_wg` contains a failed migration to version 1 !
163at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:196) ~[worldguard-6.2.jar:?]
164at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
165at com.sk89q.worldguard.internal.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[worldguard-6.2.jar:?]
166at com.sk89q.worldguard.internal.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[worldguard-6.2.jar:?]
167at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:864) ~[worldguard-6.2.jar:?]
168at com.sk89q.worldguard.internal.flywaydb.core.Flyway$1.execute(Flyway.java:811) ~[worldguard-6.2.jar:?]
169at com.sk89q.worldguard.internal.flywaydb.core.Flyway.execute(Flyway.java:1171) ~[worldguard-6.2.jar:?]
170at com.sk89q.worldguard.internal.flywaydb.core.Flyway.migrate(Flyway.java:811) ~[worldguard-6.2.jar:?]
171at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.migrate(SQLDriver.java:185) ~[worldguard-6.2.jar:?]
172... 21 more