Problem with saving player info #45


  • New
  • Defect
Open
Assigned to sablednah
  • _ForgeUser6841652 created this issue Oct 16, 2015

    What steps will reproduce the problem?
    1.Downloaded plugin
    2.Changed config added some new classes
    3./admin class [name] [class]
    4.Gives the extra hearts
    5.After restart or relog hearts gone

    What is the expected output? What do you see instead?
    I expected the person to keep their class but instead they keep going back to the default class

    What version of the LegendQuest, Bukkit and Skill Defaults are you using?
    Legend Quest v1.9.7, Spigot 1.8.7 Build#40 and No Skill Defaults

    Do you have error logs of what happened? (Bukkit and /plugins/LegendQuest/legendquest.log)

    [07:25:06] [Craft Scheduler Thread - 48/ERROR]: [LegendQuest] Error writing lq_pc to database.
    [07:25:06] [Craft Scheduler Thread - 48/WARN]: java.sql.SQLException: [SQLITE_BUSY]  The database file is locked (database is locked)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.newSQLException(DB.java:383)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.newSQLException(DB.java:387)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.execute(DB.java:339)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.Stmt.exec(Stmt.java:65)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.Stmt.execute(Stmt.java:114)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at lib.PatPeter.SQLibrary.Database.query(Database.java:242)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync.writeData(DataSync.java:747)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync.access$0(DataSync.java:710)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync$dbProcessCache.run(DataSync.java:48)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.lang.Thread.run(Thread.java:745)
    [07:25:06] [Craft Scheduler Thread - 48/ERROR]: [LegendQuest] Error writing lq_datastore sets to database.
    [07:25:06] [Craft Scheduler Thread - 48/WARN]: java.sql.SQLException: cannot commit transaction - SQL statements in progress
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.throwex(DB.java:370)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.ensureAutoCommit(DB.java:435)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.DB.execute(DB.java:332)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.Stmt.exec(Stmt.java:65)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.sqlite.Stmt.execute(Stmt.java:114)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at lib.PatPeter.SQLibrary.Database.query(Database.java:242)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync.saveDataStore(DataSync.java:994)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync.writeData(DataSync.java:823)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync.access$0(DataSync.java:710)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at me.sablednah.legendquest.db.DataSync$dbProcessCache.run(DataSync.java:48)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    [07:25:06] [Craft Scheduler Thread - 48/WARN]:     at java.lang.Thread.run(Thread.java:745)

    Please provide any additional information below.

    Config File- Link Removed: https://www.mediafire.com/?1jhzlekdzk9rodk

  • _ForgeUser6841652 added the tags New Defect Oct 16, 2015
  • sablednah posted a comment Oct 17, 2015

    Well that pretty much sums it up - the database file is locked for some reason.

    Firstly delete LegendQuest.db-journal

    Then what server are you running on? Linux, Windows? Check your permissions and make sure the LQ folder and the .db are writable.

  • _ForgeUser6841652 posted a comment Oct 21, 2015

    We are running server using Shockbyte hosting website. I deleted the LegendQuest.db-journal sadly it didnt help. We cant control the permissions.

  • sablednah posted a comment Oct 21, 2015

    @simon8198: Go

    Ok, try shutting down - deleting the db entirely (you'll lose all LQ player info :/ but not inventories etc.) and then restarting.

    The alternative is, Is there any way you could switch to MySQL - do Shockbyte offer support for it?

  • _ForgeUser6841652 posted a comment Oct 25, 2015

    I changed it to MySQL which has fixed the problem. Thanks for telling me


To post a comment, please login or register a new account.