1347993 - Deploy Splice 2.1.26 to stage

Status: RESOLVED FIXED

(Firefox :: New Tab Page, enhancement)

Description

[Nan Jiang [:nanj]]

This is a database migration deploy, which contains following changes,

* migration/versions/18b96423fcf0_.py (For Alembic)
* ddl/migrations/redshift/1489612009.sql (For Redshift)

Note that this migration won't create any new table, but just "ALTER" existing tables. No read/write permission changes needed for this one.


Thanks,

Nan

Comment 1

[Jon Buckley [:jbuck]]

Deployed 2.1.26 to stage and ran the following commands:

$ cd /opt/splice/
$ SPLICE_IGNORE_REDSHIFT=true SPLICE_SETTINGS=splice_config.SpliceConfig /opt/splice/bin/python /opt/splice/bin/manage.py db upgrade
INFO  [alembic.env] Migrating database <default>
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 3473e3069558 -> 18b96423fcf0, empty message
INFO  [alembic.env] Migrating database stats
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 3473e3069558 -> 18b96423fcf0, empty message

$ psql < ddl/migrations/redshift/1489612009.sql
BEGIN
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COMMIT