[rt-users] problem with searchbuilder
Bjoern Schulz
bjoern.schulz at desy.de
Wed Jun 27 10:02:08 EDT 2007
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
More information about the rt-users
mailing list