[rt-users] RT gets jealous of my weekend vacation, goes bonkers

[Beachey, Kendric]

I left for a relaxing weekend at the lake with all things RT working just
fine.  I came back this morning and found that most superficial parts of
WebRT were OK (the front page, the admin console, the statistics) but the
Search and direct viewing of any ticket were broken.  I stopped and started
apache and mysql a few times, and that didn't help.  I don't find any errors
in the log files.  Here is the error message I am getting in the browser:


-------------------------------------------------
Mason error
error in file:   /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm
 
line 522:  Can't call method "dbh" on an undefined value
context:  
... 
518:  #if we're explicitly told not to to quote the value or
519:  # we're doing an IS or IS NOT (null), don't quote the operator.
520: 
521: 
522:  if ($args{'QUOTEVALUE'} && $args{'OPERATOR'} !~ /IS/) {
523:  $args{'VALUE'} = $self->_Handle->dbh->quote($args{'VALUE'});
524:  }
525:  }
526: 
... 
component stack:   /Ticket/Elements/Tabs [standard]
//Ticket/Display.html [standard]
//autohandler [standard]
code stack:   /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:522
/usr/local/rt2/lib/RT/EasySearch.pm:95
/usr/local/rt2/lib/RT/Tickets.pm:1150
/usr/local/rt2/lib/RT/Tickets.pm:993
/usr/local/rt2/lib/RT/Tickets.pm:980
/usr/local/rt2/WebRT/data/obj/STANDARD/Ticket/Elements/Tabs:105
/usr/local/rt2/WebRT/data/obj/STANDARD//Ticket/Display.html:148
/usr/local/rt2/WebRT/data/obj/STANDARD//autohandler:69


raw error:  

error while executing /Ticket/Elements/Tabs [standard]:
Can't call method "dbh" on an undefined value at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 522,  line 121.
HTML::Mason::Interp::__ANON__('Can\'t call method "dbh" on an undefined
value at /usr/lib/perl5...') called at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 522
DBIx::SearchBuilder::Limit('RT::Tickets=HASH(0x904e8e0)', 'VALUE', 6,
'FIELD', 'Queue', 'ENTRYAGGREGATOR', 'OR', 'OPERATOR', ...) called at
/usr/local/rt2/lib/RT/EasySearch.pm line 95
RT::EasySearch::Limit('RT::Tickets=HASH(0x904e8e0)', 'FIELD', 'Queue',
'ENTRYAGGREGATOR', 'OR', 'OPERATOR', '=', 'VALUE', ...) called at
/usr/local/rt2/lib/RT/Tickets.pm line 1150
RT::Tickets::_ProcessRestrictions('RT::Tickets=HASH(0x904e8e0)') called at
/usr/local/rt2/lib/RT/Tickets.pm line 993
RT::Tickets::Next('RT::Tickets=HASH(0x904e8e0)') called at
/usr/local/rt2/lib/RT/Tickets.pm line 980
RT::Tickets::ItemsArrayRef('RT::Tickets=HASH(0x904e8e0)') called at
/usr/local/rt2/WebRT/data/obj/STANDARD/Ticket/Elements/Tabs line 105
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x907b3bc)',
'current_tab', 'Ticket/Display.html?id=25') called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x907c14
c)', 'Ticket', 'RT::Ticket=HASH(0x907b3bc)', 'current_tab',
'Ticket/Display.html?id=25') called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653
eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm
line 653
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x90748
40)', '/Ticket/Elements/Tabs', 'Ticket', 'RT::Ticket=HASH(0x907b3bc)',
'current_tab', 'Ticket/Display.html?id=25') called at
/usr/local/rt2/WebRT/data/obj/STANDARD//Ticket/Display.html line 148
HTML::Mason::Commands::__ANON__('id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x904f9d
c)', 'id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653
eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm
line 653
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x90748
40)', 'HTML::Mason::Component::FileBased=HASH(0x904f9dc)', 'id', 25) called
at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 316
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x
9074840)') called at /usr/local/rt2/WebRT/data/obj/STANDARD//autohandler
line 69
HTML::Mason::Commands::__ANON__('id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8f4588
c)', 'id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653
eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm
line 653
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x90748
40)', 'HASH(0x90749a8)',
'HTML::Mason::Component::FileBased=HASH(0x8f4588c)', 'id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 159
eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm
line 159
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x90748
40)', '//Ticket/Display.html', 'id', 25) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 914
HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HAS
H(0x83fa6f0)', 'Apache=SCALAR(0x8edae08)',
'HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', undef) called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 560
eval {...} called at
/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 560
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
0x83fa6f0)', 'Apache=SCALAR(0x8edae08)') called at
/usr/local/rt2/bin/webmux.pl line 165
RT::Mason::handler('Apache=SCALAR(0x8edae08)') called at /dev/null line 0
eval {...} called at /dev/null line 0
-------------------------------------------------


I haven't monkeyed with the RT code in a while, so it seems pretty weird
that this would crop up now.

I am still able to display tickets without any trouble on the command line.

I am running RT 2.0.11pre (basically 2.0.12 with a different version
designation) against MySQL 3.23.47 on a Red Hat 7.1 box.  This arrangement
has worked smoothly for quite a few months.

Anyone got any ideas?

--
Kendric Beachey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20020805/6d81e3e9/attachment.htm>