Skip to content

Merge hotfix/release-19286bf into /eclipseFdn/open-vsx.org main branch

PR: https://github.com/EclipseFdn/open-vsx.org/pull/1094

Before deploying to staging, reset the database:

-- Reset migration 1.23
DROP TABLE public.extract_resources_migration_item;

-- Reset migration 1.24
ALTER TABLE extension DROP COLUMN published_date;
ALTER TABLE extension DROP COLUMN last_updated_date;

-- Rerun database migrations
DELETE FROM flyway_schema_history WHERE version = '1.23' OR version = '1.24';

If the deployment to staging runs without exception (maybe let it run for 5 min), then it can be deployed to production.
Before deploying to production:

  • Please make a database backup (just to be safe).
  • If migrations 1.23 and 1.24 have run to completion on production (SELECT * FROM flyway_schema_history WHERE version = '1.23' OR version = '1.24';), then use the same database script as above.
Edited by Aart van Baren