1405662 - Deploy Splice 2.1.39 to prod

Status: RESOLVED FIXED

(Firefox :: New Tab Page, enhancement)

Description

[Nan Jiang [:nanj]]

This is a new database migration, which:

* Include a new migration: migrations/versions/153663fadcdb_.py
* Include a new schema: ddl/migrations/redshift/1505922169.sql

Please grant following permissions for the new table "ping_centre_main",

* Grant write permission to "infernyx"
* Grant read permission to "read_only", also "redash" in production. "pocket" doesn't need to access this table.

Comment 1

[Jon Buckley [:jbuck]]

$ cd /opt/splice/
$ cat version.json 
{
	"source": "https://github.com/mozilla/splice",
	"version": "2.1.39",
	"commit": "dda0ea6cafa6efa079e1f258dafbb8636e9add03"
}
$ 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 386a01af44c -> 153663fadcdb, 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 386a01af44c -> 153663fadcdb, empty message
$ psql < ddl/migrations/redshift/1505922169.sql
BEGIN
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COMMIT
$ psql
psql (9.2.23, server 8.0.2)
WARNING: psql version 9.2, server version 8.0.
         Some psql features might not work.
SSL connection (cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256)
Type "help" for help.

tiles=> grant insert on ping_centre_main to infernyx;
GRANT
tiles=> grant select on ping_centre_main to periscope, read_only;
GRANT