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: 47

▶ Reply to This

Take our poll!

Take our poll!

Events

Latest Activity

Russel Stuart posted a blog post

Steps towards achieving workplace conflict resolution

Conflict is one of the absolutely indispensable elements in a workplace. Whether the organization is doing business or not, it has to deal with conflicts. Humor aside, this is said simply to illustrate the enormity of the importance of conflict resolution at the workplace.Conflict is not something one runs away fromWe need to get one bare fact about conflict and conflict resolution right to start with: Conflict is not necessarily a bad thing. It is an inevitable result of the clash of people in…See More
3 hours ago
0 Comments
HrishikeshRam posted a blog post

Nebosh IGC Training Institute in India

The internationally recognized health and safety course include the NEBOSH International General Certificate (IGC).  While taking up this course, a delegate can be sure that the syllabus is designed by means of taking the students with no prior knowledge in health and safety to solid level knowledge in health and safety and much enough knowledge to pass in the final assessment will be taught by the tutor. To Know Nebosh Fees Details :…See More
5 hours ago
0 Comments
Adam Fleaming posted a blog post

The Truth About Global Trade and Logistics In a [Few] Little Words

Trade and logistics, despite its relatively recent development, has gone on to become a global one. It is one of the many industries that have benefited in immeasurable ways by the growth of technology and globalization. It is no exaggeration to say that trade and logistics has exploded following these developments.First, a basic understanding of the two:Global trade or international trade, as the term makes it rather simple to understand, is the exchange of commercial goods along international…See More
6 hours ago
0 Comments
Training Doyens posted an event
Thumbnail

STOP PISSING ME OFF! An Introduction to Conflict Resolution and Self-Management at 26468 E Walker Dr, Aurora, Colorado 80016

November 6, 2018 from 1pm to 2:30pm
OVERVIEWAfter attending this webinar participants will be able to see the difference between conflict and emotion and constructive argument and forward facilitation. By understanding the model of social styles and the fact that different people respond diversely to varying stimuli, participants…See More
6 hours ago
0 Comments

Forum

Road Safety

What can be the best measures for Road Safety?Continue

Started by Jen McDade Sep 27.

safety equipments in breweries 4 Replies

safety equipments in breweries -- kindly provide detailsContinue

Started by ajit. Last reply by Jen McDade Sep 24.

Unusual Safety Tips 10 Replies

Please share some unusual but genuine safety precautions.My unusual safety tips - Don't drink sweet fruity juice while driving in the night as it contains sugar and sugar slows down your blood…Continue

Started by Arnold Brame. Last reply by Jen McDade Sep 24.

Safety products 9 Replies

While working or at some work stations, employees are exposed to threats or at times suffer severe injuries. The safety of the employee should be the foremost priority. Safety equipment aids help in…Continue

Tags: equipments, and, products

Started by Enna Henry. Last reply by Jen McDade Sep 24.

Talend Application Integration

APPLICATION INTEGRATION:Talend ESB and Application Integration delivers agile real-time integration of applications and data.Heterogeneous Application and Data IntegrationTalend’s open source ESB…Continue

Tags: york, new, certification, training, talend

Started by nicolewells Sep 21.

Badge

Loading…

Get Badge

© 2018   Created by Safety Community.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!