{bb} Availbility Reports (bb-rep.cgi) problem timing out?

[Charles Jones <jonescr@cisco.com>]

When I run an availbility report, it takes an excessively long time, and 
the web page never returns but stays stuck on  "Generating report...", 
although it does actually generate the report on the filesystem after 
several minutes, and I can manually browse directly to it and view it.  
Any ideas what could be making it hang?  Here are the steps I took 
reproducing and troubleshooting the problem:

1.  Made sure rep dir was empty, and that the /home/bb/bb/www tree was 
writable by apache (and bb)
2. Accessed the reports option, http://mysite.com/bb/help/bb-rep.html
3. Selected report period of Oct 1 2004 - Oct 26 2004, "display only 
critical events"
4. Clicked "Generate Report" button
5. Message "Generating report for the period: Oct 01 2004 - Oct 26 2004 
(crit)" is displayed...browser running.
6. While waiting, I do a ps and can see two processes:
apache   18423  0.0  0.0  1468  512 ?        S    11:14   0:00 
/home/bb/bb/bin/bb-rep.cgi
apache   18466  0.0  0.0  1624  684 ?        S    11:14   0:00 
/home/bb/bb/bin/bbgen --reportopts=1096614000:1098774000:1:crit 
/home/bb/bb/www/rep/18423-1098814446
7. I wait a couple minutes...finally an error pops up in the error_log: 
"[Tue Oct 26 11:19:06 2004] [error] [client x.x.x.x] (70007)The timeout 
specified has expired: ap_content_length_filter: apr_bucket_read() failed"
8. Browser (IE) says "Done" in the bottom corner, but page hasn't 
changed (still on the "Generating report...")
9. I look in the directory and the report is partially there:
$ ls -l /home/bb/bb/www/rep/18423-1098814446/
total 32
-rw-r--r--    1 apache   apache      28219 Oct 26 11:19 bb.html
lrwxrwxrwx    1 apache   apache          7 Oct 26 11:19 index.html -> 
bb.html
10. I say partially because the report icon now links to 
http://mysite.com/bb/rep/18423-1098814446/help/bb-rep.html, note there 
is no help directory there
11. If I manually browse to http://mysite.com/bb/rep/18423-1098814446/, 
I can view the report.

The error in the Apache log leads me to believe that the report runs for 
too long and hits some timeout value.  I am familiar with how to change 
the timeout values for php, but I havn't found how to increase it for 
CGI scripts.  I'm mainly worried why it would take several minutes just 
to compile monthly stats for a couple dozen hosts.

Note this is BB version 1.9c w/ bbgen-2.5.  I realize there are newer 
versions of both but I have not yet upgraded.  The upgrade may make my 
problems go away, but I have spoken to other people running the same 
setup and versions with no problem.

Any ideas or suggestions are welcome :-)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
To unsubscribe from this list, or to subscribe to the bb-digest list
send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
subscribe bb-digest in the BODY of the message.