[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