Answers.Body: <p>We had similar issues in 4.6.x, see <a href="https://issues.civicrm.org/jira/browse/CRM-17213" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-17213</a>. Let me know if you think this could be related to your problem.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T10:54:41.957Z
Answers.LastActivityDate: 2016-05-17T10:54:41.957Z
Answers.UserDisplayName: Björn Endres
Body: <p>We have a serious problem after upgrading to 4.7.6 and now to 4.7.7 (without solving the problem) - it is a problem that seems to have been active already in previous version (other people posted about it in 2015), but i can´t find a clue to solve it.
  See here a post to this topic from somebody from 2015: 
  <a href="https://issues.civicrm.org/jira/browse/CRM-16277" rel="nofollow noreferrer">https://issues.civicrm.org/jira/browse/CRM-16277</a></p>
  
  <p>It is even impossible to access certain groups (the screen freezes and I manually need to kill the processes /on sleep / in the control panel)</p>
  
  <p>It works when I create a new group with 1 person, but I need to work with
  groups with approx. 4000 people.</p>
  
  <p>It also seems that sometimes it goes through, but most of the time it freezes and it´s impossible to work.</p>
  
  <p>Please if you have the same problem or know a solution, please let us know.
  <a href="https://i.sstatic.net/jS01m.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/jS01m.png" alt="enter image description here"></a></p>
  
  <p>Attached an excerpt from our slow log file</p>
  
  <h1>Query 1: 0.02 QPS, 0.15x concurrency, ID 0x59955E428CD5C6B0 at byte 18602444</h1>
  
  <h1>Scores: V/M = 8.80</h1>
  
  <h1>Time range: 2016-05-11 11:19:48 to 23:54:11</h1>
  
  <h1>Attribute    pct   total     min     max     avg     95%  stddev  median</h1>
  
  <h1>============ === ======= ======= ======= ======= ======= ======= =======</h1>
  
  <h1>Count         12     795</h1>
  
  <h1>Exec time     42   6812s   188ms     49s      9s     26s      9s      5s</h1>
  
  <h1>Lock time     17      5s     2ms      2s     6ms     8ms    63ms     3ms</h1>
  
  <h1>Rows sent      0       0       0       0       0       0       0       0</h1>
  
  <h1>Rows examine  67   2.30G   8.59k  28.24M   2.96M  27.20M   6.75M 270.35k</h1>
  
  <h1>Rows affecte   2   7.43M       0  53.07k   9.57k  44.45k  13.14k   3.35k</h1>
  
  <h1>Bytes sent     0  41.69k       0      79   53.70   54.21    8.93   54.21</h1>
  
  <h1>Query size    19 782.95k    1006    1009 1008.48  964.41       0  964.41</h1>
  
  <h1>String:</h1>
  
  <h1>Databases    gemeingut_civicrm</h1>
  
  <h1>Hosts        localhost</h1>
  
  <h1>Last errno   0 (772/97%), 1160 (22/2%), 1213 (1/0%)</h1>
  
  <h1>Users        gemeingut</h1>
  
  <h1>Query_time distribution</h1>
  
  <h1>1us</h1>
  
  <h1>10us</h1>
  
  <h1>100us</h1>
  
  <h1>1ms</h1>
  
  <h1>10ms</h1>
  
  <h1>100ms</h1>
  
  <h1>1s</h1>
  
  <h1>10s+</h1>
  
  <h1>Tables</h1>
  
  <h1>SHOW TABLE STATUS FROM <code>gemeingut_civicrm</code> LIKE 'civicrm_contact'</h1>
  
  <h1>SHOW CREATE TABLE <code>gemeingut_civicrm</code>.<code>civicrm_contact</code></h1>
  
  <h1>SHOW TABLE STATUS FROM <code>gemeingut_civicrm</code> LIKE 'civicrm_group_contact_cache'</h1>
  
  <h1>SHOW CREATE TABLE <code>gemeingut_civicrm</code>.<code>civicrm_group_contact_cache</code></h1>
  
  <h1>SHOW TABLE STATUS FROM <code>gemeingut_civicrm</code> LIKE 'civicrm_group_contact'</h1>
  
  <h1>SHOW CREATE TABLE <code>gemeingut_civicrm</code>.<code>civicrm_group_contact</code></h1>
  
  <p>CREATE TEMPORARY TABLE civicrm_temp_group_contact_cache186 (SELECT 184 as group_id,  contact_a.id as id  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_111</code> ON contact_a.id = <code>civicrm_group_contact_cache_111</code>.contact_id    LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_30</code> ON contact_a.id = <code>civicrm_group_contact_cache_30</code>.contact_id    LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_8</code> ON contact_a.id = <code>civicrm_group_contact_cache_8</code>.contact_id   WHERE  (  ( <code>civicrm_group_contact_cache_30</code>.group_id = 30 )  OR  ( <code>civicrm_group_contact_cache_111</code>.group_id = 111 )  OR  ( <code>civicrm_group_contact_cache_8</code>.group_id = 8 )  )  AND (contact_a.is_deleted = 0)   AND contact_a.id NOT IN (
                                SELECT contact_id FROM civicrm_group_contact
                                WHERE civicrm_group_contact.status = 'Removed'
                                AND   civicrm_group_contact.group_id = 184 ) )</p>
  
  <h1>Converted for EXPLAIN</h1>
  
  <h1>EXPLAIN /<em>!50100 PARTITIONS</em>/</h1>
  
  <p>SELECT 184 as group_id,  contact_a.id as id  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_111</code> ON contact_a.id = <code>civicrm_group_contact_cache_111</code>.contact_id    LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_30</code> ON contact_a.id = <code>civicrm_group_contact_cache_30</code>.contact_id    LEFT JOIN civicrm_group_contact_cache <code>civicrm_group_contact_cache_8</code> ON contact_a.id = <code>civicrm_group_contact_cache_8</code>.contact_id   WHERE  (  ( <code>civicrm_group_contact_cache_30</code>.group_id = 30 )  OR  ( <code>civicrm_group_contact_cache_111</code>.group_id = 111 )  OR  ( <code>civicrm_group_contact_cache_8</code>.group_id = 8 )  )  AND (contact_a.is_deleted = 0)   AND contact_a.id NOT IN (
                                SELECT contact_id FROM civicrm_group_contact
                                WHERE civicrm_group_contact.status = 'Removed'
                                AND   civicrm_group_contact.group_id = 184 ) )</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-13T21:40:47.540Z
Comments.Text: We saw a similar issue in 4.6.4. Happened when we excluded or included more than a couple of groups in a mailing. Haven't seen it just trying to load one group. Our poor mans workaround was to do all of our excludes first in search builder / custom search and just load one group into the mailing. Seems to have gotten much rarer / possibly gone since upgrading to 4.7.13.
Comments.UserDisplayName: Eli Lisseck
Tags: <email><error>
Title: After upgrade to 4.7.6(and 4.7.7) - Freezes on "estimating" when loading group into Email, when working with groups in general
ThreadText: # After upgrade to 4.7.6(and 4.7.7) - Freezes on "estimating" when loading group into Email, when working with groups in general
  
  (Asked by: username_0 on 2016-05-11)
  
  We have a serious problem after upgrading to 4.7.6 and now to 4.7.7 (without solving the problem) - it is a problem that seems to have been active already in previous version (other people posted about it in 2015), but i can´t find a clue to solve it.
  See here a post to this topic from somebody from 2015:
  <https://issues.civicrm.org/jira/browse/CRM-16277>
  
  It is even impossible to access certain groups (the screen freezes and I manually need to kill the processes /on sleep / in the control panel)
  
  It works when I create a new group with 1 person, but I need to work with
  groups with approx. 4000 people.
  
  It also seems that sometimes it goes through, but most of the time it freezes and it´s impossible to work.
  
  Please if you have the same problem or know a solution, please let us know.
  [![enter image description here](https://i.sstatic.net/jS01m.png)](https://i.sstatic.net/jS01m.png)
  
  Attached an excerpt from our slow log file
  
  # Query 1: 0.02 QPS, 0.15x concurrency, ID 0x59955E428CD5C6B0 at byte 18602444
  
  # Scores: V/M = 8.80
  
  # Time range: 2016-05-11 11:19:48 to 23:54:11
  
  # Attribute pct total min max avg 95% stddev median
  
  # ============ === ======= ======= ======= ======= ======= ======= =======
  
  # Count 12 795
  
  # Exec time 42 6812s 188ms 49s 9s 26s 9s 5s
  
  # Lock time 17 5s 2ms 2s 6ms 8ms 63ms 3ms
  
  # Rows sent 0 0 0 0 0 0 0 0
  
  # Rows examine 67 2.30G 8.59k 28.24M 2.96M 27.20M 6.75M 270.35k
  
  # Rows affecte 2 7.43M 0 53.07k 9.57k 44.45k 13.14k 3.35k
  
  # Bytes sent 0 41.69k 0 79 53.70 54.21 8.93 54.21
  
  # Query size 19 782.95k 1006 1009 1008.48 964.41 0 964.41
  
  # String:
  
  # Databases gemeingut\_civicrm
  
  # Hosts localhost
  
  # Last errno 0 (772/97%), 1160 (22/2%), 1213 (1/0%)
  
  # Users gemeingut
  
  # Query\_time distribution
  
  # 1us
  
  # 10us
  
  # 100us
  
  # 1ms
  
  # 10ms
  
  # 100ms
  
  # 1s
  
  # 10s+
  
  # Tables
  
  # SHOW TABLE STATUS FROM `gemeingut_civicrm` LIKE 'civicrm\_contact'
  
  # SHOW CREATE TABLE `gemeingut_civicrm`.`civicrm_contact`
  
  # SHOW TABLE STATUS FROM `gemeingut_civicrm` LIKE 'civicrm\_group\_contact\_cache'
  
  # SHOW CREATE TABLE `gemeingut_civicrm`.`civicrm_group_contact_cache`
  
  # SHOW TABLE STATUS FROM `gemeingut_civicrm` LIKE 'civicrm\_group\_contact'
  
  # SHOW CREATE TABLE `gemeingut_civicrm`.`civicrm_group_contact`
  
  CREATE TEMPORARY TABLE civicrm\_temp\_group\_contact\_cache186 (SELECT 184 as group\_id, contact\_a.id as id FROM civicrm\_contact contact\_a LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_111` ON contact\_a.id = `civicrm_group_contact_cache_111`.contact\_id LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_30` ON contact\_a.id = `civicrm_group_contact_cache_30`.contact\_id LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_8` ON contact\_a.id = `civicrm_group_contact_cache_8`.contact\_id WHERE ( ( `civicrm_group_contact_cache_30`.group\_id = 30 ) OR ( `civicrm_group_contact_cache_111`.group\_id = 111 ) OR ( `civicrm_group_contact_cache_8`.group\_id = 8 ) ) AND (contact\_a.is\_deleted = 0) AND contact\_a.id NOT IN (
  SELECT contact\_id FROM civicrm\_group\_contact
  WHERE civicrm\_group\_contact.status = 'Removed'
  AND civicrm\_group\_contact.group\_id = 184 ) )
  
  # Converted for EXPLAIN
  
  # EXPLAIN /*!50100 PARTITIONS*/
  
  SELECT 184 as group\_id, contact\_a.id as id FROM civicrm\_contact contact\_a LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_111` ON contact\_a.id = `civicrm_group_contact_cache_111`.contact\_id LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_30` ON contact\_a.id = `civicrm_group_contact_cache_30`.contact\_id LEFT JOIN civicrm\_group\_contact\_cache `civicrm_group_contact_cache_8` ON contact\_a.id = `civicrm_group_contact_cache_8`.contact\_id WHERE ( ( `civicrm_group_contact_cache_30`.group\_id = 30 ) OR ( `civicrm_group_contact_cache_111`.group\_id = 111 ) OR ( `civicrm_group_contact_cache_8`.group\_id = 8 ) ) AND (contact\_a.is\_deleted = 0) AND contact\_a.id NOT IN (
  SELECT contact\_id FROM civicrm\_group\_contact
  WHERE civicrm\_group\_contact.status = 'Removed'
  AND civicrm\_group\_contact.group\_id = 184 ) )
  
  **Tags:** email, error
  
  > **Comments:**
  > **username_1**: We saw a similar issue in 4.6.4. Happened when we excluded or included more than a couple of groups in a mailing. Haven't seen it just trying to load one group. Our poor mans workaround was to do all of our excludes first in search builder / custom search and just load one group into the mailing. Seems to have gotten much rarer / possibly gone since upgrading to 4.7.13.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-05-17. Score: 1
  
  We had similar issues in 4.6.x, see <https://issues.civicrm.org/jira/browse/CRM-17213>. Let me know if you think this could be related to your problem.
  
  
  ---
  
  