Just out of nowhere I'm getting Hibernate timeout errors on my dspace 6 app. Not sure what is causing it. It seems to reach the max connection setting quickly ( 30 is default, and I have been using that for a long time, but I changed it to 50 ). This is what I am seeing in the database for one of the connections that is not releasing:
Any ideas? => SELECT relation, transactionid, pid, mode, granted, relname FROM pg_locks INNER JOIN pg_stat_user_tables ON pg_locks.relation = pg_stat_user_tables.relid WHERE pg_locks.pid='10269'; relation | transactionid | pid | mode | granted | relname -----------+---------------+-------+-----------------+---------+------------------------- 24125181 | | 10269 | AccessShareLock | t | collection 24125274 | | 10269 | AccessShareLock | t | eperson 24125123 | | 10269 | AccessShareLock | t | bitstream 24125535 | | 10269 | AccessShareLock | t | workspaceitem 24125131 | | 10269 | AccessShareLock | t | bitstreamformatregistry 24125319 | | 10269 | AccessShareLock | t | handle 24125187 | | 10269 | AccessShareLock | t | collection2item 24125512 | | 10269 | AccessShareLock | t | versionhistory 24125208 | | 10269 | AccessShareLock | t | community2collection 24125242 | | 10269 | AccessShareLock | t | metadatafieldregistry 24125374 | | 10269 | AccessShareLock | t | item2bundle 24125154 | | 10269 | AccessShareLock | t | bundle2bitstream 24125407 | | 10269 | AccessShareLock | t | metadataschemaregistry 24125440 | | 10269 | AccessShareLock | t | resourcepolicy 24125371 | | 10269 | AccessShareLock | t | item 24125151 | | 10269 | AccessShareLock | t | bundle 24125517 | | 10269 | AccessShareLock | t | versionitem 913986038 | | 10269 | AccessShareLock | t | dspaceobject 24125282 | | 10269 | AccessShareLock | t | epersongroup 24125213 | | 10269 | AccessShareLock | t | community2community 24125530 | | 10269 | AccessShareLock | t | workflowitem 24125249 | | 10269 | AccessShareLock | t | metadatavalue 24125202 | | 10269 | AccessShareLock | t | community 913986043 | | 10269 | AccessShareLock | t | site 24125314 | | 10269 | AccessShareLock | t | group2groupcache -- 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 on the web visit https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-uPnfy94q%3DAH-hb-5LpordTgwtRxgnZw4srweMf%2BK0gKg%40mail.gmail.com.
