Answers.Body: <p>I looked into this for Eric. The backtrace for the error was </p>
  
  <pre><code>sites/all/modules/civicrm/packages/DB/mysql.php(895): DB_common-&gt;raiseError(-1, NULL, NULL, NULL, "1114 ** The table 'I_1884' is full"
  </code></pre>
  
  <p>The mailing job is trying to create a temporary table of all the email addresses, but it can't. This is a result of the max_heap_table_size being set to low in the mysql config file. The default is 16 mb. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-18T16:28:37.710Z
Answers.LastActivityDate: 2015-12-18T16:28:37.710Z
Answers.UserDisplayName: Tommy B
Answers.Body: <p>I was able to 'fix' the issue by simply deleting all the groups (I didn't have any previous mailings in here) from the Recipients field and then re-adding them. Make no other edits before the estimated number of recipients finishes, and the draft is saved. I was able to send a test email successfully after that. The mailing list this happened with to me is ~585 contacts.</p>
  
  <p>NOTE: I just had this error pop up and found this Stack Exchange question from a Google search of the error message.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-17T23:15:07.740Z
Answers.LastActivityDate: 2015-11-17T23:27:40.847Z
Answers.LastEditDate: 2015-11-17T23:27:40.847Z
Answers.UserDisplayName: Evan
Body: <p>I'm unable to send and/or produce test emails for large mailings. This seems to be a result of CiviMail not completing the recipient estimation process. Attempting a test email while it's stuck on "estimating" gives this error:</p>
  
  <pre><code>Error in call to Mailing_send_test : Error in call to MailingJob_create : DB Constraint Violation - possibly mailing_id should possibly be marked as mandatory for this API. If so, please raise a bug report
  </code></pre>
  
  <p>This appears to happen in the neighborhood of 4500 recipients and above.</p>
  
  <p>[I have seen reports that similar issues were resolved in version 4.6.3, but this error occurred in 4.6.9]</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-18T16:40:15.963Z
Comments.Text: See my accepted solution for Drupal Watchdog Error.
Comments.UserDisplayName: Eric H
Tags: <civimail><mysql>
Title: CiviMail recipient count stuck on Estimating
ThreadText: # CiviMail recipient count stuck on Estimating
  
  (Asked by: username_0 on 2015-10-09)
  
  I'm unable to send and/or produce test emails for large mailings. This seems to be a result of CiviMail not completing the recipient estimation process. Attempting a test email while it's stuck on "estimating" gives this error:
  
  ```
  Error in call to Mailing_send_test : Error in call to MailingJob_create : DB Constraint Violation - possibly mailing_id should possibly be marked as mandatory for this API. If so, please raise a bug report
  
  ```
  
  This appears to happen in the neighborhood of 4500 recipients and above.
  
  [I have seen reports that similar issues were resolved in version 4.6.3, but this error occurred in 4.6.9]
  
  **Tags:** civimail, mysql
  
  > **Comments:**
  > **username_0**: See my accepted solution for Drupal Watchdog Error.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-12-18. Score: 2 | Accepted answer
  
  I looked into this for username_0. The backtrace for the error was
  
  ```
  sites/all/modules/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-1, NULL, NULL, NULL, "1114 ** The table 'I_1884' is full"
  
  ```
  
  The mailing job is trying to create a temporary table of all the email addresses, but it can't. This is a result of the max\_heap\_table\_size being set to low in the mysql config file. The default is 16 mb.
  
  
  ---
  
  ### Answer by username_2 on 2015-11-17. Score: 3
  
  I was able to 'fix' the issue by simply deleting all the groups (I didn't have any previous mailings in here) from the Recipients field and then re-adding them. Make no other edits before the estimated number of recipients finishes, and the draft is saved. I was able to send a test email successfully after that. The mailing list this happened with to me is ~585 contacts.
  
  NOTE: I just had this error pop up and found this Stack Exchange question from a Google search of the error message.
  
  
  ---
  
  