1267382 - Deploy Splice 2.1.12 to stage

Status: VERIFIED FIXED

(Content Services Graveyard :: Tiles: Ops, defect)

Description

[Nan Jiang [:nanj]]

Please deploy Splice 2.1.12 to the stage tiles server, note that it's a (Redshift) database migration deploy, so we need to complete it as follows:

1. $ manage.py db upgrade
2. manually execute the "ddl/migrations/redshift/1461612090.sql" against the redshift database


Thanks,
Nan

Comment 1

[Daniel Thorn [:relud]]

deployed, but:

> BEGIN
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:3: ERROR:  ALTER COLUMN TYPE is not supported
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:5: ERROR:  ALTER COLUMN TYPE is not supported
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:6: ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:8: ERROR:  ALTER COLUMN TYPE is not supported
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:10: ERROR:  ALTER COLUMN TYPE is not supported
> psql:/opt/splice/ddl/migrations/redshift/1461612090.sql:11: ERROR:  current transaction is aborted, commands ignored until end of transaction block
> ROLLBACK

Comment 2

[Nan Jiang [:nanj]]

Thanks for the update, relud.

Looks like I've introduced some incompatible ddl statements for redshift. Will make a quick workaround for this change, and file a new deploy bug shortly.