Minepacks

Minepacks

Bukkit Plugins
2M Downloads

Error migrating database MySQL to SQLite

aces52s opened this issue ยท 3 comments

commented

Information

Environment information
Plugin + server version info:


[18:45:42 INFO]: ##### Start Minepacks version info #####
[18:45:42 INFO]: Minepacks: 2.3.6-Release
[18:45:42 INFO]: Server: git-Paper-205 (MC: 1.15.2)
[18:45:42 INFO]: Java: 1.8.0_252
[18:45:42 INFO]: #####  End Minepacks version info  #####

Online mode: yes

BungeeCord: yes

Server/crash log


https://gist.github.com/aces52s/cee8d40ff401142409819910c7852c1f

Plugin config (optional)


https://gist.github.com/aces52s/4c19a0cfd107b10a815ad54d71f64eb1

Details

Description
We've been experiencing random data loss issues with minepacks and as such have decided to migrate the data to SQLite from MySQL. However, as shown in the log when attempting this migration it always fails.

Steps to reproduce
Attempt to migrate database from MySQL to SQLite.

Expected behavior
Migrate the data from MySQL to SQLite.

Other information (e.g. detailed explanation, related issues, suggestions how to fix, links for us to have context, screenshots, etc.)
N/A.

commented

Please delete your backpack.db file before running the migration. It probably already has data in it that are causing the problem.

commented

That solved the migration issue - now getting this stacktrace upon stopping the server, unsure if important.

[19:03:37 INFO]: [Minepacks] Disabling Minepacks v2.3.6-Release
[19:03:37 WARN]: Exception in thread "Thread-85" org.bukkit.plugin.IllegalPluginAccessE
xception: Plugin attempted to register task while disabled
[19:03:37 WARN]:        at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftScheduler.val
idate(CraftScheduler.java:518)
[19:03:37 WARN]:        at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftScheduler.run
TaskTimer(CraftScheduler.java:197)
[19:03:37 WARN]:        at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftScheduler.run
TaskTimer(CraftScheduler.java:188)
[19:03:37 WARN]:        at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftScheduler.run
TaskLater(CraftScheduler.java:152)
[19:03:37 WARN]:        at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftScheduler.run
Task(CraftScheduler.java:121)
[19:03:37 WARN]:        at at.pcgamingfreaks.MinepacksStandalone.libs.at.pcgamingfreaks
.Bukkit.Updater.runSync(Updater.java:89)
[19:03:37 WARN]:        at at.pcgamingfreaks.MinepacksStandalone.libs.at.pcgamingfreaks
.Updater.Updater.lambda$update$1(Updater.java:383)
[19:03:37 WARN]:        at java.lang.Thread.run(Thread.java:748)
[19:03:38 INFO]: [at.pcgamingfreaks.MinepacksStandalone.libs.com.zaxxer.hikari.HikariDa
taSource] Minepacks-Connection-Pool - Shutdown initiated...
[19:03:38 INFO]: [at.pcgamingfreaks.MinepacksStandalone.libs.com.zaxxer.hikari.HikariDa
taSource] Minepacks-Connection-Pool - Shutdown completed.
[19:03:38 INFO]: [Minepacks]  Minepacks has been disabled.  :(
commented

You can ignore that for now. I will fix it with the next update.

Edit: Has been fixed with the v2.3.7 update.