Question

Question2Answer query failed:

UPDATE qawords AS x, (SELECT qawords.wordid, COUNT(qacontentwords.wordid) AS contentcount FROM qawords LEFT JOIN qacontentwords ON qacontentwords.wordid=qawords.wordid WHERE qawords.wordid IN (39,38,206,82,2444,66,6888,13320,17,124,4508,47,699,4544) GROUP BY wordid) AS a SET x.contentcount=a.contentcount WHERE x.wordid=a.wordid

Error 1213: Deadlock found when trying to get lock; try restarting transaction

If I was to hazard a guess, it might be caused by the same thing as in chat or is a result of your fixing the chat. Or perhaps completely random.

Answer 1

I think it was because I was "reindexing" the questions (to help with searching). You shouldn't see it again, let me know if you do.