Step B: (Live to VOD and VOD Catalog Only) Clean the Database - AWS Elemental Delta

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.

Warning

This process can take multiple hours to complete. Make sure you perform cleanup within a maintenance window.

  1. 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

  2. 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.

  3. Stop elemental_se using the following command.

    sudo service elemental_se stop

  4. 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

  5. Continue with the upgrade process.