Closed
Bug 1374641
Opened 7 years ago
Closed 7 years ago
Deploy Splice 2.1.30 to stage
Categories
(Firefox :: New Tab Page, enhancement)
Firefox
New Tab Page
Tracking
()
RESOLVED
FIXED
People
(Reporter: nanj, Assigned: jbuck)
References
Details
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•7 years 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 | ||
Comment 2•7 years 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•7 years 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
Closed: 7 years ago
Resolution: --- → FIXED
Updated•5 years ago
|
Component: Activity Streams: Application Servers → New Tab Page
You need to log in
before you can comment on or make changes to this bug.
Description
•