[pgpool-general: 914] Re: Connection leaks through pgmemcache

Kouber Saparev kouber at saparev.com
Tue Aug 21 02:57:39 JST 2012


On 08/20/2012 02:56 PM, Tatsuo Ishii wrote:
>> We are experiencing some connection leaks, when using pgpool +
>> pgmemcache + memcached. Some of the connections to memcached stay open,
>> so at the end the memcached connections limit is reached and we have to
>> restart memcached in order to not get timeout connection hungs.
>>
>> At the beginning of every connection to pgpool we "SELECT
>> memcache_server_add(..., ...)". The thing is that the connection for
>> some reason is not closed properly.
>>
>> We now switched back to pgbouncer and the issue is gone, so it
>> definitely has something to do with pgpool itself.
>>
>> Any ideas?
> I don't know anything about pgmemcache, so this is just a wild
> guess. Does pgmemcache has disconnection function to memcached? If so,
> I guess you need to call it eveytime you disconnect to pgpool. If the
> argument of the function is fixed, you might be able to add to
> reset_query_list.

Unfortunately it does not have such a function. I was just wondering
whether somebody had similar experience and what is the reason for the
connections to rest open for so much time.

--
Kouber Saparev



More information about the pgpool-general mailing list