[rt-users] Quick Searches are empty

Bryon Baker bbaker at copesan.com
Tue Apr 1 10:32:33 EDT 2014


Before reboot I look at memory and cpu utilization which looked fine.  After the reboot all is well.



At this point I am looking for help identifying what happened.  Are there some setting I need to change?


Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  *  262-783-6261 ext. 2296
bbaker at copesan.com<mailto:cstephan at copesan.com>
www.copesan.com<http://www.copesan.com/>
"Servicing North America with Local Care"

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Bryon Baker
Sent: Tuesday, April 01, 2014 9:18 AM
To: rt-users at lists.bestpractical.com; qa at bestpractical.com
Subject: [rt-users] Quick Searches are empty


Good morning need help quickly please



Came in this morning and all the Quick search are not showing any data.

[cid:image001.png at 01CF4D8D.4E2CA570]



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 at 01CF4D8D.4E2CA570]



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::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Report/Tickets.pm line 563
        RT::Report::Tickets::_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::Tickets::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::Runner::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

bbaker at copesan.com<mailto:bbaker at copesan.com>

www.copesan.com<http://www.copesan.com>

"Servicing North America with Local Care"


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/f1f29718/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 13303 bytes
Desc: image001.png
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/f1f29718/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 13116 bytes
Desc: image002.png
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/f1f29718/attachment-0001.png>


More information about the rt-users mailing list