[SERVER-9379] getIndexes returns duplicated indexes Created: 17/Apr/13 Updated: 10/Dec/14 Resolved: 20/May/13 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance |
| Affects Version/s: | 2.2.3 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Minor - P4 |
| Reporter: | Marcio Trindade | Assignee: | Thomas Rueckstiess |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | duplication, index | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Operating System: | Linux |
| Participants: |
| Description |
|
When I run the function "getIndexes" I got duplicated results for a specific index (account_id_1_list_ids_1_status_1) with the same key.
|
| Comments |
| Comment by Thomas Rueckstiess [ 08/May/13 ] | |||||
|
Hi Marcio, Thanks for the additional information and I'm glad to hear that you were able to fix the problem. Can I ask how you determined that the index was not working on the secondary? Even in stand-alone mode, it should not be possible to add an index again that is already existing. I've tried to reproduce your steps but without success. If you do find the log files covering these events, please let us know. Without them, unfortunately there is not much to go on to find out how you ended up with the multiple indexes. Best regards, | |||||
| Comment by Marcio Trindade [ 06/May/13 ] | |||||
|
Hi Thomas, 1 - I don't remember. PS. Let me try to explain how it's happen: Now it's ok because I removed stop mongod again, remove the index and create it again. Thank you, | |||||
| Comment by Thomas Rueckstiess [ 06/May/13 ] | |||||
|
Hi Marcio, We wouldn't expect the index to appear multiple times in the system.indexes collection. Are you aware of any issues that you had recently with this node? I.e. multiple restarts while an index may have been building? Can you also provide more information on your system:
It's difficult to say where the multiple entries came from. To fix the issue: If this is part of a replica set, can you check if the other nodes also have the multiple entries in their system.indexes collection on the emailmarketing_production database? If they don't, you could promote one secondary to primary, and resync this current node from it. Regards, | |||||
| Comment by Marcio Trindade [ 25/Apr/13 ] | |||||
|
Hi Dan, Here the result.
If you need something else please send it to me. Thank you | |||||
| Comment by Daniel Pasette (Inactive) [ 25/Apr/13 ] | |||||
|
Hi Marcio, can you post the results of running:
|