Some instances stuck at 'waiting' state

madhurrya commented 2 months ago

In test.mod noticed a set of instances are at 'waiting' state. Noticed a similar thing in dev.app about a month ago as mentioned here. https://github.com/sartography/spiff-arena/issues/1152#issuecomment-1975810898

jasquat commented 2 months ago

I'm not sure how they get in this state, but for instance 205 it doesn't have any ready tasks:

MySQL [spiff-workflow-backend]> select count(*) from task where process_instance_id = 205 and state = "READY";
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.012 sec)

but it does have future tasks:

MySQL [spiff-workflow-backend]> select count(*) from task where process_instance_id = 205 and state = "FUTURE";
+----------+
| count(*) |
+----------+
|      130 |
+----------+
1 row in set (0.029 sec)

madhurrya commented 2 weeks ago

Noticed another set like that in test.mod

sartography / spiff-arena

Some instances stuck at 'waiting' state #1306