Hi Nada,
You are not alone, we have this problem too with our DSpace 6.4
instance. Our current solution for this problem is a cronjob in Linux:
If there are more than 50 "idle in transaction" transactions, then
restart PostgreSQL, Tomcat and Nginx.
This is our code:
Cronjob:
*/1 * * * * root /usr/bin/test `/usr/bin/pgrep -f 'idle in transaction'
| /usr/bin/wc -l ` -gt 50 && Reset.sh
Reset.sh:
service nginx stop
service postgresql restart
service tomcat9 restart
service nginx start
Hope this works :-)
Good luck & kind regards,
Marion
Am 27.11.2025 um 18:34 schrieb Nada Mehmoud Ahmed Ibrahim Aboueata:
Dear DSpace Community,
I am writing to seek assistance with a critical and persistent issue
regarding database connection management immediately following
application startup on my DSpace 6.3 instance.
Immediately after restarting my Tomcat service running DSpace 6.3
(using PostgreSQL and Apache Commons DBCP2/Hibernate), the database
connection pool rapidly fills up with connections in the *|idle in
transaction|* state. This eventually exhausts the pool, leading to
application-wide errors (|Timeout waiting for idle object|) and
general slowness. Browsing and performing functions as approving
rejected or uploading files, is extremely slow, and sometimes it fails.
Can you please assist, as this is a production env.
--
All messages to this mailing list should adhere to the Code of
Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
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 visit
https://groups.google.com/d/msgid/dspace-tech/CAPzkmC4LWEhn_jtLfm08TbQBXVFaSGqDeX19DCQ2fOArb_drBA%40mail.gmail.com
<https://groups.google.com/d/msgid/dspace-tech/CAPzkmC4LWEhn_jtLfm08TbQBXVFaSGqDeX19DCQ2fOArb_drBA%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
Marion Rupp
Bibliotheks-IT
Universitäts- und Landesbibliothek Bonn
Postfach 2460, D-53014 Bonn
Tel. 0228 / 73 75 50
Mobil: 01515 8391029
Fax: 0228 / 73 75 46
eMail:[email protected]
Internet:https://www.ulb.uni-bonn.de
Facebook:https://facebook.com/ulbbonn
Instagram:https://www.instagram.com/ulbbonn/
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
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 visit
https://groups.google.com/d/msgid/dspace-tech/630b51e8-9e3e-4071-800e-371d61bb18cc%40uni-bonn.de.
