RT3.0.3 - Ticket search - System Error

Hi,

I’ve been having fun with the Ticket search screen and have found more
and more occurrances of errors.

1 - Doing a search for all tickets (by showing where priority<1000) says
"Found 10 tickets" at the top, but only lists seven.

2 - Doing a ticket search with multiple criteria which results in no
matches found generates a “System Error” as below (which was caused with
queue=general, status!=rejected, status!=resolved):

Don’t get me wrong, I’m not moaning. From what I’ve seen, RT is probably
the best thing since sliced bread and I’m very happy with what’s there -
it’s just a few niggles I have at the moment.

The system is: RT 3.0.3, Apache 2.0.40, mod_perl2 & Sendmail on RedHat 9

Many thanks,

Nick Barnes.

System error

error: Assertion flags == 0 failed: file “Storable.xs”, line 2336 at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.

Stack:
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line
21

context: …
187: # whether they should generate a full stack trace (confess() and
cluck())
188: # or simply report the caller’s package (croak() and carp()),
respectively.
189: # confess() and croak() die, carp() and cluck() warn.
190:
191: sub croak { die shortmess @_ }
192: sub confess { die longmess @_ }
193: sub carp { warn shortmess @_ }
194: sub cluck { warn longmess @_ }
195:

code stack: /usr/lib/perl5/5.8.0/Carp.pm:191
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/logcroak.al):66
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):283
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050

raw error

Assertion flags == 0 failed: file "Storable.xs", line 2336 at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.

Stack:
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270]

[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line
21

Trace begun at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Exceptions.pm
line 128
HTML::Mason::Exceptions::rethrow_exception(‘Assertion flags == 0 failed:
file “Storable.xs”, line 2336 at …/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/_freeze.al) line
282.^J^JStack:^J […/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line
21^J’) called at /usr/lib/perl5/5.8.0/Carp.pm line 191
Carp::croak(‘Assertion flags == 0 failed: file “Storable.xs”,
line 2336 at …/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.^J^JStack:^J
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050],’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/logcroak.al) line 66
Storable::logcroak(‘Assertion flags == 0 failed: file
"Storable.xs", line 2336 at …/…/lib/Storable.pm (autosplit
into …/…/lib/auto/Storable/_freeze.al) line 282.^J^JStack:^J
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050],’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 283
Storable::_freeze(‘CODE(0x93d7f9c)’, ‘HASH(0x93c22dc)’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al) line 270
Storable::nfreeze(‘HASH(0x93c22dc)’) called at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line
21
Apache::Session::Serialize::Storable::serialize(‘Apache::Session::MySQL=
HASH(0x8818868)’) called at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm line 507
Apache::Session::save(‘Apache::Session::MySQL=HASH(0x8818868)’) called
at /usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm line 462
Apache::Session::DESTROY(‘Apache::Session::MySQL=HASH(0x8818868)’)
called at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1050
eval {…}(‘Apache::Session::MySQL=HASH(0x8818868)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1050
HTML::Mason::Request::comp(undef, undef, undef, ‘DateType’, ‘Created’,
‘OwnerOp’, ‘=’, ‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1,
‘ValueOfOwner’, ‘’, ‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’,
‘PriorityOp’, ‘<’, ‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’,
‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’,
‘LIKE’, ‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’,
‘rejected’, ‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’,
’’, ‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’,
‘AttachmentFieldOp’, ‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’,
‘ValueOfDate’, ‘’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 331
eval {…}(undef, undef, undef, ‘DateType’, ‘Created’, ‘OwnerOp’, ‘=’,
‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1, ‘ValueOfOwner’,
’’, ‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’, ‘PriorityOp’, ‘<’,
‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’, ‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’,
‘LIKE’, ‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’,
‘rejected’, ‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’,
’’, ‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’,
‘AttachmentFieldOp’, ‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’,
‘ValueOfDate’, ‘’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 331
eval {…}(undef, undef, undef, ‘DateType’, ‘Created’, ‘OwnerOp’, ‘=’,
‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1, ‘ValueOfOwner’,
’’, ‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’, ‘PriorityOp’, ‘<’,
‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’, ‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’,
‘LIKE’, ‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’,
‘rejected’, ‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’,
’’, ‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’,
‘AttachmentFieldOp’, ‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’,
‘ValueOfDate’, ‘’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 290
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x9
6207cc)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134
eval {…}(‘HTML::Mason::Request::ApacheHandler=HASH(0x96207cc)’) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheH
andler=HASH(0x96207cc)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 792
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=H
ASH(0x85379a4)’, ‘Apache::RequestRec=SCALAR(0x85366b4)’) called at
/opt/rt3/bin/webmux.pl line 118
RT::Mason::handler(‘Apache::RequestRec=SCALAR(0x85366b4)’) called at -e
line 0
eval {…}(‘Apache::RequestRec=SCALAR(0x85366b4)’) called at -e line 0
OK
The server encountered an internal error or misconfiguration and was
unable to complete your request.

Please contact the server administrator, root@localhost and inform them
of the time the error occurred, and anything you might have done that
may have caused the error.

More information about this error may be available in the server error
log.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.

Apache/2.0.40 Server at ********* Port 80

This one time, at band camp, Nick Barnes wrote:

System error

error: Assertion flags == 0 failed: file “Storable.xs”, line 2336 at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.

I’m seeing this after a restart of apache, but reload the page and it’s
gone. Seems like it’s just having problems with sessions when RT is
restarted but the user is still logged in.

jaq@spacepants.org http://spacepants.org/jaq.gpg

Nick–

I’m new to RT, so don’t take my comments as the “final
word”, but my experience is that RT counts all tickets
found, even deleted tickets, in the ticket count. But
it only DISPLAYS the non-deleted tickets.

Have you deleted some tickets? It’s my understanding
they never actually get purged from the database (the
archives hold some talk about ways to actually do so)
but rather sit in a deleted state.

-j-----Original Message-----
From: Nick Barnes [mailto:nick@bcn-it.co.uk]
Sent: Tuesday, July 01, 2003 5:49 AM
To: rt-users@lists.fsck.com
Subject: [rt-users] RT3.0.3 - Ticket search - System Error

Hi,

I’ve been having fun with the Ticket search screen and have found more and
more occurrances of errors.

1 - Doing a search for all tickets (by showing where priority<1000) says
"Found 10 tickets" at the top, but only lists seven.

2 - Doing a ticket search with multiple criteria which results in no matches
found generates a “System Error” as below (which was caused with
queue=general, status!=rejected, status!=resolved):

Don’t get me wrong, I’m not moaning. From what I’ve seen, RT is probably the
best thing since sliced bread and I’m very happy with what’s there - it’s
just a few niggles I have at the moment.

The system is: RT 3.0.3, Apache 2.0.40, mod_perl2 & Sendmail on RedHat 9

Many thanks,

Nick Barnes.

System error

error: Assertion flags == 0 failed: file “Storable.xs”, line 2336 at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.

Stack:
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line 21

context: …
187: # whether they should generate a full stack trace (confess() and
cluck())
188: # or simply report the caller’s package (croak() and carp()),
respectively.
189: # confess() and croak() die, carp() and cluck() warn.
190:
191: sub croak { die shortmess @_ }
192: sub confess { die longmess @_ }
193: sub carp { warn shortmess @_ }
194: sub cluck { warn longmess @_ }
195:

code stack: /usr/lib/perl5/5.8.0/Carp.pm:191 …/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/logcroak.al):66
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):283
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050

raw error

Assertion flags == 0 failed: file "Storable.xs", line 2336 at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.

Stack:
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al):270]

[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line 21

Trace begun at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Exceptions.pm
line 128
HTML::Mason::Exceptions::rethrow_exception(‘Assertion flags == 0 failed:
file “Storable.xs”, line 2336 at …/…/lib/Storable.pm (autosplit
into …/…/lib/auto/Storable/_freeze.al) line 282.^J^JStack:^J
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050], at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line
21^J’) called at /usr/lib/perl5/5.8.0/Carp.pm line 191
Carp::croak(‘Assertion flags == 0 failed: file “Storable.xs”, line
2336 at …/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 282.^J^JStack:^J
[…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050],’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/logcroak.al) line 66 Storable::logcroak(‘Assertion
flags == 0 failed: file “Storable.xs”, line 2336 at
…/…/lib/Storable.pm (autosplit into …/…/lib/auto/Storable/_freeze.al)
line 282.^J^JStack:^J […/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al):282]^J […/…/lib/Storable.pm
(autosplit into …/…/lib/auto/Storable/nfreeze.al):270]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm:21]
^J [/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:507]^J
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
[/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:1050],’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/_freeze.al) line 283
Storable::_freeze(‘CODE(0x93d7f9c)’, ‘HASH(0x93c22dc)’) called at
…/…/lib/Storable.pm (autosplit into
…/…/lib/auto/Storable/nfreeze.al) line 270
Storable::nfreeze(‘HASH(0x93c22dc)’) called at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Serialize/Storable.pm line 21
Apache::Session::Serialize::Storable::serialize(‘Apache::Session::MySQL=
HASH(0x8818868)’) called at /usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm
line 507
Apache::Session::save(‘Apache::Session::MySQL=HASH(0x8818868)’) called at
/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm line 462
Apache::Session::DESTROY(‘Apache::Session::MySQL=HASH(0x8818868)’)
called at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1050
eval {…}(‘Apache::Session::MySQL=HASH(0x8818868)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1050
HTML::Mason::Request::comp(undef, undef, undef, ‘DateType’, ‘Created’,
‘OwnerOp’, ‘=’, ‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1,
‘ValueOfOwner’, ‘’, ‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’,
‘PriorityOp’, ‘<’, ‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’,
‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’, ‘LIKE’,
‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’, ‘rejected’,
‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’, ‘’,
‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’, ‘AttachmentFieldOp’,
‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’, ‘ValueOfDate’, ‘’) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 331 eval
{…}(undef, undef, undef, ‘DateType’, ‘Created’, ‘OwnerOp’, ‘=’,
‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1, ‘ValueOfOwner’, ‘’,
‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’, ‘PriorityOp’, ‘<’,
‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’, ‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’, ‘LIKE’,
‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’, ‘rejected’,
‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’, ‘’,
‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’, ‘AttachmentFieldOp’,
‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’, ‘ValueOfDate’, ‘’) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 331 eval
{…}(undef, undef, undef, ‘DateType’, ‘Created’, ‘OwnerOp’, ‘=’,
‘CompileRestriction’, 1, ‘RefreshSearchInterval’, -1, ‘ValueOfOwner’, ‘’,
‘QueueOp’, ‘=’, ‘ValueOfAttachmentField’, ‘’, ‘PriorityOp’, ‘<’,
‘AttachmentField’, ‘Content’, ‘Action’, ‘Search’, ‘Bookmark’,
‘FrT%3B%402%7C%254%7C%242%7C11%241%7C9%258%7C%2411%7CDESCRIPTION%245%7CF
IELD%248%7COPERATOR%245%7CVALUE%2418%7CStatus%20%21%3D%20resolved%246%7C
Status%242%7C%21%3D%248%7Cresolved%258%7C%2411%7CDESCRIPTION%245%7CFIELD
%248%7COPERATOR%245%7CVALUE%2415%7CQueue%20%3D%20General%245%7CQueue%241
%7C%3D%247%7CGeneral%242%7C12’, ‘ValueOfRequestor’, ‘’, ‘SubjectOp’, ‘LIKE’,
‘StatusOp’, ‘!=’, ‘TicketsSortBy’, ‘id’, ‘ValueOfStatus’, ‘rejected’,
‘RowsPerPage’, 50, ‘ValueOfQueue’, ‘’, ‘ValueOfPriority’, ‘’,
‘ValueOfSubject’, ‘’, ‘TicketsSortOrder’, ‘ASC’, ‘AttachmentFieldOp’,
‘LIKE’, ‘RequestorOp’, ‘LIKE’, ‘DateOp’, ‘<’, ‘ValueOfDate’, ‘’) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 290
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x9
6207cc)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134 eval
{…}(‘HTML::Mason::Request::ApacheHandler=HASH(0x96207cc)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheH
andler=HASH(0x96207cc)’) called at
/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 792
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=H
ASH(0x85379a4)’, ‘Apache::RequestRec=SCALAR(0x85366b4)’) called at
/opt/rt3/bin/webmux.pl line 118
RT::Mason::handler(‘Apache::RequestRec=SCALAR(0x85366b4)’) called at -e line
0 eval {…}(‘Apache::RequestRec=SCALAR(0x85366b4)’) called at -e line 0 OK
The server encountered an internal error or misconfiguration and was unable
to complete your request.

Please contact the server administrator, root@localhost and inform them of
the time the error occurred, and anything you might have done that may have
caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an
ErrorDocument to handle the request.

Apache/2.0.40 Server at ********* Port 80

rt-users mailing list
rt-users@lists.fsck.com http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Jason Diegmueller

I’m new to RT, so don’t take my comments as the “final
word”, but my experience is that RT counts all tickets
found, even deleted tickets, in the ticket count. But
it only DISPLAYS the non-deleted tickets.

Hmmmm.

OK, I deleted a ticket to test what’s happening and it now says “Found 9
tickets” and displays six!

If I change the criteria to “queue=complaints, queue=general” (the only
two queues I’ve got), it then says “Found 10 tickets” and still only
displays six.

Doing a search for “status=deleted” says “Found 4 tickets” and lists
none.

Either I’m seriously misunderstanding what it’s meant to do (which I’m
quite prepared to accept), or something kooky’s going on!

Cheers,

Nick.

Hi,

I’ve been having fun with the Ticket search screen and have found more
and more occurrances of errors.

1 - Doing a search for all tickets (by showing where priority<1000) says
"Found 10 tickets" at the top, but only lists seven.

The “count” is a quick count performed directly by the database. It
doesn’t take RT’s access control into account. The tickets you you see
are those you have access to see. Changing this would be a really big
performance hit. Changing the wording might be good though.
“Found about 10 tickets”?

2 - Doing a ticket search with multiple criteria which results in no
matches found generates a “System Error” as below (which was caused with
queue=general, status!=rejected, status!=resolved):

I think that’s actually a bug in the version of Storable.pm that RedHat
ships with 9.0.

Don’t get me wrong, I’m not moaning. From what I’ve seen, RT is probably
the best thing since sliced bread and I’m very happy with what’s there -
it’s just a few niggles I have at the moment.

The system is: RT 3.0.3, Apache 2.0.40, mod_perl2 & Sendmail on RedHat 9

Many thanks,

Nick Barnes.

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

Jesse Vincent:

The “count” is a quick count performed directly by the database. It
doesn’t take RT’s access control into account. The tickets you you see
are those you have access to see. Changing this would be a really big
performance hit. Changing the wording might be good though.
“Found about 10 tickets”?

Ah.

I think I prefer ‘approximately’ or ‘approx.’.

But logged in as the user ‘root’ (who has all privs. under the sun)
should enable me to see all the tickets, shouldn’t it?

2 - Doing a ticket search with multiple criteria which results in no
matches found generates a “System Error” as below (which
was caused with queue=general, status!=rejected, status!=resolved):
I think that’s actually a bug in the version of Storable.pm
that RedHat ships with 9.0.

Hmmm. Installed Storable-2.07, restarted everything and I’m still seeing
the same problem. Is there anything else I need to update as well?

Cheers,

Nick.

Jesse Vincent:

The “count” is a quick count performed directly by the database. It
doesn’t take RT’s access control into account. The tickets you you see
are those you have access to see. Changing this would be a really big
performance hit. Changing the wording might be good though.
“Found about 10 tickets”?

Ah.

I think I prefer ‘approximately’ or ‘approx.’.

nod

But logged in as the user ‘root’ (who has all privs. under the sun)
should enable me to see all the tickets, shouldn’t it?

To see what’s going on behind the scenes, turn on mysql’s query logging
and execute the SELECT main.* from Tickets… query and see what results
its leaving out.

2 - Doing a ticket search with multiple criteria which results in no
matches found generates a “System Error” as below (which
was caused with queue=general, status!=rejected, status!=resolved):
I think that’s actually a bug in the version of Storable.pm
that RedHat ships with 9.0.

Hmmm. Installed Storable-2.07, restarted everything and I’m still seeing
the same problem. Is there anything else I need to update as well?

Dunno. But I’ve only heard of the problem on redhat 9.

Cheers,

Nick.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

http://www.bestpractical.com/rt – Trouble Ticketing. Free.