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. Any explanation? PS - I have been told that users' ids are unique and auto-increment in sequence when users register to the project asked 16 Feb '17, 16:45 jfd553 |
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 '17, 23:45 SimonPoole ♦ Yep, I understand the discrepancies may origin from multiple operations made either on the database and/or the rails frontends when someone register. Thank Simon.
(17 Feb '17, 09:43)
jfd553
|
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 '17, 08:19 escada 1
Right, as now understand that the process results from multiple treads or operations which may result in such inconsistencies. BTW, I do not think these inconsistencies are a problem, I was just curious to understand where they come from :-)
(17 Feb '17, 09:49)
jfd553
|