[rt-users] problem with searchbuilder

Ruslan Zakirov ruz at bestpractical.com
Wed Jun 27 10:25:33 EDT 2007


The problem's been fixed in 3.6.4rc2 or as workaround you can
downgrade to SearchBuilder 1.45

On 6/27/07, Bjoern Schulz <bjoern.schulz at desy.de> wrote:
> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.


More information about the rt-users mailing list