How Do I Upgrade MongoDB to version 4.2 from 3.2?

What should I do if I have any issues while following these steps?

If at any point the database refuses to start, check DeadlineDatabase10\mongo\data\logs\log.txt for a possible explanation.

If it's not clear in the log what is going wrong, please send that log along with how far you've gotten in these steps to Thinkbox Support by creating a new support request.

Steps overview:

1. Create file-system backup.

2. Dump database with the mongodump tool.

3. Run the Deadline Repository installer and install a new database.

4. Restore database with mongorestore tool.

1. Create a file-system backup.

First save a copy of your DeadlineDatabase10 folder elsewhere on the computer. If anything goes wrong you can use this to recover back to your existing setup. Name it DeadlineDatabase10_backup so it's easy to find later.

To recover, delete the contents of the DeadlineDatabase10 folder and replace it with the contents of this DeadlineDatabase10_backup folder.

2. Dump the database with mongodump

We're going to export the data from your database into a file. If you'd like more information on the mongodump command, refer to the mongodump documentation.

The command is different depending on if your database requires TLS/SSL or not. Replace the data in the <> characters with your information.

TLS/SSL:

mongodump --out="<Archive location>" --db "deadline10db" --host "<hostname of database machine>" --port "27100" --ssl --sslPEMKeyFile "<DeadlineDatabase10\certs\mongo_client.pem>" --sslCAFile "<\DeadlineDatabase10\certs\ca.crt>"

No TLS/SSL:

mongodump --out="<Archive location>" --db "deadline10db" --host "<hostname of database machine>" --port "27100"

If these flags don't work, check the deadline_mongo connection script we provide to see what your settings should be:

Windows: C:\DeadlineDatabase10\mongo\application\bin\deadline_mongo
Linux: /opt/Thinkbox/DeadlineDatabase10/mongo/application/bin/deadline_mongo
Mac: /Applications/Thinkbox/DeadlineDatabase10/mongo/application/bin/deadline_mongo

The flags used in the deadline_mongo script cannot be copied exactly but they should help guide you in the right direction.

3. Run the Deadline Repository and install a new Database

Go through the Repository installer but be sure to pick "Create new database". There will be a couple of warnings including that there is an existing database and about how the existing database will be backed up. This is expected.

4. Restore database with mongorestore

Now we are going to import the database dump we created earlier and fill the new database with your existing data. If you'd like more information on the mongorestore command, refer to the mongorestore documentation.

The command is different depending on if your database requires TLS/SSL or not. Replace the data in the <> characters with your own. This will be using the newly installed 4.2 executable, not the ones from your old 3.2 installation. The dump file itself will be compatible between the two.

TLS/SSL:

mongorestore --dir="<Archive location>" --port "27100" --drop --ssl --sslPEMKeyFile "<DeadlineDatabase10\certs\mongo_client.pem>" --sslCAFile "<\DeadlineDatabase10\certs\ca.crt>"

No TLS/SSL:

mongorestore --dir="<Archive location>" --port "27100" --drop

5. Test upgrade

To test, open a Monitor to check if your job queue and settings have been successfully imported. If it seems that the import has failed you must:

1.Stop the database.

To do that in a command prompt run the appropriate command for your operating system.

Windows:

sc stop Deadline[VERSION]DatabaseService

Linux:

sudo service deadline[VERSION]db stop 

MacOS:

sudo launchctl unload /Library/LaunchDaemons/org.mongodb.mongod_Deadline[VERSION]DatabaseService.plist

where [VERSION] is the MAJOR version number of Deadline, such as: 10.

2. Delete the contents of the DeadlineDatabase10 folder and replace it with the contents of the DeadlineDatabase10_backup folder you created at the start of these steps.

3. Start the database again.

To do that in a command prompt run the appropriate command for your operating system.

Windows:

sc start Deadline[VERSION]DatabaseService

Linux:

sudo service deadline[VERSION]db start

MacOS:

sudo launchctl load /Library/LaunchDaemons/org.mongodb.mongod_Deadline[VERSION]Database.plist

And you're done!