issue - worflow process generating high CPU process

[raramuridesign]

PHP version: 8.2.x
FreeScout version: 1.8.107
Database: Mysql
Are you using CloudFlare: Yes

@freescout-helpdesk
We have noticed that the CPU levels when workflows are running seems to be abnormally high.
Nothing unusual has been added to the workflows, but we do have a few rules which have a lot of items to check.

Questions
Is it normal for the processes to be running for such a long time?
Why would they consume so much CPU processes?
Can they be self terminated? As it looks like they have issues or cannot finish after a certain time.

Your thoughts
M.

[freescout-helpdesk]

Also send screenshot of the Workflow settings and conditions.

[raramuridesign]

I already did that...

[freescout-helpdesk]

Depending on condition types used workflows may need to scan all threads/conversations in DB.
How many conversations and threads do you have in DB?

[raramuridesign]

@freescout-helpdesk We have 75.000 messages which are closed. Possibly more in terms of threads.

[freescout-helpdesk]

Try to execute the following console command and check how much time it takes for it to finish:

php artisan freescout:workflows-process

[raramuridesign]

@freescout-helpdesk been running for 40 minutes now. Still busy and the CPU is hitting 65-75%
workflow process is consuming on average 55-70%

[freescout-helpdesk]

Try to kill already running "freescout:workflows-process" processes and run the console command again.

[freescout-helpdesk]

Disable all wokflows and enable them one-by-one running "freescout:workflows-process" command to find out which workflow takes time to process . After that send us that workflow's settings and conditions.

[freescout-helpdesk]

And make sure everything is ok on Manage > Status page, especially pcntl extension.

[freescout-helpdesk]

Also try to set "Max Executions" parameter to 1 for all other workflows and run "freescout:workflows-process". Maybe you've configured an infinite loop with your workflows. See "Max Executions and Workflows Infinite Loop" section at https://freescout.net/module/workflows/ for more details.

[raramuridesign]

@freescout-helpdesk

• pcntl is intalled - no issues
• we had one workflow which had max execution set to 5 -This is now 1.
  Will monitor the processes now.

[freescout-helpdesk]

Closing for no activity.