Under sql7, we are using an integer identity field that has started skipping
values with the latest release. There are no rollbacks on insert xactions,
or any uncommitted insert xactions. We are not deleting records. All
attempted inserts go thru (to the best of my knowlege). The skipping
appears to happen randomly, and there are about 100 skips out of 1000 new
inserts. Our app is written in java and we use threads heavily
(multiprocessing) to perform db updates and inserts.
I am curious about other conditions which can cause the unsequential values.
I know ident fields are only meant to keep the row unique, however, I would
like to understand what is happening internally.