Forbidding the sitemap route path (!45359) · Merge requests · GitLab.org / GitLab

Francisco Javier López (ex-Gitlab) requested to merge fj-forbid-snippet-route into master Oct 16, 2020

What does this MR do?

In this MR we forbid the top-level route sitemap.xml and sitemap.xml.gz because we need to reserve it for that file.

More info about the reasoning in #268221 (closed)

Refs #268221 (closed)

Migration UP

```text == 20201019094741 RenameSitemapRootNamespaces: migrating ====================== -- execute("SET statement_timeout TO 0") -> 0.0005s -- quote_string("gitlab-org") -> 0.0000s -- quote_string("gitlab-org/%") -> 0.0000s -- execute("UPDATE \"routes\" SET \"path\" = regexp_replace(\"routes\".\"path\", 'gitlab-org', 'gitlab-org0') WHERE routes.id IN ( SELECT routes.id FROM routes WHERE lower(routes.path) = lower('gitlab-org') UNION SELECT routes.id FROM routes WHERE routes.path ILIKE 'gitlab-org/%' )") -> 0.0082s -- tracked rename: rename:RenameSitemapRootNamespaces:namespace: gitlab-org -> gitlab-org0 -- /workspace/gitlab/public/uploads/gitlab-org doesn't exist, skipping -- /workspace/gitlab/shared/pages/gitlab-org doesn't exist, skipping -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"projects\" WHERE \"projects\".\"id\" = 1") -> 0.0009s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" = 1 ORDER BY \"projects\".\"id\" ASC LIMIT 1") -> 0.0008s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" >= 1 AND \"projects\".\"id\" = 1 ORDER BY \"projects\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"projects\" SET \"description_html\" = NULL WHERE \"projects\".\"id\" >= 1 AND \"projects\".\"id\" = 1") -> 0.0105s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"project_id\" = 1") -> 0.0021s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1") -> 0.0009s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 1 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 1 AND \"issues\".\"id\" < 4 AND \"issues\".\"project_id\" = 1") -> 0.0084s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 4 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0010s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 4 AND \"issues\".\"id\" < 7 AND \"issues\".\"project_id\" = 1") -> 0.0076s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 7 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 7 AND \"issues\".\"id\" < 10 AND \"issues\".\"project_id\" = 1") -> 0.0078s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 10 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 10 AND \"issues\".\"id\" < 140 AND \"issues\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 140 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 140 AND \"issues\".\"id\" < 143 AND \"issues\".\"project_id\" = 1") -> 0.0081s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 143 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 143 AND \"issues\".\"id\" < 146 AND \"issues\".\"project_id\" = 1") -> 0.0077s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 146 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 146 AND \"issues\".\"id\" < 149 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 149 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 149 AND \"issues\".\"id\" < 152 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 152 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 152 AND \"issues\".\"id\" < 155 AND \"issues\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 155 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 155 AND \"issues\".\"id\" < 158 AND \"issues\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 158 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 158 AND \"issues\".\"id\" < 481 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 481 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 481 AND \"issues\".\"id\" < 484 AND \"issues\".\"project_id\" = 1") -> 0.0082s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 484 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 484 AND \"issues\".\"id\" < 487 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 487 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 487 AND \"issues\".\"project_id\" = 1") -> 0.0085s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 1") -> 0.0021s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 1 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 1 AND \"merge_requests\".\"id\" < 2 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0083s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 2 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 2 AND \"merge_requests\".\"id\" < 3 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 3 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0010s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 3 AND \"merge_requests\".\"id\" < 4 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0083s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 4 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 4 AND \"merge_requests\".\"id\" < 5 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0071s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 5 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 5 AND \"merge_requests\".\"id\" < 6 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 6 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 6 AND \"merge_requests\".\"id\" < 7 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 7 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 7 AND \"merge_requests\".\"id\" < 30 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 30 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 30 AND \"merge_requests\".\"id\" < 31 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 31 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 31 AND \"merge_requests\".\"id\" < 32 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0077s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 32 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 32 AND \"merge_requests\".\"id\" < 33 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0076s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 33 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 33 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0072s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"notes\" WHERE \"notes\".\"project_id\" = 1") -> 0.0012s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1") -> 0.0006s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 1 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 1 AND \"notes\".\"id\" < 10 AND \"notes\".\"project_id\" = 1") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 10 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 10 AND \"notes\".\"id\" < 19 AND \"notes\".\"project_id\" = 1") -> 0.0071s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 19 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0005s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 19 AND \"notes\".\"id\" < 28 AND \"notes\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 28 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 28 AND \"notes\".\"id\" < 37 AND \"notes\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 37 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 37 AND \"notes\".\"id\" < 46 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 46 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 46 AND \"notes\".\"id\" < 55 AND \"notes\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 55 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 55 AND \"notes\".\"id\" < 64 AND \"notes\".\"project_id\" = 1") -> 0.0133s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 64 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 64 AND \"notes\".\"id\" < 73 AND \"notes\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 73 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 73 AND \"notes\".\"id\" < 82 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 82 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 82 AND \"notes\".\"id\" < 91 AND \"notes\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 91 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 91 AND \"notes\".\"id\" < 461 AND \"notes\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 461 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 461 AND \"notes\".\"id\" < 470 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 470 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 470 AND \"notes\".\"id\" < 479 AND \"notes\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 479 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 479 AND \"notes\".\"id\" < 488 AND \"notes\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 488 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 488 AND \"notes\".\"id\" < 497 AND \"notes\".\"project_id\" = 1") -> 0.0102s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 497 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 497 AND \"notes\".\"id\" < 506 AND \"notes\".\"project_id\" = 1") -> 0.0083s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 506 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 506 AND \"notes\".\"id\" < 686 AND \"notes\".\"project_id\" = 1") -> 0.0082s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 686 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 686 AND \"notes\".\"id\" < 695 AND \"notes\".\"project_id\" = 1") -> 0.0094s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 695 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 695 AND \"notes\".\"project_id\" = 1") -> 0.0094s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 1") -> 0.0011s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1") -> 0.0006s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 1 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0005s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 1 AND \"milestones\".\"id\" < 2 AND \"milestones\".\"project_id\" = 1") -> 0.0093s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 2 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0005s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 2 AND \"milestones\".\"id\" < 3 AND \"milestones\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 3 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 3 AND \"milestones\".\"id\" < 4 AND \"milestones\".\"project_id\" = 1") -> 0.0081s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 4 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 4 AND \"milestones\".\"id\" < 5 AND \"milestones\".\"project_id\" = 1") -> 0.0087s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 5 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 5 AND \"milestones\".\"id\" < 45 AND \"milestones\".\"project_id\" = 1") -> 0.0083s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 45 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 45 AND \"milestones\".\"project_id\" = 1") -> 0.0079s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"projects\" WHERE \"projects\".\"id\" = 2") -> 0.0008s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" = 2 ORDER BY \"projects\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" >= 2 AND \"projects\".\"id\" = 2 ORDER BY \"projects\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"projects\" SET \"description_html\" = NULL WHERE \"projects\".\"id\" >= 2 AND \"projects\".\"id\" = 2") -> 0.0091s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"project_id\" = 2") -> 0.0007s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1") -> 0.0006s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 13 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0006s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 13 AND \"issues\".\"id\" < 15 AND \"issues\".\"project_id\" = 2") -> 0.0090s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 15 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 15 AND \"issues\".\"id\" < 17 AND \"issues\".\"project_id\" = 2") -> 0.0144s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 17 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 17 AND \"issues\".\"id\" < 19 AND \"issues\".\"project_id\" = 2") -> 0.0081s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 19 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 19 AND \"issues\".\"id\" < 21 AND \"issues\".\"project_id\" = 2") -> 0.0089s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 21 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 21 AND \"issues\".\"id\" < 81 AND \"issues\".\"project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 81 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 81 AND \"issues\".\"id\" < 83 AND \"issues\".\"project_id\" = 2") -> 0.0090s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 83 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 83 AND \"issues\".\"id\" < 85 AND \"issues\".\"project_id\" = 2") -> 0.0082s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 85 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0006s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 85 AND \"issues\".\"id\" < 87 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 87 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 87 AND \"issues\".\"id\" < 89 AND \"issues\".\"project_id\" = 2") -> 0.0069s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 89 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 89 AND \"issues\".\"id\" < 91 AND \"issues\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 91 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 91 AND \"issues\".\"id\" < 93 AND \"issues\".\"project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 93 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 93 AND \"issues\".\"id\" < 95 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 95 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 95 AND \"issues\".\"id\" < 97 AND \"issues\".\"project_id\" = 2") -> 0.0070s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 97 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0006s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 97 AND \"issues\".\"id\" < 99 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 99 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0006s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 99 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 2") -> 0.0007s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 8 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 8 AND \"merge_requests\".\"id\" < 9 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0082s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 9 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 9 AND \"merge_requests\".\"id\" < 10 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0067s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 10 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 10 AND \"merge_requests\".\"id\" < 11 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0070s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 11 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 11 AND \"merge_requests\".\"id\" < 12 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0070s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 12 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 12 AND \"merge_requests\".\"id\" < 13 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0071s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 13 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 13 AND \"merge_requests\".\"id\" < 14 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 14 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 14 AND \"merge_requests\".\"id\" < 34 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0071s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 34 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 34 AND \"merge_requests\".\"id\" < 35 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0079s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 35 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 35 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0074s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"notes\" WHERE \"notes\".\"project_id\" = 2") -> 0.0009s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 97 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 97 AND \"notes\".\"id\" < 104 AND \"notes\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 104 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 104 AND \"notes\".\"id\" < 111 AND \"notes\".\"project_id\" = 2") -> 0.0070s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 111 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 111 AND \"notes\".\"id\" < 118 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 118 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 118 AND \"notes\".\"id\" < 125 AND \"notes\".\"project_id\" = 2") -> 0.0078s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 125 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 125 AND \"notes\".\"id\" < 132 AND \"notes\".\"project_id\" = 2") -> 0.0084s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 132 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 132 AND \"notes\".\"id\" < 139 AND \"notes\".\"project_id\" = 2") -> 0.0083s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 139 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 139 AND \"notes\".\"id\" < 146 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 146 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 146 AND \"notes\".\"id\" < 153 AND \"notes\".\"project_id\" = 2") -> 0.0082s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 153 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 153 AND \"notes\".\"id\" < 160 AND \"notes\".\"project_id\" = 2") -> 0.0078s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 160 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 160 AND \"notes\".\"id\" < 167 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 167 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 167 AND \"notes\".\"id\" < 519 AND \"notes\".\"project_id\" = 2") -> 0.0087s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 519 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 519 AND \"notes\".\"id\" < 526 AND \"notes\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 526 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 526 AND \"notes\".\"id\" < 533 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 533 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0005s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 533 AND \"notes\".\"id\" < 540 AND \"notes\".\"project_id\" = 2") -> 0.0078s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 540 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 540 AND \"notes\".\"id\" < 547 AND \"notes\".\"project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 547 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 547 AND \"notes\".\"id\" < 554 AND \"notes\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 554 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 554 AND \"notes\".\"id\" < 561 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 561 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 561 AND \"notes\".\"id\" < 568 AND \"notes\".\"project_id\" = 2") -> 0.0080s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 568 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 568 AND \"notes\".\"project_id\" = 2") -> 0.0082s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 2") -> 0.0007s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 6 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 6 AND \"milestones\".\"id\" < 7 AND \"milestones\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 7 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 7 AND \"milestones\".\"id\" < 8 AND \"milestones\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 8 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 8 AND \"milestones\".\"id\" < 9 AND \"milestones\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 9 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 9 AND \"milestones\".\"id\" < 10 AND \"milestones\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 10 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 10 AND \"milestones\".\"id\" < 42 AND \"milestones\".\"project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 42 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 42 AND \"milestones\".\"project_id\" = 2") -> 0.0072s -- execute("RESET ALL") -> 0.0004s == 20201019094741 RenameSitemapRootNamespaces: migrated (1.3024s) ============= ```

Migration DOWN

```text == 20201019094741 RenameSitemapRootNamespaces: reverting ====================== -- execute("SET statement_timeout TO 0") -> 0.0005s -- renaming namespace from gitlab-org0 back to gitlab-org -- quote_string("gitlab-org0") -> 0.0000s -- quote_string("gitlab-org0/%") -> 0.0000s -- execute("UPDATE \"routes\" SET \"path\" = regexp_replace(\"routes\".\"path\", 'gitlab-org0', 'gitlab-org') WHERE routes.id IN ( SELECT routes.id FROM routes WHERE lower(routes.path) = lower('gitlab-org0') UNION SELECT routes.id FROM routes WHERE routes.path ILIKE 'gitlab-org0/%' )") -> 0.0086s -- /workspace/gitlab/public/uploads/gitlab-org0 doesn't exist, skipping -- /workspace/gitlab/shared/pages/gitlab-org0 doesn't exist, skipping -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"projects\" WHERE \"projects\".\"id\" = 1") -> 0.0009s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" = 1 ORDER BY \"projects\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" >= 1 AND \"projects\".\"id\" = 1 ORDER BY \"projects\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"projects\" SET \"description_html\" = NULL WHERE \"projects\".\"id\" >= 1 AND \"projects\".\"id\" = 1") -> 0.0107s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"project_id\" = 1") -> 0.0020s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 1 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 1 AND \"issues\".\"id\" < 4 AND \"issues\".\"project_id\" = 1") -> 0.0112s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 4 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 4 AND \"issues\".\"id\" < 7 AND \"issues\".\"project_id\" = 1") -> 0.0096s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 7 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 7 AND \"issues\".\"id\" < 10 AND \"issues\".\"project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 10 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 10 AND \"issues\".\"id\" < 140 AND \"issues\".\"project_id\" = 1") -> 0.0076s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 140 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 140 AND \"issues\".\"id\" < 143 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 143 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0010s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 143 AND \"issues\".\"id\" < 146 AND \"issues\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 146 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 146 AND \"issues\".\"id\" < 149 AND \"issues\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 149 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 149 AND \"issues\".\"id\" < 152 AND \"issues\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 152 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 152 AND \"issues\".\"id\" < 155 AND \"issues\".\"project_id\" = 1") -> 0.0076s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 155 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 155 AND \"issues\".\"id\" < 158 AND \"issues\".\"project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 158 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0007s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 158 AND \"issues\".\"id\" < 481 AND \"issues\".\"project_id\" = 1") -> 0.0115s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 481 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 481 AND \"issues\".\"id\" < 484 AND \"issues\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 484 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 484 AND \"issues\".\"id\" < 487 AND \"issues\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 487 AND \"issues\".\"project_id\" = 1 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 3") -> 0.0006s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 487 AND \"issues\".\"project_id\" = 1") -> 0.0071s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 1") -> 0.0019s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 1 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 1 AND \"merge_requests\".\"id\" < 2 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0081s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 2 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 2 AND \"merge_requests\".\"id\" < 3 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 3 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 3 AND \"merge_requests\".\"id\" < 4 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0068s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 4 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 4 AND \"merge_requests\".\"id\" < 5 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 5 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 5 AND \"merge_requests\".\"id\" < 6 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 6 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 6 AND \"merge_requests\".\"id\" < 7 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0071s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 7 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 7 AND \"merge_requests\".\"id\" < 30 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 30 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 30 AND \"merge_requests\".\"id\" < 31 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0068s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 31 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 31 AND \"merge_requests\".\"id\" < 32 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0068s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 32 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 32 AND \"merge_requests\".\"id\" < 33 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0077s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 33 AND \"merge_requests\".\"target_project_id\" = 1 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 33 AND \"merge_requests\".\"target_project_id\" = 1") -> 0.0074s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"notes\" WHERE \"notes\".\"project_id\" = 1") -> 0.0017s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1") -> 0.0006s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 1 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0005s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 1 AND \"notes\".\"id\" < 10 AND \"notes\".\"project_id\" = 1") -> 0.0081s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 10 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0005s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 10 AND \"notes\".\"id\" < 19 AND \"notes\".\"project_id\" = 1") -> 0.0071s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 19 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 19 AND \"notes\".\"id\" < 28 AND \"notes\".\"project_id\" = 1") -> 0.0071s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 28 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 28 AND \"notes\".\"id\" < 37 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 37 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 37 AND \"notes\".\"id\" < 46 AND \"notes\".\"project_id\" = 1") -> 0.0103s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 46 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 46 AND \"notes\".\"id\" < 55 AND \"notes\".\"project_id\" = 1") -> 0.0074s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 55 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 55 AND \"notes\".\"id\" < 64 AND \"notes\".\"project_id\" = 1") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 64 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 64 AND \"notes\".\"id\" < 73 AND \"notes\".\"project_id\" = 1") -> 0.0079s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 73 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 73 AND \"notes\".\"id\" < 82 AND \"notes\".\"project_id\" = 1") -> 0.0076s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 82 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 82 AND \"notes\".\"id\" < 91 AND \"notes\".\"project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 91 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 91 AND \"notes\".\"id\" < 461 AND \"notes\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 461 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 461 AND \"notes\".\"id\" < 470 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 470 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 470 AND \"notes\".\"id\" < 479 AND \"notes\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 479 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 479 AND \"notes\".\"id\" < 488 AND \"notes\".\"project_id\" = 1") -> 0.0088s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 488 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 488 AND \"notes\".\"id\" < 497 AND \"notes\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 497 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0006s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 497 AND \"notes\".\"id\" < 506 AND \"notes\".\"project_id\" = 1") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 506 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 506 AND \"notes\".\"id\" < 686 AND \"notes\".\"project_id\" = 1") -> 0.0070s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 686 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0011s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 686 AND \"notes\".\"id\" < 695 AND \"notes\".\"project_id\" = 1") -> 0.0073s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 695 AND \"notes\".\"project_id\" = 1 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 9") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 695 AND \"notes\".\"project_id\" = 1") -> 0.0069s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 1") -> 0.0011s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 1 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 1 AND \"milestones\".\"id\" < 2 AND \"milestones\".\"project_id\" = 1") -> 0.0108s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 2 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 2 AND \"milestones\".\"id\" < 3 AND \"milestones\".\"project_id\" = 1") -> 0.0068s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 3 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 3 AND \"milestones\".\"id\" < 4 AND \"milestones\".\"project_id\" = 1") -> 0.0067s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 4 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 4 AND \"milestones\".\"id\" < 5 AND \"milestones\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 5 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 5 AND \"milestones\".\"id\" < 45 AND \"milestones\".\"project_id\" = 1") -> 0.0069s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 45 AND \"milestones\".\"project_id\" = 1 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 45 AND \"milestones\".\"project_id\" = 1") -> 0.0067s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"projects\" WHERE \"projects\".\"id\" = 2") -> 0.0011s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" = 2 ORDER BY \"projects\".\"id\" ASC LIMIT 1") -> 0.0008s -- exec_query("SELECT \"projects\".\"id\" FROM \"projects\" WHERE \"projects\".\"id\" >= 2 AND \"projects\".\"id\" = 2 ORDER BY \"projects\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0010s -- execute("UPDATE \"projects\" SET \"description_html\" = NULL WHERE \"projects\".\"id\" >= 2 AND \"projects\".\"id\" = 2") -> 0.0077s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"project_id\" = 2") -> 0.0008s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 13 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0008s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 13 AND \"issues\".\"id\" < 15 AND \"issues\".\"project_id\" = 2") -> 0.0108s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 15 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0011s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 15 AND \"issues\".\"id\" < 17 AND \"issues\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 17 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0012s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 17 AND \"issues\".\"id\" < 19 AND \"issues\".\"project_id\" = 2") -> 0.0076s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 19 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0012s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 19 AND \"issues\".\"id\" < 21 AND \"issues\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 21 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0010s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 21 AND \"issues\".\"id\" < 81 AND \"issues\".\"project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 81 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0010s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 81 AND \"issues\".\"id\" < 83 AND \"issues\".\"project_id\" = 2") -> 0.0108s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 83 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0013s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 83 AND \"issues\".\"id\" < 85 AND \"issues\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 85 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0012s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 85 AND \"issues\".\"id\" < 87 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 87 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 87 AND \"issues\".\"id\" < 89 AND \"issues\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 89 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0012s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 89 AND \"issues\".\"id\" < 91 AND \"issues\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 91 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0013s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 91 AND \"issues\".\"id\" < 93 AND \"issues\".\"project_id\" = 2") -> 0.0079s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 93 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0011s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 93 AND \"issues\".\"id\" < 95 AND \"issues\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 95 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0009s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 95 AND \"issues\".\"id\" < 97 AND \"issues\".\"project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 97 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0011s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 97 AND \"issues\".\"id\" < 99 AND \"issues\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"issues\".\"id\" FROM \"issues\" WHERE \"issues\".\"id\" >= 99 AND \"issues\".\"project_id\" = 2 ORDER BY \"issues\".\"id\" ASC LIMIT 1 OFFSET 2") -> 0.0012s -- execute("UPDATE \"issues\" SET \"description_html\" = NULL WHERE \"issues\".\"id\" >= 99 AND \"issues\".\"project_id\" = 2") -> 0.0080s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 2") -> 0.0010s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 8 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0006s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 8 AND \"merge_requests\".\"id\" < 9 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0076s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 9 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 9 AND \"merge_requests\".\"id\" < 10 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 10 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 10 AND \"merge_requests\".\"id\" < 11 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0070s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 11 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 11 AND \"merge_requests\".\"id\" < 12 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0073s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 12 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 12 AND \"merge_requests\".\"id\" < 13 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 13 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 13 AND \"merge_requests\".\"id\" < 14 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 14 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 14 AND \"merge_requests\".\"id\" < 34 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0078s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 34 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 34 AND \"merge_requests\".\"id\" < 35 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"merge_requests\".\"id\" FROM \"merge_requests\" WHERE \"merge_requests\".\"id\" >= 35 AND \"merge_requests\".\"target_project_id\" = 2 ORDER BY \"merge_requests\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"merge_requests\" SET \"description_html\" = NULL WHERE \"merge_requests\".\"id\" >= 35 AND \"merge_requests\".\"target_project_id\" = 2") -> 0.0070s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"notes\" WHERE \"notes\".\"project_id\" = 2") -> 0.0007s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 97 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 97 AND \"notes\".\"id\" < 104 AND \"notes\".\"project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 104 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 104 AND \"notes\".\"id\" < 111 AND \"notes\".\"project_id\" = 2") -> 0.0079s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 111 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0011s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 111 AND \"notes\".\"id\" < 118 AND \"notes\".\"project_id\" = 2") -> 0.0090s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 118 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 118 AND \"notes\".\"id\" < 125 AND \"notes\".\"project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 125 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 125 AND \"notes\".\"id\" < 132 AND \"notes\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 132 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 132 AND \"notes\".\"id\" < 139 AND \"notes\".\"project_id\" = 2") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 139 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0010s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 139 AND \"notes\".\"id\" < 146 AND \"notes\".\"project_id\" = 2") -> 0.0074s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 146 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 146 AND \"notes\".\"id\" < 153 AND \"notes\".\"project_id\" = 2") -> 0.0071s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 153 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 153 AND \"notes\".\"id\" < 160 AND \"notes\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 160 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0007s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 160 AND \"notes\".\"id\" < 167 AND \"notes\".\"project_id\" = 2") -> 0.0069s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 167 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0009s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 167 AND \"notes\".\"id\" < 519 AND \"notes\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 519 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 519 AND \"notes\".\"id\" < 526 AND \"notes\".\"project_id\" = 2") -> 0.0076s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 526 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 526 AND \"notes\".\"id\" < 533 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 533 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 533 AND \"notes\".\"id\" < 540 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 540 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 540 AND \"notes\".\"id\" < 547 AND \"notes\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 547 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0008s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 547 AND \"notes\".\"id\" < 554 AND \"notes\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 554 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0010s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 554 AND \"notes\".\"id\" < 561 AND \"notes\".\"project_id\" = 2") -> 0.0117s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 561 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0012s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 561 AND \"notes\".\"id\" < 568 AND \"notes\".\"project_id\" = 2") -> 0.0081s -- exec_query("SELECT \"notes\".\"id\" FROM \"notes\" WHERE \"notes\".\"id\" >= 568 AND \"notes\".\"project_id\" = 2 ORDER BY \"notes\".\"id\" ASC LIMIT 1 OFFSET 7") -> 0.0010s -- execute("UPDATE \"notes\" SET \"note_html\" = NULL WHERE \"notes\".\"id\" >= 568 AND \"notes\".\"project_id\" = 2") -> 0.0076s -- transaction_open?() -> 0.0000s -- exec_query("SELECT COUNT(*) AS count FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 2") -> 0.0009s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1") -> 0.0007s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 6 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0007s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 6 AND \"milestones\".\"id\" < 7 AND \"milestones\".\"project_id\" = 2") -> 0.0072s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 7 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 7 AND \"milestones\".\"id\" < 8 AND \"milestones\".\"project_id\" = 2") -> 0.0077s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 8 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0010s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 8 AND \"milestones\".\"id\" < 9 AND \"milestones\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 9 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0009s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 9 AND \"milestones\".\"id\" < 10 AND \"milestones\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 10 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 10 AND \"milestones\".\"id\" < 42 AND \"milestones\".\"project_id\" = 2") -> 0.0075s -- exec_query("SELECT \"milestones\".\"id\" FROM \"milestones\" WHERE \"milestones\".\"id\" >= 42 AND \"milestones\".\"project_id\" = 2 ORDER BY \"milestones\".\"id\" ASC LIMIT 1 OFFSET 1") -> 0.0008s -- execute("UPDATE \"milestones\" SET \"description_html\" = NULL WHERE \"milestones\".\"id\" >= 42 AND \"milestones\".\"project_id\" = 2") -> 0.0076s -- execute("RESET ALL") -> 0.0004s == 20201019094741 RenameSitemapRootNamespaces: reverted (1.2220s) ============= ```

In production, we have one namespace that will be migrated, but it doesn't have any data. It's very unlikely we have to migrate anything in self-hosted instances.

Does this MR meet the acceptance criteria?

Conformity

Edited Oct 19, 2020 by Francisco Javier López (ex-Gitlab)

Forbidding the sitemap route path

What does this MR do?

Does this MR meet the acceptance criteria?

Conformity

Merge request reports