| View previous topic :: View next topic |
| Author |
Message |
moocha
Watchman
Joined: 21 Oct 2003
Posts: 5722
|
 Posted: Thu Jun 10, 2004 11:06 am Post subject: Egosearch deadlock error (temporary, fixed itself) |
 |
|
| Code: | Could not delete old search id sessions
DEBUG MODE
SQL Error : 1213 Deadlock found when trying to get lock; Try restarting transaction
DELETE FROM phpbb_search_results WHERE session_id NOT IN ('0026338a513fa8a067bd55a2784b458e', '0030a8c2abf81624ce4116eb1d5df2ef', '00644cdfe61df7f4f65cf519e8b83600', '009ade8d7e823cb425903010ee9a17ed', '00acb00cd50fbe7c11c6baa67eb9426f', '00c6b21417ebc74f2f8c71a04dbcff0e', '00c717f2916b57a86db16a1c7ffcc2b8', '00efd4959d0c14d85ce41ea51ae4b911', '00fd7334ab2ebe30051b0da84fa56684', '0120b6508681009278e3c84ebf1beb00', '013d90c7b904d08edcd7cc1982cb4ac8', '01580299ffd96ef4d62c568296a9505a', '01ff111706740a89de0eec69de7a5a4c', '022b1f53e49a47a89f589a746a91b509', '022c3cbb00adf5e3f238d6607a11b48d', '022e87f942571ead3289a6f499e859db', '029b66bc1156158df14f25ab8157c0d5', '02e201020482ae4952e04f754135d0d5', '02e55f1d363d82fef40def8efc0add62', '030007dc2f3928992287ac471ab47cca', '033661fbe969b8110423ee28f8aae18f', '03391b4b92f9df2362d2b06b0d736e48',
<snip>
9bb512503c21ac62284f0816294488c4')
Line : 487
File : /var/www/forums.gentoo.org/search.php
|
Snipped off the rest of the session IDs. Next attempt worked just fine. I encountered this one before once (2 or so months ago).
Couldn't find a similar report via searching for "egosearch deadlock". Please delete this post or move to Duplicates if it's a known problem.
Edit: It was about 4 minutes before this post, if it's any help.
_________________
Military Commissions Act of 2006: http://tinyurl.com/jrcto
"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
-- attributed to Benjamin Franklin |
|
| Back to top |
|
 |
abzs2k
Apprentice
Joined: 17 Jan 2004
Posts: 181
Location: London, UK
|
| Posted: Thu Jun 10, 2004 9:44 pm Post subject: |
|
|
Those wierd MySQL errors normally happened to me when there is lot of users logged on (hence lot of load on the server). Normally (or in my experience) a refresh just fixes them.
_________________
I am never wrong. I am simply misinterpreted.
*This User Observes Netiquette Compliance* |
|
| Back to top |
|
|
ian!
Bodhisattva
Joined: 25 Feb 2003
Posts: 3829
Location: Essen, Germany
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Duplicate Threads
