[rt-users] Ticket Errors

Mathew Snyder theillien at yahoo.com
Fri Feb 9 01:37:51 EST 2007


sweet.  Thanks Ruslan.  I'll have to print all of this out for future use
because I KNOW it will come up again... se la vie

Thanks again.

Ruslan Zakirov wrote:
> Ok, I've got all info I needed. Thanks.
> 
> Now you can delete these transactions and get rid of those errors.
> 
> If you're using mysql 4.1 and greater then you can use the following
> queries:
> DELETE txn FROM Transactions txn LEFT JOIN Principals p ON (
> txn.NewValue = p.id ) WHERE txn.Type = 'AddWatcher' AND p.id IS NULL;
> DELETE txn FROM Transactions txn LEFT JOIN Principals p ON (
> txn.OldValue = p.id ) WHERE txn.Type = 'DelWatcher' AND p.id IS NULL;
> 
> 
> On 2/9/07, Mathew Snyder <theillien at yahoo.com> wrote:
>> The results of each query are attached as .txt files.
>>
>>
>> Ruslan Zakirov wrote:
>> > I'm terribly sorry bu here is more correct queries:
>> >
>> > SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
>> > txn.ReferenceType, txn.NewReference, t.id tid FROM Tickets t JOIN
>> > Transactions txn ON txn.Type = 'AddWatcher' AND txn.ObjectType =
>> > 'RT::Ticket' AND txn.ObjectId = t.id LEFT JOIN Principals p ON p.id =
>> > txn.NewValue WHERE p.id IS NULL AND t.id = XXX;
>> >
>> > and
>> >
>> > SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
>> > txn.ReferenceType, txn.NewReference, txn.ObjectId tid FROM
>> > Transactions txn LEFT JOIN Principals p ON p.id = txn.NewValue WHERE
>> > txn.Type = 'AddWatcher' AND txn.ObjectType = 'RT::Ticket' AND p.id IS
>> > NULL;
>> >
>> >
>> > On 2/9/07, Ruslan Zakirov <ruslan.zakirov at gmail.com> wrote:
>> >> On 2/9/07, Mathew Snyder <theillien at yahoo.com> wrote:
>> >> > It would appear I removed someone that was added as a CC:
>> >> >
>> >> > +--------+-----------+---------------+--------------+-------+
>> >> > | Name   | Field     | ReferenceType | NewReference | tid   |
>> >> > +--------+-----------+---------------+--------------+-------+
>> >> > | NULL   | Cc        | NULL          |         NULL | 55767 |
>> >> > | rbates | Requestor | NULL          |         NULL | 55767 |
>> >> > +--------+-----------+---------------+--------------+-------+
>> >> >
>> >> > Is it possible to correct this?
>> >> Yes, sure.
>> >> This means that you've deleted a user who was added as Cc watcher to
>> >> ticket 55767. As well this means a bug exists in shredder and I've
>> >> fixed it and released shredder 0.05.
>> >>
>> >> The following query is more informative:
>> >> SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue,
>> txn.ReferenceType,
>> >> txn.NewReference, t.id tid FROM Tickets t JOIN Transactions txn ON
>> >> txn.Type = 'AddWatcher' AND txn.ObjectType = 'RT::Ticket' AND
>> >> txn.ObjectId = t.id LEFT JOIN Users u ON u.id = txn.NewValue WHERE
>> >> u.id IS NULL AND t.id = XXXXX;
>> >>
>> >> This query selects only transactions with problems. txn_id column in
>> >> the result will show you problematic Transactions and NewValue column
>> >> will show you ids of the users that don't exist anymore.
>> >>
>> >> You can safely delete this transactions using the following query:
>> >> DELETE FROM Transactions WHERE id IN (xxx, xxx, xxx,...);
>> >>
>> >> Also, you can select all such transactions from your DB:
>> >> SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue,
>> txn.ReferenceType,
>> >> txn.NewReference, t.id tid FROM Tickets t JOIN Transactions txn ON
>> >> txn.Type = 'AddWatcher' AND txn.ObjectType = 'RT::Ticket' AND
>> >> txn.ObjectId = t.id LEFT JOIN Users u ON u.id = txn.NewValue WHERE
>> >> u.id IS NULL;
>> >>
>> >> If amount of the transactions is too big then I could help you write
>> >> down a delete query that will delete all this txns.
>> >>
>> >>
>> >>
>> >> >
>> >> > Ruslan Zakirov wrote:
>> >> > > Please, run the following SQL query:
>> >> > > SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference,
>> t.id
>> >> > > tid FROM Tickets t JOIN Transactions txn ON txn.Type =
>> 'AddWatcher'
>> >> > > AND txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id LEFT
>> JOIN
>> >> > > Users u ON u.id = txn.NewValue WHERE t.id = XXXXX;
>> >> > >
>> >> > > Where XXXX id of the ticket. Then send me results.
>> >> > >
>> >> > >
>> >> > > On 2/7/07, Mathew Snyder <theillien at yahoo.com> wrote:
>> >> > >> I'd like to add to this.  I've looked at the database and
>> found that
>> >> > >> there are
>> >> > >> 63 transactions attached to this ticket.  There are also no
>> >> > >> transactions for
>> >> > >> which there isn't a user.  I've looked up the names on each user
>> >> id in
>> >> > >> the
>> >> > >> transactions table and found that they correspond to someone that
>> >> > >> would likely
>> >> > >> have had a part in the ticket.
>> >> > >>
>> >> > >> There are as many user id entries as there are transactions. 
>> What I
>> >> > >> mean is,
>> >> > >> there are multiple entries for some ids but all transactions
>> have a
>> >> > >> user id
>> >> > >> attached to it.  This tells me that the transactions aren't
>> >> corrupted
>> >> > >> by a
>> >> > >> missing user that possibly got Shredded out of the database.
>> >> > >>
>> >> > >> As I've said before, this isn't the first time we've seen this so
>> >> I'm
>> >> > >> beginning
>> >> > >> to think this is a bug of some sort.
>> >> > >>
>> >> > >> The full error follows.
>> >> > >>
>> >> > >> error:          Can't call method "Name" on an undefined value at
>> >> > >> /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm line 690.
>> >> > >> context:
>> >> > >> ...
>> >> > >> 686:    AddWatcher => sub {
>> >> > >> 687:    my $self = shift;
>> >> > >> 688:    my $principal = RT::Principal->new($self->CurrentUser);
>> >> > >> 689:    $principal->Load($self->NewValue);
>> >> > >> 690:    return $self->loc( "[_1] [_2] added", $self->Field,
>> >> > >> $principal->Object->Name);
>> >> > >> 691:    },
>> >> > >> 692:    DelWatcher => sub {
>> >> > >> 693:    my $self = shift;
>> >> > >> 694:    my $principal = RT::Principal->new($self->CurrentUser);
>> >> > >> ...
>> >> > >> code stack:
>> >> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:690
>> >> > >> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:602
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction:54
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory:102
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Display.html:63
>> >> > >> /usr/local/rt-3.6.1/share/html/autohandler:279
>> >> > >>
>> >> > >>
>> >> > >>
>> >> > >> raw error
>> >> > >> Can't call method "Name" on an undefined value at
>> >> > >> /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm line 690.
>> >> > >>
>> >> > >>
>> >> > >> Trace begun at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Exceptions.pm line
>> 129
>> >> > >> HTML::Mason::Exceptions::rethrow_exception('Can\'t call method
>> >> "Name"
>> >> > >> on an
>> >> > >> undefined value at
>> >> /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm
>> >> > >> line
>> >> > >> 690.^J') called at
>> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm
>> >> > >> line 690
>> >> > >> RT::Transaction::__ANON__('RT::Transaction=HASH(0xc706568)')
>> >> called at
>> >> > >> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 602
>> >> > >>
>> RT::Transaction::BriefDescription('RT::Transaction=HASH(0xc706568)')
>> >> > >> called at
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction
>> >> line 54
>> >> > >> HTML::Mason::Commands::__ANON__('Attachments',
>> >> > >> 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)',
>> >> 'ShowHeaders',
>> >> > >> undef,
>> >> > >> 'Collapsed', undef, 'Tickets', undef, 'AttachPath',
>> >> '/Ticket/Attachment',
>> >> > >> 'UpdatePath', '/Ticket/Update.html', 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'Transaction', 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders',
>> >> undef,
>> >> > >> 'Collapsed', undef, 'RowNum', 23, 'ShowTitleBarCommands', 1,
>> >> > >> 'Attachments',
>> >> > >> 'ARRAY(0xc59f11c)', 'AttachmentContent', 'HASH(0xc6a31d4)',
>> >> > >> 'LastTransaction',
>> >> > >> 0) called at
>> >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm
>> >> > >> line 135
>> >> > >>
>> >>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbf6c9a0)',
>>
>> >>
>> >> > >>
>> >> > >> 'Attachments', 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)', 'AttachmentContent',
>> >> > >> 'RT::Attachments=HASH(0xc98d840)', 'ShowHeaders', undef,
>> >> 'Collapsed',
>> >> > >> undef,
>> >> > >> 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
>> 'UpdatePath',
>> >> > >> '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'Transaction',
>> >> > >> 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders', undef,
>> >> 'Collapsed',
>> >> > >> undef,
>> >> > >> 'RowNum', 23, 'ShowTitleBarCommands', 1, 'Attachments',
>> >> > >> 'ARRAY(0xc59f11c)',
>> >> > >> 'AttachmentContent', 'HASH(0xc6a31d4)', 'LastTransaction', 0)
>> >> called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 1245
>> >> > >> HTML::Mason::Request::comp(undef, undef, 'Attachments',
>> >> > >> 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)',
>> >> 'ShowHeaders',
>> >> > >> undef,
>> >> > >> 'Collapsed', undef, 'Tickets', undef, 'AttachPath',
>> >> '/Ticket/Attachment',
>> >> > >> 'UpdatePath', '/Ticket/Update.html', 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'Transaction', 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders',
>> >> undef,
>> >> > >> 'Collapsed', undef, 'RowNum', 23, 'ShowTitleBarCommands', 1,
>> >> > >> 'Attachments',
>> >> > >> 'ARRAY(0xc59f11c)', 'AttachmentContent', 'HASH(0xc6a31d4)',
>> >> > >> 'LastTransaction',
>> >> > >> 0) called at
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory
>> line 102
>> >> > >> HTML::Mason::Commands::__ANON__('Ticket',
>> >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef,
>> >> > >> 'Attachments',
>> >> > >> 'RT::Attachments=HASH(0xc99b5f0)', 'AttachmentContent',
>> >> > >> 'RT::Attachments=HASH(0xc98d840)') called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> >> > >>
>> >>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbf63114)',
>>
>> >>
>> >> > >>
>> >> > >> 'Ticket', 'RT::Ticket=HASH(0xc54ce28)', 'Tickets', undef,
>> >> 'Collapsed',
>> >> > >> undef,
>> >> > >> 'ShowHeaders', undef, 'Attachments',
>> >> 'RT::Attachments=HASH(0xc99b5f0)',
>> >> > >> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)') called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 1245
>> >> > >> HTML::Mason::Request::comp(undef, undef, 'Ticket',
>> >> > >> 'RT::Ticket=HASH(0xc54ce28)',
>> >> > >> 'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef,
>> >> > >> 'Attachments',
>> >> > >> 'RT::Attachments=HASH(0xc99b5f0)', 'AttachmentContent',
>> >> > >> 'RT::Attachments=HASH(0xc98d840)') called at
>> >> > >> /usr/local/rt-3.6.1/share/html/Ticket/Display.html line 63
>> >> > >> HTML::Mason::Commands::__ANON__('id', 55767, 'id', 55767)
>> called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> >> > >>
>> >>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbbdd85c)',
>>
>> >>
>> >> > >>
>> >> > >> 'id', 55767, 'id', 55767) called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 1245
>> >> > >> HTML::Mason::Request::comp(undef, undef, 'id', 55767, 'id',
>> 55767)
>> >> > >> called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 914
>> >> > >>
>> >>
>> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)',
>>
>> >>
>> >> > >>
>> >> > >> 'id', 55767) called at /usr/local/rt-3.6.1/share/html/autohandler
>> >> line
>> >> > >> 279
>> >> > >> HTML::Mason::Commands::__ANON__('id', 55767) called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> >> > >>
>> >>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbb4ad10)',
>>
>> >>
>> >> > >>
>> >> > >> 'id', 55767) called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 1246
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 1245
>> >> > >> HTML::Mason::Request::comp(undef, undef, undef, 'id', 55767)
>> >> called at
>> >> > >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 459
>> >> > >> eval {...} at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> >> > >> line 411
>> >> > >>
>> >>
>> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)')
>>
>> >>
>> >> > >>
>> >> > >> called at
>> >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>> >> > >> line 168
>> >> > >>
>> >>
>> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)')
>>
>> >>
>> >> > >>
>> >> > >> called at
>> >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>> >> > >> line 826
>> >> > >>
>> >>
>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xb0c1e5c)',
>>
>> >>
>> >> > >>
>> >> > >> 'Apache2::RequestRec=SCALAR(0xc98d78c)') called at
>> >> > >> /usr/local/rt-3.6.1/bin/webmux.pl line 123
>> >> > >> eval {...} at /usr/local/rt-3.6.1/bin/webmux.pl line 123
>> >> > >> RT::Mason::handler('Apache2::RequestRec=SCALAR(0xc98d78c)')
>> >> called at
>> >> > >> -e line 0
>> >> > >> eval {...} at -e line 0
>> >> > >>
>> >> > >> If we don't protect the freedom of speech, how will we know
>> who the
>> >> > >> assholes are?
>> >> > >> http://theillien.blogspot.com
>> >> > >>
>> >> > >>
>> >> > >> Mathew Snyder wrote:
>> >> > >> > I think I've asked about this before and I'm fairly certain I
>> >> > >> already know the
>> >> > >> > answer.  However, I'm not certain it should be happening.
>> >> > >> >
>> >> > >> > We keep getting the error "Can't call method "Name" on an
>> >> undefined
>> >> > >> value..."
>> >> > >> > If I recall correctly this is a result of eliminating via
>> >> Shredder a
>> >> > >> user which
>> >> > >> > was at one point attatched to a ticket.  The only problem with
>> >> this
>> >> > >> is that the
>> >> > >> > only users I remove are those that are created when we receive
>> >> spam.
>> >> > >> >
>> >> > >> > So is this the only explanation?  More and more of these
>> tickets
>> >> > >> keep appearing
>> >> > >> > but I can't figure out how all of these users are disappearing.
>> >> > >> >
>> >> > >> > Thanks
>> >> > >> > Mathew
>> >> > >> > _______________________________________________
>> >> > >> >
>> 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
>> >> > >> >
>> >> > >> _______________________________________________
>> >> > >> 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.
>> >>
>> >
>> >
>>
>> mysql> SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field,
>> txn.NewValue,
>>     -> txn.ReferenceType, txn.NewReference, t.id tid FROM Tickets t JOIN
>>     -> Transactions txn ON txn.Type = 'AddWatcher' AND txn.ObjectType =
>>     -> 'RT::Ticket' AND txn.ObjectId = t.id LEFT JOIN Principals p ON
>> p.id =
>>     -> txn.NewValue WHERE p.id IS NULL AND t.id = 55767;
>> +------+---------------+--------+-------+----------+---------------+--------------+-------+
>>
>> | id   | PrincipalType | txn_id | Field | NewValue | ReferenceType |
>> NewReference | tid   |
>> +------+---------------+--------+-------+----------+---------------+--------------+-------+
>>
>> | NULL | NULL          | 377862 | Cc    | 3368     | NULL         
>> |         NULL | 55767 |
>> +------+---------------+--------+-------+----------+---------------+--------------+-------+
>>
>> 1 row in set (0.00 sec)
>> mysql> SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field,
>> txn.NewValue,
>>     -> txn.ReferenceType, txn.NewReference, txn.ObjectId tid FROM
>>     -> Transactions txn LEFT JOIN Principals p ON p.id = txn.NewValue
>> WHERE
>>     -> txn.Type = 'AddWatcher' AND txn.ObjectType = 'RT::Ticket' AND
>> p.id IS
>>     -> NULL;
>> +------+---------------+--------+-----------+----------+---------------+--------------+-------+
>>
>> | id   | PrincipalType | txn_id | Field     | NewValue | ReferenceType
>> | NewReference | tid   |
>> +------+---------------+--------+-----------+----------+---------------+--------------+-------+
>>
>> | NULL | NULL          |    195 | Cc        | 270      | NULL         
>> |         NULL | 15015 |
>> | NULL | NULL          |   2596 | Requestor | 2112     | NULL         
>> |         NULL | 15305 |
>> | NULL | NULL          |   2273 | Requestor | 1872     | NULL         
>> |         NULL | 15387 |
>> | NULL | NULL          |   2274 | Requestor | 1874     | NULL         
>> |         NULL | 15387 |
>> | NULL | NULL          |   4231 | Cc        | 60       | NULL         
>> |         NULL | 15671 |
>> | NULL | NULL          |   4666 | Cc        | 60       | NULL         
>> |         NULL | 15728 |
>> | NULL | NULL          |   4810 | AdminCc   | 2112     | NULL         
>> |         NULL | 15745 |
>> | NULL | NULL          |   6023 | Cc        | 60       | NULL         
>> |         NULL | 15913 |
>> | NULL | NULL          |   6174 | Requestor | 180      | NULL         
>> |         NULL | 15936 |
>> | NULL | NULL          |   6369 | Cc        | 2670     | NULL         
>> |         NULL | 15958 |
>> | NULL | NULL          |   6586 | Requestor | 4756     | NULL         
>> |         NULL | 15994 |
>> | NULL | NULL          |   6589 | Requestor | 2670     | NULL         
>> |         NULL | 15994 |
>> | NULL | NULL          |   6590 | Requestor | 4758     | NULL         
>> |         NULL | 15994 |
>> | NULL | NULL          |   8229 | Requestor | 3980     | NULL         
>> |         NULL | 16195 |
>> | NULL | NULL          |   8470 | Cc        | 5870     | NULL         
>> |         NULL | 16235 |
>> | NULL | NULL          |  10810 | Requestor | 7490     | NULL         
>> |         NULL | 16572 |
>> | NULL | NULL          |  12068 | Cc        | 7706     | NULL         
>> |         NULL | 16770 |
>> | NULL | NULL          |  13686 | Cc        | 60       | NULL         
>> |         NULL | 17039 |
>> | NULL | NULL          |  15175 | AdminCc   | 3368     | NULL         
>> |         NULL | 17299 |
>> | NULL | NULL          |  19283 | Requestor | 2508     | NULL         
>> |         NULL | 17973 |
>> | NULL | NULL          |  27026 | Cc        | 3368     | NULL         
>> |         NULL | 19448 |
>> | NULL | NULL          |  27032 | Cc        | 3368     | NULL         
>> |         NULL | 19463 |
>> | NULL | NULL          |  27022 | Cc        | 3368     | NULL         
>> |         NULL | 19470 |
>> | NULL | NULL          |  28635 | Cc        | 80       | NULL         
>> |         NULL | 19698 |
>> | NULL | NULL          |  30104 | Cc        | 3368     | NULL         
>> |         NULL | 19875 |
>> | NULL | NULL          |  34258 | Cc        | 3368     | NULL         
>> |         NULL | 20689 |
>> | NULL | NULL          |  35064 | Requestor | 29500    | NULL         
>> |         NULL | 20765 |
>> | NULL | NULL          |  37891 | Cc        | 3368     | NULL         
>> |         NULL | 21147 |
>> | NULL | NULL          |  37451 | Cc        | 80       | NULL         
>> |         NULL | 21325 |
>> | NULL | NULL          |  37455 | Cc        | 3368     | NULL         
>> |         NULL | 21325 |
>> | NULL | NULL          |  41186 | Cc        | 3980     | NULL         
>> |         NULL | 22037 |
>> | NULL | NULL          |  46850 | Cc        | 43751    | NULL         
>> |         NULL | 23378 |
>> | NULL | NULL          |  50198 | Cc        | 46908    | NULL         
>> |         NULL | 23926 |
>> | NULL | NULL          |  50744 | Cc        | 3368     | NULL         
>> |         NULL | 24139 |
>> | NULL | NULL          |  50741 | Cc        | 3368     | NULL         
>> |         NULL | 24140 |
>> | NULL | NULL          |  55822 | Cc        | 3368     | NULL         
>> |         NULL | 24528 |
>> | NULL | NULL          |  56273 | Cc        | 3368     | NULL         
>> |         NULL | 24569 |
>> | NULL | NULL          |  54174 | Requestor | 8080     | NULL         
>> |         NULL | 24918 |
>> | NULL | NULL          |  57190 | Cc        | 3368     | NULL         
>> |         NULL | 25636 |
>> | NULL | NULL          |  62220 | Requestor | 29500    | NULL         
>> |         NULL | 25955 |
>> | NULL | NULL          |  60048 | Cc        | 3368     | NULL         
>> |         NULL | 26286 |
>> | NULL | NULL          |  60638 | Cc        | 3368     | NULL         
>> |         NULL | 26421 |
>> | NULL | NULL          |  61226 | Cc        | 3368     | NULL         
>> |         NULL | 26560 |
>> | NULL | NULL          |  63750 | AdminCc   | 3368     | NULL         
>> |         NULL | 27124 |
>> | NULL | NULL          |  67219 | Cc        | 3368     | NULL         
>> |         NULL | 27552 |
>> | NULL | NULL          |  67687 | Cc        | 3368     | NULL         
>> |         NULL | 27913 |
>> | NULL | NULL          |  69689 | Cc        | 56816    | NULL         
>> |         NULL | 28316 |
>> | NULL | NULL          |  69767 | Cc        | 69640    | NULL         
>> |         NULL | 28316 |
>> | NULL | NULL          |  91506 | Cc        | 87643    | NULL         
>> |         NULL | 31135 |
>> | NULL | NULL          |  93739 | Cc        | 70530    | NULL         
>> |         NULL | 31709 |
>> | NULL | NULL          |  94865 | Cc        | 46726    | NULL         
>> |         NULL | 31954 |
>> | NULL | NULL          |  96762 | Cc        | 94386    | NULL         
>> |         NULL | 32376 |
>> | NULL | NULL          |  96885 | Cc        | 94462    | NULL         
>> |         NULL | 32405 |
>> | NULL | NULL          |  97572 | Requestor | 92077    | NULL         
>> |         NULL | 32548 |
>> | NULL | NULL          |  98231 | Requestor | 70530    | NULL         
>> |         NULL | 32602 |
>> | NULL | NULL          |  98295 | Cc        | 28368    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  98296 | Cc        | 13287    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  98297 | Cc        | 95798    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  99376 | Requestor | 28368    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  99378 | Cc        | 95792    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  99380 | Requestor | 13287    | NULL         
>> |         NULL | 32662 |
>> | NULL | NULL          |  99361 | Cc        | 3448     | NULL         
>> |         NULL | 32843 |
>> | NULL | NULL          | 103316 | Requestor | 65511    | NULL         
>> |         NULL | 33745 |
>> | NULL | NULL          | 105409 | Cc        | 3368     | NULL         
>> |         NULL | 34100 |
>> | NULL | NULL          | 105671 | Requestor | 2638     | NULL         
>> |         NULL | 34139 |
>> | NULL | NULL          | 106944 | Cc        | 3368     | NULL         
>> |         NULL | 34251 |
>> | NULL | NULL          | 107906 | Cc        | 3368     | NULL         
>> |         NULL | 34544 |
>> | NULL | NULL          | 108606 | Cc        | 3368     | NULL         
>> |         NULL | 34645 |
>> | NULL | NULL          | 120082 | Cc        | 101555   | NULL         
>> |         NULL | 34676 |
>> | NULL | NULL          | 115778 | Cc        | 3368     | NULL         
>> |         NULL | 34956 |
>> | NULL | NULL          | 111031 | Requestor | 103208   | NULL         
>> |         NULL | 35077 |
>> | NULL | NULL          | 111441 | Cc        | 108236   | NULL         
>> |         NULL | 35157 |
>> | NULL | NULL          | 113017 | Requestor | 13287    | NULL         
>> |         NULL | 35427 |
>> | NULL | NULL          | 118641 | Cc        | 114272   | NULL         
>> |         NULL | 35642 |
>> | NULL | NULL          | 115584 | Requestor | 20559    | NULL         
>> |         NULL | 35899 |
>> | NULL | NULL          | 122977 | Requestor | 56991    | NULL         
>> |         NULL | 37107 |
>> | NULL | NULL          | 122590 | Cc        | 3368     | NULL         
>> |         NULL | 37109 |
>> | NULL | NULL          | 123679 | Cc        | 118250   | NULL         
>> |         NULL | 37276 |
>> | NULL | NULL          | 123685 | Cc        | 3980     | NULL         
>> |         NULL | 37276 |
>> | NULL | NULL          | 123688 | Requestor | 3980     | NULL         
>> |         NULL | 37276 |
>> | NULL | NULL          | 124658 | Cc        | 115066   | NULL         
>> |         NULL | 37442 |
>> | NULL | NULL          | 126140 | Cc        | 114272   | NULL         
>> |         NULL | 37672 |
>> | NULL | NULL          | 128117 | Requestor | 121662   | NULL         
>> |         NULL | 38015 |
>> | NULL | NULL          | 129436 | Cc        | 122762   | NULL         
>> |         NULL | 38247 |
>> | NULL | NULL          | 131431 | Cc        | 2638     | NULL         
>> |         NULL | 38591 |
>> | NULL | NULL          | 132796 | Requestor | 115066   | NULL         
>> |         NULL | 38825 |
>> | NULL | NULL          | 138759 | Cc        | 93112    | NULL         
>> |         NULL | 39852 |
>> | NULL | NULL          | 138760 | Cc        | 12404    | NULL         
>> |         NULL | 39852 |
>> | NULL | NULL          | 139254 | Requestor | 131402   | NULL         
>> |         NULL | 40025 |
>> | NULL | NULL          | 170704 | Cc        | 145261   | NULL         
>> |         NULL | 42026 |
>> | NULL | NULL          | 165328 | Cc        | 143705   | NULL         
>> |         NULL | 42380 |
>> | NULL | NULL          | 178572 | Requestor | 145221   | NULL         
>> |         NULL | 43382 |
>> | NULL | NULL          | 263341 | Cc        | 100603   | NULL         
>> |         NULL | 44028 |
>> | NULL | NULL          | 189265 | Cc        | 151286   | NULL         
>> |         NULL | 44042 |
>> | NULL | NULL          | 189268 | Cc        | 151288   | NULL         
>> |         NULL | 44042 |
>> | NULL | NULL          | 189271 | Cc        | 151290   | NULL         
>> |         NULL | 44042 |
>> | NULL | NULL          | 191666 | Cc        | 3368     | NULL         
>> |         NULL | 44190 |
>> | NULL | NULL          | 205214 | Cc        | 3368     | NULL         
>> |         NULL | 45009 |
>> | NULL | NULL          | 285102 | Cc        | 3368     | NULL         
>> |         NULL | 45042 |
>> | NULL | NULL          | 217596 | Requestor | 159539   | NULL         
>> |         NULL | 45721 |
>> | NULL | NULL          | 224299 | Cc        | 162093   | NULL         
>> |         NULL | 46213 |
>> | NULL | NULL          | 224300 | Requestor | 29760    | NULL         
>> |         NULL | 46213 |
>> | NULL | NULL          | 233472 | Cc        | 165261   | NULL         
>> |         NULL | 46833 |
>> | NULL | NULL          | 260741 | Cc        | 3368     | NULL         
>> |         NULL | 48741 |
>> | NULL | NULL          | 284029 | Requestor | 3980     | NULL         
>> |         NULL | 49971 |
>> | NULL | NULL          | 288692 | Requestor | 185022   | NULL         
>> |         NULL | 50658 |
>> | NULL | NULL          | 298445 | Cc        | 10268    | NULL         
>> |         NULL | 51160 |
>> | NULL | NULL          | 307010 | Cc        | 3368     | NULL         
>> |         NULL | 51802 |
>> | NULL | NULL          | 314703 | Cc        | 3368     | NULL         
>> |         NULL | 52094 |
>> | NULL | NULL          | 320961 | Cc        | 196017   | NULL         
>> |         NULL | 52511 |
>> | NULL | NULL          | 336707 | Cc        | 3368     | NULL         
>> |         NULL | 53444 |
>> | NULL | NULL          | 340022 | Cc        | 3368     | NULL         
>> |         NULL | 53686 |
>> | NULL | NULL          | 363180 | Cc        | 3368     | NULL         
>> |         NULL | 53858 |
>> | NULL | NULL          | 343420 | Cc        | 3368     | NULL         
>> |         NULL | 53870 |
>> | NULL | NULL          | 345199 | Cc        | 3368     | NULL         
>> |         NULL | 54012 |
>> | NULL | NULL          | 377862 | Cc        | 3368     | NULL         
>> |         NULL | 55767 |
>> +------+---------------+--------+-----------+----------+---------------+--------------+-------+
>>
>> 116 rows in set (2.03 sec)
>>
> 
> 



More information about the rt-users mailing list