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