CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't seem to Find and Merge Duplicate Contacts
Pages: [1]

Author Topic: Can't seem to Find and Merge Duplicate Contacts  (Read 1407 times)

wftl

  • I’m new here
  • *
  • Posts: 28
  • Karma: 4
    • Writer and Free Thinker at Large
Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 10:26:52 am
Hello everyone,

I've got a CiviCRM site running 4.3.5 with just under 130 thousand contact records. When I try to run a "Find and Merge Duplicate Contacts", nothing happens. I'm doing a simple search with Last name, First name, and Email address. I select the rule, choose "All contacts" from the list of groups, click "Continue" and nothing happens. Seriously. The browser spins and tells me it's waiting on the site, but it waits forever. Even selecting a small group with only a few contacts yields the same results. No messages appear in the Apache error log.  ???

Anyhow, I'm stumped. Ideas?

--
Marcel Gagné
Note: This massagee wos nat speel or gramer-checkered.

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 10:30:20 am
I'm pretty sure that the Find and Merge Duplicate Contacts screen is AJAX-y - so you may want to check your Javascript console in your browser for errors.

You can look up how to do it with your browser of choice - for recent versions of Firefox, it's Ctrl-Shift-K, or Tools -> Web Developer -> Web Console.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

wftl

  • I’m new here
  • *
  • Posts: 28
  • Karma: 4
    • Writer and Free Thinker at Large
Re: Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 11:28:46 am
Interesting. I managed to generate an error, namely that php memory was exhausted. My server has 8 GB of ram, so I increased PHP memory_limit from 128M to 256M, which failed, then from 256 to 512M which also failed, then again from 512 to 1024M. And that also failed. How much memory does PHP require to do a dedup?

Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 25 bytes) in /home/username/public_html/sites/all/modules/civicrm/packages/DB/mysql.php on line 801

Nothing else in my CiviCRM installation fails. Just the find and merge. Does that memory demand seem reasonable. I can throw more at it, but a PHP script needing more than a gig of RAM seems wrong.

Thoughts?

-- Marcel

wftl

  • I’m new here
  • *
  • Posts: 28
  • Karma: 4
    • Writer and Free Thinker at Large
Re: Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 11:58:23 am
This can't be right.

I increased the PHP memory_limit to 2048M and now I get the following.

Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 98672830 bytes)

This time, it's packages/PEAR.php

Does this seem right to any of the core CiviCRM people? For a PHP script to consume that kind of memory?

-- Marcel

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 12:00:49 pm

most likely not. Would be great if you can debug and help figure out whats happening and why

Seeing the mysql query log might be a good first step and then following the code from there

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wftl

  • I’m new here
  • *
  • Posts: 28
  • Karma: 4
    • Writer and Free Thinker at Large
Re: Can't seem to Find and Merge Duplicate Contacts
August 30, 2013, 12:32:15 pm
Quote from: Donald Lobo on August 30, 2013, 12:00:49 pm

most likely not. Would be great if you can debug and help figure out whats happening and why

Seeing the mysql query log might be a good first step and then following the code from there

lobo

Curse you, Perry the Platypus, er, I mean Donald Lobo! I was afraid you'd say something like this.

Yeah, it doesn't seem right to me either. Sadly, every time I start digging that deep, I have to re-learn everything I'd forgotten from the last time I had to re-learn. If you know what I mean.

-- Marcel
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't seem to Find and Merge Duplicate Contacts

This forum was archived on 2017-11-26.