CiviCRM Community Forums (archive)

Using CiviCRM 2.28 with Drupal 6.13 I am consistently hitting memory issues, especially when using dedupe.

I try to merge contacts and select the field to be merged (only relationships for most of my duplicate contacts), I get the following memory error with htaccess set to 128M (or white screen when set to 96M), yet the merging is successful.
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /sites/all/modules/civicrm/packages/DB/DataObject.php on line 561
While this behavior is most prevalent when merging contacts, it has popped up in other places as well. Media Temple was having SQL memory issues on my cluster so right now I have a separate 128M container just for use of my sites, but the behavior is the same in both instances.

While the merging seems to work in spite of these errors, I would like to solve this problem as I have about 10,000 contacts to merge . Any ideas?

is the version 2.1.x. There were some significant scalability issues with the dedupe code in 2.0 which we rectified in 2.1

can u upgrade (the live site or a copy) to 2.2.8. If the problem still persists there, we'd love to take a look (either ssh access or a copy of the db) and figure out whats happening and why.

lobo

how big is the compressed DB? u can email it to my yahoo dot com address if not too big

if big, u might want to use something like yousendit http://www.yousendit.com/

also can u include steps to duplicate the issue

thanx

lobo