The topic skipped an id

iCosmo

The topic skipped an id, from 85_87, 86 is gone, I have not deleted the theme, check MySQL is also 85_87.

clarkwinkelmann

iCosmo could you explain in more details ?

Are you talking about something that happened on one of your forum ? What did you do, what was expected ?

Discussion IDs are usually continuous, but of course a discussion could have been deleted.

iCosmo

clarkwinkelmann I posted the discussion normally, I never deleted the discussion but it skipped an id. Viewing the discussion ID in MySQL also skips one. I do not know why.

iCosmo

Discussion id86 is missing ，After discussing id85 I sent a discussion ID of 87.

clarkwinkelmann

iCosmo Are you sure nobody created discussion 86 and permanently deleted it afterward ?

I suppose there could also be multiple MySQL reasons for an ID to be skipped. Maybe a backup happened at that time, or maybe some parallel queries caused the auto increment to skip 1, or maybe something else ? I'm not sure those example could actually cause it, but yeah. MySQL auto-increment are probably guaranteed to be incremental, but I don't think they are guaranteed to never skip any number.

iCosmo

clarkwinkelmann I am sure I have not deleted it because only I have permanent delete permission.