[rt-users] DBIx::SearchBuilder panic, rt 3.0.9

matthew zeier mrz at intelenet.net
Fri Feb 13 22:14:39 EST 2004


To further my woes, I backed out to 3.0.8 and DBIx::SearchBuilder 0.96, and
reinstalled Redhat 8.0's perl-5.8.0-88.3.

I'm left with a semi-working system that can no longer display ticket
content. .

error:  Can't locate object method "Columns" via package "RT::Attachments"
at /opt/rt3/share/html/Ticket/Elements/ShowAttachments line 66.

context:  ...
62:  my %documents;
63:  my $transactions = $Ticket->Transactions();
64:  while (my $trans = $transactions->Next()) {
65:  my $attachments = $trans->Attachments();
66:  while (my $attach = $attachments->Next()) {
67:  next unless ($attach->Filename());
68:  # most recent at the top
69:  unshift (@{$documents{$attach->Filename}}, $attach);
70:  }
...

code stack:  /opt/rt3/share/html/Ticket/Elements/ShowAttachments:66
/opt/rt3/share/html/Ticket/Elements/ShowSummary:68
/opt/rt3/share/html/Ticket/Display.html:33
/opt/rt3/share/html/autohandler:195


Help?

----- Original Message ----- 
From: "matthew zeier" <mrz at intelenet.net>
To: <rt-users at lists.fsck.com>
Sent: Friday, February 13, 2004 6:28 PM
Subject: [rt-users] DBIx::SearchBuilder panic, rt 3.0.9


>
> Upgraded perl 5.8.0 to 5.8.3, upgraded DBIx::SearchBuilder
> (from DBIx-SearchBuilder-0.97_02.tar.gz) and then upgraded rt from 3.0.8
to
> 3.0.9.  Rebuilt mod_perl 1.28 and for completeness, rebuilt apache 1.3.28
> with mod_ssl.
>
> I'm now seeing the following errors:
>
> [Fri Feb 13 18:13:14 2004] [error] panic: DBI active kids (16) > kids (2)
at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410.
> [Fri Feb 13 18:13:18 2004] [error] panic: DBI active kids (10) > kids (3)
at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410.
> [Fri Feb 13 18:13:22 2004] [error] panic: DBI active kids (9) > kids (2)
at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410.
> [Fri Feb 13 18:13:42 2004] [error] panic: DBI active kids (17) > kids (2)
at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410.
>
>
> This is causing random broken images and sometimes broken webrt.css (like
> it's not even being spit out).
>
> Restarting Apache cleans things up only momentary.  After a short time I
see
> the following:
>
> Attempt to free temp prematurely: SV 0x90ae8ec at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm line 819.
>
> Attempt to free unreferenced scalar: SV 0x90a37f4 at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record/Cachable.pm line
> 112.
>
>
> The webui shows:
>
> System error
>
> error:  panic: DBI active kids (3) > kids (2) at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> line 410.
>
> context:  ...
> 406:  delete $bhash->{'value'};
> 407:  $sth->bind_param($bind_idx+1, undef, $bhash );
> 408:  }
> 409:  }
> 410:  unless ( $sth->execute(@bind_values) ) {
> 411:  if ($DEBUG) {
> 412:  die "$self couldn't execute the query
> '$QueryString'"
> 413:  . $self->dbh->errstr . "\n";
> 414:
> ...
>
> code stack:
>  /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm:410
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm:899
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm:819
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record/Cachable.pm:110
> /opt/rt3/lib/RT/Record.pm:225
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm:769
> /opt/rt3/lib/RT/CurrentUser.pm:251
> /opt/rt3/share/html/autohandler:169
>
> raw error
>
>
> panic: DBI active kids (3) > kids (2) at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> line 410.
>
>
> Trace begun at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Exceptions.pm
> line 131
> HTML::Mason::Exceptions::rethrow_exception('panic: DBI
> active kids (3) > kids (2) at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> line 410.^J') called at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
> line 410
> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x927919c)',
> 'SELECT  * FROM Users WHERE Name = ?', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm
> line 899
>
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x91435f4)',
> 'SELECT  * FROM Users WHERE Name = ?', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm
> line 819
> DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x91435f4)',
> 'Name', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record/Cachable.pm
> line 110
>
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x91
> 435f4)',
> 'Name', 'dpark') called at /opt/rt3/lib/RT/Record.pm line
> 225
> RT::Record::LoadByCols('RT::CurrentUser=HASH(0x91435f4)',
> 'Name', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Record.pm
> line 769
> DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x91435f4)',
> 'Name', 'dpark') called at /opt/rt3/lib/RT/CurrentUser.pm
> line 251
> RT::CurrentUser::Load('RT::CurrentUser=HASH(0x91435f4)',
> 'dpark') called at /opt/rt3/share/html/autohandler line
> 169
> HTML::Mason::Commands::__ANON__('pass', 'change',
> 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Component.pm
> line 134
>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x92c013
> 8)',
> 'pass', 'change', 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
> 1057
> eval
> {...}('HTML::Mason::Component::FileBased=HASH(0x92c0138)',
> 'pass', 'change', 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
> 1056
> HTML::Mason::Request::comp(undef, undef, undef, 'pass',
> 'change', 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
> 331
> eval {...}(undef, undef, undef, 'pass', 'change',
> 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
> 331
> eval {...}(undef, undef, undef, 'pass', 'change',
> 'user', 'dpark') called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
> 290
>
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9564f
> a4)')
> called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
> line 134
> eval
> {...}('HTML::Mason::Request::ApacheHandler=HASH(0x9564fa4)')
> called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
> line 134
>
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandl
> er=HASH(0x9564fa4)')
> called at
> /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
> line 792
>
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
> 0x9322bec)',
> 'Apache=SCALAR(0x93228e0)') called at
> /opt/rt3/bin/webmux.pl line 134
> eval {...}('HTML::Mason::ApacheHandler=HASH(0x9322bec)',
> 'Apache=SCALAR(0x93228e0)') called at
> /opt/rt3/bin/webmux.pl line 134
> RT::Mason::handler('Apache=SCALAR(0x93228e0)') called at
> /dev/null line 0
> eval {...}('Apache=SCALAR(0x93228e0)') called at /dev/null
> line 0
>
>
>
> --
> matthew zeier                        | "Nothing in life is to be feared.
> InteleNet Communications, Inc.       |  It is only to be understood."
> (949) 784-7904                       |       - Marie Curie
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>




More information about the rt-users mailing list