CiviCRM Community Forums (archive)

I am trying to dedupe a small batch of contacts (about 750, although I have tested this with only 2 contacts in the group as below with the same effect).

MySQL just hangs on the following statement:

INSERT INTO dedupe( id1, id2, weight )
SELECT t1.id id1, t2.id id2, 10 weight
FROM civicrm_contact t1
JOIN civicrm_contact t2
USING ( first_name )
WHERE t1.contact_type =  'Individual'
AND t2.contact_type =  'Individual'
AND t1.id < t2.id
AND t1.first_name IS NOT NULL
AND (
t1.id
IN ( 282014, 368873)
OR t2.id
IN ( 282014, 368873 )
)
It will run continuously. Showing in Log_slow_queries as being over an hour before I stop it. Any ideas why?

No, sorry. I haven't looked at it in a while. I may get to look at it again though in the near future.