CanaryModTeam / CanaryLib

The CanaryMod API Library
http://canarymod.net
28 stars 22 forks source link

refreshRow() called on row that has been deleted or had primary key changed (CanaryMod#152) #94

Open darkdiplomat opened 9 years ago

darkdiplomat commented 9 years ago

In some cases the canary database is modified outside of minecraft (modifying player permissions etc); occasionally when that happens this exception is thrown in the console.

[SERVER] 2014-12-18 20:22:35 [ERROR] refreshRow() called on row that has been deleted or had primary key changed.
[SERVER] java.sql.SQLException: refreshRow() called on row that has been deleted or had primary key changed.
[SERVER]        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.UpdatableResultSet.refreshRow(UpdatableResultSet.java:1388) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.UpdatableResultSet.refreshRow(UpdatableResultSet.java:1306) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mysql.jdbc.UpdatableResultSet.updateRow(UpdatableResultSet.java:2405) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at com.mchange.v2.c3p0.impl.NewProxyResultSet.updateRow(NewProxyResultSet.java:1958) ~[CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at net.canarymod.database.mysql.MySQLDatabase.update(MySQLDatabase.java:118) [CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at net.canarymod.backbone.BackbonePermissions.updatePermission(BackbonePermissions.java:370) [CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]
[SERVER]        at net.canarymod.backbone.BackbonePermissions.addPermission(BackbonePermissions.java:312) [CanaryMod-1.7.10-1.1.3-20141119.185316-43-shaded.jar:1.7.10-1.1.3-SNAPSHOT]

Originally posted as https://github.com/CanaryModTeam/CanaryMod/issues/152