Hi Martin, Can you run your load tests fetching the current main of incubator-kie-kogito-apps, I merged https://github.com/apache/incubator-kie-kogito-apps/pull/1906 with some fixes regarding concurrency in data-index once consuming events from runtimes, so maybe the results would be different, let's see, but one of the things that has been changed was the replacement of (delete + insert) with a merge.
I hope it helps in the discussion. Thanks, _____________________________________ *Tiago Marchetti Dolphine* <tiagodolph...@gmail.com> On Tue, Nov 21, 2023 at 2:08 PM Martin Weiler <mwei...@ibm.com.invalid> wrote: > I looked into the new examples using data-index persistence addon - Neus' > PR#1813 [1] for serverless and Pere's branch [2] for workflow (great job > both!) - and they work without issues using single requests. However, under > some load (I used 'ab' for testing with a light concurrency of 10 parallel > requests) I ran into the following problems: > > (1) Large number of insert/delete calls (eg. for tables such as nodes, > definitions, etc) > > (2) Hibernate OptimisticLockExceptions / StaleStateExceptions > > (3) DB deadlocks > > (4) Error responses, slow response times > > The reason I am reaching out with this topic here is to find out if we are > aware of this issue, and if someone is already looking into or being > assigned to it? > > Thanks, > Martin > > [1] https://github.com/apache/incubator-kie-kogito-examples/pull/1813 > [2] > https://github.com/pefernan/kogito-examples/tree/example_data-index_persistence > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@kie.apache.org > For additional commands, e-mail: dev-h...@kie.apache.org > >
