Deploy Splice 2.1.14 to stage

RESOLVED FIXED

Status

RESOLVED FIXED
2 years ago
2 years ago

People

(Reporter: nanj, Assigned: relud)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

2 years ago
This fixes the db migration script in 2.1.13.

To test this in stage,
* Drop table activity_stream_stats_daily and activity_stream_events_daily
* Execute following migration files in order:
  1. 1457402851.sql
  2. 1458766468.sql
  3. 1461612090.sql

If no error takes place in the process, then the last migration works.
(Reporter)

Updated

2 years ago
Assignee: nobody → dthorn
(Assignee)

Comment 1

2 years ago
> tiles=> \i ddl/migrations/redshift/1457402851.sql
> BEGIN
> psql:ddl/migrations/redshift/1457402851.sql:3: INFO:  Table "activity_stream_stats_daily" does not exist and will be skipped
> DROP TABLE
> CREATE TABLE
> COMMIT
> tiles=> \i ddl/migrations/redshift/1458766468.sql
> BEGIN
> ALTER TABLE
> UPDATE 0
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> CREATE TABLE
> COMMIT
> tiles=> \i ddl/migrations/redshift/1461612090.sql
> BEGIN
> ALTER TABLE
> UPDATE 0
> ALTER TABLE
> UPDATE 0
> UPDATE 0
> ALTER TABLE
> UPDATE 0
> ALTER TABLE
> UPDATE 0
> UPDATE 0
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> COMMIT
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.