Note: This applies to customers that have SQL Express or SQL Server installed for the database.
Issue
Performance issue, DocuShare is slow, home page displaying JDBC errors, users not being able to login anymore.
The {dshome}\logs\DSServer.stdError log displays a lost database connection errors:
11 Aug 2016 11:53:08 - [Thread[Thread-37,5,main]] - DatabaseJDBC.getConnection: Failed to get one. ADDING TO LIST at 6 for thread Thread-40, waiting to do command getObject
It appears connections are being queued because SQL Server cannot serve more connections.
The trace means a connection request has waited 2 min for one connection among the pool of connections to free up and it’s adding to the list at 0, 1, 2 or more= its position in the queue.
In the example above, the connection request is added in th 6th position in the queue.
Solution
Increase the Connection Pool size.
See the article on how to increase the Pool Size: https://help.docushare.com/hc/en-us/articles/31552893804571-poolSize-configuration-for-SQL-Server
Solution ID: 1810