Closed Bug 1212130 Opened 9 years ago Closed 9 years ago

Drop the aggregate_id column from the result_set table

Categories

(Tree Management :: Treeherder: Infrastructure, defect, P3)

Product:
Tree Management
Component:
Treeherder: Infrastructure
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: emorley, Assigned: emorley)

References

Details

Once bug 1211836 is in production, we can drop the aggregate_id column from the resultset table, on stage/prod/Heroku.
Heroku: [~/src/treeherder]$ heroku run -- ./manage.py run_sql -s "ALTER TABLE result_set DROP COLUMN aggregate_id;" Running ./manage.py run_sql -s "ALTER TABLE result_set DROP COLUMN aggregate_id;" on treeherder-heroku... up, run.9308 SQL command: ALTER TABLE result_set DROP COLUMN aggregate_id; 53 datasource found -------------------------- Sql code executed on mozilla-central: -------------------------- Sql code executed on mozilla-inbound: -------------------------- ... Stage: [emorley@treeherder-rabbitmq1.stage.private.scl3 ~]$ cd /data/www/treeherder.allizom.org/treeherder-service/ [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "A LTER TABLE result_set DROP COLUMN aggregate_id;" SQL command: ALTER TABLE result_set DROP COLUMN aggregate_id; 67 datasource found -------------------------- Sql code executed on addon-sdk: -------------------------- Sql code executed on alder: -------------------------- Sql code executed on ash: -------------------------- Sql code executed on b2g-inbound: -------------------------- Sql code executed on birch: -------------------------- Sql code executed on build-system: -------------------------- Sql code executed on cedar: -------------------------- Sql code executed on comm-aurora: -------------------------- Sql code executed on comm-beta: -------------------------- Sql code executed on comm-central: -------------------------- Sql code executed on comm-esr24: -------------------------- Sql code executed on comm-esr31: -------------------------- Sql code executed on cypress: -------------------------- Sql code executed on date: -------------------------- Sql code executed on elm: -------------------------- Sql code executed on fig: -------------------------- Sql code executed on fx-team: -------------------------- Sql code executed on gaia: -------------------------- Sql code executed on gaia-master: -------------------------- Sql code executed on gaia-try: -------------------------- Sql code executed on gaia-v1_4: -------------------------- Sql code executed on graphics: -------------------------- Sql code executed on gum: -------------------------- Sql code executed on holly: -------------------------- Sql code executed on jamun: -------------------------- Sql code executed on larch: -------------------------- Sql code executed on maple: -------------------------- Sql code executed on mozilla-aurora: -------------------------- Sql code executed on mozilla-b2g18: -------------------------- Sql code executed on mozilla-b2g18_v1_1_0_hd: -------------------------- Sql code executed on mozilla-b2g26_v1_2: -------------------------- Sql code executed on mozilla-b2g28_v1_3: -------------------------- Sql code executed on mozilla-b2g28_v1_3t: -------------------------- Sql code executed on mozilla-b2g30_v1_4: -------------------------- Sql code executed on mozilla-b2g32_v2_0: -------------------------- Sql code executed on mozilla-b2g34_v2_1: -------------------------- Sql code executed on mozilla-beta: -------------------------- Sql code executed on mozilla-central: -------------------------- Sql code executed on mozilla-esr17: -------------------------- Sql code executed on mozilla-esr24: -------------------------- Sql code executed on mozilla-esr31: -------------------------- Sql code executed on mozilla-inbound: -------------------------- Sql code executed on mozilla-release: -------------------------- Sql code executed on oak: -------------------------- Sql code executed on pine: -------------------------- Sql code executed on qa-try: -------------------------- Sql code executed on services-central: -------------------------- Sql code executed on staging-gaia-try: -------------------------- Sql code executed on taskcluster-integration: -------------------------- Sql code executed on try: -------------------------- Sql code executed on try-comm-central: -------------------------- Sql code executed on try-taskcluster: -------------------------- Sql code executed on unknown: -------------------------- Sql code executed on ux: -------------------------- Sql code executed on mozilla-b2g34_v2_1s: -------------------------- Sql code executed on mozilla-b2g37_v2_2: -------------------------- Sql code executed on bugzilla: -------------------------- Sql code executed on bmo: -------------------------- Sql code executed on mozilla-esr38: -------------------------- Sql code executed on comm-esr38: -------------------------- Sql code executed on bugzilla-master: -------------------------- Sql code executed on bmo-master: -------------------------- Sql code executed on bugzilla-5_0: -------------------------- Sql code executed on bugzilla-4_4: -------------------------- Sql code executed on bugzilla-4_2: -------------------------- Sql code executed on bmo-development: -------------------------- Sql code executed on mozilla-b2g37_v2_2r: real 0m9.979s user 0m1.314s sys 0m0.165s
Summary: Drop the aggregate_id column from the resultset table → Drop the aggregate_id column from the result_set table
Prod: [emorley@treeherder-rabbitmq1.private.scl3 treeherder-service]$ time ../venv/bin/python ./manage.py run_sql -s "ALTER TABLE result_set DROP COLUMN aggregate_id;" SQL command: ALTER TABLE result_set DROP COLUMN aggregate_id; 73 datasource found -------------------------- Sql code executed on accessibility: -------------------------- Sql code executed on addon-sdk: -------------------------- Sql code executed on alder: -------------------------- Sql code executed on ash: -------------------------- Sql code executed on b2g-inbound: -------------------------- Sql code executed on birch: -------------------------- Sql code executed on build-system: -------------------------- Sql code executed on cedar: -------------------------- Sql code executed on cypress: -------------------------- Sql code executed on date: -------------------------- Sql code executed on elm: -------------------------- Sql code executed on fig: -------------------------- Sql code executed on fx-team: -------------------------- Sql code executed on gaia: -------------------------- Sql code executed on gaia-master: -------------------------- Sql code executed on gaia-try: -------------------------- Sql code executed on gaia-v1_4: -------------------------- Sql code executed on graphics: -------------------------- Sql code executed on gum: -------------------------- Sql code executed on holly: -------------------------- Sql code executed on jamun: -------------------------- Sql code executed on larch: -------------------------- Sql code executed on maple: -------------------------- Sql code executed on mozilla-aurora: -------------------------- Sql code executed on mozilla-b2g18: -------------------------- Sql code executed on mozilla-b2g18_v1_1_0_hd: -------------------------- Sql code executed on mozilla-b2g26_v1_2: -------------------------- Sql code executed on mozilla-b2g28_v1_3: -------------------------- Sql code executed on mozilla-b2g30_v1_4: -------------------------- Sql code executed on mozilla-beta: -------------------------- Sql code executed on mozilla-central: -------------------------- Sql code executed on mozilla-esr17: -------------------------- Sql code executed on mozilla-esr24: -------------------------- Sql code executed on mozilla-inbound: -------------------------- Sql code executed on mozilla-release: -------------------------- Sql code executed on oak: -------------------------- Sql code executed on pine: -------------------------- Sql code executed on qa-try: -------------------------- Sql code executed on services-central: -------------------------- Sql code executed on taskcluster-integration: -------------------------- Sql code executed on thunderbird-aurora: -------------------------- Sql code executed on thunderbird-beta: -------------------------- Sql code executed on thunderbird-esr24: -------------------------- Sql code executed on thunderbird-trunk: -------------------------- Sql code executed on thunderbird-try: -------------------------- Sql code executed on try: -------------------------- Sql code executed on try-taskcluster: -------------------------- Sql code executed on unknown: -------------------------- Sql code executed on ux: -------------------------- Sql code executed on mozilla-b2g32_v2_0: -------------------------- Sql code executed on comm-aurora: -------------------------- Sql code executed on comm-beta: -------------------------- Sql code executed on comm-central: -------------------------- Sql code executed on comm-esr24: -------------------------- Sql code executed on mozilla-b2g28_v1_3t: -------------------------- Sql code executed on mozilla-esr31: -------------------------- Sql code executed on staging-gaia-try: -------------------------- Sql code executed on try-comm-central: -------------------------- Sql code executed on mozilla-b2g34_v2_1: -------------------------- Sql code executed on comm-esr31: -------------------------- Sql code executed on mozilla-b2g34_v2_1s: -------------------------- Sql code executed on mozilla-b2g37_v2_2: -------------------------- Sql code executed on bugzilla: -------------------------- Sql code executed on bmo: -------------------------- Sql code executed on mozilla-esr38: -------------------------- Sql code executed on comm-esr38: -------------------------- Sql code executed on bugzilla-master: -------------------------- Sql code executed on bmo-master: -------------------------- Sql code executed on bugzilla-5_0: -------------------------- Sql code executed on bugzilla-4_4: -------------------------- Sql code executed on bugzilla-4_2: -------------------------- Sql code executed on bmo-development: -------------------------- Sql code executed on mozilla-b2g37_v2_2r: real 0m8.770s user 0m1.139s sys 0m0.136s
Status: ASSIGNED → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.