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