Page MenuHomePhabricator

Smart Group crashed?
Open, Needs TriagePublic

Description

Was attempting to change the criteria for a smart group London Events. Then adjusting the criteria to the following.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 16 2018, 12:36 AM

Query was

explain SELECT DISTINCT 'civicrm_contact', contact_a.id, contact_a.id, 'civicrm search 40623a7b932bbf62e4a4818634c61aeb_3057', contact_a.display_name
    ->   FROM civicrm_contact contact_a 
    -> LEFT JOIN civicrm_address `Home-address` ON ( contact_a.id = `Home-address`.contact_id ) and `Home-address`.location_type_id = 1  
    -> LEFT JOIN civicrm_location_type `Home-location_type` ON (  ( `Home-address`.location_type_id = `Home-location_type`.id )  )  
    -> LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id   
    -> LEFT JOIN civicrm_group_contact `civicrm_group_contact-341` ON (contact_a.id = `civicrm_group_contact-341`.contact_id AND `civicrm_group_contact-341`.status IN ('Added'))  
    -> WHERE  (  ( `Home-address`.country_id = 1226 AND civicrm_contribution.total_amount >= 1000 )  OR  (  ( ( `civicrm_group_contact-341`.group_id = 341  ) )  )  )  AND (contact_a.is_deleted = 0)   GROUP BY contact_a.id  ORDER BY `contact_a`.`sort_name` asc, `contact_a`.`id`  LIMIT 0, 500;
+------+-------------+---------------------------+------+---------------------------------------------------+------------------------------------+---------+----------------------+----------+----------------------------------------------+
| id   | select_type | table                     | type | possible_keys                                     | key                                | key_len | ref                  | rows     | Extra                                        |
+------+-------------+---------------------------+------+---------------------------------------------------+------------------------------------+---------+----------------------+----------+----------------------------------------------+
|    1 | SIMPLE      | contact_a                 | ref  | index_is_deleted_sort_name                        | index_is_deleted_sort_name         | 1       | const                | 13154039 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | Home-address              | ref  | index_location_type,FK_civicrm_address_contact_id | FK_civicrm_address_contact_id      | 5       | civicrm.contact_a.id |        1 | Using where                                  |
|    1 | SIMPLE      | civicrm_contribution      | ref  | FK_civicrm_contribution_contact_id                | FK_civicrm_contribution_contact_id | 4       | civicrm.contact_a.id |        1 |                                              |
|    1 | SIMPLE      | civicrm_group_contact-341 | ref  | UI_contact_group                                  | UI_contact_group                   | 4       | civicrm.contact_a.id |        1 | Using where                                  |
+------+-------------+---------------------------+------+---------------------------------------------------+------------------------------------+---------+----------------------+----------+----------------------------------------------+
4 rows in set (0.00 sec)
Vvjjkkii renamed this task from Smart Group crashed? to 2vcaaaaaaa.Jul 1 2018, 1:09 AM
Vvjjkkii removed Eileenmcnaughton as the assignee of this task.
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii edited subscribers, added: Eileenmcnaughton; removed: Aklapper.
CommunityTechBot renamed this task from 2vcaaaaaaa to Smart Group crashed?.Jul 2 2018, 4:08 PM
CommunityTechBot assigned this task to Eileenmcnaughton.
CommunityTechBot raised the priority of this task from High to Needs Triage.
CommunityTechBot updated the task description. (Show Details)
CommunityTechBot edited subscribers, added: Aklapper; removed: Eileenmcnaughton.
Eileenmcnaughton removed Eileenmcnaughton as the assignee of this task.Oct 27 2020, 7:57 PM
Eileenmcnaughton added a subscriber: Eileenmcnaughton.