Class::DBI::Pg, mod_perl, sporadic errors

[prev] [thread] [next] [Date index for 2004/07/26]

Hello,

I get a sporadic error when stress-testing my mod_perl/Class::DBI::Pg app,
and I'm not sure what to make of it.

I have set up a test script which generates about 12 requests/sec to the
mod_perl handler.  Of the first 25 or so requests, 5 return this error.

---------------------------------------------------------------------------
[Mon Jul 26 09:27:17 2004] [error] [client xxx.xxx.xxx.xxx]
Precis::UserPrecis::User can't SELECT user_id\nFROM   users\nWHERE  ( status
!= ? OR user_email = ? )\n: Assertion i == (((((SV *) (name_av))->sv_flags &
0x00008000)) ? Perl_mg_size(((PerlInterpreter
*)pthread_getspecific((*Perl_Gthr_key_ptr(((void *)0))))), (SV *) name_av) :
((XPVAV*) (name_av)->sv_any)->xav_fill)+1 failed: file "DBI.xs", line 1638
at /usr/lib/perl5/site_perl/5.8.4/Class/DBI.pm line 1125.\nerrAssertion i ==
(((((SV *) (name_av))->sv_flags & 0x00008000)) ?
Perl_mg_size(((PerlInterpreter
*)pthread_getspecific((*Perl_Gthr_key_ptr(((void *)0))))), (SV *) name_av) :
((XPVAV*) (name_av)->sv_any)->xav_fill)+1 failed: file "DBI.xs", line 1638
at /usr/lib/perl5/site_perl/5.8.4/Class/DBI.pm line 1125.\n at /usr/
---------------------------------------------------------------------------

Of course, now it seems to not show up anymore...

Now I've traded that error for this one:
---------------------------------------------------------------------------
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect() at /usr/lib/perl5/site_perl/5.8.4/Ima/DBI.pm line 319.
---------------------------------------------------------------------------
I looked through the source there, and that's where Ima::DBI returns an
active $dbh.  

Any ideas?
I have Apache::DBI installed and loaded, so I'm not sure what I'm doing
wrong.

Thanks!
John Drago