Bug 103829 – Bugzilla frequently not responding at random times

• Product: Gentoo Infrastructure
• Status: RESOLVED WORKSFORME

[Description Jakub Moc (RETIRED) 2005-08-26 07:48:52 UTC]

For at least last week or so, bugzilla has been inaccessible at random times,
sometimes just for a few minutes, once or twice even for a couple of hours.

This is causing lots of duplicate bugs when people are trying to resubmit their
bug reports, and also wastes bug wranglers' and developers' time. 

Could infra please investigate what's wrong here? Needs some a solution as soon
as possible. Thanks!


Reproducible: Sometimes
Steps to Reproduce:

[Comment 1 Jeffrey Forman (RETIRED) 2005-08-26 07:51:11 UTC]

jakub,

the db behind bugs/forums has been getting slammed beause of the increasing
number of people using it. we're not the only project using that one database
box, kerneltrap is one example of a party who is sharing our db box. 

i believe our host, the OSL, is working on a replacement to off load some of it.
but for right now, there's not much we can do :/

-jeffrey

[Comment 2 Lance Albertson (RETIRED) 2005-08-29 06:43:17 UTC]

Are we even sure its db1 thats the primary cause of the problem? Forums is a
huge db1 user and I haven't heard any complaints about its speed. We have been
dealing with DoS issues lately on that box and that could be part of the
problem. I've noticed that its been happening more doing the middle of night for
me. Is that when you've noticed the problems, or is it any time during the day?
Please let me know a more specific timeframe of these problems.

Thanks-

[Comment 3 Mark Loeser (RETIRED) 2005-08-29 06:53:52 UTC]

I personally have experienced it during the day (3-6PM EST).  Its normally
unresponsive to queries for a couple of minutes and then comes back.

[Comment 4 Jeffrey Forman (RETIRED) 2005-09-11 08:42:11 UTC]

havent heard any reports of it being slow lately, so closing it for now. 

[Comment 5 Jakub Moc (RETIRED) 2005-09-12 03:06:13 UTC]

Closing this bug seems to have disastrous effect on bugzilla; http is dead,
https really slow. Same for packages.g.o. :(

Reopen.

[Comment 6 Lance Albertson (RETIRED) 2005-09-12 06:45:24 UTC]

After doing some looking, I'm thinking the problem is more drawn towards
packages.g.o which is hosted on the same box. Been having problems of RSS
readers hammering the box and/or spiders doing the same. We have been looking
into ways to limit that. We may just need to adjust the robots.txt also for that
site.

[Comment 7 Lance Albertson (RETIRED) 2005-09-12 06:46:27 UTC]

Marduk: Do you have a better robots.txt we could put on packages.g.o to limit
search engine's affect on the site?

[Comment 8 Jeffrey Forman (RETIRED) 2005-09-12 06:56:43 UTC]

lance,

you mentioned about people nailing packages with RSS. does RSS run over the http
protocol? i'm just thinking, can we put limits on the number of spawned apache
processes for just that vhost (packages.g.o) so that it doesnt overwhelm
nuthatch? is that not the problem?

[Comment 9 Jeffrey Forman (RETIRED) 2005-10-12 06:33:11 UTC]

think this was fixed with lance limiting the memory bugzilla can eat. closing
for now.