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:
: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’, ‘' id/TITLE:#',^J'Subject/TITLE:Subject',^J'Status',^J'QueueName',^J'OwnerName',^J'Priority',^J'NEWLINE',^J'',^J'Requestors',^J'CreatedRelative',^J'ToldRelative',^J'LastUpdatedRelative',^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^J'Subject/TITLE:Subject',^J'Status',^J'QueueName',^J'OwnerName',^J'Priority',^J'NEWLINE',^J'',^J'Requestors',^J'CreatedRelative',^J'ToldRelative',^J'LastUpdatedRelative',^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^J'Subject/TITLE:Subject',^J'Status',^J'QueueName',^J'OwnerName',^J'Priority',^J'NEWLINE',^J'',^J'Requestors',^J'CreatedRelative',^J'ToldRelative',^J'LastUpdatedRelative',^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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’, ‘' id/TITLE:#',^M^J'Subject/TITLE:Subject',^M^J'Status',^M^J'QueueName',^M^J'OwnerName',^M^J'Priority',^M^J'NEWLINE',^M^J'',^M^J'Requestors',^M^J'CreatedRelative',^M^J'ToldRelative',^M^J'LastUpdatedRelative',^M^J'TimeLeft'’,
‘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