Using MongoDB to update old projects with new compute node information

Problem

If you have installed new compute node and you don't have access to the old compute node, you could not access the old projects which are pointing to old compute node.

Solution

You need to update your old projects with your new compute node's ObjectID using Mongodb.

1. To find the compute node information run the following Mongodb queries:

mongo
use wakari
db.projects.find( { "name" : "<OLD PROJECT_NAME>" }, { "_id" : 0, "fr.resource_id" : 1})

Replace <OLD PROJECT_NAME> with your old project name. The above query gives the ObjectId of the compute node associated with an old project.

2. To get the new compute node's ObjectID, run the above query replacing<OLD PROJECT_NAME> with any new project name.

mongo
use wakari
db.projects.find( { "name" : "<NEW PROJECT_NAME>" }, { "_id" : 0, "fr.resource_id" : 1})

The above query gives the ObjectId of the compute node associated with a new project.

3. Now update your old project compute node's ObjectId with new compute node's Objectid.

mongo
use wakari
db.projects.update({ "name" : "OLD PROJECT NAME" }, { "$set" : { "fr.resource_id" : ObjectId("5a9d6dcdcf8c4610c5de8f78") }})

Replace 5a9d6dcdcf8c4610c5de8f78 with your new compute node's ObjectId from Step 2 and <OLD PROJECT_NAME> with your old project name.

To update all old project's ObjectID with the new one in a single step, run the following query:

mongo
use wakari
db.projects.update( { "fr.resource_id" : ObjectId("5a32819c06bad38ed4360f95") }, { "$set" : { "fr.resource_id" : ObjectId("5a9d6dcdcf8c4610c5de8f78")}}, { "multi" : true })

Replace 5a32819c06bad38ed4360f95 with your old compute node's ObjectId from step 1 and 5a9d6dcdcf8c4610c5de8f78 with your new compute node's ObjectId from Step 2.