CoreProtect Integer Overflow

Discussion in 'Spigot Discussion' started by Samistine, Jun 7, 2016.

  1. Ohh noes there goes my database :(

    Code (Text):
    [22:32:30 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2147483647' for key 'PRIMARY'
     
  2. you need to raise the primary key from an int to a "big int" then your db should work again :p
     
  3. but considering that you are on 2.000.000.000 records, i belive that might take ... umm how do i say this nicely ? ... well, your grandkids would have taken over the server, before that action would be done.
     
  4. I've run into this problem before with LogBlock too. Just edit the schema and you're good to go, doesn't take that long if you're on a decent server.
     
  5. 4chan

    Supporter

    what the actual fuck
    why
     
  6. I treat the core protect database like its something nice to have but not absolutely nessesary. When something like this happens I usually end up dropping the database and recreating it. The db wasn't full as I did monthlyish cleanups, however the primary key never was, as such, reset.