title: How to Repair MySQL InnoDB Table That Has Issues?
body: <p>Our company is using SailPoint IIQ for its IAM solution. </p>
  
  <p>When trying to run:
  <code>delete IdentityRequest *</code> </p>
  
  <p>I get an error of <code>sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.items</code></p>
  
  <p>Doing a <code>select * from spt_identity_request_item where id is null;</code> returns no results. </p>
  
  <p>I'm reaching for straws and have attempted to repair the table, in case that is what is causing the issue. The table types they use for their db is innodb. </p>
  
  <p><code>repair table spt_identity_request_item;</code> yields a note of <code>The storage engine for the table doesn't support repair</code></p>
  
  <p>I've also tried the command:</p>
  
  <p><code>sudo mysqlcheck --repair --databases identityiq -u identityiq -p</code></p>
  
  <p>While it runs, it gives a bunch of notes of:</p>
  
  <p><code>note     : The storage engine for the table doesn't support repair</code></p>
  
  <p>Is this command actually doing something to repair the issues? If not, is there a way to repair this and how?</p>