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

Jesse Vincent jesse at bestpractical.com
Fri Feb 13 22:38:01 EST 2004


That sounds very much like you didn't have DBIx::SearchBuilder 0.97
installed.


On Fri, Feb 13, 2004 at 07:20:25PM -0800, matthew zeier wrote:
> Commenting out ShowAttachments from ShowSummary has temporarily given me a
> working system.
> 
> If anyone has any insights as to what I broke, how I broke it and how to fix
> it, I'd be most gratious.
> 
> ----- Original Message ----- 
> From: "matthew zeier" <mrz at intelenet.net>
> To: <rt-users at lists.fsck.com>
> Sent: Friday, February 13, 2004 7:14 PM
> Subject: Re: [rt-users] DBIx::SearchBuilder panic, rt 3.0.9
> 
> 
> > 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
> > >
> >
> > _______________________________________________
> > 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
> >
> 
> _______________________________________________
> 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
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the rt-users mailing list