[jira] [Commented] (COUCHDB-1405) error generating document id with utc_random

["Nick North (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/COUCHDB-1405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204363#comment-13204363 ] 

Nick North commented on COUCHDB-1405:
-------------------------------------

I am unable to reproduce this on my 64-bit Windows 7 setup. The app I'm using creates a document containing the current system time as one of its fields, and using  utc_random to create document id (actually a slight variant, but it's using the utc_random code for the utc element). When I fetch the document back and extract the UTC time from the document id, it agrees with the system time field to a small fraction of a second, which is accounted for by the time taken to submit the document to CouchDb. Running this for ten thousand or so documents over a 15-hour period shows no drift in the times.

It's just possible that Hyper-V is affecting things in your case, though it feels unlikely. utc_random just takes the time from Erlang's clock which, I assume, gets it from the same place as a call to system time does. But virtualisation may do something odd there.

At the risk of asking a stupid question: is the system time that you are checking against the document id taken from the CouchDb server itself, or some other machine on the network? Your problem has all the symptoms of system clock drift between client and server machines. The test I ran above was with the document creating app on the CouchDb server itself so that the server time field in the document comes from the same system clock that is used to create the utc_random doc id.
                
> error generating document id with utc_random
> --------------------------------------------
>
>                 Key: COUCHDB-1405
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-1405
>             Project: CouchDB
>          Issue Type: Bug
>          Components: Database Core
>    Affects Versions: 1.1.1
>         Environment: Windows 7, 64-bit, running as virtual pc in hyper-v
>            Reporter: André Bögge
>
> I use the utc_random algorithm for generating document ids. So it's possible for me to calculate time and date out of the id in my client application. After running CouchDB for about a month i got a difference between system time and calculated time of id of about half an hour. I restarted the database and even then i got a difference about 1 minute.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira