Meta-PokéBase Q&A
2 votes
294 views

Question2Answer query failed:

UPDATE qa_words AS x, (SELECT qa_words.wordid, COUNT(qa_contentwords.wordid) AS contentcount FROM qa_words LEFT JOIN qa_contentwords ON qa_contentwords.wordid=qa_words.wordid WHERE qa_words.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.

by
retagged by

1 Answer

1 vote

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.

by