Timer Events in Flowable Not Triggering Promptly: Inconsistent Processing and Random Delays with GaussDB (Flowable 4.6.1 #4026
Description
Database: GaussDB, Flowable version: 4.6.1. We have observed that the program fails to trigger timer-related events promptly. When the timer event reaches its due time, the data from the act_tu_timer_job table is moved to the act_ru_job table. After a long period of time, the timer event is finally processed in the act_ru_job table. Sometimes the timer events are triggered promptly, but it seems to happen randomly. We cannot figure out the cause of this issue. Additionally, other asynchronous tasks in the act_ru_job table are executed promptly without any issues.