View previous topic :: View next topic |
Author |
Message |
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 04, 2009 3:14 am Post subject: Slow searches after migration (unanswered, user posts, etc.) |
|
|
two links I pulled off of here:
https://forums.gentoo.org/search.php?search_author=desultory : works with a count of 4049 (less than his real post count, interestingly enough - deleted posts? nvm that tho)
https://forums.gentoo.org/search.php?search_author=bunder : for examply. Neddy, me, others are all like this. I suspect it has to do with the over-6666-ness of the real posts (including otw)...
please fix?
Mod edit: Changed topic title to indicate that several kinds of searches are affected.
--timeBandit _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP.
Last edited by poly_poly-man on Tue Aug 04, 2009 4:58 am; edited 1 time in total |
|
Back to top |
|
|
yabbadabbadont Advocate
Joined: 14 Mar 2003 Posts: 4791 Location: 2 exits past crazy
|
Posted: Tue Aug 04, 2009 3:29 am Post subject: |
|
|
After I saw this, I ran the query for all posts for my user and got the '6666' results (fine, what I expected) and 257 pages of results. When I tried to jump to page 257 to see the oldest results, I got the following error message:
http://omploader.org/vMjNjMg
I used a screenshot so that you could see the URL as well as the message and where it was displayed. |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 04, 2009 3:38 am Post subject: |
|
|
yabbadabbadont wrote: | After I saw this, I ran the query for all posts for my user and got the '6666' results (fine, what I expected) and 257 pages of results. When I tried to jump to page 257 to see the oldest results, I got the following error message:
http://omploader.org/vMjNjMg
I used a screenshot so that you could see the URL as well as the message and where it was displayed. | can you see bunder's? _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP. |
|
Back to top |
|
|
yabbadabbadont Advocate
Joined: 14 Mar 2003 Posts: 4791 Location: 2 exits past crazy
|
Posted: Tue Aug 04, 2009 3:39 am Post subject: |
|
|
poly_poly-man wrote: | can you see bunder's? |
I'm letting it run now. Mine took a few minutes to return...
Edit: I mean I got up and refilled my beverage, nuked a couple of frozen burritos, and made a pitstop in the restroom before the query completed...
Edit2: It just returned fine. Took it a little over two minutes to finish. |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 04, 2009 3:44 am Post subject: |
|
|
yabbadabbadont wrote: | poly_poly-man wrote: | can you see bunder's? |
I'm letting it run now. Mine took a few minutes to return...
Edit: I mean I got up and refilled my beverage, nuked a couple of frozen burritos, and made a pitstop in the restroom before the query completed...
Edit2: It just returned fine. Took it a little over two minutes to finish. | more patience than I have... wonder why it's limited to certain users. Fixing title. _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP. |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
|
Back to top |
|
|
yabbadabbadont Advocate
Joined: 14 Mar 2003 Posts: 4791 Location: 2 exits past crazy
|
Posted: Tue Aug 04, 2009 3:48 am Post subject: |
|
|
I clicked the link you provided in your first post for bunder.... |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 04, 2009 3:50 am Post subject: |
|
|
yabbadabbadont wrote: | I clicked the link you provided in your first post for bunder.... | and that took a few minutes.
EDIT: I get it... it turns into a search id when you go to a page.. nvm...
btw, desultory's last page is "no posts match"... EDIT... or was the first time..
what did you guys do to searching? I didn't know it was possible for it to get *worse* _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP.
Last edited by poly_poly-man on Tue Aug 04, 2009 3:52 am; edited 1 time in total |
|
Back to top |
|
|
yabbadabbadont Advocate
Joined: 14 Mar 2003 Posts: 4791 Location: 2 exits past crazy
|
Posted: Tue Aug 04, 2009 3:51 am Post subject: |
|
|
poly_poly-man wrote: | yabbadabbadont wrote: | I clicked the link you provided in your first post for bunder.... | and that took a few minutes.
EDIT: I get it... it turns into a search id when you go to a page.. nvm...
btw, desultory's last page is "no posts match"... |
A little over two, yes. |
|
Back to top |
|
|
bunder Bodhisattva
Joined: 10 Apr 2004 Posts: 5935
|
Posted: Tue Aug 04, 2009 3:42 pm Post subject: |
|
|
this also affects "view unanswered posts", it has something to do with the hardware upgrade, but from what i understand they're looking into it. _________________
Neddyseagoon wrote: | The problem with leaving is that you can only do it once and it reduces your influence. |
banned from #gentoo since sept 2017 |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 04, 2009 3:59 pm Post subject: |
|
|
bunder wrote: | this also affects "view unanswered posts", it has something to do with the hardware upgrade, but from what i understand they're looking into it. | unanswered has only ever hung for a small number of seconds for me... _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP. |
|
Back to top |
|
|
yabbadabbadont Advocate
Joined: 14 Mar 2003 Posts: 4791 Location: 2 exits past crazy
|
Posted: Tue Aug 04, 2009 7:40 pm Post subject: |
|
|
poly_poly-man wrote: | bunder wrote: | this also affects "view unanswered posts", it has something to do with the hardware upgrade, but from what i understand they're looking into it. | unanswered has only ever hung for a small number of seconds for me... |
It just took 166 seconds for me... |
|
Back to top |
|
|
think4urs11 Bodhisattva
Joined: 25 Jun 2003 Posts: 6659 Location: above the cloud
|
Posted: Tue Aug 04, 2009 8:27 pm Post subject: Re: >6666 realpost count users - search takes 2+min |
|
|
The first one should be ok, as long as you don't find an account where viewprofile>search_author # of posts.
The second one sees strange; contrary to the old setup i see now (but only for my own account) a search_author value of >6666, for e.g. Neddy though it shows 6666...
unanswered-search is known to be slow in the new setup, see https://forums.gentoo.org/viewtopic-t-785980.html _________________ Nothing is secure / Security is always a trade-off with usability / Do not assume anything / Trust no-one, nothing / Paranoia is your friend / Think for yourself |
|
Back to top |
|
|
timeBandit Bodhisattva
Joined: 31 Dec 2004 Posts: 2719 Location: here, there or in transit
|
Posted: Tue Aug 04, 2009 10:04 pm Post subject: |
|
|
bunder wrote: | ... from what i understand they're looking into it. | Correct, if by "looking into it" you mean "someone ensured infra and desultory are aware of the problem and this thread" and if "someone" is me. _________________ Plants are pithy, brooks tend to babble--I'm content to lie between them.
Super-short f.g.o checklist: Search first, strip comments, mark solved, help others. |
|
Back to top |
|
|
VinzC Watchman
Joined: 17 Apr 2004 Posts: 5098 Location: Dark side of the mood
|
Posted: Wed Aug 05, 2009 10:55 am Post subject: Is there a problem with unanswered posts? |
|
|
Hi admins.
For two days I've been trying to get the list of unanswered posts and it takes a very, very long time -- too long to me and I'd rather stop the request instead. So the list of unanswered posts doesn't appear and it's been more or less two days it is so. Has anybody reported a problem around that?
Thanks. _________________ Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739! |
|
Back to top |
|
|
simon_irl Guru
Joined: 07 Oct 2004 Posts: 403 Location: New Zealand
|
Posted: Wed Aug 05, 2009 11:24 am Post subject: |
|
|
i'm having this problem too: i logged in to look through the unanswered questions, but gave up waiting for the screen to load. |
|
Back to top |
|
|
bunder Bodhisattva
Joined: 10 Apr 2004 Posts: 5935
|
|
Back to top |
|
|
VinzC Watchman
Joined: 17 Apr 2004 Posts: 5098 Location: Dark side of the mood
|
Posted: Wed Aug 05, 2009 12:24 pm Post subject: |
|
|
Okay, thanks... Sorry I didn't [bother] see the announcement ...
Take it as a suggestion: in some forum software is a place to provide a note or link on top of each browsed page. That note/link appears until it's acknowledged by the [subscribed] visitor. That's how I knew TombRaider forums there was a soundtrack community pack, IIRC. _________________ Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739! |
|
Back to top |
|
|
timeBandit Bodhisattva
Joined: 31 Dec 2004 Posts: 2719 Location: here, there or in transit
|
Posted: Wed Aug 05, 2009 3:08 pm Post subject: |
|
|
VinzC wrote: | Okay, thanks... Sorry I didn't [bother] see the announcement ... | Thank you for at least being honest.
Quote: | Take it as a suggestion: in some forum software is a place to provide a note or link on top of each browsed page. That note/link appears until it's acknowledged by the [subscribed] visitor. That's how I knew TombRaider forums there was a soundtrack community pack, IIRC. | If it's provided by phpBB v3, it might appear here after the upgrade (officially, Real Soon Now, edging closer by the day). Sounds more annoying than useful though.
The Latest Site News section at the top of the forums main index serves the purpose nicely. Items are marked new until you read them. As of this writing all three announcements pertain to the migration. Honestly, there's only so much we can do short of reaching through the monitor, knocking you gently on the head, saying "Hey! Read this!" and pointing to the news item. _________________ Plants are pithy, brooks tend to babble--I'm content to lie between them.
Super-short f.g.o checklist: Search first, strip comments, mark solved, help others. |
|
Back to top |
|
|
timeBandit Bodhisattva
Joined: 31 Dec 2004 Posts: 2719 Location: here, there or in transit
|
Posted: Wed Aug 05, 2009 3:22 pm Post subject: |
|
|
Merged above five posts here and changed the original topic title to reflect the more general nature of the problem. _________________ Plants are pithy, brooks tend to babble--I'm content to lie between them.
Super-short f.g.o checklist: Search first, strip comments, mark solved, help others. |
|
Back to top |
|
|
VinzC Watchman
Joined: 17 Apr 2004 Posts: 5098 Location: Dark side of the mood
|
Posted: Wed Aug 05, 2009 3:45 pm Post subject: |
|
|
Quote: | Take it as a suggestion: in some forum software is a place to provide a note or link on top of each browsed page. That note/link appears until it's acknowledged by the [subscribed] visitor. That's how I knew TombRaider forums there was a soundtrack community pack, IIRC. |
timeBandit wrote: | If it's provided by phpBB v3, it might appear here after the upgrade (officially, Real Soon Now, edging closer by the day). Sounds more annoying than useful though.
The Latest Site News section at the top of the forums main index serves the purpose nicely. Items are marked new until you read them. As of this writing all three announcements pertain to the migration. Honestly, there's only so much we can do short of reaching through the monitor, knocking you gently on the head, saying "Hey! Read this!" and pointing to the news item. |
I'm not sure I understood but the trick is to gently avoid to have to read forum announcements everyday, knowing such a thing [as this one move] happens very, very, very rarely -- in the spirit «notifications are better than polling». _________________ Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739! |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Wed Aug 05, 2009 4:03 pm Post subject: |
|
|
VinzC wrote: | Quote: | Take it as a suggestion: in some forum software is a place to provide a note or link on top of each browsed page. That note/link appears until it's acknowledged by the [subscribed] visitor. That's how I knew TombRaider forums there was a soundtrack community pack, IIRC. |
timeBandit wrote: | If it's provided by phpBB v3, it might appear here after the upgrade (officially, Real Soon Now, edging closer by the day). Sounds more annoying than useful though.
The Latest Site News section at the top of the forums main index serves the purpose nicely. Items are marked new until you read them. As of this writing all three announcements pertain to the migration. Honestly, there's only so much we can do short of reaching through the monitor, knocking you gently on the head, saying "Hey! Read this!" and pointing to the news item. |
I'm not sure I understood but the trick is to gently avoid to have to read forum announcements everyday, knowing such a thing [as this one move] happens very, very, very rarely -- in the spirit «notifications are better than polling». | ++ - most of us do not actually hit forums.gentoo.org/ on any more than about a monthly basis...and even then it's not to look at that, it's to quick hit egosearch or another forum (like goaa, which hardly ever shows up in 24 hours) _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP. |
|
Back to top |
|
|
desultory Bodhisattva
Joined: 04 Nov 2005 Posts: 9410
|
Posted: Tue Aug 18, 2009 5:46 am Post subject: |
|
|
Those posts exist, they just happen to be hidden.
Done, robbat2 managed to generally locate, and correct, some interesting behavior on the part of the intermediate database interface which manifested under exactly the conditions you described. It should work in a more timely manner now. |
|
Back to top |
|
|
poly_poly-man Advocate
Joined: 06 Dec 2006 Posts: 2477 Location: RIT, NY, US
|
Posted: Tue Aug 18, 2009 5:56 am Post subject: |
|
|
desultory wrote: | Those posts exist, they just happen to be hidden.
Done, robbat2 managed to generally locate, and correct, some interesting behavior on the part of the intermediate database interface which manifested under exactly the conditions you described. It should work in a more timely manner now. | that explains the short database outage as well? cool, thanks. _________________ iVBORw0KGgoAAAANSUhEUgAAA
avatar: new version of logo - see topic 838248. Potentially still a WiP. |
|
Back to top |
|
|
desultory Bodhisattva
Joined: 04 Nov 2005 Posts: 9410
|
Posted: Tue Aug 18, 2009 6:18 am Post subject: |
|
|
That it does, there was a glitch in switching over which got fixed by the next automated pass. |
|
Back to top |
|
|
|