Deploy Splice 2.1.29 to stage

RESOLVED FIXED

Status

()

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

People

(Reporter: nanj, Assigned: jbuck)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

6 months ago
Deploy runs as follows:

* Drop the table "activity_stream_impression_daily" and "ss_impression" in RS
* Re-run the sql file in release 2.1.28(https://bugzilla.mozilla.org/show_bug.cgi?id=1359884)
* Re-grant the permission as specified in 2.1.28
(Reporter)

Updated

6 months ago
Assignee: nobody → jbuckley
(Assignee)

Comment 1

6 months ago
$ cd /opt/splice/
$ cat version.json
{
	"source": "https://github.com/mozilla/splice",
	"version": "2.1.29",
	"commit": "2ec5d5eb3827bd522a77ddd28e314dcc9e8a623c"
}
$ psql
tiles=> DROP TABLE activity_stream_impression_daily;
DROP TABLE
tiles=> DROP TABLE ss_impression;
DROP TABLE
tiles=> ALTER TABLE ss_masga DROP COLUMN tp_version;
ALTER TABLE
tiles=> \q
$ psql < ddl/migrations/redshift/1493213710.sql
BEGIN
CREATE TABLE
CREATE TABLE
ALTER TABLE
COMMIT
$ psql
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
GRANT
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public to infernyx;
GRANT
tiles=> \q

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