Grave problem related to chooser.jsp (Or whatever code that calls it).
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 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)
That's ok for me, not scared by ugly messages, but the fun part is to
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.
Kudos,
Flávio Botelho
On Wed, Nov 26, 2008 at 4:22 PM, Flavio Botelho <[EMAIL PROTECTED]> wrote:
> Hello Fabian,
>
> Do you have extra Autentication Methods?
> Specially ones that have extras login urls, like LDAPAuthentication,
> LDAPHierarchicalAutentication?
>
> We have a similar problem and only happens when the chooser.jsp is
> called (there is more then 1 authentication method with a url)
>
> Flavio Botelho
>
> On Wed, Nov 26, 2008 at 9:01 AM, Fabian Smagghe <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> in September 2007 Mika Stenberg reported connection problems:
>> "PSQLException: This statement has been closed"
>> "LOG: unexpected EOF on client connection"
>>
>> We have the same problem (we use dspace 1.5.0 + customization) and MANY
>> "System Error" with following
>> message in the log : "SQLException: This statement has been closed".
>>
>> To get around this problem, we install 2 classes of version 1.5.1 to
>> improved cleanup of database resources:
>> org.dspace.storage.rdbms.DatabaseManager.java and
>> org.dspace.storage.rdbms.TableRowIterator.java
>> ...but the problem remains !
>>
>> James Rutherford wrote (September 2007) that it was probably indicative
>> of sloppy / incorrect use of the Context somewhere.
>> Can someone say what "sloppy /incorrect use" does mean
>> or how to cleanup database resources
>> or how to find the code responsible for the problem ?
>>
>> Thanks,
>>
>> Fabian
>>
>>
>>
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
