Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-725

ISODate FailedToParse in tools query option

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None

      Running the following command leads to an error:

      mongodump -d myDB -c data -q "{'timestampStart':{\$gte: ISODate('2013-09-01T12:00:00Z'),\$lte: ISODate('2013-09-01T12:01:00Z')}}" -o tmp

assertion: 16619 code FailedToParse: FailedToParse: Bad characters in value: offset:24

      Also if I escape the command this way it failes:

      mongodump -d datamanagement -c data -q '{timestampStart: {$gte: ISODate("2013-09-01T12:00:00Z"),$lte: ISODate("2013-09-01T12:01:00Z")}}' -o tmp

assertion: 16619 code FailedToParse: FailedToParse: Bad characters in value: offset:23

      And it seems I'm not the only one having these problems see http://stackoverflow.com/questions/19805738/mongodump-range-query-on-timestamp-filed-raising-failedtoparser-error

      Also there is another Bug (SERVER-11721) which documents this bug. But sadly no solution was provided.

            Assignee:
            shraya.ramani Shraya Ramani
            Reporter:
            mkappeller Matthias Kappeller
            Votes:
            6 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: