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

[matthew zeier]

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