Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
random search bug. (?)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo Forums Feedback
View previous topic :: View next topic  
Author Message
lvizard
n00b
n00b


Joined: 14 Jan 2003
Posts: 5

PostPosted: Wed Dec 24, 2003 7:43 pm    Post subject: random search bug. (?) Reply with quote

after typing in Quick Search "gentoo-source" the forum responded with this:

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 ('002d9cb93b70bc4906f342acfc57a940', '006cbfbc795a5cc4aa1b18550e1d9f1b', '00a312b3e7be39bb7bb6245dadccf219', '00c28ca5bfa20d5d74c84a6e73328508', '00e647ef299008e7b5b17b7b63523132', '0108004349e5e74ec8612fd723af648e', '011615b856e852175c5086091d3eb1d3', '01420bb722ca6046237b4ea930d9cf70', '01c3399623868452fdab2a0f16bbe0d7', '01c3538fc1b8ba620f14ee44bf688f13', '01e20ec89ee91b31ee33f4bc4515ef7d', '0264556e1329a4f3974b14c8d2509e46', '02b98b648ac2706645f18582d940ce75'
[.....]
'fd21a7ebef72cbd7a211ce18e2f5db37')

Line : 481
File : /var/www/forums.gentoo.org/search.php


i typed "gentoo-source" again and then the forum responded properly
Back to top
View user's profile Send private message
Earthwings
Bodhisattva
Bodhisattva


Joined: 14 Apr 2003
Posts: 7753
Location: Germany

PostPosted: Thu Dec 25, 2003 8:26 pm    Post subject: Reply with quote

Looks like phpbb handles deadlocks with the Ostrich-algorithm (put head in the sand and pretend they don't happen), while SQL detected a deadlock and aborted the query. That's alright, the only inconvenience is you have to start your search again.
Back to top
View user's profile Send private message
brandsmeier
n00b
n00b


Joined: 26 Sep 2004
Posts: 14

PostPosted: Fri May 06, 2005 3:58 pm    Post subject: Forum Bug Could not delete old search id sessions Reply with quote

I tried searching and got this response:

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 ('000a8ef0a625ef8a9539203314b2fa81', '001b6233786bd3004894953a77e1ad37', '002acbcebee91843ce77977f965841d9', '002e223b24474c6708b3fece07c64549', '003f56305d29ca36474b887b9366c8e7', '0042f386d5fb1c5841114bd3df412546', '00445fb4d80efcefc3df489f43a68363', '004bbefd0ffd457336f37ba73dba9984', '004fa3e141a0c6059796a390e1189d07', '005657d7e1d792289f60cdb932c73464', '0060a62b0188b76b86dc2ad3300c5f46', '006c8d7f21a335475a9ec9ff297740c3',
[....]

Line : 525
File : search.php


1st. This bug was not reproducible, well its a deadlock.
2nd. I think that SQL Query needs REALLY to be fixed. It seems to be really slow.

Greets,
Holger Brandsmeier
Back to top
View user's profile Send private message
pjp
Administrator
Administrator


Joined: 16 Apr 2002
Posts: 18335

PostPosted: Fri May 06, 2005 7:11 pm    Post subject: Reply with quote

Merged previous.

There is also a report in this thread, though it looks like a different issue to me.
_________________
Don't even pause and ask them why. Turn around and say goodbye.
Back to top
View user's profile Send private message
moocha
Watchman
Watchman


Joined: 21 Oct 2003
Posts: 5722

PostPosted: Sat May 07, 2005 7:52 am    Post subject: Reply with quote

Used to get lots of those around last November or so. Not sure when I got the last one, but I'm certain there were none at all this year (so far).
Earthwings: "Ostrich algorithm"... I love that :lol:
_________________
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
View user's profile Send private message
dschobel
n00b
n00b


Joined: 26 Jan 2005
Posts: 51

PostPosted: Fri Oct 21, 2005 8:27 pm    Post subject: search error Reply with quote

I tried to do a Quick Search and got the following

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 ('002058d610068562ecfc39eb985848e4', '00392ec069a27909aae6af2c7432b2ff', '0053fe27eed07e66b2a30ee6b0a82e0d', '0075ef7edaf2378d49519ec8d0fda4bb', '0083d5ff8c9f310d86b58493e22f85fb', '00879c6eaa523257f7d560e5ef37ddd2', '008e53724a25e7dd8132a3bdbf5c4d76', '0096a0ede12e7e846c8e8659c0c419c6', '009dad74a39e005a3451f11384713a98', '00a03711397add992cc38698daa8260c', '00c36f6c139c87ca48ef1b8400a334ea', '00e1702fdb2dee718064207e0a3b7385', '00e5e60a8e7564a0d492d5035f84a874', '00eea534e53c80e5f56e09dbf90d7a0d',


followed by hundreds of lines of the same cryptic codes and then at the bottom:
Code:
Line : 544
File : search.php
Back to top
View user's profile Send private message
tomk
Bodhisattva
Bodhisattva


Joined: 23 Sep 2003
Posts: 7221
Location: Sat in front of my computer

PostPosted: Sat Oct 22, 2005 9:59 am    Post subject: Reply with quote

Merged previous post.
_________________
Search | Read | Answer | Report | Strip
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo Forums Feedback All times are GMT
Page 1 of 1

 
Jump to:  
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