Re: [SL] Apache error running summary reports - reality checking script?

[Michael H. <mh...@it...>]

Months later, I'm getting back to this, (prodded by tax deadlines of  
course!  :)

    I did check the timeout directive and raised it to some  
ridiculous level to no avail, (and same duration of wait so I don't  
think that's it).
    Also don't think it's a record count issue as it was working fine  
right up a month or two before the upgrade and we don't do THAT much  
business.
    I also opened a terminal session to the host server and watched  
the stats as it was running and there were no issues with memory/swap/ 
etc running out or anything like that.
    Somebody suggested checking another company in the system, (good  
idea, my apologies for not doing that before posting!  Brain fade...).
    Unfortunately that company works just fine so I have to assume at  
this point that I have a corrupt record somewhere/somehow.

    So now the question is - are there any sort of scripts that can  
be run to do a sanity check?  Has anybody had to deal with bad  
records and might have some tips to save a few hours of poring over  
the DB structure?


Thanks!!!!!!!!!!!!

Michael



On Jan 8, 2008, at 6:01 AM, William McKee wrote:

> On Mon, Jan 07, 2008 at 09:34:39PM -0800, Michael Hasse wrote:
>> Just an update on this.  Permissions are all fine and the reports run
>> with no problems in our test company.  Reading up a bit on the errors
>> it looks like a simple timeout problem where Apache is giving up on
>> the script before it finishes due to the amount of data we have
>> slowing the script down.  (System resources are okay so we're not
>> running out of memory or anything).
>
> Interesting, I hadn't considered timeout error causing that message.
>
>
>>     Suggestions/advice are welcome and we'll keep plugging away at it
>> and post back if we figure it out.
>
> Have you checked out the TimeOut directive[1]? I've seen some people
> comment the TimeOut does not affect CGI scripts, but Apache security
> tips[2] say the following:
>
>  "As TimeOut is currently used for several different operations,  
> setting
>  it to a low value introduces problems with long running CGI scripts."
>
> I've seen others suggest using FastCGI. Keep us posted on your  
> progress.
>
>
> Good luck,
> William
>
> [1] http://httpd.apache.org/docs/2.0/mod/core.html#timeout
> [2] http://httpd.apache.org/docs/trunk/misc/security_tips.html#dos
>
> -- 
> Knowmad Technologies - Web Site Development & Programming
> W: http://www.knowmad.com | E: wi...@kn...
> P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee
>
> ---------------------------------------------------------------------- 
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ 
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users