Hi, I have experienced this same problem after pushing new mason code to production. This has never happened in development, the only difference is that there is only one or two users in development while production has approximately 200. It would strike with out warning, i.e. working fine for a few hours and then tanking.
Restarting Oracle/Apache would not fix the problem. Now I blow away the entire cache after pushing files to production. All is well. Apache 2.0.53, Mason 1.28, mod_perl 1.999_21 -Bill On Mon, 2006-02-27 at 15:20 -0500, Mike M. wrote: > Hi, > > We're using apache 1.3.33, mod_perl 1.29, HTML::Mason 1.26 (we cannot > upgrade because of a strange mason method bug with our app in all masons > above 1.26), DBI 1.48, DBD::Oracle 1.16. We have mason caching turned > on in production. > > We keep running into a weird problem. Every couple weeks or so, our app > starts opening connections like mad to the oracle database and never > seems to let them go. This ends up tanking our database and app. > > Today, we think we may have finally figured out what was happening after > months of looking through our queries to see if there was some sort of > performance problem. We noticed that even though our app had slowed > down to a crawl and the database cpu was high, everything still worked > except for two pages. Every time we hit one of those two pages, it'd > just tank the database and hang. Even after restarting the database and > web server they would still tank. So, we came up with the random > thought, why not delete the cached version of these files and see what > happens. Lo and behold, the problem went away! We're totally stumped. > How could a cached version of a mason page cause our database to tank? > I mean, we killed the apache processes that could've had them open and > that didn't solve the problem. It was only when we actually removed the > mason cache files that everything went back to normal; and, we didn't > even restart the web server after removing these files. > > Any ideas? > > Thanks, > -Mike M. > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Mason-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mason-users ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Mason-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mason-users
