PokeBase Battle Subway Meta-PokeBase Q&A

Hey Pokemaster, I have been getting this message multiple times just a little bit ago.

2 votes

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.

asked Oct 15, 2010 by trachy
retagged Dec 23, 2012 by Pokemaster

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.

answered Oct 15, 2010 by Pokemaster