Answers.Body: <p>I encountered this today, and it was because my maximum temp table size in MySQL was set too low.  The solution I found (<a href="https://stackoverflow.com/a/27830218/2832108">https://stackoverflow.com/a/27830218/2832108</a>) was to edit my <code>/etc/my.cnf</code> to increase the values of <code>tmp_table_size</code> and <code>max_heap_table_size</code>.  Assuming you're using <code>innodb_table_per_file</code> (and if you aren't you should!) this is likely your problem (unless you ran out of space in your temp directory, in which case that's your problem).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-01T16:37:37.530Z
Answers.LastActivityDate: 2021-10-01T16:37:37.530Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Your message says this several times:</p>
  
  <pre><code>[nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
  </code></pre>
  
  <p>See <a href="https://dev.mysql.com/doc/refman/5.6/en/server-error-reference.html#error_er_record_file_full" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.6/en/server-error-reference.html#error_er_record_file_full</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-15T17:13:25.520Z
Answers.LastActivityDate: 2018-11-15T17:13:25.520Z
Answers.UserDisplayName: Aidan
Body: <p>I try to run Contact Logging Report, but I get an error message about there are no data in the logging table (Detailed logging is enabled, in the MySQL tables there are a lot of data, and on the Contact's Activity log tab I can see a lot of entries). The CiviCRM Log Viewer extension gives the following error: </p>
  
  <pre><code>[info] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; handle
          )
  
      [code] =&gt; -1
      [message] =&gt; DB Error: unknown error
      [mode] =&gt; 16
      [debug_info] =&gt; INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
      [type] =&gt; DB_Error
      [user_info] =&gt; INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
      [to_string] =&gt; [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]"]
  )
  </code></pre>
  
  <p>What's wrong? </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-14T21:50:16.967Z
Comments.Text: It would be really helpful if you could add your version of Civi and the CMS, just so people know in case they want to try to replicate your issue.
Comments.UserDisplayName: Lesley Carter - BackOffice
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-16T08:24:32.880Z
Comments.Text: Sorry. Drupal7, CiviCRM 5.7.0.
Comments.UserDisplayName: Pál Rudan
Tags: <reports><db-logging>
Title: Contact Logging Report crash - the table is full
ThreadText: # Contact Logging Report crash - the table is full
  
  (Asked by: username_0 on 2018-11-14)
  
  I try to run Contact Logging Report, but I get an error message about there are no data in the logging table (Detailed logging is enabled, in the MySQL tables there are a lot of data, and on the Contact's Activity log tab I can see a lot of entries). The CiviCRM Log Viewer extension gives the following error:
  
  ```
  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => handle
          )
  
      [code] => -1
      [message] => DB Error: unknown error
      [mode] => 16
      [debug_info] => INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
      [type] => DB_Error
      [user_info] => INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
      [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO civicrm_temp_civireport_logsummary SELECT entity_log_civireport.id as log_civicrm_entity_id, 1, entity_log_civireport.log_action as log_civicrm_entity_log_action, 'log_civicrm_contact' as log_civicrm_entity_log_type, entity_log_civireport.log_user_id as log_civicrm_entity_log_user_id, entity_log_civireport.log_date as log_civicrm_entity_log_date, modified_contact_civireport.display_name as log_civicrm_entity_altered_contact, modified_contact_civireport.id as log_civicrm_entity_altered_contact_id, entity_log_civireport.log_conn_id as log_civicrm_entity_log_conn_id, modified_contact_civireport.is_deleted as log_civicrm_entity_is_deleted, altered_by_contact_civireport.display_name as altered_by_contact_display_name  
  FROM `c5civicrm_crm`.log_civicrm_contact entity_log_civireport
  
  INNER JOIN civicrm_contact modified_contact_civireport
          ON (entity_log_civireport.id = modified_contact_civireport.id )
  LEFT  JOIN civicrm_contact altered_by_contact_civireport
          ON (entity_log_civireport.log_user_id = altered_by_contact_civireport.id) WHERE ( 1 )  AND (entity_log_civireport.log_action != 'Initialization') GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id  ORDER BY entity_log_civireport.log_date DESC  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]"]
  )
  
  ```
  
  What's wrong?
  
  **Tags:** reports, db-logging
  
  > **Comments:**
  > **username_1**: It would be really helpful if you could add your version of Civi and the CMS, just so people know in case they want to try to replicate your issue.  
  > **username_0**: Sorry. Drupal7, CiviCRM 5.7.0.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2021-10-01. Score: 2 | Accepted answer
  
  I encountered this today, and it was because my maximum temp table size in MySQL was set too low. The solution I found (<https://stackoverflow.com/a/27830218/2832108>) was to edit my `/etc/my.cnf` to increase the values of `tmp_table_size` and `max_heap_table_size`. Assuming you're using `innodb_table_per_file` (and if you aren't you should!) this is likely your problem (unless you ran out of space in your temp directory, in which case that's your problem).
  
  
  ---
  
  ### Answer by username_3 on 2018-11-15. Score: 2
  
  Your message says this several times:
  
  ```
  [nativecode=1114 ** The table 'civicrm_temp_civireport_logsummary' is full]
  
  ```
  
  See <https://dev.mysql.com/doc/refman/5.6/en/server-error-reference.html#error_er_record_file_full>
  
  
  ---
  
  