[rt-users] Very troubling error

Mathew Snyder theillien at yahoo.com
Tue Jan 22 11:25:25 EST 2008 

In addition to all of this we are not longer getting any emails into the
database.  Postfix and procmail are handling things as they have been but
nothing is being entered into the DB

Keep up with me and what I'm up to: http://theillien.blogspot.com


Ruslan Zakirov wrote:
> Upgrade to the latest version of DBIx::SearchBuilder module.
> 
> On Jan 22, 2008 1:46 AM, Mathew <theillien at yahoo.com> wrote:
>> We recently started getting this error which seems to be preventing incoming email from making it into the database:
>>
>> [Mon Jan 21 22:42:30 2008] [warning]: RT::Handle=HASH(0xadd9538) couldn't execute the query 'SELECT DISTINCT main.* FROM ((Tickets main  JOIN Groups Groups_1  ON ((Groups_1.Domain = 'RT::Ticket-Role')) AND ( (Groups_1.Type = 'Requestor')) AND (  Groups_1.Instance = main.id))  LEFT JOIN CachedGroupMembers CachedGroupMembers_2  ON ( CachedGroupMembers_2.GroupId = Groups_1.id) AND ( (CachedGroupMembers_2.MemberId = Users_3.id))) , Users Users_3  WHERE ((Users_3.id = '60292')) AND ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (CachedGroupMembers_2.id IS NOT NULL) )  AND  ( (main.Status = 'open') OR (main.Status = 'new') ) )  ORDER BY main.Priority DESC  LIMIT 10' at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
>>         DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xadd9538)', 'SELECT DISTINCT main.* FROM ((Tickets main  JOIN Groups Group...') called at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 231
>>         DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0xb59cf20)') called at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 491
>>         DBIx::SearchBuilder::Next('RT::Tickets=HASH(0xb59cf20)') called at /usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2670
>>         RT::Tickets::Next('RT::Tickets=HASH(0xb59cf20)') called at /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 74
>>         HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315
>>         HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') called at /usr/local/rt3/share/html/Widgets/TitleBox line 51
>>         HTML::Mason::Commands::__ANON__('title_href', 'undef', 'title', 'More about cluther at xybernaut.com') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb33a0dc)', 'title_href', 'undef', 'title', 'More about cluther at company.com') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title_href', 'undef', 'title', 'More about cluther at company.com') called at /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 83
>>         HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xb59d67c)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb595ae4)', 'Ticket', 'RT::Ticket=HASH(0xb59d67c)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'Ticket', 'RT::Ticket=HASH(0xb59d67c)') called at /usr/local/rt3/share/html/Ticket/Elements/ShowSummary line 72
>>         HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', 'RT::Attachments=HASH(0xb578d7c)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb581864)', 'Ticket', 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', 'RT::Attachments=HASH(0xb578d7c)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'Ticket', 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', 'RT::Attachments=HASH(0xb578d7c)') called at /usr/local/rt3/share/html/Ticket/Display.html line 58
>>         HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315
>>         HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') called at /usr/local/rt3/share/html/Widgets/TitleBox line 51
>>         HTML::Mason::Commands::__ANON__('title', 'Ticket metadata') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb33a0dc)', 'title', 'Ticket metadata') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title', 'Ticket metadata') called at /usr/local/rt3/share/html/Ticket/Display.html line 59
>>         HTML::Mason::Commands::__ANON__('id', 112208) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb5823b0)', 'id', 112208) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 112208) called at /usr/local/rt3/share/html/autohandler line 291
>>         HTML::Mason::Commands::__ANON__('id', 112208) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>         HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb12686c)', 'id', 112208) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1246
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>>         HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 112208) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
>>         eval {...} called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 411
>>         HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 168
>>         HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826
>>         HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xa41827c)', 'Apache2::RequestRec=SCALAR(0xb58b3dc)') called at /usr/local/rt3/bin/webmux.pl line 125
>>         eval {...} called at /usr/local/rt3/bin/webmux.pl line 125
>>         RT::Mason::handler('Apache2::RequestRec=SCALAR(0xb58b3dc)') called at -e line 0
>>         eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
>>
>>
>> Emails are coming into our system but not being handled properly.  Can anyone shed some light on this?
>>
>> --
>> Keep up with my goings on at http://theillien.blogspot.com
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
> 
> 
>

More information about the rt-users mailing list