To edit pages or tickets please login with username/password: aaf/aaf

Ticket #173 (new defect)

Opened 1 year ago

Last modified 1 year ago

drb server opening hundreds of connections to mysql server

Reported by: aaf Assigned to: jk
Priority: critical Milestone:
Component: 0plugin Version:
Keywords: Cc:

Description

the drb server in latest acts_as_ferret trunk (as of 10/3/07) slowly keeps opening more and more connections to our mysql server on another machine until we reach the limit of 256 max connections. very bad. the ferret drb server opens about a connection or two a minute, without closing the old connections. this is a very busy high-traffic website, but i believe the problem even occurs when there aren't that many requests going to the drb server. this occurs even after i comment out the line with 'reconnect!' that was recently added. the additions to the trunk that reconnect to mysql when the drb server thinks it has disconnected seem to be causing this problem, as i didn't experience this before those changes.

yossarian1 gmail.com

Change History

11/17/07 17:39:21 changed by jk

I'm not sure what the problem is here.

I tried to reproduce this with a [simple script http://projects.jkraemer.net/acts_as_ferret/browser/trunk/demo/test/smoke/drb_smoke_test.rb] that spawns 10 processes hitting the DRb server, but the number of open MySQL connections stayed constant all the time.

Also if you comment out the reconnect line I don't see how the DRb server could cause this connection leak except if active_record itself opened these new connections at will.

To edit pages or tickets please login with username/password: aaf/aaf