[Vtigercrm-developers] Time Interval workflow exhausts memory

[Sukhdev Mohan]

Let me guess, you are using create/update API and the error arrises at
arround 5k records.

I think that the system fails at arround 5k, the reason is because they
didn't think of bulk actions.

Just today it took me almost 20 Min to create 3k records in orgs... With
rest API using Pentaho data integration tool. I just think if the CRM could
somehow batch the JSON accepting an array rather than an object this could
be achieved. Of course this means effort in redesigning API.

Il ven 5 feb 2021, 00:42 Rubén A. Estrada Orozco <rulotec1 at gmail.com> ha
scritto:

> Hi,
>
> I have a time interval workflow set to run every day at a specific time
> for the accounts module. The related action is to just update a field.
>
> The accounts module currently has 33k records, which is not huge IMHO.
>
> When running the vtigercron.php script, I get a memory exhausted error:
>
> [CRON],"1612409402.1677",https://my_vtiger_instance.com/,Instance,"2021-02-03
> 21:30:02","",[STARTS]
> [CRON],"1612409402.1677",https://my_vtiger_instance/,Workflow,"2021-02-03
> 21:30:02","",[STARTS]
> PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried
> to allocate 20480 bytes) in /var/www/html/include/database/PearDatabase.php
> on line 181
>
> Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to
> allocate 20480 bytes) in /var/www/html/include/database/PearDatabase.php on
> line 181
>
>
> My memory limit is 512M in config.inc.php
>
> If I disable that workflow I don't get the error. So I'm certain it has to
> do with that particular workflow.
>
> So the questions here are:
>
> Is this a general problem with vtiger?
> What are the known limitations for this kind of workflow?
> Is it ok to increase the memory limit to say 1 GB?
> any other tip or hint?
>
> Saludos
>
> Rubén
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210205/a8e6e25f/attachment.html>