Robomongo: Creating an index does nothing

[JamesTheHacker]

OS: Ubuntu 14
RoboMongo Version: 0.9.0 RC9

I'm unable to create a unique index.

I right click on indexes for the collection, and press add new with the following details:

Name: _userid_
JSON: { "userid": 1 }

I check unique, and check the box to delete duplicates. I then press save. The box closes and nothing appears to be happening. There is nothing in the logs either.

[JamesTheHacker]

To add, it seemed to work if I deleted all the documents and set the index beforehand.

[juliashibalko]

@JamesTheHacker thanks for reporting!
I suppose that if you try to create unique index via shell (db.myCollectionName.createIndex({"userid": 1}, {name: "_userid_", unique: true})) just _before_ deleting all docs (as was described first), error "11000 duplicate key error index" will occur (https://docs.mongodb.com/manual/core/index-unique/#unique-index-and-missing-field)
Could you please try this and share result if you have some free minutes? It will help a lot with problem investigation.

JFYI: I create new issue Add/Edit Index: "Drop Duplicates" option should be disabled.., so if you're using Mongo 2.6 and higher, checkbox 'Drop duplicate' won't work at all.

[juliashibalko]

Checked in Robo3T 1.1 under Mac OS X 10.12 and Windows 10. Closing this issue as can't reproduce. Feel free to re-open the ticket in case.

[reduxdj]

This happens to me too. creating an index does nothing

[reduxdj]

Actually also, editing an index just deletes the index :/ I'm using Robo3T: 1.1.1, not sure if there's an error in the commands, why the UI doesn't show it, just closes.

[reduxdj]

And, yes, if you create an index on a new collection it works fine, it just doesn't work on larger collections with a few thousand documents.

[eseite47]

Was this issue ever resolved? I am having a similar experience: the index I was trying to edit on an existing collection simply disappeared and every attempt to re-add it a new index has done nothing. Any clues what may be happening?

[abhinavbom]

Facing similar issue. Creating index on an existing collection with over 10 million records results into nothing.

[abhinavbom]

I think the issue is with the key we want to index. I tried creating the key using MongoDB compass Community edition. It gave me the error message stating:

"WiredTigerIndex::insert: key too large to index, failing

In MongoDB, since 2.6, the total size of an index entry must be less than 1024 bytes as stated here:
https://docs.mongodb.com/manual/reference/limits/#Index-Key-Limit

Probably the error handling is having some issue in Robo 3T (The error in my case had the entire key being printed which was huge). The index doest get created and the error message doest show up.

[JohnSeals]

Did this ever get solved?

[nikmartin]

It still doesn't work for me in robo3t 1.3, although I can create indexes in mongo shell with no problem.