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

[Aleš Sušnik]

Search archives for messages posted by me, for one of the RT 3.0.9 pre
versions... I had, I believe the same problem, which I solved by manually
installing DBIx::SearchBuilder 0.97 by downloading it from CPAN.
Solved my problems... I believe that was just last week!

A. 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of matthew zeier
Sent: Saturday, February 14, 2004 4:20 AM
To: matthew zeier; rt-users at lists.fsck.com
Subject: Re: [rt-users] DBIx::SearchBuilder panic, rt 3.0.9

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