buglist.cgi times out

[Myk Melez]

Is buglist.cgi timing out or throwing a server error?  If the problem is 
a server error, look in your web server logs for clues to what the error 
is.  If the problem is buglist.cgi timing out, on the other hand, you 
may have database corruption.

To find out, add "&debug=1" to the working buglist.cgi URL to see the 
query it produces, then connect to both databases with the mysql client 
and run "explain" (http://www.mysql.com/doc/en/EXPLAIN.html) on each one 
to see how MySQL expects to optimize the query.  If there are 
differences, the problem is probably database corruption, and the best 
solution is to dump and rebuild the database using mysqldump.

This question is better answered in the netscape.public.mozilla.webtools 
newsgroup.  cc:ing and setting follow-ups appropriately.

-myk


usmle Prep wrote:

>Hi Friends,
>Buglist.cgi times out on my bugzilla installation.I
>did verify that the permissions are good and the same
>buglist.cgi script runs on another instance of
>bugzilla on the same server(different database). I
>feel it's something to do with the database. Do any
>one know what might have  gone wrong with the
>database? One more thing is if I run a older version
>of buglist.cgi it works fine but it doesn't have
>customfields support.
>Thanks a lot for your help,
>Srikant
>Server error!
>
>The server encountered an internal error and was
>unable to complete your request.
>
>    Error message:
>Premature end of script headers: buglist.cgi
>
>If you think this is a server error, please contact
>the webmaster
>Error 500
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Web Hosting - establish your business online
>http://webhosting.yahoo.com
>----
>To view or change your list settings, click here:
><http://bugzilla.org/cgi-bin/mj_wwwusr?user=myk@mozilla.org>
>  
>