NitorCreations / nflow

Embeddable JVM-based workflow engine with high availability, fault tolerance, and support for multiple databases. Additional libraries are provided for visualization and REST API.
196 stars 37 forks source link

when nflow under load, timestamps seem incorrect. #625

Closed RealZimboGuy closed 5 months ago

RealZimboGuy commented 7 months ago

in the below image, you can see the created timestamp is after the execution of the first state, and the started

image

image

the workflow diagram

image

RealZimboGuy commented 5 months ago

for future reference something that nflow is quite sensitive is time shift between where nflow is running and the time on the database server

the query used checks if nextActivation is less than or equal to current_timestamp (database timestamp) If the database is ever ahead of the app server you get that scenario of instant execution of future dated tasks