Mass update of 5206 contacts: Allowed memory size of 167772160 bytes exhausted

[Thub]

I know there are lots of posts like this, but my question is whether this is to be expected when doing an operation on so many contacts? Is it just a matter of increasing the memory_limit value until the message goes away?

I'm using CentOS 5.3 with Apache 2.2.3, PHP 5.1.6, and SugarCRM CE 5.2.0i

My memory_limit is set to 160M and the client is doing a mass update of 5206 contacts.

"Allowed memory size of 167772160 bytes exhausted"

Thanks,

Thub

[swcramer]

Here is a report from one of my users - which makes it appear that it doesn't matter how many contacts are being mass updated.

---begin user e-mail---
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 54 bytes) in /home/fundmatr/public_html/crm/data/SugarBean.php on line 612

i get each time i try to move groups of files to a forward date under activities. the only thing i am altering under mass update is the date i wanted to move the files to. I just selected 8 files hit update and got that error and only 5 moved.
---end user e-mail---

[wynn]

I think you can only set a higher memory limit.

the memory management of PHP is not so good.
i.e $this->abc = new ABC(); in a loop, it will use more and more memory accumulatively.

So I think you can only set a higer memory limit.
In addintion, there is a limit in sugar, which will limit the database manipulation times in one request.
So I think you will not update so many contacts at one time.

[swcramer]

I think you can only set a higher memory limit.

In addintion, there is a limit in sugar, which will limit the database manipulation times in one request.
So I think you will not update so many contacts at one time.

So, how many records can one expect to update in a mass update? My user bombed on 8. Seems low.

[salesagility]

I agree with Wynn. Increase your php.ini max_memory

As for how many records can be updated by Mass Update ... theoretically, as many as you want and have sufficient memory and php.ini variables allow.

Practically, we tend to limit users to 1,000

[Chrono_trigger]

I have the same problem.

Anyone has a solution ?

[nazmul87]

i have also a similar problem.



i want to override module.php core file of sugarcrm for upgrade-safe customization of bean class.its give memory issue jsut as PermGen Exception of java.

and after changing in php.ini

memory_limit=128M ; its by - default ,

and i tried 256M,512M,1024M but problem remain same.

so can any one tell me what is fix for this issue?

My Aim is : Override Module.php as Upgrade-Safe.

Thanks.

[morrighu]

That's really a server thing and not a "sugar" thing per se. You might also want to increase your swap space and the physical RAM on your machine if you alter the php.ini & my.cnf and continue to have issues.