Body: <p>I am using CiviCRM wordpress version 5.12.3 - For some reason Civicrm_acl_contact_cache table got deleted</p>
  
  <p>I am sure no one has Database access (apart from me). But still the table got deleted. Also, it wasn't fully deleted when I SSH the server I was able to view the table (even I couldn't dump the DB). so, I dropped it through SSH and created again.</p>
  
  <p>I am not sure what triggered the table to drop in the database from front-end.</p>
  
  <p>Has anyone faced the same issue before?</p>
  
  <p>Thanks in advance 
  <br/>Ramesh Rajendran</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-02T11:24:58.187Z
Comments.Text: Do you have plenty of disk space?  I've seen weird things happen if you run out of disk space where MySQL stores it files.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-02T12:34:27.743Z
Comments.Text: Yes, Server has 100 GB Free space and 64 GB RAM
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-02T12:12:02.447Z
Comments.Text: I have just recently seen the same phenomenon - just the column definitions where still there, the contents file for the table was missing. This seems to have happened overnight with no user activity. A backup was created after the last activity and before this happened and the table was apparently empty. Currently I am unsure, how to proceed. Would like to hear if you got any more infos. (Using Civi 5.17.5 on WP with separate db)
Comments.UserDisplayName: Joachim
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-03T08:17:43.060Z
Comments.Text: @joachim I have given the answer in the question - you need to SSH and drop the table and create a new table - That should work - If you need more help let me know
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-03T18:30:04.890Z
Comments.Text: Thanks @Ramesh. While the database admin system of my hosting solution failed to even start, since the db was corrupted, it did indeed work accessing it directly and dropping/re-creating the table. However, I am still concerned about the fact that the database can even enter into this corrupted state. Currently, I have no idea what might be causing this - and apparently it is always the same table that gets impacted.
Comments.UserDisplayName: Joachim
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-06T09:36:09.570Z
Comments.Text: @joachim Are you still having this issue ?
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-06T18:29:49.887Z
Comments.Text: @Ramesh at the moment, it's working fine without any problems.
Comments.UserDisplayName: Joachim
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-24T08:49:24.360Z
Comments.Text: Today the issue appeared again, the table civicrm_acl_contact_cache got corrupted. On file system level, the '.frm' file was there, but the '.ibd' file was missing. There is hardly any activity on this db, also disk space is not a problem.
Comments.UserDisplayName: Joachim
Tags: <wordpress><database>
Title: Wordpress Civicrm_acl_contact_cache Table got Deleted
ThreadText: # Wordpress Civicrm_acl_contact_cache Table got Deleted
  
  (Asked by: username_0 on 2019-07-01)
  
  I am using CiviCRM wordpress version 5.12.3 - For some reason Civicrm\_acl\_contact\_cache table got deleted
  
  I am sure no one has Database access (apart from me). But still the table got deleted. Also, it wasn't fully deleted when I SSH the server I was able to view the table (even I couldn't dump the DB). so, I dropped it through SSH and created again.
  
  I am not sure what triggered the table to drop in the database from front-end.
  
  Has anyone faced the same issue before?
  
  Thanks in advance
    
  Ramesh Rajendran
  
  **Tags:** wordpress, database
  
  > **Comments:**
  > **username_1**: Do you have plenty of disk space?  I've seen weird things happen if you run out of disk space where MySQL stores it files.  
  > **username_0**: Yes, Server has 100 GB Free space and 64 GB RAM  
  > **username_2**: I have just recently seen the same phenomenon - just the column definitions where still there, the contents file for the table was missing. This seems to have happened overnight with no user activity. A backup was created after the last activity and before this happened and the table was apparently empty. Currently I am unsure, how to proceed. Would like to hear if you got any more infos. (Using Civi 5.17.5 on WP with separate db)  
  > **username_0**: @joachim I have given the answer in the question - you need to SSH and drop the table and create a new table - That should work - If you need more help let me know  
  > **username_2**: Thanks @Ramesh. While the database admin system of my hosting solution failed to even start, since the db was corrupted, it did indeed work accessing it directly and dropping/re-creating the table. However, I am still concerned about the fact that the database can even enter into this corrupted state. Currently, I have no idea what might be causing this - and apparently it is always the same table that gets impacted.  
  > **username_0**: @joachim Are you still having this issue ?  
  > **username_2**: @Ramesh at the moment, it's working fine without any problems.  
  > **username_2**: Today the issue appeared again, the table civicrm_acl_contact_cache got corrupted. On file system level, the '.frm' file was there, but the '.ibd' file was missing. There is hardly any activity on this db, also disk space is not a problem.  
  
  ---
  
  ## 0 answers
  
  