Ticket Increment after Reboot/Restart

RT Users
1

Good Morning,

RT 4.2.12 on Debian/MySQL

I have an odd situation where my ticket numbers seem to jump
significantly after a restart of services or a reboot of the server.

For example:

40060 40059 40058 40057 40056 32988 29893 25564 24217 24216 24215 24214
24213 20555 20554 20553 20552
And again previously:

19746 19727 19725 19717 19706 19684 18421 16252 13050 12989 12934 12886
12885 12878 12877 11916 11363 11154 10669 9868 9867

Thoughts appreciated,

Thanks,

Trev

2

Good Morning,

RT 4.2.12 on Debian/MySQL

I have an odd situation where my ticket numbers seem to jump
significantly after a restart of services or a reboot of the server.
If you were using Oracle I would say that Oracle is caching sequence
numbers and that would be the reason for the jumps, although the jumps
would only be 10 or 20 numbers, from memory thus not sure.
Maybe MySQL is also caching and thus it will skip a certain amount of
numbers.

Joop