Skip to content

Probabilistic database PRIMARY KEY error, leading to data loss #1

@CodeZhangBorui

Description

@CodeZhangBorui
[03:00:00 ERROR]: [PixelRank] Could not connect to the SQLite database!
org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_PRIMARYKEY] A PRIMARY KEY constraint failed (UNIQUE constraint failed: mining_rank.player)
        at org.sqlite.core.DB.newSQLException(DB.java:1179) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.core.DB.newSQLException(DB.java:1190) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.core.DB.execute(DB.java:985) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.core.CoreStatement.exec(CoreStatement.java:79) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.jdbc3.JDBC3Statement.lambda$execute$0(JDBC3Statement.java:52) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:454) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:40) ~[sqlite-jdbc-3.42.0.0.jar:?]
        at com.codezhangborui.pixelRank.database.Database.lambda$save$0(Database.java:73) ~[PixelRank-1.1.jar:?]
        at java.lang.Thread.run(Thread.java:833) ~[?:?]

Metadata

Metadata

Labels

bugSomething isn't workingpriorityHigh priority for this issue

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions