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

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?From: “matthew zeier” mrz@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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.From: “matthew zeier” mrz@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

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

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@intelenet.net
To: rt-users@lists.fsck.com
Sent: Friday, February 13, 2004 7:14 PM
Subject: Re: [rt-users] DBIx::SearchBuilder panic, rt 3.0.9

I’m having a similar problem on a sun Solaris 2.8 machine.

I was testing 3.0.9pre6 and this “Coloms” and “Attachments” error popped up.

I figured,… let’s upgrade everything to the latest…

Installed perl 5.8.3, installed latest apache 1 with latest mod_perl 1.

Installed RT 3.0.9 … nope,… still this “Coloms” and “Attachments” error.

And yes,… Searchbuilder 0.97 is installed.

Must be something else then.

Jesse,… any hints ?

TIA

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.

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@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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

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.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of matthew zeier
Sent: Saturday, February 14, 2004 4:20 AM
To: matthew zeier; rt-users@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.

From: “matthew zeier” mrz@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

rt-users mailing list
rt-users@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

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@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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@lists.bestpractical.com
The rt-users Archives

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

Oh, and if it matters, lastnight was 0.97_02, from the link you posted.
Today I grabbed just 0.97 which had a February timestamp.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@intelenet.net
To: rt-users@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@intelenet.net
To: rt-users@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@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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@lists.bestpractical.com
The rt-users Archives

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

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.

So. Just don’t complain if you see attachment corruption :wink: Other than
that, you should be ok.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.