[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