I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client app and if their HWID isn't in the database, it adds it. The app connects every 1-5 minutes and works flawlessy (if I delete their row while it's running, it re-adds it. If I delete the row, then run the app, it re-adds it again).
But for some reason, once the row goes missing by itself, it won't re-add until it decides it wants to (seems to be random times). I've looked around online and can only find information on things such as missing rows once tables have been converted from MyISAM to InnoDB - my tables were created as InnoDB tables.