[dancer-users] random web page breakages

[Nikos Vaggalis]

I should explain more:

there are two queries each one in its own sub, the first one being called
through a straightforward
[% PROCESS tablets.tt %] which populates some elements like drop down
select menus,sliders etc

When the user makes a choice the second query is fired through an Ajax call:
$.ajax({
            url: '/query2',
            type: "POST",

            data: AllData(1)}).success(function(data){
                                $("#contentx").append(data);
                              });

which populates a #contentx div with the results of the query.

Now,when in the same session, the error does not occur no matter how much I
stress it. When opening another 4-5 sessions,or doing a couple of reloads
of the same session, the DBI error comes up
and I get the effect of the first query being run as the elements are still
populated, but then there is nothing else:no css,scripts,and the rest of
the html code . Is that indicating a global DBI handle that is reused and
cleaned up at some time,having to do with Starman's preforking? The thing
is that in my Model I initialize the database and statement handles within
the subs scope and not globally.

DBD:mysql 4.031
DBI 1.633
Dancer2 0.158000
Ubuntu  14.04 x86_64 x86_64 x86_64 GNU/Linux






On Sun, Apr 26, 2015 at 12:56 PM, Nikos Vaggalis <nikos.vaggalis at gmail.com>
wrote:

> I'm building a site and it's all fine and well except when randomly
> getting part of the page (without any css,html)
> essentially like a semi-half blank page and ,sometimes again, getting a
> "Reload the page to get source for:"
> from the GET request using Firebug. Firebug's Net panels shows only the
> initial GET request but not the subsequent ones
> to the other resources, like the CSS file, images,Javascripts etc
> When that happens I get the following in the DBI trace log :
>
> "
> <-- dbd_st_finish
> 1   <- fetch= ( undef ) [1 items] row1 at
> /home/starman/perl5/perlbrew/perls/perl-5.18.1/lib/site_perl/5.18.1/x86_64-linux/DBD/
> mysql.pm line 867 via  at /home/starman/Foo/bin/../lib/MySite/Model.pm
> line 219
>     <- fetchrow_hashref= ( undef ) [1 items] row1 at
> /home/starman/Foo/bin/../lib/MySite/Model.pm line 219 via  at
> /home/starman/Foo/bin/../lib/Foo.pm line 34
>     <> DESTROY(DBI::st=HASH(0x3fcfc60)) ignored for outer handle (inner
> DBI::st=HASH(0x3fcfac8) has ref cnt 1)
>     -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x3fcfac8)~INNER)
>     <- DESTROY= ( undef ) [1 items] at /home/starman/Foo/bin/../lib/Foo.pm
> line 34 via  at /home/starman/Foo/bin/../lib/Foo.pm line 34
>     DESTROY (dbih_clearcom) (sth 0x3fcfac8, com 0x41e4d70, imp
> DBD::mysql::st):
>        FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn
>        PARENT DBI::db=HASH(0x3d23dc0)
>        KIDS 0 (0 Active)
>        NUM_OF_FIELDS 38
>        NUM_OF_PARAMS 0
>     dbih_clearcom 0x3fcfac8 (com 0x41e4d70, type 3) done.
>
>     <> DESTROY(DBI::db=HASH(0x3d18b00)) ignored for outer handle (inner
> DBI::db=HASH(0x3d23dc0) has ref cnt 1)
>     -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x3d23dc0)~INNER)
> imp_dbh->pmysql: 42d7440
>     <- DESTROY= ( undef ) [1 items] at /home/starman/Foo/bin/../lib/Foo.pm
> line 34 via  at /home/starman/Foo/bin/../lib/Foo.pm line 34
>     DESTROY (dbih_clearcom) (dbh 0x3d23dc0, com 0x418e4e0, imp
> DBD::mysql::db):
>        FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn
> AutoCommit
>        PARENT DBI::dr=HASH(0x3c85940)
>        KIDS 0 (0 Active)
>        IMP_DATA HASH(0x3d23478)
>     dbih_clearcom 0x3d23dc0 (com 0x418e4e0, type 2) done.
> "
>
> The setup is Dancer,Starman,Mysql on Digital Ocean
>
> Any help deeply appreciated, thanks!
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.preshweb.co.uk/pipermail/dancer-users/attachments/20150426/c169cb1f/attachment.html>