Actions
Defect #17609
closed
The issue ID number increments a lot for no apparent reason (example 2 subsequent id's are 1299 and the next one is 2297)
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Invalid
Affected version:
Description
The issue ID number increments a lot for no apparent reason (example 2 subsequent id's are 1299 and the next one is 2297)
We have had the same issue again now, it jumped from 2362 to 3355.
The backend database we use is a SQL Server 2012 Express. Apart from that I do not see an entry in the log pointing to why it behaves like this.
Anyone has an idea how this happens/can happen ? Or how to avoid it in the future ?
Updated by Leonel Iturralde about 10 years ago
I found something about this
http://stackoverflow.com/questions/17587094/identity-column-value-suddenly-jumps-to-1001-in-sql-server
Updated by Marius BĂLTEANU over 6 years ago
- Status changed from New to Closed
- Resolution set to Invalid
I think that it is a problem generated by the SQL Server and not by Redmine. Please reopen if I'm wrong.
Actions