#1733 Project shard mongo indexes are not created by standard setup-app
invalid
General
nobody
2011-06-23
2011-03-16
No
Looking at both localdev and sandboxes, project shards' mongo indexes are not created with the standard setup. There's command "paster ensure_index" to create them, but that is not described in Allura docs, not apparently being run on sandbox setup.
To reproduce:
[root@psokolovsky-3024 ~]# mongo
> use project-data-t
switched to db project-data-t
> db.system.indexes.find()
{ "name" : "_id_", "ns" : "project-data-t.config", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.discussion", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.artifact_link", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.page_history", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.artifact_feed", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.wiki-globals", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.page", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.thread", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.globals", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.bin", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.forum", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.portal_config", "key" : { "_id" : 1 } }
{ "name" : "_id_", "ns" : "project-data-t.git-repository", "key" : { "_id" : 1 } }
The real fix here apparently should be to run ensure_index as part of standard "paster setup-app" sequence.
Note that [#1584] will make this irrelevant, so maybe not worth our time addressing
Related
Tickets:
#1584Closing per Dave's suggestion.