[rt-users] problem with searchbuilder

Wed, 27 Jun 2007 07:03:02 -0700 

hi everyone!

we have a problem with searchbuilder.

CONFIG:
we use
RHEL 4
rt 3.6.3
mysql 4.1.20-2.RHEL4.1
 DBD::mysql v2.9004;
 DBI v1.40;
 DBIx::SearchBuilder v1.48;
 DBIx::SearchBuilder::Union v0;
 DBIx::SearchBuilder::Unique v0.01;


PROBLEM
This search
Queue = 'general' AND Content LIKE 'firefox' AND Content LIKE
'netinstall' AND Created > '2007-1-1'

creates this error
System error
error: Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at 

more details at the end of this mail.



any hints are appreciated!

bjoern

Björn Schulz                    DESY - Deutsches Elektronen-Synchrotron
IT Support                          Member of the Helmholtz Association
D-22603 Hamburg                        Notkestrasse 85  / 22607 Hamburg



System error
error: Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 1045. 
context:        
...     
1041:
1042: # here we could check if there is recursion in joins by checking that all joins 
1043:   # are processed
1044:   if ( my @not_processed = grep !$processed{ $_ }, keys %$joins ) {
1045:   die "Unsatisfied dependency chain in joins @not_processed";
1046:   }
1047:   return $join_clause;
1048:   }
1049:   
...
code stack: /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:1045 
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm:353
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm:462
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm:293
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm:1432
/opt/rt3/lib/RT/Tickets_Overlay.pm:2515
/opt/rt3/share/html/Search/Results.html:144
/opt/rt3/share/html/Search/Build.html:777
/opt/rt3/share/html/autohandler:292

raw error:
Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 1045.
Trace begun at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 1045.^J') called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 1045 DBIx::SearchBuilder::Handle::_BuildJoins('RT::Handle=HASH(0xa7a9f18)', 'RT::Tickets=HASH(0xba66a78)') called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 353 DBIx::SearchBuilder::_BuildJoins('RT::Tickets=HASH(0xba66a78)') called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 462 DBIx::SearchBuilder::BuildSelectCountQuery('RT::Tickets=HASH(0xba66a78)') called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 293 DBIx::SearchBuilder::_DoCount('RT::Tickets=HASH(0xba66a78)', 1) called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 1432 DBIx::SearchBuilder::CountAll('RT::Tickets=HASH(0xba66a78)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2515 RT::Tickets::CountAll('RT::Tickets=HASH(0xba66a78)') called at /opt/rt3/share/html/Search/Results.html line 144 HTML::Mason::Commands::__ANON__('Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^J\'__Status__\',^J\'__QueueName__\',^J\'__OwnerName__\',^J\'__Priority__\',^J\'__NEWLINE__\',^J\'\',^J\'<small>__Requestors__</small>\',^J\'<small>__CreatedRelative__</small>\',^J\'<small>__ToldRelative__</small>\',^J\'<small>__LastUpdatedRelative__</small>\',^J\'<small>__TimeLeft__</small>\'', 'Order', 'ASC|ASC|ASC|ASC', 'OrderBy', 'id|||', 'Rows', 0) called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb1c2c14)', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^J\'__Status__\',^J\'__QueueName__\',^J\'__OwnerName__\',^J\'__Priority__\',^J\'__NEWLINE__\',^J\'\',^J\'<small>__Requestors__</small>\',^J\'<small>__CreatedRelative__</small>\',^J\'<small>__ToldRelative__</small>\',^J\'<small>__LastUpdatedRelative__</small>\',^J\'<small>__TimeLeft__</small>\'', 'Order', 'ASC|ASC|ASC|ASC', 'OrderBy', 'id|||', 'Rows', 0) called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1251 eval {...} at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1245 HTML::Mason::Request::comp(undef, undef, 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^J\'__Status__\',^J\'__QueueName__\',^J\'__OwnerName__\',^J\'__Priority__\',^J\'__NEWLINE__\',^J\'\',^J\'<small>__Requestors__</small>\',^J\'<small>__CreatedRelative__</small>\',^J\'<small>__ToldRelative__</small>\',^J\'<small>__LastUpdatedRelative__</small>\',^J\'<small>__TimeLeft__</small>\'', 'Order', 'ASC|ASC|ASC|ASC', 'OrderBy', 'id|||', 'Rows', 0) called at /opt/rt3/share/html/Search/Build.html line 777 HTML::Mason::Commands::__ANON__('ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xb9402c4)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xbaf1540)', 'Description', '') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb3ac21c)', 'ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xb9402c4)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xbaf1540)', 'Description', '') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1251 eval {...} at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1245 HTML::Mason::Request::comp(undef, undef, undef, 'ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xb9402c4)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xbaf1540)', 'Description', '') called at /opt/rt3/share/html/autohandler line 292 HTML::Mason::Commands::__ANON__('ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xbac9edc)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xb917420)', 'Description', '') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xaaa676c)', 'ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xbac9edc)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xb917420)', 'Description', '') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1246 eval {...} at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 1245 HTML::Mason::Request::comp(undef, undef, undef, 'ActorOp', '=', 'AndOr', 'AND', 'WatcherOp', 'LIKE', 'ValueOfActor', '', 'Format', '\' <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#\',^M^J\'<b><a href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject\',^M^J\'__Status__\',^M^J\'__QueueName__\',^M^J\'__OwnerName__\',^M^J\'__Priority__\',^M^J\'__NEWLINE__\',^M^J\'\',^M^J\'<small>__Requestors__</small>\',^M^J\'<small>__CreatedRelative__</small>\',^M^J\'<small>__ToldRelative__</small>\',^M^J\'<small>__LastUpdatedRelative__</small>\',^M^J\'<small>__TimeLeft__</small>\'', 'LinksOp', '=', 'PriorityOp', '<', 'SearchId', 'new', 'idOp', '<', 'Size', '', 'ActorField', 'Owner', 'PriorityField', 'Priority', 'LinksField', 'HasMember', 'ValueOfStatus', '', 'Owner', 'RT::User-21230', 'ValueOfLinks', '', 'ValueOfPriority', '', 'ValueOfTime-TimeUnits', 'minutes', 'Query', ' Queue = \'general\' AND Content LIKE \'firefox\' AND Content LIKE \'netinstall\' AND Created > \'2007-1-1\'', 'ValueOfTime', '', 'DoSearch', 'Add and Search', 'AttachmentOp', 'LIKE', 'ValueOfDate', '', 'TimeOp', '<', 'QueueOp', '=', 'Title', '', 'Order', 'ARRAY(0xbac9edc)', 'AttachmentField', 'Subject', 'Face', '', 'Link', 'None', 'StatusOp', '=', 'DateField', 'Created', 'TimeField', 'TimeWorked', 'RowsPerPage', 0, 'ValueOfQueue', '', 'ValueOfid', '', 'LoadSavedSearch', '', 'WatcherField', 'Requestor.EmailAddress', 'ValueOfWatcher', '', 'ValueOfAttachment', '', 'DateOp', '<', 'OrderBy', 'ARRAY(0xb917420)', 'Description', '') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 459 eval {...} at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 459 eval {...} at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/Request.pm line 411 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb926644)') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb926644)') called at /usr/lib/perl5/vendor_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x948662c)', 'Apache2::RequestRec=SCALAR(0xbb4193c)') called at /opt/rt3/bin/webmux.pl line 123 
eval {...} at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler('Apache2::RequestRec=SCALAR(0xbb4193c)') called at -e line 0 
eval {...} at -e line 0
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com

Reply via email to