Deploy Splice 2.1.25 to prod

RESOLVED FIXED

Status

()

Firefox
Activity Streams: Application Servers
RESOLVED FIXED
8 months ago
8 months ago

People

(Reporter: nanj, Assigned: jbuck)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

8 months ago
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)".
(Reporter)

Updated

8 months ago
Assignee: nobody → jbuckley
(Reporter)

Updated

8 months ago
Blocks: 1340293
(Assignee)

Comment 1

8 months ago
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
Status: NEW → RESOLVED
Last Resolved: 8 months ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.