Skip to content

Clean up the schema of the table "issues"

Yorick Peterse requested to merge cleanup-issues-schema into master

This takes care of most of the items listed in https://gitlab.com/gitlab-org/gitlab-ce/issues/31811.

Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/31811

Database Checklist

When adding migrations:

  • Updated db/schema.rb
  • Added a down method so the migration can be reverted
  • Added the output of the migration(s) to the MR body
  • Added the execution time of the migration(s) to the MR body
  • Made sure the migration won't interfere with a running GitLab cluster, for example by disabling transactions for long running migrations

Migration Output

Migration Output 
== 20171106132212 IssuesConfidentialNotNull: migrating ========================
-- change_column_null(:issues, :confidential, false)
   -> 0.0003s
== 20171106132212 IssuesConfidentialNotNull: migrated (0.0024s) ===============
== 20171106135924 IssuesMilestoneIdForeignKey: migrating ======================
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE issues\nADD CONSTRAINT fk_96b1dd429c\nFOREIGN KEY (milestone_id)\nREFERENCES milestones (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0068s
-- execute("ALTER TABLE issues VALIDATE CONSTRAINT fk_96b1dd429c;")
-> 0.0047s
== 20171106135924 IssuesMilestoneIdForeignKey: migrated (11.2226s) ============
== 20171106150657 IssuesUpdatedByIdForeignKey: migrating ======================
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:issues, :updated_by_id, {:where=>"updated_by_id IS NOT NULL", :algorithm=>:concurrently})
-> 0.0390s
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE issues\nADD CONSTRAINT fk_ffed080f01\nFOREIGN KEY (updated_by_id)\nREFERENCES users (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0057s
-- execute("ALTER TABLE issues VALIDATE CONSTRAINT fk_ffed080f01;")
-> 0.0045s
== 20171106150657 IssuesUpdatedByIdForeignKey: migrated (0.0945s) =============
== 20171106151218 IssuesMovedToIdForeignKey: migrating ========================
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- execute("ALTER TABLE issues\nADD CONSTRAINT fk_a194299be1\nFOREIGN KEY (moved_to_id)\nREFERENCES issues (id)\nON DELETE SET NULL\nNOT VALID;\n")
-> 0.0042s
-- execute("ALTER TABLE issues VALIDATE CONSTRAINT fk_a194299be1;")
-> 0.0145s
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:issues, :moved_to_id, {:where=>"moved_to_id IS NOT NULL", :algorithm=>:concurrently})
-> 0.0367s
== 20171106151218 IssuesMovedToIdForeignKey: migrated (0.0779s) ===============
== 20171106154015 RemoveIssuesBranchName: migrating ===========================
-- remove_column(:issues, :branch_name, :string)
-> 0.0005s
== 20171106154015 RemoveIssuesBranchName: migrated (0.0005s) ==================
== 20171106155656 TurnIssuesDueDateIndexToPartialIndex: migrating =============
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0002s
-- add_index(:issues, [:project_id, :due_date, :id, :state], {:where=>"due_date IS NOT NULL", :name=>"idx_issues_on_project_id_and_due_date_and_id_and_state_partial", :algorithm=>:concurrently})
-> 0.0349s
-- transaction_open?()
-> 0.0000s
-- select_one("SELECT current_setting('server_version_num') AS v")
-> 0.0003s
-- execute("SET statement_timeout TO 0")
-> 0.0001s
-- remove_index(:issues, {:name=>"index_issues_on_project_id_and_due_date_and_id_and_state", :algorithm=>:concurrently, :column=>nil})
-> 0.0065s
== 20171106155656 TurnIssuesDueDateIndexToPartialIndex: migrated (0.0422s) ====
== 20171106171453 AddTimezoneToIssuesClosedAt: migrating ======================
-- transaction_open?()
-> 0.0000s
-- columns(:issues)
-> 0.0007s
-- add_column(:issues, "closed_at_for_type_change", :datetime_with_timezone, {:limit=>nil, :precision=>nil, :scale=>nil})
-> 0.0041s
-- quote_table_name(:issues)
-> 0.0000s
-- quote_column_name(:closed_at)
-> 0.0000s
-- quote_column_name("closed_at_for_type_change")
-> 0.0000s
-- execute("CREATE OR REPLACE FUNCTION trigger_08acb26c5ecf()\nRETURNS trigger AS\n$BODY$\nBEGIN\n  NEW."closed_at_for_type_change" := NEW."closed_at";\n  RETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE\n")
-> 0.0045s
-- execute("CREATE TRIGGER trigger_08acb26c5ecf\nBEFORE INSERT OR UPDATE\nON "issues"\nFOR EACH ROW\nEXECUTE PROCEDURE trigger_08acb26c5ecf()\n")
-> 0.0049s
-- transaction_open?()
-> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM "issues"")
-> 0.0121s
-- exec_query("SELECT  "issues"."id" FROM "issues"  ORDER BY "issues"."id" ASC LIMIT 1")
-> 0.0004s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 1  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0006s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 1 AND "issues"."id" < 1001")
-> 0.0263s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 1001  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0014s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 1001 AND "issues"."id" < 2002")
-> 0.0197s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 2002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0016s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 2002 AND "issues"."id" < 3002")
-> 0.0184s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 3002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0015s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 3002 AND "issues"."id" < 4002")
-> 0.0198s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 4002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0016s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 4002 AND "issues"."id" < 5002")
-> 0.0198s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 5002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0014s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 5002 AND "issues"."id" < 6002")
-> 0.0193s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 6002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 6002 AND "issues"."id" < 7002")
-> 0.0175s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 7002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0014s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 7002 AND "issues"."id" < 8002")
-> 0.0254s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 8002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 8002 AND "issues"."id" < 9002")
-> 0.0191s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 9002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 9002 AND "issues"."id" < 10002")
-> 0.0166s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 10002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 10002 AND "issues"."id" < 11002")
-> 0.0190s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 11002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 11002 AND "issues"."id" < 12002")
-> 0.0181s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 12002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 12002 AND "issues"."id" < 13002")
-> 0.0234s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 13002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 13002 AND "issues"."id" < 14002")
-> 0.0246s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 14002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 14002 AND "issues"."id" < 15002")
-> 0.0208s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 15002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 15002 AND "issues"."id" < 16002")
-> 0.0199s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 16002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 16002 AND "issues"."id" < 17002")
-> 0.0227s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 17002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 17002 AND "issues"."id" < 18002")
-> 0.0181s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 18002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 18002 AND "issues"."id" < 19002")
-> 0.0249s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 19002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 19002 AND "issues"."id" < 20002")
-> 0.0162s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 20002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 20002 AND "issues"."id" < 21002")
-> 0.0232s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 21002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 21002 AND "issues"."id" < 22002")
-> 0.0269s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 22002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 22002 AND "issues"."id" < 23002")
-> 0.0183s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 23002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 23002 AND "issues"."id" < 24002")
-> 0.0165s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 24002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 24002 AND "issues"."id" < 25002")
-> 0.0177s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 25002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 25002 AND "issues"."id" < 26002")
-> 0.0204s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 26002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 26002 AND "issues"."id" < 27002")
-> 0.0173s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 27002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 27002 AND "issues"."id" < 28002")
-> 0.0160s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 28002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 28002 AND "issues"."id" < 29002")
-> 0.0687s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 29002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 29002 AND "issues"."id" < 30002")
-> 0.0223s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 30002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 30002 AND "issues"."id" < 31002")
-> 0.0205s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 31002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 31002 AND "issues"."id" < 32002")
-> 0.1001s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 32002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 32002 AND "issues"."id" < 33002")
-> 0.0268s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 33002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 33002 AND "issues"."id" < 34002")
-> 0.0260s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 34002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 34002 AND "issues"."id" < 35002")
-> 0.0285s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 35002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 35002 AND "issues"."id" < 36002")
-> 0.0322s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 36002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 36002 AND "issues"."id" < 37002")
-> 0.0287s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 37002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 37002 AND "issues"."id" < 38002")
-> 0.0301s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 38002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 38002 AND "issues"."id" < 39002")
-> 0.0274s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 39002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 39002 AND "issues"."id" < 40002")
-> 0.0267s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 40002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 40002 AND "issues"."id" < 41002")
-> 0.0258s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 41002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 41002 AND "issues"."id" < 42002")
-> 0.0293s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 42002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 42002 AND "issues"."id" < 43002")
-> 0.0268s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 43002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 43002 AND "issues"."id" < 44002")
-> 0.0283s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 44002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 44002 AND "issues"."id" < 45002")
-> 0.0286s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 45002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 45002 AND "issues"."id" < 46002")
-> 0.0295s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 46002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 46002 AND "issues"."id" < 47002")
-> 0.0259s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 47002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 47002 AND "issues"."id" < 48002")
-> 0.0255s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 48002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 48002 AND "issues"."id" < 49002")
-> 0.0333s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 49002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 49002 AND "issues"."id" < 50002")
-> 0.0750s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 50002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 50002 AND "issues"."id" < 51002")
-> 0.0287s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 51002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 51002 AND "issues"."id" < 52002")
-> 0.0298s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 52002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 52002 AND "issues"."id" < 53002")
-> 0.0268s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 53002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 53002 AND "issues"."id" < 54002")
-> 0.0276s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 54002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0008s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 54002 AND "issues"."id" < 55002")
-> 0.0256s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 55002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 55002 AND "issues"."id" < 56002")
-> 0.0277s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 56002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 56002 AND "issues"."id" < 57002")
-> 0.0239s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 57002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 57002 AND "issues"."id" < 58002")
-> 0.0259s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 58002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 58002 AND "issues"."id" < 59002")
-> 0.0208s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 59002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 59002 AND "issues"."id" < 60002")
-> 0.0246s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 60002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 60002 AND "issues"."id" < 61002")
-> 0.0268s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 61002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 61002 AND "issues"."id" < 62002")
-> 0.0262s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 62002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 62002 AND "issues"."id" < 63002")
-> 0.0234s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 63002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 63002 AND "issues"."id" < 64002")
-> 0.0257s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 64002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 64002 AND "issues"."id" < 65002")
-> 0.0626s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 65002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 65002 AND "issues"."id" < 66002")
-> 0.0228s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 66002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 66002 AND "issues"."id" < 67002")
-> 0.0202s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 67002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 67002 AND "issues"."id" < 68002")
-> 0.0205s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 68002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 68002 AND "issues"."id" < 69002")
-> 0.0263s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 69002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 69002 AND "issues"."id" < 70002")
-> 0.0213s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 70002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 70002 AND "issues"."id" < 71002")
-> 0.0234s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 71002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 71002 AND "issues"."id" < 72002")
-> 0.0260s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 72002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 72002 AND "issues"."id" < 73002")
-> 0.0239s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 73002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 73002 AND "issues"."id" < 74002")
-> 0.0241s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 74002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 74002 AND "issues"."id" < 75002")
-> 0.0648s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 75002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 75002 AND "issues"."id" < 76002")
-> 0.0251s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 76002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 76002 AND "issues"."id" < 77002")
-> 0.0229s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 77002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 77002 AND "issues"."id" < 78002")
-> 0.0228s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 78002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 78002 AND "issues"."id" < 79002")
-> 0.0231s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 79002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 79002 AND "issues"."id" < 80002")
-> 0.0199s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 80002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 80002 AND "issues"."id" < 81002")
-> 0.0277s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 81002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 81002 AND "issues"."id" < 82002")
-> 0.0209s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 82002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 82002 AND "issues"."id" < 83002")
-> 0.0216s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 83002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 83002 AND "issues"."id" < 84002")
-> 0.0253s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 84002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 84002 AND "issues"."id" < 85002")
-> 0.0224s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 85002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 85002 AND "issues"."id" < 86002")
-> 0.0220s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 86002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 86002 AND "issues"."id" < 87002")
-> 0.0239s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 87002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 87002 AND "issues"."id" < 88002")
-> 0.0210s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 88002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 88002 AND "issues"."id" < 89002")
-> 0.0182s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 89002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 89002 AND "issues"."id" < 90002")
-> 0.0173s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 90002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 90002 AND "issues"."id" < 91002")
-> 0.0218s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 91002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 91002 AND "issues"."id" < 92002")
-> 0.0255s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 92002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 92002 AND "issues"."id" < 93002")
-> 0.0193s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 93002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 93002 AND "issues"."id" < 94002")
-> 0.0258s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 94002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0013s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 94002 AND "issues"."id" < 95002")
-> 0.0180s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 95002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 95002 AND "issues"."id" < 96002")
-> 0.0244s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 96002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 96002 AND "issues"."id" < 97002")
-> 0.0266s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 97002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0012s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 97002 AND "issues"."id" < 98002")
-> 0.0258s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 98002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 98002 AND "issues"."id" < 99002")
-> 0.0275s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 99002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 99002 AND "issues"."id" < 100002")
-> 0.0281s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 100002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0011s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 100002 AND "issues"."id" < 101002")
-> 0.0367s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 101002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 101002 AND "issues"."id" < 102002")
-> 0.0697s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 102002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0009s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 102002 AND "issues"."id" < 103002")
-> 0.0316s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 103002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 103002 AND "issues"."id" < 104002")
-> 0.0311s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 104002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0010s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 104002 AND "issues"."id" < 105002")
-> 0.0301s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 105002  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0017s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 105002 AND "issues"."id" < 206138")
-> 0.1839s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 206138  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0022s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 206138 AND "issues"."id" < 207138")
-> 0.1543s
-- exec_query("SELECT  "issues"."id" FROM "issues" WHERE "issues"."id" >= 207138  ORDER BY "issues"."id" ASC LIMIT 1 OFFSET 1000")
-> 0.0018s
-- execute("UPDATE "issues" SET "closed_at_for_type_change" = "issues"."closed_at" WHERE "issues"."id" >= 207138")
-> 0.2902s
-- indexes(:issues)
-> 0.0046s
-- foreign_keys(:issues)
-> 0.0019s
== 20171106171453 AddTimezoneToIssuesClosedAt: migrated (3.6271s) =============

General Checklist

Edited by Sean McGivern

Merge request reports