[rt-users] Ticket Errors
Ruslan Zakirov
ruslan.zakirov at gmail.com
Fri Feb 9 01:35:20 EST 2007
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)
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list