Integration

We just ran into an unexplained occurrence using a sequence table.

Suddenly it started assigning id number millions higher than the sequence it was previously filling. As you can see in the log the original range was in the 19 million area and then it began inserting values in the 28 million range.

Here is the id sequence it put in (I realize these are not exactly sequential because it does not commit them in the same order it allocates them.)

Previous transaction
many ids, the last one is...
19712292

Problematic transaction
28064436 ---> ???
19741496
19728823
19742100
19741852
28064408 ---> ???
19726424
28064433 ---> ???
19737253
etc...

I have no idea where these 28 million series numbers came from. It was a large transaction but I certainly did not insert 9 million rows.