Re: Catalyst (app_)server.pl hangs a lot

[Your Mother]

The dev server is generally just for testing but it’s also pretty robust and some devs have deployed it to production.

The only times I’ve seen the sort of thing you describe is when doing wonky fork/self-referential code. A potential help would be to add a -k to the command line in case things are just blocking somewhere. You could also start with perl -MCarp::Always script/myapp_server.pl ....

Barring success with that, and not being a perl -d kinda dev unless backed into a corner, I tend to remove new code to get back to a functioning version and then progressively return things till I discover the fail point. I have hardly had to do this since becoming more serious about writing tests for individual pieces before trying to mix them. Skipping test writing is a false economy and there is a wealth of test appliances for Perl and Catalyst.

[miguelele]

Finally: the server hangs after five minutes of inactivity when the database is in a remote host.

A) Recreating the database in the same server that is running Catalyst -> OK

B) Installing Catalyst in the server server that is running the database -> OK

I can live with that by now because "B" will be the production environment. But surely I will come back, because using a remote database seems to be a good option to consider.

Thank you for your interest

[miguelele]

Wowo, I have returned to my computer and the last page I tested has finally rendered!!. Las action took 968.4581s. So the server script does not hangs. It is heavily delayed!!.

I wonder how I can monitor the action even deeper

[Anonymous Monk]

I wonder how I can monitor the action even deeper

Finding such a huge delay should be easy, just look for one of sleep, DBI...execute, or for(1..1_000_000){ DoSomethingExpensive(); }

This being a Catalyst app, look in your model

[miguelele]

Well, it seems like a time out of some kind. About FIVE minutes

I can repeat the same action (reload the page) as many or as few times as I want. Then I leave it for a while, about five minutes, and when I reload the page (even from another computer) I get the weird big delay again.

Can you imagine what can have such five minutes timeout? DBI configuration or something?

[miguelele]

I tried to run the server with keepalive... and it works fine!! With all the queries and models running.

I do not understand. Is this the "correct" way?

While developing I am the only user, and I have even stripped the app down to just one query without success if I turn off keepalive again.