Dear All,

I would like to submit you a fairly frequent problem in our cadmus.eui.eu 
repository.

Our DSpace 5.2 installation works as a front-end on a virtual machine with 
4 CPU and 8 GB RAM and the back-end with Oracle db on the Oracle enterprise 
installation in our University ICT environment. The access to the DMZ, 
where the front-end is located, is managed by linux server with an 
Apache httpd.conf configuration apparently not limited by the number of 
simultaneous connections. Our problem is the number of connections to the 
db that quite frequently reach 200 as configured in dspace.cfg.


#Maximum number of DB connections in pool 

db.maxconnections = 200


Unfortunately, despite the fact that the 200 connections are inactive, they 
blocked access to the server forcing tomcat to restart.

Please find attached the result of an SQL query for inactive connections


Any suggestions or previous experience in this regard are extremely welcome.

Best Regards


Paolo Baglioni

Library Systems Analyst

European University Institute

50014 Firenze ITALY

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/79f1fd7c-b1e2-4279-9b83-a1de82e74f5f%40googlegroups.com.

Attachment: inactive db connections.ods
Description: application/vnd.oasis.opendocument.spreadsheet

Reply via email to