Good morning need help quickly please
Came in this morning and all the Quick search are not showing any data.
[cid:image001.png@01CF4D8A.F8E33860]
If I click anywhere in the quick search box the searches are working meaning I get a list of tickets.
This is also happening on all of the Quick searches I have defined.
I also look in the var directory and found a lot of directories see below.
[cid:image002.png@01CF4D8B.1F6B43B0]
This is just a small list.
Here is a part of the RT log after a restart which does not look normal.
[26474] [Tue Apr 1 14:11:25 2014] [warning]: RT::Handle=HASH(0x8a1a460) couldn’t execute the query 'SELECT main.Status AS status, main.Queue AS queue, COUNT(DISTINCT main.id) AS id FROM Tickets main WHERE (main.IsMerged IS NULL) AND (main.Status != ‘deleted’) AND (main.Type = ‘ticket’) AND ( ( main.Status = ‘new’ OR main.Status = ‘assigned’ OR main.Status = ‘opened’ OR main.Status = ‘evaluation’ OR main.Status = ‘closed’ ) AND ( main.Queue = ‘15’ OR main.Queue = ‘16’ OR main.Queue = ‘21’ OR main.Queue = ‘17’ OR main.Queue = ‘10’ OR main.Queue = ‘18’ OR main.Queue = ‘19’ OR main.Queue = ‘25’ OR main.Queue = ‘20’ OR main.Queue = ‘12’ OR main.Queue = ‘4’ OR main.Queue = ‘14’ OR main.Queue = ‘13’ ) ) GROUP BY main.Status, main.Queue ’ at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder/Handle.pm line 602.
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x8a1a460)’, ‘SELECT main.Status AS status, main.Queue AS queue, COUNT(DIST…’) called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 990
RT::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /opt/rt4/sbin/…/lib/RT/Tickets.pm line 2374
RT::_DoSearch(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /opt/rt4/sbin/…/lib/RT/Report/Tickets.pm line 563
RT::Report::_DoSearch(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /opt/rt4/sbin/…/lib/RT/Report/Tickets.pm line 603
RT::Report::Next(‘RT::Report::Tickets=HASH(0x8acc040)’) called at /opt/rt4/share/html/Elements/QueueSummaryByLifecycle line 157
HTML::Mason::Commands::ANON(‘queue_filter’, ‘CODE(0x8f91d90)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8fed3c8)’, ‘queue_filter’, ‘CODE(0x8f91d90)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, ‘queue_filter’, ‘CODE(0x8f91d90)’) called at /opt/rt4/share/html/Elements/Quicksearch line 58
HTML::Mason::Commands::ANON() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383
HTML::Mason::Request::content(‘RT::Interface::Web::Request=HASH(0x8920180)’) called at /opt/rt4/share/html/Widgets/TitleBox line 56
HTML::Mason::Commands::ANON(‘title’, ‘Quick search’, ‘bodyclass’, ‘’, ‘titleright’, ‘Edit’, ‘titleright_href’, ‘/rt/Prefs/Quicksearch.html’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8e56f88)’, ‘title’, ‘Quick search’, ‘bodyclass’, ‘’, ‘titleright’, ‘Edit’, ‘titleright_href’, ‘/rt/Prefs/Quicksearch.html’, …) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Quick search’, ‘bodyclass’, ‘’, ‘titleright’, ‘Edit’, …) called at /opt/rt4/share/html/Elements/Quicksearch line 58
HTML::Mason::Commands::ANON() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x1af9bc8)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/Elements/MyRT line 97
HTML::Mason::Commands::ANON(‘HASH(0x8ac8308)’) called at /opt/rt4/share/html/Elements/MyRT line 58
HTML::Mason::Commands::ANON() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8dddd90)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/index.html line 78
HTML::Mason::Commands::ANON() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8a3b558)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 680
RT::Interface::Web::ShowRequestedPage(‘HASH(0x8b1ab60)’) called at /opt/rt4/sbin/…/lib/RT/Interface/Web.pm line 368
RT::Interface::Web::HandleRequest(‘HASH(0x8b1ab60)’) called at /opt/rt4/share/html/autohandler line 53
HTML::Mason::Commands::ANON() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8a5b958)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1300
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec(‘RT::Interface::Web::Request=HASH(0x8920180)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(‘RT::Interface::Web::Request=HASH(0x8920180)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59
eval {…} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(‘HTML::Mason::PSGIHandler::Streamy=HASH(0x89a7018)’, ‘HASH(0x8a6fcc8)’, ‘HASH(0x8a6fd40)’) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::ANON(‘CODE(0x8ac9c20)’) called at /opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm line 307
RT::Interface::Web::Handler::ANON(‘CODE(0x8ac9c20)’) called at /usr/lib/perl5/site_perl/5.16.2/Plack/Util.pm line 301
Plack::Util::ANON(‘CODE(0x8bc0648)’) called at /usr/lib/perl5/site_perl/5.16.2/Plack/Handler/FCGI.pm line 136
Plack::Handler::FCGI::run(‘Plack::Handler::FCGI=HASH(0x89d5e70)’, ‘CODE(0x89c7868)’) called at /usr/lib/perl5/site_perl/5.16.2/Plack/Loader.pm line 84
Plack::Loader::run(‘Plack::Loader=HASH(0x89c7550)’, ‘Plack::Handler::FCGI=HASH(0x89d5e70)’) called at /usr/lib/perl5/site_perl/5.16.2/Plack/Runner.pm line 277
Plack::run(‘RT::PlackRunner=HASH(0x85ff8b0)’) called at /opt/rt4/sbin/…/lib/RT/PlackRunner.pm line 141
eval {…} called at /opt/rt4/sbin/…/lib/RT/PlackRunner.pm line 141
I have not rebooted the server yet but at this point that is next.
Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726 * 262-783-6261 ext. 2296
“Servicing North America with Local Care”