Noticing these errors a lot it my logs. Any idea why, or how to stop it from happening?
Jan 27 15:02:58 myapp.com ool: myapp: [craft] [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'b790ee3c633c1693d2140bfae35b65fe' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO craft_cache (id,expire,value) VALUES ('b790ee3c633c1693d2140bfae35b65fe',1485633775,:value).
Update - also seeing:
Jan 27 15:49:58 myapp.com ool: myapp: [craft] [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction. The SQL statement executed was: DELETE FROM craft_cache WHERE expire>0 AND expire<1485550196.
- I'm not using any template level caching (site is Varnished)
- Load balanced setup (1 LB, 2 web heads, 1 LB, 1 DB)
- Looking up the key in the latter example, it is a serialized object of
Craft\SearchPlus_AlgoliaMapModel(plugin). However, looking at the SearchPlus code I'm pretty it the plugin itself isn't storing this. It has one call to
craft()->cache->setand it just stores a string.