If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

Deploy Splice 2.1.30 to stage

RESOLVED FIXED

Status

()

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

People

(Reporter: nanj, Assigned: jbuck)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

3 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
(Reporter)

Comment 1

3 months ago
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".


Thanks,
Nan
Assignee: nobody → jbuckley
(Reporter)

Updated

3 months ago
Blocks: 1374645
(Reporter)

Comment 2

3 months ago
Please apply data expiration policy as follows:

* 90 days for assa_performance_daily and assa_masga_daily
* 180 days for assa_sessions_daily and assa_events_daily

Regarding the "activity_stream" ddfs tag, let's keep 6 month of history for now.
(Assignee)

Comment 3

3 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;
GRANT
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
GRANT

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