Bugs item #2352146, was opened at 2008-11-26 20:33
Message generated for change (Comment added) made by nuncanada
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=2352146&group_id=19984
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Authentication
Group: None
Status: Closed
Resolution: Fixed
Priority: 9
Private: No
Submitted By: Flavio Botelho (nuncanada)
Assigned to: Claudia Juergen (cjuergen)
Summary: 2 Authentications with LoginPage cause connection exhaust
Initial Comment:
Grave problem related to chooser.jsp (Or whatever code that calls it, maybe
RegisteredFilter?).
The problem that caused the connection pool to get exhausted in our production
site can be reproduced by taking Dspace's current Trunk and enabling at least 2
Autentication methods that have loginURLs (ie.: PasswordAuthentication and
LDAPAuthentication).
Then just go to a page (/profile for example) where chooser.jsp is called and
hit a 3 or 4 refreshs. In my machine usually it takes less than 30 secs the
following message appears:
2008-11-26 18:09:57,494 ERROR org.dspace.dao.GlobalDAO @ Um erro de E/S ocorreu
ao enviar para o processo do servidor.
2008-11-26 18:09:57,494 WARN org.dspace.storage.rdbms.DatabaseManager @
Already closed.
2008-11-26 18:09:57,516 ERROR org.dspace.dao.GlobalDAO @ Um erro de E/S ocorreu
ao enviar para o processo do servidor.
2008-11-26 18:09:57,516 WARN org.dspace.storage.rdbms.DatabaseManager @
Already closed.
And the following is outputed in the tomcat console: (might be one of the empty
SQLExceptions catch where i have put e.printStackTrace(), so might not appear
for you)
java.sql.SQLException: Already closed.
at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
at
org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.close(PoolingDriver.java:269)
at
org.dspace.storage.rdbms.DatabaseManager.freeConnection(DatabaseManager.java:566)
at
org.dspace.dao.postgres.GlobalDAOPostgres.abortTransaction(GlobalDAOPostgres.java:105)
at org.dspace.core.Context.abort(Context.java:381)
at org.dspace.core.Context.finalize(Context.java:504)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
To exhaust the connection pool, use Apache's JMeter against one of these pages
where choose.jsp is called:
I am making the test with 20 simultaneous users and loop count of 5 (and the
default 30 connections in the pool). And the pool gets exhausted very quickly.
----------------------------------------------------------------------
Comment By: Flavio Botelho (nuncanada)
Date: 2008-12-15 19:31
Message:
Yep, right on the bull's eye :)
Tested and all the problems are gone.
Thanks a lot Claudia, you're great!
----------------------------------------------------------------------
Comment By: Claudia Juergen (cjuergen)
Date: 2008-12-15 12:45
Message:
Hi Flavio,
I attached a fix, as you got the test environment ready, would you mind
testing it.
Sunny Greetings
Claudia
----------------------------------------------------------------------
Comment By: Claudia Juergen (cjuergen)
Date: 2008-12-10 14:03
Message:
Hi,
guess it's due to the cause that chooser.jsp creates a new Context, which
should never happen in a jsp.
Claudia
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=2352146&group_id=19984
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
