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

matthew zeier mrz at intelenet.net
Sat Feb 14 16:24:59 EST 2004 

Running with 3.0.8, perl 5.8.0 DBIx::SearchBuilder 0.97 -  
ShowAttachments works again.

How much of a hurt am I in for if I leave perl at 5.8.0?  Considering  
that nearly all my tickets are ASCII/English?  I'm inclined to think  
that the perl upgrade is what hosed me lastnight.

On Feb 13, 2004, at 10:04 PM, matthew zeier wrote:

>
> 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
>
> _______________________________________________
> 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