| View previous topic :: View next topic |
| Author |
Message |
zhenlin
Veteran
Joined: 09 Nov 2002
Posts: 1361
|
 Posted: Thu Aug 28, 2003 1:23 pm Post subject: Possible bug - although may be a once-in-a-lifetime error |
 |
|
Erm, I just got this from a 'view posts since last visit':
| Quote: |
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '1303372992' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1303372992, 'd889bb704b03bd348e150a7a51838934', 'a:7:{s:14:"search_results";s:1461:"11125, 14562, 16846, 21941, 31484, 31631, 32220, 35564, 41143, 43139, 45827, 47834, 48130, 49719, 52290, 54399, 56650, 59862, 60477, 62798, 64975, 65393, 66239, 67249, 69350, 69539, 70216, 71032, 71272, 72451, 72831, 73260, 73671, 74079, 74165, 74243, 74665, 75261, 75622, 75635, 75816, 76244, 76447, 76528, 76943, 77157, 77180, 77203, 77235, 77481, 77593, 77726, 77727, 77741, 77820, 77834, 77848, 77884, 77979, 78004, 78020, 78029, 78041, 78066, 78075, 78116, 78123, 78124, 78143, 78164, 78203, 78205, 78210, 78247, 78321, 78326, 78332, 78335, 78368, 78376, 78381, 78411, 78424, 78431, 78433, 78443, 78445, 78446, 78450, 78468, 78471, 78473, 78475, 78485, 78494, 78497, 78504, 78506, 78507, 78511, 78514, 78515, 78518, 78522, 78523, 78544, 78545, 78549, 78551, 78553, 78554, 78559, 78566, 78568, 78572, 78573, 78583, 78588, 78596, 78601, 78606, 78611, 78613, 78626, 78630, 78636, 78643, 78649, 78651, 78659, 78660, 78671, 78684, 78693, 78697, 78698, 78701, 78704, 78709, 78717, 78718, 78725, 78733, 78737, 78738, 78743, 78745, 78746, 78747, 78748, 78751, 78752, 78753, 78754, 78755, 78757, 78758, 78759, 78760, 78761, 78762, 78763, 78764, 78765, 78766, 78767, 78768, 78769, 78770, 78771, 78772, 78773, 78774, 78775, 78776, 78777, 78778, 78779, 78780, 78781, 78783, 78784, 78785, 78786, 78787, 78788, 78789, 78790, 78791, 78792, 78793, 78794, 78795, 78796, 78797, 78798, 78799, 78800, 78801, 78802, 78803, 78804, 78805, 78806, 78807, 78808, 78809, 78810, 78811";s:17:"total_match_count";i:209;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')
Line : 610
File : /nfs/disk/data/www/virtual/forums.gentoo.org/search.php
|
|
|
| Back to top |
|
 |
masseya
Bodhisattva
Joined: 17 Apr 2002
Posts: 2602
Location: Baltimore, MD
|
| Posted: Thu Aug 28, 2003 4:32 pm Post subject: |
|
|
I am unable to repeat this error. Anyone else?
_________________
if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
| Back to top |
|
|
zhenlin
Veteran
Joined: 09 Nov 2002
Posts: 1361
|
| Posted: Fri Aug 29, 2003 4:32 am Post subject: |
|
|
Apparently, twice a lifetime.
| Quote: |
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '489896017' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(489896017, '7a51783e37d5ba4b69557649db325e61', 'a:7:{s:14:"search_results";s:740:"17028, 27865, 35464, 39219, 39998, 52290, 54293, 65674, 67914, 70326, 71132, 73008, 73260, 74079, 74665, 74813, 75455, 76032, 76772, 76825, 76843, 77004, 77040, 77203, 77653, 77726, 77727, 77820, 77979, 78090, 78231, 78239, 78326, 78374, 78379, 78431, 78549, 78582, 78606, 78611, 78638, 78652, 78659, 78685, 78708, 78713, 78715, 78743, 78754, 78762, 78765, 78767, 78772, 78804, 78807, 78828, 78829, 78834, 78836, 78840, 78861, 78867, 78880, 78885, 78888, 78913, 78914, 78917, 78921, 78934, 78944, 78945, 78949, 78952, 78954, 78955, 78957, 78958, 78962, 78964, 78965, 78966, 78967, 78968, 78969, 78970, 78971, 78972, 78973, 78974, 78975, 78976, 78977, 78978, 78979, 78980, 78981, 78982, 78983, 78984, 78985, 78986, 78987, 78988, 78989, 78990";s:17:"total_match_count";i:106;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')
Line : 610
File : /nfs/disk/data/www/virtual/forums.gentoo.org/search.php
|
|
|
| Back to top |
|
|
Beekster
Apprentice
Joined: 26 Nov 2002
Posts: 268
Location: Sydney
|
| Posted: Fri Aug 29, 2003 4:47 am Post subject: |
|
|
The "view since last visit" works for me, but the "view posts from last 24 hours" has been giving me:
| Quote: |
Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 35 bytes) in /nfs/disk/data/www/virtual/forums.gentoo.org/search.php on line 448 |
for quite some time now... My care factor is low, but I thought I'd mention it. |
|
| Back to top |
|
|
masseya
Bodhisattva
Joined: 17 Apr 2002
Posts: 2602
Location: Baltimore, MD
|
| Posted: Fri Aug 29, 2003 4:09 pm Post subject: |
|
|
zhenlin, hrm.. I still can't reproduce this. I'll try again from a few different machines later. 
Beekster, the "view posts from last 24 hours" problem is a known issue that we are working on correcting as soon as we can. Thanks for bringing it to our attention though.
_________________
if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
| Back to top |
|
|
masseya
Bodhisattva
Joined: 17 Apr 2002
Posts: 2602
Location: Baltimore, MD
|
| Posted: Fri Aug 29, 2003 4:21 pm Post subject: |
|
|
YAY!!
| Quote: | Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '970975818' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(970975818, 'b66a983c22059f05fc8f6354fb6f105e', 'a:7:{s:14:"search_results";s:404:"11600, 12452, 37179, 47152, 65393, 72974, 75547, 76027, 76097, 76288, 76568, 76984, 76986, 77131, 77203, 77253, 77261, 77311, 77312, 77331, 77488, 77575, 77655, 77764, 77775, 77794, 77814, 77834, 77950, 77962, 77981, 78008, 78086, 78135, 78223, 78321, 78404, 78471, 78480, 78505, 78534, 78535, 78551, 78598, 78762, 78776, 78813, 78885, 78897, 78941, 78977, 79004, 79020, 79021, 79030, 79037, 79053, 79069";s:17:"total_match_count";i:58;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')
Line : 610
File : /nfs/disk/data/www/virtual/forums.gentoo.org/search.php |
Still have no clue how to reproduce it though. I got it doing an egosearch and the next time I did one it proceeded without the error. 
_________________
if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
| Back to top |
|
|
Beekster
Apprentice
Joined: 26 Nov 2002
Posts: 268
Location: Sydney
|
| Posted: Fri Aug 29, 2003 5:25 pm Post subject: |
|
|
| masseya wrote: | | Beekster, the "view posts from last 24 hours" problem is a known issue that we are working on correcting as soon as we can. Thanks for bringing it to our attention though. |
And here I was, thinking I had seen every relevant post on the forum...   |
|
| Back to top |
|
|
masseya
Bodhisattva
Joined: 17 Apr 2002
Posts: 2602
Location: Baltimore, MD
|
| Posted: Sat Aug 30, 2003 1:57 am Post subject: |
|
|
| Beekster wrote: | | And here I was, thinking I had seen every relevant post post on the forum... |
You and me both.. 
_________________
if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
| Back to top |
|
|
jonfr
Veteran
Joined: 20 Jul 2003
Posts: 1008
Location: Denmark
|
| Posted: Fri Jan 21, 2005 3:45 pm Post subject: |
|
|
I am going to add to this topic. Since my topic did end up in duplicate.
| 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 ('00422982e61b84e3a8ffe8278cfa21cd', '004ea28b9f890a50ca7139388c3c1ab1', '005fa2bc8e9227771a9843a49b252edd', '006efd30f720f144462cf60d5686aefc', '007b52448100a4c03b7f8fdcd0f311f0', '007ba8960b6e7831a1ebb6787329b599', '009f2cd3ae83707ea1a260af288d53d5', '00c9d7c5430fd89aa15d1dab6f200e59', '00d2584de9f700ecd68f3f5d90646753', '00dab3efcbc1759c9f0c6e6fcd3935cf', '00f8b665348697c1f7be9f05a8d8afb6', '00f92f52b72b65127ee014b756612477', '01096cf16c8bb6c4b87f1f97d0ef7d6f', '010a95a31cdbc883e09c742dd622dd2c', '012d444a955f087b31e0bb8e0a31b099', '013d1946d77dcef6404f8dcede26dcec', '01547a66d91d419dd54ccc06ad59cc70', '017feb02160832f68dc8b1569ceb9fe0', '01904aa5880bc84603b5e0837f64fac9', '01ab4e67a704e0e553a746d3481cb3f2', '01c5d3448432a7c109092aa6c1272c36', '01c642ff722ac3ff0b2b7b9217023dab', '01d22de5600a86eeadcea27ef67ba96b', '01fb2981535ca04cc5b4636017c4dd8d', '02020b4c3f993d9b79ffba3afce8f1d0', '0236e1d30c0031163bfa877504ca0543', '0238648cb5b8dc5724d3506b6c482199', '024e207a1748f4785a905bf4202d2941', '027ce0e24c7ce18949083ab08a4042f5', '0297e439392096a5e3867c7513ad98c8', '02bf57c749102401b95247ef5eb91985', '02e99da27f597217fc941b15c02c9206', '02f48bcea46315f8e7e2d24ed4e0b62b', '030348a05f53762a0d7af739ef39aa0f', '0330643c6943ddda41456435b7095f2d', '036195cf548585e90f8cfce37e6f251d', '0396c5f1b576f99f7c22ba1245915aaa', '03d9541baa8d9cf9e88f5cd2f7e9fdcd', '03da2824709542f2a8210c4129c6fb8a', '040501ffbf31ea8b3ee855adcad2cf20', '04351fc5c60cc7c99f15dac9cf5b7f53', '04470e9419ca5f90561e4844d48d1065', '044dd286f3b038b3c01cf216a3bcbf72', '048eba1d3ed0523e08f071ba8077a1c1', '04a7ed311373cd03af345750bab83b81', '04bc1de8b52f14462f1cf63fd4c449d6', '04dc111b43835f6ce9319d7b5d01ffe7', '04eafbdff138f51ad0e69024adb85044', '04fe2958ed7f035059e0c63b369879cb', '05045756fb945aae39162d00ab123d9d', '052878d4080d1a62d67e6bf6d1fc8165', '052d526e0e626330ac7e5a11c1c2d269', '0554bcce099d0c2fcdf1c1a328b6e9a4', '058db03f33170882121787f2014c76dd', '059a77b1a56f9441a411a254b1fb13c5', '05a2bd646afb79d310afc8182eb33790', '05be8f9b6a94210425a03bfc25232fbe', '05d7fcb9253b358ebe6e5005d40a0f35', '05ea6eda4a6be32c5f5bfbc7a76e08a1', '05fc6077e13d42b0b9882197d50de8b0', '064f011564be4c6242a23f7ebb289c39', '0651341539a261e5acb7ab4dbe5d600a', '0676b44ac41203088bd87fa8e42b24f6', '069e7919fc0bebe3636fe642f7b7249f', '06a2796381b5fff65ad45f6b2b6937c4', '06d6d23cf700d7dbd9e79decce72ed70', '06f2a9e77d4412a7787b8bebe5d86ea6', |
This goes on for few more pages. |
|
| Back to top |
|
|
masseya
Bodhisattva
Joined: 17 Apr 2002
Posts: 2602
Location: Baltimore, MD
|
| Posted: Fri Jan 21, 2005 9:27 pm Post subject: |
|
|
I believe we eventually decided that this was the result of extremely heavy load on the forums database. What time of day do you see this error? Is it always repeatable?
_________________
if i never try anything, i never learn anything..
if i never take a risk, i stay where i am.. |
|
| Back to top |
|
|
Earthwings
Bodhisattva
Joined: 14 Apr 2003
Posts: 7753
Location: Germany
|
|
| Back to top |
|
|
ian!
Bodhisattva
Joined: 25 Feb 2003
Posts: 3829
Location: Essen, Germany
|
| Posted: Sat Jan 22, 2005 7:52 am Post subject: |
|
|
It's indeed a bug in phpBB.
_________________
"To have a successful open source project, you need to be at least somewhat successful at getting along with people." -- Daniel Robbins |
|
| 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
|
|
Gentoo Forums Feedback
