Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Catalyst: Users

Application stallling problem

 

 

Catalyst users RSS feed   Index | Next | Previous | View Threaded


kakimoto at tpg

Mar 25, 2009, 3:35 PM

Post #1 of 19 (2465 views)
Permalink
Application stallling problem

hi guys,

i have this issue when i click on any url of my site more than once (ie
double clicking).
When i click more than once, the site stalls and nothing loads (even if it's
just a light weight static page that i want to load).

Example:

1. i load up www.lginsurance.com
2. all loaded up and nice
3. i now click on "about us" link which points to
www.lginsurance.com/aboutus
4. i then immediately change my mind and want to go to the "products"
page and click on the link, "products" which points to
www.lginsurance.com/products
5. the site stalls and doens't move

at the terminal, i observed that HTML::View->process is the last thing
that's being called.

[debug] "GET" request for "/" from "123.243.50.59"
[debug] Path is "/"
[debug] Rendering template "index.tt2"
[debug] Applying HTML page layout wrappers to index.tt2
[info] Request took 0.094246s (10.611/s)
.----------------------------------------------------------------+-----------.
| Action | Time
|
+----------------------------------------------------------------+-----------+
| /auto | 0.000406s
|
| /default | 0.000129s
|
| /end | 0.049609s
|
| -> myApp::View::HTML->process | 0.047017s
|
'----------------------------------------------------------------+-----------'



Any ideas??


K. akimoto


kakimoto at tpg

Mar 25, 2009, 9:38 PM

Post #2 of 19 (2378 views)
Permalink
Re: Application stallling problem [In reply to]

sorry, guys, some bad character encodings from my mail client.
Here's the mail again:

hi guys,

i have this issue when i click on any url of my site more than once (ie
double clicking).
When i click more than once, the site stalls and nothing loads (even if
it's just a light weight static page that i want to load).

Example:

1. i load up www.lginsurance.com
2. all loaded up and nice
3. i now click on "about us" link which points to
www.lginsurance.com/aboutus
4. i then immediately change my mind and want to go to the "products"
page and click on the link, "products" which points to
www.lginsurance.com/products
5. the site stalls and doens't move

at the terminal, i observed that HTML::View->process is the last thing
that's being called.

[debug] "GET" request for "/" from "123.243.50.59"
[debug] Path is "/"
[debug] Rendering template "index.tt2"
[debug] Applying HTML page layout wrappers to index.tt2
[info] Request took 0.094246s (10.611/s)
.----------------------------------------------------------------+-----------.
| Action | Time
|
+----------------------------------------------------------------+-----------+
| /auto |
0.000406s |
| /default |
0.000129s |
| /end |
0.049609s |
| -> myApp::View::HTML->process |
0.047017s |
'----------------------------------------------------------------+-----------'



Any ideas??


K. akimoto

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


bobtfish at bobtfish

Mar 26, 2009, 6:17 AM

Post #3 of 19 (2373 views)
Permalink
Re: Application stallling problem [In reply to]

kakimoto [at] tpg wrote:
> sorry, guys, some bad character encodings from my mail client.
> Here's the mail again:

> Any ideas??

Not sure, but I think its something between the server you're using and
the browser - if you're getting the request table, then as far as the
Catalyst server is aware, then it has passed a page to your browser, and
your browser hasn't requested another one..

Probably trying to use tcpdump or a capturing proxy (parosproxy.org) to
try and take apart the requests/responses to work out whats going on
would be helpful?

Cheers
t0m


_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


alexander.hartmaier at t-systems

Mar 26, 2009, 9:12 AM

Post #4 of 19 (2376 views)
Permalink
Re: Application stallling problem [In reply to]

The test server can only process one request per time!
Maybe your first request blocks the server cause a e.g. database query
takes long so the second query isn't handles by the server.

-
BR Alex


Am Donnerstag, den 26.03.2009, 14:17 +0100 schrieb Tomas Doran:
> kakimoto [at] tpg wrote:
> > sorry, guys, some bad character encodings from my mail client.
> > Here's the mail again:
>
> > Any ideas??
>
> Not sure, but I think its something between the server you're using
> and
> the browser - if you're getting the request table, then as far as the
> Catalyst server is aware, then it has passed a page to your browser,
> and
> your browser hasn't requested another one..
>
> Probably trying to use tcpdump or a capturing proxy (parosproxy.org)
> to
> try and take apart the requests/responses to work out whats going on
> would be helpful?
>
> Cheers
> t0m
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

Mar 26, 2009, 3:57 PM

Post #5 of 19 (2364 views)
Permalink
Re: Application stallling problem [In reply to]

hello Alex,

Good morning.
Not likely. The pages I am requesting don't even use the database. Just
controller and view needed.


any ideas, everyone?


K. akimoto


2009/3/27 Alexander Hartmaier <alexander.hartmaier [at] t-systems>

> The test server can only process one request per time!
> Maybe your first request blocks the server cause a e.g. database query
> takes long so the second query isn't handles by the server.
>
> -
> BR Alex
>
>
> Am Donnerstag, den 26.03.2009, 14:17 +0100 schrieb Tomas Doran:
> > kakimoto [at] tpg wrote:
> > > sorry, guys, some bad character encodings from my mail client.
> > > Here's the mail again:
> >
> > > Any ideas??
> >
> > Not sure, but I think its something between the server you're using
> > and
> > the browser - if you're getting the request table, then as far as the
> > Catalyst server is aware, then it has passed a page to your browser,
> > and
> > your browser hasn't requested another one..
> >
> > Probably trying to use tcpdump or a capturing proxy (parosproxy.org)
> > to
> > try and take apart the requests/responses to work out whats going on
> > would be helpful?
> >
> > Cheers
> > t0m
> >
> >
> > _______________________________________________
> > List: Catalyst [at] lists
> > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> > Searchable archive:
> > http://www.mail-archive.com/catalyst [at] lists/
> > Dev site: http://dev.catalyst.perl.org/
>
>
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
> T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
> Handelsgericht Wien, FN 79340b
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
> Notice: This e-mail contains information that is confidential and may be
> privileged.
> If you are not the intended recipient, please notify the sender and then
> delete this e-mail immediately.
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/
>


kakimoto at tpg

Apr 8, 2009, 6:14 PM

Post #6 of 19 (2229 views)
Permalink
Re: Application stallling problem [In reply to]

hello

good morning. The page which I access at first doesn't require any
database request. It's just pretty much a page that's generated by
template toolkit and that's it.

On the terminal which I am running the myapp_server.pl script, it seems
to stall and not do anything when i put in another url path into the
webbrowser and hit enter.

Example:


1) URL, www.lginsurance.com/signup is accessed
2) URL, www.lginsurance.com/signup is accessed again by highlighting the
url on the web browser and hitting "enter"
--> notice that on the terminal screen, the last line is " HTML->process
" along with the time taken and stalls there

Is this a problem you guys have?



for production deployment, do many of you run myapp_server.pl or
myapp_fastcgi.pl?

Any comments please?


thank you


K. akimoto





Quoting Tomas Doran <bobtfish [at] bobtfish>:

> kakimoto [at] tpg wrote:
> > sorry, guys, some bad character encodings from my mail client.
> > Here's the mail again:
>
> > Any ideas??
>
> Not sure, but I think its something between the server you're using
> and
> the browser - if you're getting the request table, then as far as the
>
> Catalyst server is aware, then it has passed a page to your browser,
> and
> your browser hasn't requested another one..
>
> Probably trying to use tcpdump or a capturing proxy (parosproxy.org)
> to
> try and take apart the requests/responses to work out whats going on
>
> would be helpful?
>
> Cheers
> t0m
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/
>
>
>




_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kieren at diment

Apr 8, 2009, 6:23 PM

Post #7 of 19 (2216 views)
Permalink
Re: Application stallling problem [In reply to]

Are you using the CGI Template Toolkit plugin thingy? Don't. This
will cause your problem as described. If not you've given us
insufficient information

Fastcgi is easier to setup on shared hosting, and has some
advantages. CATALYST_ENGINE=HTTP::Prefork script/myapp_server.pl is
pretty simple and can be reverse proxied pretty easily. Install
C::E::HTTP::Prefork from CPAN and give it a shot...

On 09/04/2009, at 11:14 AM, kakimoto [at] tpg wrote:

>
> hello
>
> good morning. The page which I access at first doesn't require any
> database request. It's just pretty much a page that's generated by
> template toolkit and that's it.
>
> On the terminal which I am running the myapp_server.pl script, it
> seems
> to stall and not do anything when i put in another url path into the
> webbrowser and hit enter.
>
> Example:
>
>
> 1) URL, www.lginsurance.com/signup is accessed
> 2) URL, www.lginsurance.com/signup is accessed again by highlighting
> the
> url on the web browser and hitting "enter"
> --> notice that on the terminal screen, the last line is " HTML-
> >process
> " along with the time taken and stalls there
>
> Is this a problem you guys have?
>
>
>
> for production deployment, do many of you run myapp_server.pl or
> myapp_fastcgi.pl?
>
> Any comments please?
>
>
> thank you
>
>
> K. akimoto
>
>
>
>
>
> Quoting Tomas Doran <bobtfish [at] bobtfish>:
>
>> kakimoto [at] tpg wrote:
>>> sorry, guys, some bad character encodings from my mail client.
>>> Here's the mail again:
>>
>>> Any ideas??
>>
>> Not sure, but I think its something between the server you're using
>> and
>> the browser - if you're getting the request table, then as far as the
>>
>> Catalyst server is aware, then it has passed a page to your browser,
>> and
>> your browser hasn't requested another one..
>>
>> Probably trying to use tcpdump or a capturing proxy (parosproxy.org)
>> to
>> try and take apart the requests/responses to work out whats going on
>>
>> would be helpful?
>>
>> Cheers
>> t0m
>>
>>
>> _______________________________________________
>> List: Catalyst [at] lists
>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
>> Searchable archive:
>> http://www.mail-archive.com/catalyst [at] lists/
>> Dev site: http://dev.catalyst.perl.org/
>>
>>
>>
>
>
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

Apr 8, 2009, 6:41 PM

Post #8 of 19 (2229 views)
Permalink
Re: Application stallling problem [In reply to]

Hello, Kieren,

thank you for your feedback.

1) CGI Template Toolkit plugin - not using it

I do not think that I am using the CGI Template Toolkit plugin.
I have only been using Template Toolkit as prescribed in the Catalyst
tutorials.

in my file, /myAppl/lib/myApp/View/HTML.pm, I have the line,
"TEMPLATE_EXTENSION => '.tt2'"


May I ask on what sort of CGI Template Toolkit plugin are you referring
to specifically?


2) Currently having my own ubuntu virtual server to deploy my application.


- Any good recommendations?
- Would using myapp_server.pl cut for an application which has say 50
users logged in at the same time?

Please pardon my lack of knowledge for I am only a developer and have
little experience in the systems administation and tuning sector.

Thank you, all.





Quoting Kieren Diment <kieren [at] diment>:

> Are you using the CGI Template Toolkit plugin thingy? Don't. This
>
> will cause your problem as described. If not you've given us
> insufficient information
>
> Fastcgi is easier to setup on shared hosting, and has some
> advantages. CATALYST_ENGINE=HTTP::Prefork script/myapp_server.pl is
>
> pretty simple and can be reverse proxied pretty easily. Install
> C::E::HTTP::Prefork from CPAN and give it a shot...
>
> On 09/04/2009, at 11:14 AM, kakimoto [at] tpg wrote:
>
> >
> > hello
> >
> > good morning. The page which I access at first doesn't require any
> > database request. It's just pretty much a page that's generated by
> > template toolkit and that's it.
> >
> > On the terminal which I am running the myapp_server.pl script, it
>
> > seems
> > to stall and not do anything when i put in another url path into
> the
> > webbrowser and hit enter.
> >
> > Example:
> >
> >
> > 1) URL, www.lginsurance.com/signup is accessed
> > 2) URL, www.lginsurance.com/signup is accessed again by
> highlighting
> > the
> > url on the web browser and hitting "enter"
> > --> notice that on the terminal screen, the last line is " HTML-
> > >process
> > " along with the time taken and stalls there
> >
> > Is this a problem you guys have?
> >
> >
> >
> > for production deployment, do many of you run myapp_server.pl or
> > myapp_fastcgi.pl?
> >
> > Any comments please?
> >
> >
> > thank you
> >
> >
> > K. akimoto
> >
> >
> >

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


brucem at dynamicrange

Apr 8, 2009, 6:43 PM

Post #9 of 19 (2218 views)
Permalink
Re: Application stallling problem [In reply to]

I do not have this problem. I use _server.pl exclusively.

Have you considered testing via curl? It's pretty effective. I wrote a
small wrapper around it because the options get annoying.

B.

On Apr 8, 2009, at 6:14 PM, kakimoto [at] tpg wrote:

>
> hello
>
> good morning. The page which I access at first doesn't require any
> database request. It's just pretty much a page that's generated by
> template toolkit and that's it.
>
> On the terminal which I am running the myapp_server.pl script, it
> seems
> to stall and not do anything when i put in another url path into the
> webbrowser and hit enter.
>
> Example:
>
>
> 1) URL, www.lginsurance.com/signup is accessed
> 2) URL, www.lginsurance.com/signup is accessed again by highlighting
> the
> url on the web browser and hitting "enter"
> --> notice that on the terminal screen, the last line is " HTML-
> >process
> " along with the time taken and stalls there
>
> Is this a problem you guys have?
>
>
>
> for production deployment, do many of you run myapp_server.pl or
> myapp_fastcgi.pl?
>
> Any comments please?
>
>
> thank you
>
>
> K. akimoto
>
>
>
>
>
> Quoting Tomas Doran <bobtfish [at] bobtfish>:
>
>> kakimoto [at] tpg wrote:
>>> sorry, guys, some bad character encodings from my mail client.
>>> Here's the mail again:
>>
>>> Any ideas??
>>
>> Not sure, but I think its something between the server you're using
>> and
>> the browser - if you're getting the request table, then as far as the
>>
>> Catalyst server is aware, then it has passed a page to your browser,
>> and
>> your browser hasn't requested another one..
>>
>> Probably trying to use tcpdump or a capturing proxy (parosproxy.org)
>> to
>> try and take apart the requests/responses to work out whats going on
>>
>> would be helpful?
>>
>> Cheers
>> t0m
>>
>>
>> _______________________________________________
>> List: Catalyst [at] lists
>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
>> Searchable archive:
>> http://www.mail-archive.com/catalyst [at] lists/
>> Dev site: http://dev.catalyst.perl.org/
>>
>>
>>
>
>
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/

---
Bruce McKenzie
brucem [at] dynamicrange




_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

Apr 9, 2009, 6:22 PM

Post #10 of 19 (2200 views)
Permalink
Re: Application stallling problem [In reply to]

hello , everyone :)

good morning. Happy eAster!

any more ideas?

thank you


Quoting kakimoto [at] tpg:

> Hello, Kieren,
>
> thank you for your feedback.
>
> 1) CGI Template Toolkit plugin - not using it
>
> I do not think that I am using the CGI Template Toolkit plugin.
> I have only been using Template Toolkit as prescribed in the
> Catalyst
> tutorials.
>
> in my file, /myAppl/lib/myApp/View/HTML.pm, I have the line,
> "TEMPLATE_EXTENSION => '.tt2'"
>
>
> May I ask on what sort of CGI Template Toolkit plugin are you
> referring
> to specifically?
>
>
> 2) Currently having my own ubuntu virtual server to deploy my
> application.
>
>
> - Any good recommendations?
> - Would using myapp_server.pl cut for an application which has say
> 50
> users logged in at the same time?
>
> Please pardon my lack of knowledge for I am only a developer and
> have
> little experience in the systems administation and tuning sector.
>
> Thank you, all.
>
>
>
>
>
> Quoting Kieren Diment <kieren [at] diment>:
>
> > Are you using the CGI Template Toolkit plugin thingy? Don't. This
>
> >
> > will cause your problem as described. If not you've given us
> > insufficient information
> >
> > Fastcgi is easier to setup on shared hosting, and has some
> > advantages. CATALYST_ENGINE=HTTP::Prefork script/myapp_server.pl
> is
> >
> > pretty simple and can be reverse proxied pretty easily. Install
> > C::E::HTTP::Prefork from CPAN and give it a shot...
> >
> > On 09/04/2009, at 11:14 AM, kakimoto [at] tpg wrote:
> >
> > >
> > > hello
> > >
> > > good morning. The page which I access at first doesn't require
> any
> > > database request. It's just pretty much a page that's generated
> by
> > > template toolkit and that's it.
> > >
> > > On the terminal which I am running the myapp_server.pl script, it
>
> >
> > > seems
> > > to stall and not do anything when i put in another url path into
> > the
> > > webbrowser and hit enter.
> > >
> > > Example:
> > >
> > >
> > > 1) URL, www.lginsurance.com/signup is accessed
> > > 2) URL, www.lginsurance.com/signup is accessed again by
> > highlighting
> > > the
> > > url on the web browser and hitting "enter"
> > > --> notice that on the terminal screen, the last line is " HTML-
>
> > > >process
> > > " along with the time taken and stalls there
> > >
> > > Is this a problem you guys have?
> > >
> > >
> > >
> > > for production deployment, do many of you run myapp_server.pl or
> > > myapp_fastcgi.pl?
> > >
> > > Any comments please?
> > >
> > >
> > > thank you
> > >
> > >
> > > K. akimoto
> > >
> > >
> > >
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/
>
>
>




_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


diment at gmail

Apr 9, 2009, 7:59 PM

Post #11 of 19 (2202 views)
Permalink
Re: Application stallling problem [In reply to]

Show us your template.


On 10/04/2009, at 11:22 AM, kakimoto [at] tpg wrote:

> hello , everyone :)
>
> good morning. Happy eAster!
>
> any more ideas?
>
> thank you
>
>
> Quoting kakimoto [at] tpg:
>
>> Hello, Kieren,
>>
>> thank you for your feedback.
>>
>> 1) CGI Template Toolkit plugin - not using it
>>
>> I do not think that I am using the CGI Template Toolkit plugin.
>> I have only been using Template Toolkit as prescribed in the
>> Catalyst
>> tutorials.
>>
>> in my file, /myAppl/lib/myApp/View/HTML.pm, I have the line,
>> "TEMPLATE_EXTENSION => '.tt2'"
>>
>>
>> May I ask on what sort of CGI Template Toolkit plugin are you
>> referring
>> to specifically?
>>
>>
>> 2) Currently having my own ubuntu virtual server to deploy my
>> application.
>>
>>
>> - Any good recommendations?
>> - Would using myapp_server.pl cut for an application which has say
>> 50
>> users logged in at the same time?
>>
>> Please pardon my lack of knowledge for I am only a developer and
>> have
>> little experience in the systems administation and tuning sector.
>>
>> Thank you, all.
>>
>>
>>
>>
>>
>> Quoting Kieren Diment <kieren [at] diment>:
>>
>>> Are you using the CGI Template Toolkit plugin thingy? Don't. This
>>
>>>
>>> will cause your problem as described. If not you've given us
>>> insufficient information
>>>
>>> Fastcgi is easier to setup on shared hosting, and has some
>>> advantages. CATALYST_ENGINE=HTTP::Prefork script/myapp_server.pl
>> is
>>>
>>> pretty simple and can be reverse proxied pretty easily. Install
>>> C::E::HTTP::Prefork from CPAN and give it a shot...
>>>
>>> On 09/04/2009, at 11:14 AM, kakimoto [at] tpg wrote:
>>>
>>>>
>>>> hello
>>>>
>>>> good morning. The page which I access at first doesn't require
>> any
>>>> database request. It's just pretty much a page that's generated
>> by
>>>> template toolkit and that's it.
>>>>
>>>> On the terminal which I am running the myapp_server.pl script, it
>>
>>>
>>>> seems
>>>> to stall and not do anything when i put in another url path into
>>> the
>>>> webbrowser and hit enter.
>>>>
>>>> Example:
>>>>
>>>>
>>>> 1) URL, www.lginsurance.com/signup is accessed
>>>> 2) URL, www.lginsurance.com/signup is accessed again by
>>> highlighting
>>>> the
>>>> url on the web browser and hitting "enter"
>>>> --> notice that on the terminal screen, the last line is " HTML-
>>
>>>>> process
>>>> " along with the time taken and stalls there
>>>>
>>>> Is this a problem you guys have?
>>>>
>>>>
>>>>
>>>> for production deployment, do many of you run myapp_server.pl or
>>>> myapp_fastcgi.pl?
>>>>
>>>> Any comments please?
>>>>
>>>>
>>>> thank you
>>>>
>>>>
>>>> K. akimoto
>>>>
>>>>
>>>>
>>
>> _______________________________________________
>> List: Catalyst [at] lists
>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
>> Searchable archive:
>> http://www.mail-archive.com/catalyst [at] lists/
>> Dev site: http://dev.catalyst.perl.org/
>>
>>
>>
>
>
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

Apr 11, 2009, 7:25 PM

Post #12 of 19 (2171 views)
Permalink
Re: Application stallling problem [In reply to]

Hello, Kieren,

Good morning. Thank you for your help. I have the templates below.
My apologies if it is too long but I really need some pointers here.

The main file, "home/kakimoto/projects/myApp/root/src/index.tt2" decides
if we show the general static content if the user is not logged in. If
the user is logged in, we display the menu.

My problem happens site wide be it the user is logged in or not.
For example, clicking on either of the static page links, "Test Drive",
"About us" and so forth (within 10 seconds) causes the myapp_server.pl
screen in my terminal to not do anything (ie it freezes up).


is it true that myapp_server.pl is not good enough to handle requests
that are established within 10 seconds or less? Or even double clicks?

Thank you for your help. Any comment would be appreaciated.





1) /home/kakimoto/projects/myApp/root/src/index.tt2
=================================================

[% IF Catalyst.user_exists %]
[% PROCESS "menu.tt2" %]
[% ELSE %]
<!--
User has not logged in.
-->

<!--
this section displays the general site page (ie the general contents)
-->
[% END %]


2) /home/kakimoto/projects/myApp/root/src/sidebar.tt2
============================================================

<!-- Sidebar code [start] -->
<a href="/menu" class="sidebar">
Main
</a>
<br/>
<a href="/users/profile" class="sidebar">
Profile
</a>
<br/>
<a href="/users/subscriptions" class="sidebar">
Subscriptions
</a>
<br/>
<a href="/listings/search" class="sidebar">
Search Listings
</a>
<br/>
<a href="/users/reporting" class="sidebar">
Reporting
</a>
<br/>
<a href="/users/export_logs" class="sidebar">
Export logs
</a>
<!-- Sidebar code [end] -->



3) /home/kakimoto/projects/myApp/root/src/agents/create.tt2
============================================================

[% USE Dumper(Indent=1) -%]

[% META title = 'Sign up' %]
<!--
Load agent form [start]
-->

<h1> [% page_title %] </h1>

[% IF signup_success and message %]
<div id="message">
[% message %]
</div>
[% ELSE %]
[%
# target_action =
Catalyst.uri_for('/sign_up');
PROCESS 'agents/form.tt2';
%]
[% END %]
<!--
Load agent form [end]
-->

4) /home/kakimoto/projects/myApp/root/src/agents/form.tt2
============================================================

[% USE Dumper(Indent=1) -%]


[% META title = 'Sign up/agent profile' %]

[% element_requires_validation = '<font
id="requires_validation">*</font>' %]

[% IF message %]
<div id="message">
[% message %]
</div>

[% END %]
<pre>
[% #Dumper.dump(errors) %]
</prE>

[% IF errors %]
<br/>
<div id="error">
<ul>
[% FOREACH error IN errors %]
<li>[% error %]</li>
[% END %]
</ul>
</div>
<hr/>
[% END %]
<form method="post" action="[% target_action
%]" id="agent_profile_form" name="agent_profile_form">
<table border="0" cellspacing="3">
[% IF sign_up %]
<tr>
<td valign="top">
<h2 >Login Credentials</h2>
[% PROCESS
"agents/login_credentials.tt2" %]
</td>
</tr>
[% END %]

<tr>
<td valign="top">
<h2>Company</h2>
[% PROCESS
"agents/company_details.tt2" %]
</td>
</tr>

<tr>
<td valign="top">
<table>
<tr>
<td>
<h2>Address</h2>
[%
billing = 0;
PROCESS
"agents/address.tt2";
%]

<h2>Main
Contact</h2>
[% PROCESS
'agents/main_contact.tt2' %]
</td>
<td valign="top">
<!-- Billing
Address [start] -->
<h2 >Billing
Address</h2>
[% billing = 1 %]
[% PROCESS
'agents/address.tt2' %]
<!-- Billing
Address [end] -->
</td>
</tr>
</table>
</td>
<td
valign="top"
[% IF logos %]
width="*"
[% ELSE %]
width="0"
[% END %]
>
[% PROCESS
"agents/manage_logo.tt2" %]
</td>
</tr>

<!-- TODO: Check on this to make
sure it works -->
[% IF sign_up %]
<tr>
<td
colspan="2"
align="left"
>
[% PROCESS
'agents/terms_and_conditions.tt2' %]
</td>
</td>
[% END %]

<tr>
<td
colspan="2"
align="center"
>
<input type="submit"
name="submit" value="submit"
[% IF sign_up %]
onClick="checkAccepted()"
[% END %]
/>
<input type="reset"
name="reset" value="reset" />
</td>
</tr>
</table>
</form>

5) /home/kakimoto/projects/myApp/root/src/menu.tt2
============================================================


[% META title = 'Menu' %]

[% IF c.check_user_roles('admin') %]
Admin user logged in.
[% ELSE %]

<div id="error">
<ul>
[% FOREACH error IN errors %]
<li>[% error %]</li>
[% END %]
</ul>
</div>

<!-- Main table [start] -->
[% # PROCESS "listings/search.tt2" %]
<!-- TODO : Define listings/search.tt2 -->

<!-- Add new listing [start] -->
[% #PROCESS "listings/add.tt2" %]
<!-- Add new listing [end] -->

<!-- Main table [end] -->
[% #PROCESS "listings/show_first_10.tt2" %]
<!-- TODO : Define template above -->

<table border="0">
<tr>
<td id="sidebar">
<a href="[% Catalyst.uri_for('/listings/create') %]">
<img src="images/menu/c.gif" alt="Create" />
</a>
</td>
<td>
<a href="[% Catalyst.uri_for('/listings/list') %]">
<img src="images/menu/r.gif" alt="Inventory
listing" />
</a>
</td>
</tr>
<tr>
<td id="sidebar">
<a href="[% Catalyst.uri_for('/listings/update') %]">
<img src="images/menu/u.gif" alt="Update" />
</a>
</td>
<td>
<a href="[% Catalyst.uri_for('/listings/delete') %]">
<img src="images/menu/d.gif" alt="Delete" />
</a>
</td>
</tr>
</table>
[% END %]


6) /home/kakimoto/projects/myApp/root/lib/site/header
=====================================================


<!-- BEGIN site/header -->
<h1>
<a href="/"
title="LoadPropertyNow.com.au"><span>LoadPropertyNow.com.au</span></a>
<em>Upload properties the quick &amp;
easy way!</em>
</h1>

<div id="nav">

<!-- topMenu [start] -->
<ul id="topMenu">

[% IF not Catalyst.user_exists and not
Catalyst.namespace.match('^login$') %]
<li><a href="[%
Catalyst.uri_for('/free_trial') %]" class="freeTrial" title="Try us out
for free!"><span>Try us out for free! Free trial for 30 days or first 50
uploads</span></a></li>
<li><a href="[%
Catalyst.uri_for('/login') %]" class="login"
title="Login"><span>Login</span></a></li>
<li><a href="[%
Catalyst.uri_for('/sign_up') %]" class="signUp" title="Sign Up"
><span>Sign Up</span></a></li>
[% ELSE %]
<li><a href="[%
Catalyst.uri_for('/logout') %]" class="login"
title="Logout"><span>Logout</span></a></li>
[% END %]
</ul>

<!-- topMenu [end] -->

<!-- menu [start] -->
<div id="menu">
<ul>

[% IF not Catalyst.user_exists %]
<li><a href="[%
#Catalyst.uri_for('/sign_up') %]" title="Sign Up"
id="navHome"><span>Sign Up</span></a>|</li>
[% ELSE %]
<li><a href="[%
#Catalyst.uri_for('/menu') %]" title="Home"
id="navHome"><span>Home</span></a>|</li>
[% END %]
<li><a href="[%
Catalyst.uri_for('/free_trial') %]" title="Test Drive"
id="navFree"><span>Test Drive</span></a>|</li>
<li><a href="[%
Catalyst.uri_for('/about_us') %]" title="About Us"
id="navAbout"><span>About Us</span></a>|</li>
<li><a href="[%
Catalyst.uri_for('/services') %]" title="Insurance Plans"
id="navServices"><span>Insurance Plans</span></a>|</li>
<li><a href="[%
Catalyst.uri_for('/subscriptions') %]" title="Subscriptions"
id="navSubscriptions"><span>Subscriptions</span></a>|</li>
<li><a href="[%
Catalyst.uri_for('/contact_us') %]" title="Contact Us"
id="navContact"><span>Contact Us</span></a></li>
</ul>
</div>
<!-- menu [end] -->
</div>
<!-- end nav -->

<!-- END site/header -->


7) /home/kakimoto/projects/myApp/root/lib/site/footer
============================================================
<!-- BEGIN site/footer -->
<center>
<ul>
<li>&copy; 2009 lgInsurance pty ltd. All rights reserved |</li>
<li><a href="termsOfUse.html" title="Terms of Use">Terms of Use</a>
|</li>
<li><a href="privacyPolicy.html" title="Privacy Policy">Privacy
Policy</a></li>
</ul>
<ul>

[% IF not Catalyst.user_exists %]
<li><a href="[% #
Catalyst.uri_for('/sign_up') %]" title="Sign Up" id="Home"><span>Sign
Up</span></a>|</li>
[% ELSE %]
<li><a href="[% # Catalyst.uri_for('/menu')
%]" title="Home" id="navHome"><span>Home</span></a>|</li>
[% END %]
<li><a href="test_drive.html" title="Test Drive" >Test Drive</a> |</li>
<li><a href="aboutUs.html" title="About Us">About Us</a> |</li>
<li><a href="ourInsurancePlans.html" title="Insurance
Plans">Insurance Plans</a> |</li>
<li><a href="subscriptions.html"
title="Subscriptions">Subscriptions</a> |</li>
<li><a href="contactUs.html" title="Contact Us">Contact Us</a></li>
</ul>
</center>
<!-- END site/footer -->






8) /home/kakimoto/projects/myApp/root/lib/site/skeleton_wrapper
================================================================


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>[% template.title %]</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" content="Upload your properties the quick and
easy way!" />
<meta name="keywords" content="insurance, now, easy, quick" />
<style type="text/css">
[% PROCESS ttsite.css %]
</style>
<script language="JavaScript" type="text/javascript" src="[%
Catalyst.uri_for('/js/general.js') %]"></script>

</head>

<!-- Skeleton -->

<body id="home">
<!-- container [start] -->
<div id="container">
<div id="header">
[% PROCESS site/header %]
</div>

<!-- body start -->

<div id="body">

[% IF Catalyst.user_exists %]

<!-- body inner [start] -->
<div id="body-inner">

<!-- Sidebar [start] -->
<div id="sidebar">
[% PROCESS sidebar.tt2 %]
</div>
<!-- Sidebar [end] -->

[% END %]

<!-- Content [start] -->
<div id="content">
<span class="message">[% status_msg %]</span>
<span class="error">[% error_msg %]</span>
[% content %]
</div>
<!-- Content [end] -->

[% IF Catalyst.user_exists %]

</div>
<!-- body inner [end] -->

[% END %]

</div>
<!-- body [end] -->

<!-- footer [start] -->
<div id="footer">
[% PROCESS site/footer %]
</div>
<!-- footer [end] -->

</div>
<!-- container [end] -->
</body>
</html>







Quoting Kieren Diment <diment [at] gmail>:

> Show us your template.
>
>
> On 10/04/2009, at 11:22 AM, kakimoto [at] tpg wrote:
>
> > hello , everyone :)
> >
> > good morning. Happy eAster!
> >
> > any more ideas?
> >
> > thank you
> >
> >
> > Quoting kakimoto [at] tpg:
> >
> >> Hello, Kieren,
> >>
> >> thank you for your feedback.
> >>
> >> 1) CGI Template Toolkit plugin - not using it
> >>
> >> I do not think that I am using the CGI Template Toolkit plugin.
> >> I have only been using Template Toolkit as prescribed in the
> >> Catalyst
> >> tutorials.
> >>
> >> in my file, /myAppl/lib/myApp/View/HTML.pm, I have the line,
> >> "TEMPLATE_EXTENSION => '.tt2'"
> >>
> >>
> >> May I ask on what sort of CGI Template Toolkit plugin are you
> >> referring
> >> to specifically?
> >>
> >>
> >> 2) Currently having my own ubuntu virtual server to deploy my
> >> application.
> >>
> >>
> >> - Any good recommendations?
> >> - Would using myapp_server.pl cut for an application which has
> say
> >> 50
> >> users logged in at the same time?
> >>
> >> Please pardon my lack of knowledge for I am only a developer and
> >> have
> >> little experience in the systems administation and tuning sector.
> >>
> >> Thank you, all.
> >>
> >>
> >>
> >>
> >>
> >> Quoting Kieren Diment <kieren [at] diment>:
> >>
> >>> Are you using the CGI Template Toolkit plugin thingy? Don't.
> This
> >>
> >>>
> >>> will cause your problem as described. If not you've given us
> >>> insufficient information
> >>>
> >>> Fastcgi is easier to setup on shared hosting, and has some
> >>> advantages. CATALYST_ENGINE=HTTP::Prefork
> script/myapp_server.pl
> >> is
> >>>
> >>> pretty simple and can be reverse proxied pretty easily. Install
> >>> C::E::HTTP::Prefork from CPAN and give it a shot...
> >>>
> >>> On 09/04/2009, at 11:14 AM, kakimoto [at] tpg wrote:
> >>>
> >>>>
> >>>> hello
> >>>>
> >>>> good morning. The page which I access at first doesn't require
> >> any
> >>>> database request. It's just pretty much a page that's generated
> >> by
> >>>> template toolkit and that's it.
> >>>>
> >>>> On the terminal which I am running the myapp_server.pl script,
> it
> >>
> >>>
> >>>> seems
> >>>> to stall and not do anything when i put in another url path
> into
> >>> the
> >>>> webbrowser and hit enter.
> >>>>
> >>>> Example:
> >>>>
> >>>>
> >>>> 1) URL, www.lginsurance.com/signup is accessed
> >>>> 2) URL, www.lginsurance.com/signup is accessed again by
> >>> highlighting
> >>>> the
> >>>> url on the web browser and hitting "enter"
> >>>> --> notice that on the terminal screen, the last line is "
> HTML-
> >>
> >>>>> process
> >>>> " along with the time taken and stalls there
> >>>>
> >>>> Is this a problem you guys have?
> >>>>
> >>>>
> >>>>
> >>>> for production deployment, do many of you run myapp_server.pl
> or
> >>>> myapp_fastcgi.pl?
> >>>>
> >>>> Any comments please?
> >>>>
> >>>>
> >>>> thank you
> >>>>
> >>>>
> >>>> K. akimoto
> >>>>
> >>>>
> >>>>
> >>
> >> _______________________________________________
> >> List: Catalyst [at] lists
> >> Listinfo:
> http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> >> Searchable archive:
> >> http://www.mail-archive.com/catalyst [at] lists/
> >> Dev site: http://dev.catalyst.perl.org/
> >>
> >>
> >>
> >
> >
> >
> >
> > _______________________________________________
> > List: Catalyst [at] lists
> > Listinfo:
> http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> > Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> > Dev site: http://dev.catalyst.perl.org/
>
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/
>
>
>




_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

May 3, 2009, 5:38 PM

Post #13 of 19 (1996 views)
Permalink
Re: Application stallling problem [In reply to]

hi Kieren and everyone:)

I have sent through my templates in my previous reply.

Could I please have some feedback when you are ready?

Again, thank you everyone for your help ! :)



K. akimoto

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kieren at diment

May 3, 2009, 5:46 PM

Post #14 of 19 (2000 views)
Permalink
Re: Application stallling problem [In reply to]

try running your server under the debugger i.e. script/myapp_server.pl
-d and hit control-c where the application stalls to see where in the
code it's stalling.

On 04/05/2009, at 10:38 AM, kakimoto [at] tpg wrote:

> hi Kieren and everyone:)
>
> I have sent through my templates in my previous reply.
>
> Could I please have some feedback when you are ready?
>
> Again, thank you everyone for your help ! :)
>
>
>
> K. akimoto
>
> _______________________________________________
> List: Catalyst [at] lists
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
> Dev site: http://dev.catalyst.perl.org/



_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

May 3, 2009, 5:53 PM

Post #15 of 19 (1998 views)
Permalink
Re: Application stallling problem [In reply to]

Kieren-
try running your server under the debugger i.e. script/myapp_server.pl
-d and hit control-c where the application stalls to see where in the
code it's stalling.

Hello, Kieren,
Good morning. Strangely I tried it and it seems to be acting right. I
will keep your instructions handy and if I spot the problem again, I
will post to the thread.

Thank you:)

K. akimoto

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


ijw at cack

May 4, 2009, 1:53 AM

Post #16 of 19 (1982 views)
Permalink
Re: Application stallling problem [In reply to]

2009/5/4 <kakimoto [at] tpg>:
> Kieren-
> try running your server under the debugger i.e. script/myapp_server.pl
> -d and hit control-c where the application stalls to see where in the
> code it's stalling.
>
> Hello, Kieren,
>  Good morning. Strangely I tried it and it seems to be acting right.

Another possibility is the one that was mentioned a few days ago - on
Catalyst 5.7, the test server does a reverse DNS lookup on clients.
With a decent DNS setup this should be quick enough for test purposes
(though you'd never do it in production) but with various test setups,
particularly virtual machines in my experience, a broken DNS setup can
take a long time to decide that the lookup won't work.

Assuming your client address is 1.2.3.4, how long does 'nslookup
1.2.3.4' take on your server?

Catalyst 5.8 doesn't do this. If you're using 5.8 that's not the problem.

--
Ian.

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

May 4, 2009, 2:32 AM

Post #17 of 19 (1974 views)
Permalink
Re: Application stallling problem [In reply to]

> Catalyst 5.8 doesn't do this. If you're using 5.8 that's not the
> problem.


hello, Ian,

thanks for the reply. I have upgraded my catalyst runtime to version
5.8. I will report to the mailing list if this problem comes up again.

So far, I have observed it once (with catalyst runtime 5.8). Alas, I
was't running myapp_server.pl with the "-d" flag (as per Kieren Diment's
recommendation) to see where the problem brewed from.

thank you

K. akimoto

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

May 6, 2009, 8:12 AM

Post #18 of 19 (1953 views)
Permalink
Re: Application stallling problem [In reply to]

hi, all,

I found that the problem again.


1) I ran my application with DBIC_TRACE=1
ie "DBIC_TRACE=1 myapp_server.pl -d "

2) When I clicked on a link which shows me all the subscription listings
belonging to an agent, the application loads the page just fine (and
quickly)

3) I then moved on to click a link within the page which shows the
details of a given listing.

4 ) Application stalls

What I have done:
- Opened up new terminal
- Ran "top"
- Observed that my server process is taking up 60% of the CPU
- load average is 1.31, 1.00, 0.81
- Here's what the catalyst debug screen looks like:


---------------------------------+--------------------------------------'

You can connect to your server at
http://lginsurance.com.au.hosting24.com.au:3000
SELECT me.id, me.user_id, me.subscriptions_id, me.name,
me.rea_agent_code, me.domain_agent_code, me.logo_file, me.logo_url,
me.active_from, me.active_to, me.comments, me.created_by, me.updated_by,
me.created_on, me.updated_on, subscription.id, subscription.type,
subscription.name, subscription.price, subscription.currency,
subscription.property_type_access, subscription.comments,
subscription.created_by, subscription.updated_by,
subscription.created_on, subscription.updated_on FROM user_subscriptions
me JOIN subscriptions subscription ON subscription.id =
me.subscriptions_id WHERE ( user_id = ? ): 'test_agent'
SELECT COUNT( * ) FROM user_subscriptions me JOIN subscriptions
subscription ON subscription.id = me.subscriptions_id WHERE ( user_id =
? ): 'test_agent'
[debug] "GET" request for "users/subscriptions/" from "123.243.50.59"
[debug] Found sessionid "b061fb50b6799c8e1deb11ecd8f5011b6fc99244" in cookie
[debug] Restored session "b061fb50b6799c8e1deb11ecd8f5011b6fc99244"
[debug] Path is "users/subscriptions"
[debug] Root.pm -> Begin
[debug] Root.pm -> auto and path is users/subscriptions/
[debug] Rendering template "agents/subscriptions/list.tt2"
[debug] Applying HTML page layout wrappers to agents/subscriptions/list.tt2


Any ideas?

I suspected postgres to be the culprit but it's not taking any
percentage of load on the CPU (from reference to 'top').




_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/


kakimoto at tpg

May 7, 2009, 2:04 AM

Post #19 of 19 (1941 views)
Permalink
Re: Application stallling problem [In reply to]

hi, all,

I have something to share. With my application stalling like crazy
last night, I
1) ran my application with DBIC_TRACE=1
> ie "DBIC_TRACE=1 myapp_server.pl -d " and got all the sqls used. Fed
them into postgresql's EXPLAIN command and found that the queries were
not costly to the database at all.
2) looked at how my templates are being used to generate output

I ran the application again and performed the same tests as I had
before this morning.

My catayst application ran quickly without even causing a dint to the
server's average loads! CPU usage was very low.
I rang up my Virtual Machine hosting company's tech support. I checked
with them to see if there were other machines that were running on high
loads last night and they figured so.


Throughout the day, I have been testing my app and it's been behaving.
I suppose this is one of those problems I m faced by running a virtual
machine shared with many other virtual machines..
all good.

Thank you to everyone who has pitched in to help me.

K. akimoto.





Quoting kakimoto [at] tpg:

> hi, all,
>
> I found that the problem again.
>
>
> 1) I ran my application with DBIC_TRACE=1
> ie "DBIC_TRACE=1 myapp_server.pl -d "
>
> 2) When I clicked on a link which shows me all the subscription
> listings
> belonging to an agent, the application loads the page just fine (and
> quickly)
>
> 3) I then moved on to click a link within the page which shows the
> details of a given listing.
>
> 4 ) Application stalls
>

_______________________________________________
List: Catalyst [at] lists
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst [at] lists/
Dev site: http://dev.catalyst.perl.org/

Catalyst users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.