The iteration node occasionally gets stuck when querying the database, and sometimes it succeeds again after several hours. #19933

Closed
opened 2026-02-21 20:05:00 -05:00 by yindo · 1 comment
Owner

Originally created by @1756922564 on GitHub (Oct 26, 2025).

Self Checks

  • I have read the Contributing Guide and Language Policy.
  • This is only for bug report, if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
  • Please do not modify this template :) and fill in all the required fields.

Dify version

2.0.0bate1

Cloud or Self Hosted

Self Hosted (Docker)

Steps to reproduce

偶发问题,我调用chatflow 然后有个迭代节点看日志数据已经返回了,但是流水线卡在数据库执行,并且很长时间过去后自己会执行成功(几个小时不确定时间很长)

✔️ Expected Behavior

希望找出原因,并修复,因为现在偶发情况,日志也一切正常数据库也查询成功了就是节点卡住了,改为并发迭代也不行

Actual Behavior

No response

Originally created by @1756922564 on GitHub (Oct 26, 2025). ### Self Checks - [x] I have read the [Contributing Guide](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) and [Language Policy](https://github.com/langgenius/dify/issues/1542). - [x] This is only for bug report, if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general). - [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [x] I confirm that I am using English to submit this report, otherwise it will be closed. - [x] 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :) - [x] Please do not modify this template :) and fill in all the required fields. ### Dify version 2.0.0bate1 ### Cloud or Self Hosted Self Hosted (Docker) ### Steps to reproduce 偶发问题,我调用chatflow 然后有个迭代节点看日志数据已经返回了,但是流水线卡在数据库执行,并且很长时间过去后自己会执行成功(几个小时不确定时间很长) ### ✔️ Expected Behavior 希望找出原因,并修复,因为现在偶发情况,日志也一切正常数据库也查询成功了就是节点卡住了,改为并发迭代也不行 ### ❌ Actual Behavior _No response_
yindo added the 🐞 bug label 2026-02-21 20:05:00 -05:00
yindo closed this issue 2026-02-21 20:05:00 -05:00
Author
Owner

@dosubot[bot] commented on GitHub (Oct 26, 2025):

There have been several recent fixes and improvements to the iteration node and workflow engine that address issues with parallel execution, context handling, and variable synchronization, which could be related to the intermittent stalling you're seeing. Notably, fixes were merged to preserve Flask context during parallel iterations, properly sync conversation variables after each iteration, and improve single-step run handling for iteration and loop nodes. These changes target concurrency and state propagation issues that could cause nodes to hang or stall for long periods, especially under parallel or heavy workloads (PR #26098, PR #26368, PR #26036).

If you're running 2.0.0bate1, it's likely you don't have these fixes yet. Upgrading to the latest version should resolve or significantly reduce the issue. If you continue to experience stalls after upgrading, check your Docker environment for resource constraints (CPU, memory, database connection pool limits), and ensure all required containers (especially your database/vectorstore) are healthy and properly configured.

If you need to debug further, try running with a smaller dataset or lower concurrency to see if the issue persists, and monitor your logs for any signs of connection pool exhaustion or deadlocks.

To reply, just mention @dosu.


How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other  Chat with Dosu Join Discord Share on X

@dosubot[bot] commented on GitHub (Oct 26, 2025): <!-- Answer --> There have been several recent fixes and improvements to the iteration node and workflow engine that address issues with parallel execution, context handling, and variable synchronization, which could be related to the intermittent stalling you're seeing. Notably, fixes were merged to preserve Flask context during parallel iterations, properly sync conversation variables after each iteration, and improve single-step run handling for iteration and loop nodes. These changes target concurrency and state propagation issues that could cause nodes to hang or stall for long periods, especially under parallel or heavy workloads ([PR #26098](https://github.com/langgenius/dify/pull/26098), [PR #26368](https://github.com/langgenius/dify/pull/26368), [PR #26036](https://github.com/langgenius/dify/pull/26036)). If you're running 2.0.0bate1, it's likely you don't have these fixes yet. Upgrading to the latest version should resolve or significantly reduce the issue. If you continue to experience stalls after upgrading, check your Docker environment for resource constraints (CPU, memory, database connection pool limits), and ensure all required containers (especially your database/vectorstore) are healthy and properly configured. If you need to debug further, try running with a smaller dataset or lower concurrency to see if the issue persists, and monitor your logs for any signs of connection pool exhaustion or deadlocks. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3111cf09-6285-48db-9b17-475f6a3f2206?feedback_type=other)</sup>&nbsp;&nbsp;[![Chat with Dosu](https://dosu.dev/dosu-chat-badge.svg)](https://app.dosu.dev/6088a4f4-073a-43f3-b3d4-4f06fb0c05a0/ask?utm_source=github)&nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/langgenius/dify/issues/27467)
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#19933