Hi,

We've been using TT/mod_perl/Apache::Session/MySQL
successfully for several months. This weekend we've
starting having serious trouble and so far I've been
unable to locate it. I should mention that we also use
third-party software on our servers to validate and
protect content that uses Tomcat and servlets. 

We did a MySQL upgrade (on a separate box) and within
20 minutes of restarting Apache and Tomcat after the
upgrade, we starting seeing httpd processes with large
CPU usage. First one at 97%, the two at 45% each, etc.
I've also noted some new TT errors in the Apache error
logs (see below). 

First, I'm trying to determine if this is a TT issue
(I recall seeing heavy CPU usage when template comiled
in the past, but nothing like this). If it weren't for
the errors, I wouldn't suspect TT.

Second, what is the best way to track these processes?
We've used strace, and can see where it goes into an
infinite loop on 'brk', but I'm not really sure what
I'm seeing. We've downgraded MySQL and everything
should be back to the way it was, but no luck and we
get a 50 load with in 5-10 minutes now.

I know this is a TT list, but my guess that this is
MySQL related, but I've got to elimnate TT as a
possiblity. Any Apache::Session::MySQL gotchas?


--
[Sun Dec 15 21:05:15 2002] [error] [client
66.196.72.84] File does not exist:
/usr/local/apache/htdocs/temp.html
compiled template :
/var/ttcache/usr/local/upuzzles/lib/uc_adtag.txt did
not return a true value at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Provider.pm
line 511.

       
Template::Provider::_fetch_path('Template::Provider=HASH(0x86de978)',
'uc_adtag.txt') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Provider.pm
line 121
       
Template::Provider::fetch('Template::Provider=HASH(0x86de978)',
'uc_adtag.txt') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Context.pm
line 129
       
Template::Context::template('Template::Context=HASH(0x86de7a4)',
'uc_adtag.txt') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Context.pm
line 262
       
Template::Context::process('Template::Context=HASH(0x86de7a4)',
'uc_adtag.txt', 'HASH(0x87e74b4)') called at (eval
145) line 59
        eval {...} called at (eval 145) line 7
       
Template::Document::__ANON__('Template::Context=HASH(0x86de7a4)')
called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Document.pm
line 142
        eval {...} called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Document.pm
line 140
       
Template::Document::process('Template::Document=HASH(0x87e4a04)',
'Template::Context=HASH(0x86de7a4)') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Context.pm
line 345
        eval {...} called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Context.pm
line 337
       
Template::Context::include('Template::Context=HASH(0x86de7a4)',
'footer_default.txt') called at (eval 138) line 22
        eval {...} called at (eval 138) line 7
       
Template::Document::__ANON__('Template::Context=HASH(0x86de7a4)')
called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Document.pm
line 142
        eval {...} called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Document.pm
line 140
       
Template::Document::process('Template::Document=HASH(0x87faeb0)',
'Template::Context=HASH(0x86de7a4)') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Context.pm
line 282
       
Template::Context::process('Template::Context=HASH(0x86de7a4)',
'Template::Document=HASH(0x87faeb0)') called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Service.pm
line 90
        eval {...} called at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template/Service.pm
line 88
       
Template::Service::process('Template::Service=HASH(0x86dd598)',
'nyp/free/about_gift.html', 'HASH(0x873f228)') called
at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Template.pm
line 59
        Template::process('Template=HASH(0x86dd3f4)',
'nyp/free/about_gift.html', 'HASH(0x873f228)') called
at
/usr/local/apache/lib/perl/UClick/UPuzzles/UPuzzles.pm
line 460
       
UClick::UPuzzles::UPuzzles::handler('Apache=SCALAR(0x86dd2d4)')
called at /dev/null line 0
        eval {...} called at /dev/null line 0


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

_______________________________________________
templates mailing list
[EMAIL PROTECTED]
http://lists.ourshack.com/mailman/listinfo/templates

Reply via email to