JBPMDB database locks grow from a single query

Good morning, everyone, we use JBPM to manage processes in our customised corporate CRM. We have a problem that is blocking the whole system.

On a weekly basis all access requests are blocked by this query :

(@P0 nvarchar(4000),@P1 nvarchar(4000))select contextmap0_.mappingId as mappingI1_8_
, contextmap0_.CONTEXT_ID as CONTEXT_2_8_
, contextmap0_.KSESSION_ID as KSESSION3_8_.
, contextmap0_.OWNER_ID as OWNER_ID4_8_
, contextmap0_.OPTLOCK as OPTLOCK5_8_
from ContextMappingInfo contextmap0_
where contextmap0_.CONTEXT_ID=@P0 and contextmap0_.OWNER_ID=@P1


This query blocks all subsequent calls, which all go to suspended. The table has about 16000 records (few)

Any suggestions would be helpful.

jBPM. The version used in production is 7.56.0.Final

openjdk 11.0.11 2021-04-20 LTS OpenJDK Runtime Environment 18.9 (build 11.0.11+9-LTS) OpenJDK 64-Bit Server VM 18.9 (build 11.0.11+9-LTS, mixed mode, sharing)

The database connection drivers used are those provided by Microsoft: sqljdbc-8.2.2-ita

Continue reading...