Issue number jumping on increments of around a thousand when rebooting service.
Added by Daniel Schulz 3 days ago
Im running a redmine instance locally where different users are creating issues as tickets with some custom fields involved. When rebooting the database and application we are getting jumps in different increments but they end up landing in the same termination:
For example we create issues one through eight normally but then after rebooting we ended creating another one and that ends in 2003, then we created five more so we end up in 1008 but after a second reboot we jump again to 3003. and so on. we are running redmine in ms sql express and the most common reason for this issue seems to be identity caching for the ticket number column but we already turned identity cache off and it does not seem to help.
Are there any other fixes for this? we dont have thousands of users so this is a creation problem ocurring on a redmine/database level.