Serial execution of processes

[bonsai]

The same process is being executed in parallel on the same table.

This is causing a problem where a single record is being updated by multiple processes.

To solve this problem, we considered the following solutions:

① Run a job schedule periodically to update the table data in a single process (every 10 seconds)

② Trigger processing based on events processed sequentially in a custom queue

① works as expected because the process is not executed in parallel, but it executes the process at unnecessary times. (Checking at the start of the process would allow it to be immediately interrupted.)

② was considered to avoid unnecessary processing, but the events appear to be processed simultaneously rather than sequentially. (They may be processed sequentially in milliseconds, but to the user, they appear to be processed simultaneously.)

Ultimately, we plan to adopt a job schedule, but please let us know if you have any other ideas for executing the process sequentially.

We would like to implement this using standard functions as much as possible, without using custom tables or similar tools.

[Tanushree Maiti]

Hi @bonsai ,

It seems the focus has been more on implementing workarounds rather than identifying the root cause.

Have you investigated why the same process is being executed in parallel on the same table or how?