Defect #3349
closed
Wrong auto_increment issue ID
100%
Description
The first issue I submit in a fresh install gets issue ID 2. The second issues gets ID 4. The third 6, fourth 8, ...
So only even ID's are available and the odds are skipped. It should be an auto increment value if I look to the database.
- MySQL: 5.0.66sp1-enterprise-gpl-log
- Ruby: 1.8.6 (2008-08-11 patchlevel 287) [x86_64-linux] Ruby Enterprise Edition 20090421
- Rails: 2.3.2
- SVN: 1.5.5 (r34862)
- Redmine: 0.8.3
Updated by Jean-Philippe Lang about 16 years ago
Can you check in the issues table of your database if there's anything that is created with the missing ids (eg. 1, 3, 5...).
And please post your Redmine log with log level set to debug.
Updated by Jos Vermeulen about 16 years ago
- Nothing added with missing ids.
- I don't know how to create the logs. So if you could point me in the right direction I can give it to you.
Updated by Jos Vermeulen about 16 years ago
Just noticed that the same behavior reoccurs with the list of trackers, categories, ... .
Updated by Jos Vermeulen about 16 years ago
I can reproduce this in phpMyAdmin. So it seems that something is wrong with MySQL on that server
Updated by Jos Vermeulen about 16 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Not and issue in redmine.
The hosting company configured MySQL with variables
auto increment increment = 2
auto increment offset = 2
Updated by Jean-Philippe Lang about 16 years ago
- Status changed from Resolved to Closed
- Affected version (unused) deleted (
0.8.3) - Resolution set to Invalid
- Affected version deleted (
0.8.3)
Thanks for the feedback.