DB Connection leak with Rails-Integration?
------------------------------------------
Key: JRUBY-1167
URL: http://jira.codehaus.org/browse/JRUBY-1167
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: JRuby 1.0.0RC3
Environment: Deployed the Jruby app with Goldspike onto Glassfish V2
Reporter: Sakthivel Gopal
Assignee: Thomas E Enebo
Priority: Critical
We have deployed a JRruby app that uses JNDI conn pool onto Glassfish V2 server
. When a load of 4 concurrent users are generated for this app, it runs into
this issue:
[#|2007-06-26T07:54:25.931-0700|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=30;_ThreadName=httpSSLWorkerThread-8080-25;Error
in allocating a connection. Cause: In-use connections equal max-pool-size and
expired max-wait-time. Cannot allocate more
connections.;_RequestID=63f982de-31d0-4535-9bbe-3cf1268e67b2;|RAR5114 : Error
allocating connection : [Error in allocating a connection. Cause: In-use
connections equal max-pool-size and expired max-wait-time. Cannot allocate more
connections.]|#]
[#|2007-06-26T07:54:26.564-0700|INFO|sun-appserver9.1|javax.enterprise.system.container.web|_ThreadID=18;_ThreadName=Timer-6;|PWC1412:
WebModule[/junction1] ServletContext.log():Runtime 72 loaded|#]
It looks to me like the Rails-Integration framework doesn't release the
connections back after it's use.
This app uses Postgres Database. I have used pgAdmin to check on the
connections in use and notice that as the load tests are run, the number of
connections obtained on the database goes up until it reaches the
max_connections (100 , per the current config). It reaches the limit even for a
4 user load.
Let me know, if you need more info
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
