<div dir="ltr"><div><div><div><div>I should explain more:<br></div></div><br></div>there are two queries each one in its own sub, the first one being called through a straightforward <br>[% PROCESS <a href="http://tablets.tt">tablets.tt</a> %] which populates some elements like drop down select menus,sliders etc<br><br></div>When the user makes a choice the second query is fired through an Ajax call:<br><div>$.ajax({<br> url: '/query2',<br> type: "POST",<br> <br> data: AllData(1)}).success(function(data){<br> $("#contentx").append(data);<br> }); <br><br></div><div>which populates a #contentx div with the results of the query.<br><br>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<br>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.<br><br></div><div>DBD:mysql 4.031<br></div><div>DBI 1.633<br></div><div>Dancer2 0.158000<br></div><div>Ubuntu 14.04 x86_64 x86_64 x86_64 GNU/Linux<br><br><br><br></div><div><br></div><div> <br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Apr 26, 2015 at 12:56 PM, Nikos Vaggalis <span dir="ltr"><<a href="mailto:nikos.vaggalis@gmail.com" target="_blank">nikos.vaggalis@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I'm building a site and it's all fine and well except when randomly getting part of the page (without any css,html)<br>essentially like a semi-half blank page and ,sometimes again, getting a "Reload the page to get source for:" <br>from the GET request using Firebug. Firebug's Net panels shows only the initial GET request but not the subsequent ones<br>to the other resources, like the CSS file, images,Javascripts etc<br>When that happens I get the following in the DBI trace log :<br><br>"<br><-- dbd_st_finish<br>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/<a href="http://mysql.pm" target="_blank">mysql.pm</a> line 867 via at /home/starman/Foo/bin/../lib/MySite/Model.pm line 219<br> <- 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<br> <> DESTROY(DBI::st=HASH(0x3fcfc60)) ignored for outer handle (inner DBI::st=HASH(0x3fcfac8) has ref cnt 1)<br> -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x3fcfac8)~INNER)<br> <- 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<br> DESTROY (dbih_clearcom) (sth 0x3fcfac8, com 0x41e4d70, imp DBD::mysql::st):<br> FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn<br> PARENT DBI::db=HASH(0x3d23dc0)<br> KIDS 0 (0 Active)<br> NUM_OF_FIELDS 38<br> NUM_OF_PARAMS 0<br> dbih_clearcom 0x3fcfac8 (com 0x41e4d70, type 3) done.<br><br> <> DESTROY(DBI::db=HASH(0x3d18b00)) ignored for outer handle (inner DBI::db=HASH(0x3d23dc0) has ref cnt 1)<br> -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x3d23dc0)~INNER)<br>imp_dbh->pmysql: 42d7440<br> <- 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<br> DESTROY (dbih_clearcom) (dbh 0x3d23dc0, com 0x418e4e0, imp DBD::mysql::db):<br> FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn AutoCommit<br> PARENT DBI::dr=HASH(0x3c85940)<br> KIDS 0 (0 Active)<br> IMP_DATA HASH(0x3d23478)<br> dbih_clearcom 0x3d23dc0 (com 0x418e4e0, type 2) done.<br>"<br><br>The setup is Dancer,Starman,Mysql on Digital Ocean<br><br>Any help deeply appreciated, thanks!<br> <br></div>
</blockquote></div><br></div>