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

matthew zeier mrz at intelenet.net
Sat Feb 14 01:04:40 EST 2004 

On Feb 13, 2004, at 7:38 PM, Jesse Vincent wrote:

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


Right, now I don't - I backed out to 3.0.8 which only requires 0.95  
(I'm at 0.96 now).  My backout somehow screwed up my system and I can't  
do a ShowAttachments.  This, however, is better than what I had with  
3.0.9.

>
> 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.
> _______________________________________________
> 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
>
--
matthew zeier - "Nothing in life is to be feared.  It is only to be
understood." - Marie Curie

More information about the rt-users mailing list