1340292 - Deploy Splice 2.1.25 to prod

Status: RESOLVED FIXED

(Firefox :: New Tab Page, defect)

Description

[Nan Jiang [:nanj]]

This is a database (Redshift) migration deploy, which contains following changes:

* A new migration in "migrations/versions/3473e3069558_.py" for Alembic, and "ddl/migrations/redshift/1487106710.sql" for Redshift
* Three new tables: activity_stream_mobile_stats_daily, activity_stream_mobile_events_daily, ping_centre_test_pilot

To all those new tables, please grant the write permission for "infernyx", and the read permission for "read_only" and "re:dash(periscope)".

Comment 1

[Jon Buckley [:jbuck]]

Deployed splice 2.1.25 to prod and ran the following db migration commands:

$ 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 3addd85ccbc9 -> 4aada554f5e4, empty message
INFO  [alembic.runtime.migration] Running upgrade 4aada554f5e4 -> 3473e3069558, 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 3addd85ccbc9 -> 4aada554f5e4, empty message
INFO  [alembic.runtime.migration] Running upgrade 4aada554f5e4 -> 3473e3069558, empty message

$ psql < ddl/migrations/redshift/1487106710.sql
BEGIN
INFO:  Table "ping_centre_test_pilot" does not exist and will be skipped
DROP TABLE
INFO:  Table "activity_stream_mobile_events_daily" does not exist and will be skipped
DROP TABLE
INFO:  Table "activity_stream_mobile_stats_daily" does not exist and will be skipped
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
COMMIT

$ psql
tiles=> GRANT SELECT ON TABLE ping_centre_test_pilot, activity_stream_mobile_events_daily, activity_stream_mobile_stats_daily TO periscope;
GRANT
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
ERROR:  permission denied for relation loadview
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public TO infernyx;
ERROR:  permission denied for relation loadview

Deploy completed