[Catalyst] Frequent crashes with DBI using test server?

[Knut-Olav Hoven]

I have had similar problems using DBIC directly when running the dev server.

I don't know why that happens, but maybe the perl HTTP server does not clean 
up everything it should after each request, or something (something, [...])

It runs on FastCGI with no problems at all (10 or 20 procs, don't remember).


On Wednesday 11 June 2008 01:21:16 Kirby Krueger wrote:
> Forgive me if this is a newbie question.  I have a suspicion I'm
> missing something obvious, but I can't find the answer with a google
> search.
>
> I'm developing my first Catalyst application, and it's going fairly
> well.  For now, I'm using the test server (ie, scripts/
> myapp_server.pl), which is great for where I'm at now.
>
> The problem is: I'm connecting to a local MySQL database in my model
> over a socket.  Frequently but intermittently, this seems to get
> corrupted.  I get messages like:
>
> DBIx::Class::ResultSet::next(): DBI Connection failed: Can't connect
> to local MySQL server through socket 'ple::Cookie' (2) at  ...
>
> (Refresh changes the nonsense after the word socket, the 'ple::Cookie'
> in this case.)
>
> If I restart the server, and hit refresh, it works fine.  Sometimes I
> can get a dozen or so requests through, sometimes only one or two.
>
> I've got an abstraction layer in front of my model - not using
> DBIx::Class directly as the model, but it does use a perl library that
> ultimately does use DBIx::Class.  I don't see these kinds of problems
> from my unit tests directly against the libraries that the model uses.
>
> Is this a known issue with the standalone server?  Or am I not doing
> something I ought with the database layer?
>
> Thanks for any pointers,
>
> Kirby
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/



-- 
Knut-Olav Hoven
Systemutvikler               mob: +47 986 71 700
Linpro AS                    http://www.linpro.no/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
Url : http://lists.scsys.co.uk/pipermail/catalyst/attachments/20080611/dc945af9/attachment.pgp