Online Safety Community

How to Repair MySQL InnoDB Table That Has Issues?

When trying to run: delete IdentityRequest *

I get an error of sailpoint.tools.GeneralException: null index column for collection: sailpoint.object.IdentityRequest.items

Doing a select * from spt_identity_request_item where id is null; returns no results.

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. sailpoint

repair table spt_identity_request_item; yields a note of The storage engine for the table doesn't support repair

I've also tried the command:

sudo mysqlcheck --repair --databases identityiq -u identityiq -p

While it runs, it gives a bunch of notes of:

note : The storage engine for the table doesn't support repair

Is this command actually doing something to repair the issues? If not, is there a way to repair this and how?

Views: 52

▶ Reply to This

Take our poll!

Take our poll!

Events

Latest Activity

Roger Steven posted a blog post

Does WhatsApp show compliance with HIPAA requirements?

WhatsApp! Can life be imagined without this app on our mobile phones? When we have at the tip of our fingerprints an app with which we send out messages on everything from a family outing to an earthshattering political development day in and day out; why should we expect healthcare information to be excluded from WhatsApp messaging?One thing that is certain is that messaging about medical records on WhatsApp cannot be stopped. The fact that WhatsApp announced that it was introducing end-to-end…See More
5 hours ago
0 Comments
Mark Nilson posted events
9 hours ago
HrishikeshRam posted blog posts
1 more…
10 hours ago
Training Doyens posted events
11 hours ago

Forum

AI Machine Learning In Businesses How wоuld уоu define a small buѕinеѕѕ, thе number оf реrѕоnеl, thе size оf the budget, оr ѕаlеѕ?

How wоuld уоu define a small buѕinеѕѕ, thе number оf реrѕоnеl, thе size оf the budget, оr ѕаlеѕ?However you define уоur оwn ѕmаll business, it tоо can tаkе advantage оf thе AI/ …Continue

Tags: elite, crest, technologies, intelligence, Artificial

Started by emmablisa yesterday.

Connecting microstrategy to Hive

down vote…Continue

Started by kavya on Thursday.

Distracted Driving 1 Reply

****WARNING**** Despite the fact that this is a life event portrayed by actors, it's graphic. This video should be part of…Continue

Tags: texting, fatality, safety, car, driving

Started by Wendy. Last reply by Jen McDade Dec 5.

Safety update: OSHA announces fit-test procedures 1 Reply

Fabricators as well as other workers may be required to use respirators to protect themselves from inhaling fumes, particles, or dust when performing cutting, grinding, welding, coating, or painting,…Continue

Tags: online, training, Safety, workplace, PPE

Started by Safety Training International. Last reply by Jen McDade Dec 4.

Proper guarding protects workers: Six steps to focusing on your employees' needs 1 Reply

When people think of machine guarding, usually they think of devices to protect people from the moving parts on machinery.When people think of machine guarding, usually they think of devices to…Continue

Tags: training, compliance, PPE, Training, Safety

Started by Safety Training International. Last reply by Jen McDade Dec 4.

Badge

Loading…

Get Badge

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!