I am looking at some users' profiles using the API. From time to time I find what seem to me discrepancies between Ids and registration timestamps. For instance, if we look at the above records...
the first user (2302718) has registered 42 seconds after the second one (2302719) while, according to the timestamps, I was expecting the first one to have registered prior to the second one. In some instances there are hours between them.
PS - I have been told that users' ids are unique and auto-increment in sequence when users register to the project
I tested a bit with a local installation and am fairly sure (contrary to my original thoughts) that such inconsistencies are due to the rails frontends being out of sync time-wise which has historically happened now and then.
If you are seeing such behaviour with newly created accounts, please report them to the operations working group.
answered 16 Feb, 23:45
If the id and the creation date are not assigned in the same atomic operation, multiple threads can always create those "inconsistencies'. This could happen e.g. when the creation date is assigned by the software and the id by the database.
Can you explain why you think this is a problem ?
answered 17 Feb, 08:19