[allura:tickets] #8146 Index error with mongo 3.4

[Dave Brondsema <da...@brondsema.net>]

- **status**: open --> review
- **assigned_to**: Dave Brondsema
- **Comment**:

Fix on branch db/8146



---

** [tickets:#8146] Index error with mongo 3.4**

**Status:** review
**Milestone:** unreleased
**Created:** Tue Feb 28, 2017 04:18 PM UTC by Dave Brondsema
**Last Updated:** Tue Feb 28, 2017 04:18 PM UTC
**Owner:** Dave Brondsema


Running `paster setup-app` command with mongo 3.4 gives:

```
  File "/allura/Allura/allura/websetup/__init__.py", line 38, in setup_app
    bootstrap.bootstrap(command, conf, vars)
  File "/allura/Allura/allura/websetup/bootstrap.py", line 103, in bootstrap
    index.run([''])
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/paste/script/command.py", line 238, in run
    result = self.command()
  File "/allura/Allura/allura/command/show_models.py", line 240, in command
    self._update_indexes(db[name], indexes)
  File "/allura/Allura/allura/command/show_models.py", line 292, in _update_indexes
    collection.ensure_index(idx.index_spec, **idx.index_options)
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/pymongo/collection.py", line 1186, in ensure_index
    return self.create_index(key_or_list, cache_for, **kwargs)
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/pymongo/collection.py", line 1069, in create_index
    indexes=[index])
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/pymongo/database.py", line 439, in command
    uuid_subtype, compile_re, **kwargs)[0]
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/pymongo/database.py", line 345, in _command
    msg, allowable_errors)
  File "/allura-data/virtualenv/local/lib/python2.7/site-packages/pymongo/helpers.py", line 182, in _check_command_response
    raise OperationFailure(msg % errmsg, code, response)
OperationFailure: command SON([('createIndexes', u'basestats'), ('indexes', [{'sparse': False, 'unique': True, 'name': u'_id_1', 'key': SON([('_id', 1)])}])]) on namespace allura.$cmd failed: The field 'sparse' is not valid for an _id index specification. Specification: { ns: "allura.basestats", v: 1, sparse: false, unique: true, name: "_id_1", key: { _id: 1 } }
```

https://docs.mongodb.com/manual/release-notes/3.4-compatibility/#stricter-validation-of-index-specifications doesn't specifically mention sparse `_id`, but looks like that is the change that is causing this.

So I guess we need to omit `sparse: False` on `_id` fields, or any time it's false.


---

Sent from forge-allura.apache.org because dev@allura.apache.org is subscribed to https://forge-allura.apache.org/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://forge-allura.apache.org/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.