This is version 2.3 of the AWS Elemental Delta documentation. This is the latest version. For prior versions, see the Previous Versions section of AWS Elemental Delta Documentation.
Step B: (Live to VOD and VOD Catalog Only) Clean the Database
Delta version 2.2 included a number of improvements to the live-to-VOD and ive-to-VOD catalog features. To take full advantage of these improvements, clean the database and do a full vacuum on each node prior to upgrading.
This process can take multiple hours to complete. Make sure you perform cleanup within a maintenance window.
-
Run the following cleanup scripts
cd /opt/elemental_se/web/vendor/gems/delta/script/
./clean-orphans.rb --clean-orphaned-filters
If you're on Delta version 2.0 or later and use live-to-VOD catalog, use the following script as well.
cd /opt/elemental_se/web
RAILS_ENV=production /opt/elemental-ruby/bin/rails runner ./vendor/gems/delta/script/clean_l2vc_orphans.rb
-
Wait for segment cleanup to complete.
To view progress, navigate to the Delta Content Deletion graph on the Stats tab in the Delta web interface. Wait for Delta to reestablish a normal 60 second cleanup cadence. This indicates that the content files on the disk that were bound to the leaked filters have been cleaned up.
-
Stop elemental_se using the following command.
sudo service elemental_se stop
-
Do a full vacuum of the database to recover any wasted space. Use the following commands.
psql web_production
vacuum full;
Note You get a number of “superuser” warnings at this point. Ignore these.
\q
-
Continue with the upgrade process.