[cgiapp] CGIApp + FastCGI

[Benjamin Hitz]

We have a couple pages that use CGIApp/FastCGI.  I believe that we  
stopped using CGI::Application:FastCGI, it's a little buggy, although  
I cannot say for sure that this is the issue you get with many  
processes.  Also, it doesn't really do anything.  I can't even tell  
you how I replaced by looking at my App... it can't be more than a  
couple lines of code.

We have one outstanding issue which is Oracle DB connection related.   
If we have an app that doesn't get any hits for a long time (> default  
TIMEOUT) then the Oracle connect goes stale, and the CGI:App cannot  
recover, and the process has to be killed or apache server bumped.

Ben

On Jun 15, 2009, at 9:44 AM, Jeff MacDonald wrote:

> Hi,
>
> I'm cross posting this to CGIApp and FastCGI mailing lists, please  
> don't hit me :)
>
> I've taken over the development of a Perl/CGI::App in  house project.
>
> It has never lived its live in any sort of environment like FastCGI  
> or mod_perl and now perl startup times are starting to eat away at  
> performance. [Actually they are destroying preformance]
>
> I've tried running this application using both FastCGIServer and by  
> using the AddHandler directive to allow dynamic restarting of the  
> application.
>
> The Perl FastCGI module I am using with my application is  
> CGI::Application::FastCGI
>
> If I ran it with only one -process the results were predictable. The  
> application ran very quickly, screens came up as expected and it ran  
> generally without errors.
>
> However, when I was gearing up to shift into production, and turned  
> the processes up to 5 it because very unpredictable. It felt like  
> for some reason, one session was grabbing variables from other  
> sessions. Thus loading the wrong templates for some sessions, or  
> using the results of one query object in the wrong session and all  
> that. More or less made the system impossible to use.
>
> I'm not sure what guidelines I should be following to protect  
> against memory sharing, or if that is even an appropriate  
> description of my issue.
>
> If anyone can point me in a direction that would be helpful.
>
> --
> Jeff MacDonald
> jeff at interchange.ca
>
>
>
>
>
>
>
> #####  CGI::Application community mailing list  ################
> ##                                                            ##
> ##  To unsubscribe, or change your message delivery options,  ##
> ##  visit:  http://lists.openlib.org/mailman/listinfo/cgiapp    ##
> ##                                                            ##
> ##  Web archive:   http://lists.openlib.org/pipermail/cgiapp/   ##
> ##  Wiki:          http://cgiapp.erlbaum.net/                 ##
> ##                                                            ##
> ################################################################

--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO  
Consortium
Stanford University ** hitz at genome.stanford.edu