[keycloak-user] LockAcquisitionException against SQL Server

[Hynek Mlnarik]

For RH-SSO, please contact directly Red Hat support.

You may be experiencing [1]. Do you use Unicode characters in your
deployment? If not, try whether setting JDBC
parameter sendStringParametersAsUnicode to false helps.

[1] https://issues.jboss.org/browse/KEYCLOAK-3210

On Mon, Dec 4, 2017 at 3:52 AM, Geadah, Nicolas (VEC) <
Nicolas.Geadah at vec.virginia.gov> wrote:

> We have started a load testing effort against RedHat SSO 7.1.2, using a
> SQL Server data source.  Our datasource pool is set to min/max of 10/30.
>
> With a load of only about 5 concurrent users, we start experiencing
> LockAcquisitionException errors on user creation or access token building.
> This results in the load test failing for a large percentage of users.
>
> Any recommendations on where to look for resolving this issue?  Perhaps
> something with the data source configuration?
>
> Thanks!
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>



-- 

--Hynek