[Dspace-tech] Connections to database not closed with increasing number of file descriptors

2013-01-25 Thread João Miranda 
Hello,

We are having a problem related to the Dspace increasing the number of 
file descriptors when making connections to the database and not 
releasing them. Thus, we get a lot of idle connections in the database 
until it reaches the maximum number of file descriptors. As consequence, 
it starts degrading the service and Tomcat has to be restarted.

We are using Dspace 1.8.2 and Postgres 8.4.7.

I have searched in the release notes of Dspace 3.0, the list of current 
known bugs for Dspace 1.8.2, and the mailing list archives but I haven’t 
found an answer.

Has anything similar been reported for this version?

Thank you.

Regards,
João Miranda

-- 
/João Miranda
http://web.ist.utl.pt/joaocarvalhomiranda

Arquivo da Web Portuguesa | Portuguese Web Archive
http://www.arquivo.pt | http://www.archive.pt

FCCN
Av. do Brasil, n.º 101
1700-066 Lisboa - Portugal
Tel.: +351 21 8440190 Fax: +351 218472167
http://www.fccn.pt

Aviso de Confidencialidade | Disclaimer

Esta mensagem é exclusivamente destinada ao seu destinatário, podendo 
conter informação CONFIDENCIAL, cuja divulgação está expressamente 
vedada nos termos da lei. Caso tenha recepcionado indevidamente esta 
mensagem, solicitamos-lhe que nos comunique esse mesmo facto por esta 
via ou para o telefone +351 218440100 devendo apagar o seu conteúdo de 
imediato.
This message is intended exclusively for its addressee. It may contain 
CONFIDENTIAL information protected by law. If this message has been 
received by error, please notify us via e-mail or by telephone +351 
218440100 and delete it immediately.

--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] Connections to database not closed with increasing number of file descriptors

2013-01-25 Thread helix84 
Hi João,

I suspect that it might be a side-effect of the problem mentioned in
this thread and jira issue:

http://comments.gmane.org/gmane.comp.db.dspace.user/18148
https://jira.duraspace.org/browse/DS-1458

Can you verify that there's a lot of IDLE in transaction processes
when you list processes using the following query?
SELECT * FROM pg_stat_activity;

Anyway, how many filedescriptors are we talking about here? Can't you
just raise the limit of allowed FDs?


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette