Deploy Splice 2.1.30 to prod

RESOLVED FIXED

Status

()

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

People

(Reporter: nanj, Assigned: jbuck)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

4 months ago
Note this deploy has a database schema migration for Redshift:

* Include a new migration: migration/version/55df5c7c41fd_.py
* Include a new schema: ddl/migrations/redshift/1497554727.sql

Please grant write access to inferno for the following tables:

* assa_sessions_daily
* assa_events_daily
* assa_performance_daily
* assa_masga_daily

In prod, we'd like to give read access to "read-only" and "redash".

I think we've already modified the data expiration scripts both for DDFS and Redshift in Puppet-config. Correct me if I'm wrong.

Thanks,
nanj
(Reporter)

Updated

4 months ago
Assignee: nobody → jbuckley
(Reporter)

Updated

4 months ago
Blocks: 1379759
(Assignee)

Comment 1

4 months ago
$ cd /opt/splice/
$ cat version.json
{
	"source": "https://github.com/mozilla/splice",
	"version": "2.1.30",
	"commit": "09aeced05db3b309338e488a21fc39e21ab8197b"
}
$ 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 25c409de54cc -> 55df5c7c41fd, 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 25c409de54cc -> 55df5c7c41fd, empty message
$ psql < ddl/migrations/redshift/1497554727.sql
BEGIN
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
COMMIT
$ psql
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public to infernyx;
ERROR:  permission denied for relation loadview
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
ERROR:  permission denied for relation loadview
tiles=> GRANT SELECT ON TABLE assa_sessions_daily, assa_events_daily, assa_performance_daily, assa_masga_daily TO periscope;
GRANT

Deploy complete!
Status: NEW → RESOLVED
Last Resolved: 4 months ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.