Forums

Mysql 5.6 breaks on keys

Permalink
Just an FYI

I just upgraded my mysql to 5.6, and now everything breaks on messages like 

An exception occurred while executing 'insert into WorkflowProgress (wfID, wrID, wpDateAdded, wpCategoryID) values (?, ?, ?, ?)' with params [0, "2", "2015-02-06 15:35:54", "1"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'


I turn on the Auto-Increment for that table, and it works until it inserts into th enext table with the same error.

This is new behavior only seen with MYSQL 5.6
ntisithoj
 
ntisithoj replied on at Permalink Reply
ntisithoj
hmm... when I dropped the database and reloaded from a backup, the problem seemed to go away, which is odd as it was a backup of teh same db that was breaking. will test some more in any case, but problem seems to have gone away