For a project we are querying the DMS for relevant documents, but when we are simulating a request by only 15 users at the same time the server's processor usage goes up to 100%. And all new requests are put on hold while the requests are waiting for the previous requests to be handled.

We ran a thread dump including an analyzer. The dump is included as an attachment.

Looking at the dump we can see that calling info.magnolia.module.dms.beans.Document.isDocument() takes a long time and subsequent threads are being blocked waiting for the call to end.

In the isDocument method jackrabbit is being accessed and that is where it hangs.

Our config file holds the following settings for the persistancemanager:

<PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
<param name="driver" value="com.mysql.jdbc.Driver" />
<param name="url" value="jdbc:mysql://mydb" />
<param name="schema" value="mysql" /><!-- warning, this is not the schema name, it's the db type -->
<param name="user" value="***" />
<param name="password" value="***" />
<param name="schemaObjectPrefix" value="${wsp.name}_" />
<param name="externalBLOBs" value="false" />
</PersistenceManager>