BUG: Bug with reindexing on the index with a non-unique index will now raise a ValueError

closes #4746