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