Skip to content

CAPI 1.219.0

Latest
Latest

Choose a tag to compare

View all tags
@ari-wg-gitbot ari-wg-gitbot released this 16 Oct 19:15
1.219.0
fa01714

Highlights

bigint Migration

With this release the migration of the primary key id column type from int to bigint will be completed for the 'jobs', 'delayed_jobs', 'app_usage_events' and 'service_usage_events' tables on PostgreSQL databases (if not opted-out with the ccdb.skip_bigint_id_migration flag during step 1).

  • The migration is implemented in multiple steps and does not require any downtime.
  • Data in the 'jobs' and 'delayed_jobs' tables are cleaned up automatically (default retention time: 90 days). For the 'app_usage_events' and 'service_usage_events' tables, the retention time is 31 days. In case these time periods have not passed since the deployment of CAPI 1.214.0 / cf-deployment v51.2.0, the migration will fail in a pre-check phase. Operators then have to manually run a rake task to backfill the transitional id_bigint column before being able to re-run the migration: 
    bosh -d cf ssh api/0
sudo -i
source /var/vcap/jobs/cloud_controller_ng/bin/ruby_version.sh
cd /var/vcap/packages/cloud_controller_ng/cloud_controller_ng
# run for all tables where backfilling is not complete: jobs, delayed_jobs, app_usage_events, service_usage_events
bundle exec rake db:bigint_backfill[jobs]
# or with a given batch size (instead of 10.000)
bundle exec rake db:bigint_backfill[jobs,1000]
# or with a given batch size and number of iterations (otherwise: until everything has been processed)
bundle exec rake db:bigint_backfill[jobs,1000,10]

CC API Version: 2.269.0 and 3.204.0

Service Broker API Version: 2.15

CAPI Release

Dependency Updates

Cloud Controller

Dependency Updates

code.cloudfoundry.org/cc-uploader

Dependency Updates

code.cloudfoundry.org/tps

Dependency Updates

Cloud Controller Database Migrations

Pull Requests and Issues

Contributors

jochenehret, moleske, and 4 other contributors
Assets 3
Loading