1359994 - Deploy Splice 2.1.29 to stage

Status: RESOLVED FIXED

(Firefox :: New Tab Page, enhancement)

Description

[Nan Jiang [:nanj]]

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

Comment 1

[Jon Buckley [:jbuck]]

$ 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