#1733 Project shard mongo indexes are not created by standard setup-app

unreleased
invalid
sf-4 (350)
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.

Related

Tickets: #1584

Discussion

  • Dave Brondsema

    Dave Brondsema - 2011-03-17

    Note that [#1584] will make this irrelevant, so maybe not worth our time addressing

     

    Related

    Tickets: #1584

  • Dave Brondsema

    Dave Brondsema - 2011-03-17
    • milestone: mar-24 --> limbo
     
  • Paul Sokolovsky

    Paul Sokolovsky - 2011-04-06
    • status: open --> invalid
     
  • Paul Sokolovsky

    Paul Sokolovsky - 2011-04-06

    Closing per Dave's suggestion.

     

Log in to post a comment.