Re: [Pagekit-users] Stale MySQL handles in 2.14.14

[Collin S. <col...@co...>]

Boris Zentner wrote:
> Hi Collin,
>
> Am 16.07.2006 um 22:02 schrieb Collin Starkweather:
>
>> I get a "too many connections" error from MySQL with version 2.14.14 
>> after my
>> site has been up for any amount of time.  I notice that there are 
>> hundreds of
>> stale database handles lying about, but the only use of MySQL is for
>> Apache::PageKit session tracking.   That is, there is no other 
>> functionality
>> associated with the web pages that access MySQL.
>>
>> E.g., after just a few page loads following a restart of both Apache 
>> and MySQL,
>> I see
>>
>>   root@www$ ps auxww | grep mysql | wc
>>       114    2153   30556
>>   root@www$
>>
>> Is this a known issue with 2.14.14?
>>
>>
>
> No, your Apache::DBI is not loaded/installed. I guess it is not 
> installed in your new httpd's httpd.conf.

After some sleuthing, I figured out that this was caused by the fact 
that I had not updated my equivalent of MyPageKit::Common.  I needed to 
replace

  return DBI->connect(...)

with

  return DBI->connect_cached(...)

Cheers,

-Collin

-- 
Collin Starkweather
http://www.collinstarkweather.com