At Thu, 22 Aug 2002 07:03:40 -0700 (PDT), Jarrod Stenberg wrote: > Does not have any problems. This file uses this: > [$ while ($h = $sth->fetchrow_hashref()) $] > [$ endwhile $] > > But call it from the browser, and it kills the httpd > instance.
(you haven't said what DBD driver you're using) just in case its relevant, i found that DBI/DBD::Pg has some ref counting issues. if you keep the statement handle after the database handle has been undeffed, strange things happen. (it was definately the cause of some "spinning requests" we saw, it might even have been the cause of those @ISA corruption bugs we saw a long time ago). when we went through our code and were extremely careful about how we cleaned up our database caches, apache became much more stable. (standard DBI prepare_cached seems to work fine) looking (quickly) at the DBD::Pg code, it seemed to be using standard DBI XS macros to manage the handles; so this problem might exist in all DBD modules. -- - Gus --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
