logblock message on consol, what is wrong

Discussion in 'Bukkit Help' started by knutarn, Apr 27, 2012.

Thread Status:
Not open for further replies.
  1. Offline

    knutarn

    Suddenly nuke consol the message here :

    10:38:58 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1335514993), 245, 12, 0, 0, '-1006', 62, '-1871');:
    java.sql.SQLException: Table './minecraft_logblock/lb@002dworld' is marked as crashed and last (automatic?) repair failed
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:292)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Thread.java:679)

    what is wrong?
     
  2. Offline

    zipfe

    The table you use is broken. Delete it and let LogBlock recreate it on start-up. The old data will be lost, of course.
     
  3. Offline

    knutarn

    aah use my backup^^

    no i get this:

    2012-04-27 13:34:16 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-world-chest` (id, itemtype, itemamount, itemdata) values (LAST_INSERT_ID(), 85, -38, 0);:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '7594982' for key 'PRIMARY'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:292)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Thread.java:679)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 25, 2016
  4. Offline

    stuntguy3000

    Its still a database error >.>
     
  5. Offline

    knutarn

    Yes but what is wrong?
     
Thread Status:
Not open for further replies.

Share This Page