NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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...

  • user id="2302718" ... account_created="2014-08-31T21:44:43Z"
  • user id="2302719" ... account_created="2014-08-31T21:44:01Z"

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's gravatar image

accept rate: 0%

edited 16 Feb '17, 16:46

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.

permanent link

answered 16 Feb '17, 23:45

SimonPoole's gravatar image

SimonPoole ♦
accept rate: 18%

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 ?

permanent link

answered 17 Feb '17, 08:19

escada's gravatar image

accept rate: 21%


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

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 16 Feb '17, 16:45

question was seen: 2,258 times

last updated: 17 Feb '17, 09:49

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum