[2022-08-03 00:24:03.358 +0300] (7919) INFO Started GET "/issues?utf8=%E2%9C%93&set_filter=1&sort=id%3Adesc&f[]=status_id&op[status_id]=o&f[]=cf_105&op[cf_105]=%3D&v[cf_105][]=1&f[]=&c[]=project&c[]=tracker&c[]=status&c[]=subject&c[]=assigned_to&c[]=category&c[]=fixed_version&group_by=&t[]=" for 127.0.0.1 at 2022-08-03 00:24:03 +0300 [2022-08-03 00:24:03.471 +0300] (7919) WARN enumeration.rb:41:in `' Creating scope :system. Overwriting existing method Enumeration.system. [2022-08-03 00:24:03.476 +0300] (7919) INFO Processing by IssuesController#index as HTML [2022-08-03 00:24:03.476 +0300] (7919) INFO Parameters: {"utf8"=>"✓", "set_filter"=>"1", "sort"=>"id:desc", "f"=>["status_id", "cf_105", ""], "op"=>{"status_id"=>"o", "cf_105"=>"="}, "v"=>{"cf_105"=>["1"]}, "c"=>["project", "tracker", "status", "subject", "assigned_to", "category", "fixed_version"], "group_by"=>"", "t"=>[""]} [2022-08-03 00:24:03.482 +0300] (7919) WARN group.rb:38:in `' Creating scope :sorted. Overwriting existing method Group.sorted. [2022-08-03 00:24:03.489 +0300] (7919) WARN user.rb:147:in `' Creating scope :sorted. Overwriting existing method User.sorted. [2022-08-03 00:24:03.493 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "session_lifetime"], ["LIMIT", 1]] [2022-08-03 00:24:03.495 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "session_timeout"], ["LIMIT", 1]] [2022-08-03 00:24:03.508 +0300] (7919) DEBUG user.rb:492:in `verify_session_token' Token Update All (11.3ms) UPDATE "tokens" SET "updated_on" = '2022-08-03 00:24:03.496217' WHERE "tokens"."user_id" = $1 AND "tokens"."value" = $2 AND "tokens"."action" = $3 [["user_id", 16], ["value", "defd0ab80d11e890cf4c54799a6879462ae23ba3"], ["action", "session"]] [2022-08-03 00:24:03.509 +0300] (7919) DEBUG setting.rb:270:in `check_cache' (0.3ms) SELECT MAX("settings"."updated_on") FROM "settings" [2022-08-03 00:24:03.512 +0300] (7919) DEBUG application_controller.rb:114:in `find_current_user' User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3 [["status", 1], ["id", 16], ["LIMIT", 1]] [2022-08-03 00:24:03.523 +0300] (7919) INFO application_controller.rb:102:in `user_setup' Current user: onur (id=16) [2022-08-03 00:24:03.523 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "force_default_language_for_loggedin"], ["LIMIT", 1]] [2022-08-03 00:24:03.569 +0300] (7919) DEBUG issue_query.rb:135:in `collect' Tracker Load (1.1ms) SELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY "trackers"."position" ASC [2022-08-03 00:24:03.573 +0300] (7919) DEBUG issue_query.rb:139:in `collect' IssuePriority Load (0.3ms) SELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC [2022-08-03 00:24:03.589 +0300] (7919) DEBUG query.rb:1494:in `add_custom_fields_filters' IssueCustomField Load (0.4ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND "custom_fields"."is_filter" = $1 ORDER BY "custom_fields"."position" ASC [["is_filter", true]] [2022-08-03 00:24:03.600 +0300] (7919) DEBUG query.rb:1471:in `add_chained_custom_field_filters' CustomField Load (0.2ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 AND "custom_fields"."type" = $2 [["is_filter", true], ["type", "UserCustomField"]] [2022-08-03 00:24:03.600 +0300] (7919) DEBUG query.rb:1471:in `add_chained_custom_field_filters' CACHE CustomField Load (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 AND "custom_fields"."type" = $2 [["is_filter", true], ["type", "UserCustomField"]] [2022-08-03 00:24:03.601 +0300] (7919) DEBUG query.rb:1521:in `group_by' CustomField Load (0.3ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 [["is_filter", true]] [2022-08-03 00:24:03.603 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "issue_list_default_columns"], ["LIMIT", 1]] [2022-08-03 00:24:03.606 +0300] (7919) DEBUG issue_query.rb:256:in `collect' IssueCustomField Load (0.4ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') ORDER BY "custom_fields"."position" ASC [2022-08-03 00:24:03.610 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "user_format"], ["LIMIT", 1]] [2022-08-03 00:24:03.615 +0300] (7919) DEBUG user.rb:414:in `pref' UserPreference Load (0.3ms) SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2 [["user_id", 16], ["LIMIT", 1]] [2022-08-03 00:24:03.633 +0300] (7919) DEBUG issue_query.rb:329:in `issue_count' (12.2ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=105 WHERE (custom_values.value IN ('1')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 105)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 105) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 105)))))) [2022-08-03 00:24:03.634 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.3ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "per_page_options"], ["LIMIT", 1]] [2022-08-03 00:24:03.651 +0300] (7919) DEBUG issue_query.rb:377:in `issues' SQL (13.3ms) SELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."description" AS t0_r4, "issues"."due_date" AS t0_r5, "issues"."category_id" AS t0_r6, "issues"."status_id" AS t0_r7, "issues"."assigned_to_id" AS t0_r8, "issues"."priority_id" AS t0_r9, "issues"."fixed_version_id" AS t0_r10, "issues"."author_id" AS t0_r11, "issues"."lock_version" AS t0_r12, "issues"."created_on" AS t0_r13, "issues"."updated_on" AS t0_r14, "issues"."start_date" AS t0_r15, "issues"."done_ratio" AS t0_r16, "issues"."estimated_hours" AS t0_r17, "issues"."parent_id" AS t0_r18, "issues"."root_id" AS t0_r19, "issues"."lft" AS t0_r20, "issues"."rgt" AS t0_r21, "issues"."is_private" AS t0_r22, "issues"."closed_on" AS t0_r23, "issues"."rim_package_report_id" AS t0_r24, "issues"."rw_box_id" AS t0_r25, "issues"."rw_box_position" AS t0_r26, "issue_statuses"."id" AS t1_r0, "issue_statuses"."name" AS t1_r1, "issue_statuses"."is_closed" AS t1_r2, "issue_statuses"."position" AS t1_r3, "issue_statuses"."default_done_ratio" AS t1_r4, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "projects"."default_version_id" AS t2_r13, "projects"."default_assigned_to_id" AS t2_r14 FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND issues.id IN (SELECT issues.id FROM issues LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=issues.id AND custom_values.custom_field_id=105 WHERE (custom_values.value IN ('1')) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 105)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 105) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 105)))))) ORDER BY issues.id DESC LIMIT $1 OFFSET $2 [["LIMIT", 25], ["OFFSET", 0]] [2022-08-03 00:24:03.665 +0300] (7919) DEBUG issue_query.rb:377:in `issues' IssuePriority Load (0.4ms) SELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') AND "enumerations"."id" = $1 ORDER BY "enumerations"."position" ASC [["id", 13]] [2022-08-03 00:24:03.666 +0300] (7919) DEBUG issue_query.rb:377:in `issues' Tracker Load (0.3ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" IN ($1, $2) [["id", 2], ["id", 1]] [2022-08-03 00:24:03.667 +0300] (7919) DEBUG issue_query.rb:377:in `issues' Principal Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) [["id", 824], ["id", 951], ["id", 950], ["id", 971], ["id", 685], ["id", 834], ["id", 923], ["id", 863], ["id", 966], ["id", 952]] [2022-08-03 00:24:03.669 +0300] (7919) DEBUG issue_query.rb:377:in `issues' Version Load (0.2ms) SELECT "versions".* FROM "versions" WHERE "versions"."id" = $1 [["id", 1805]] [2022-08-03 00:24:03.674 +0300] (7919) DEBUG issue_query.rb:377:in `issues' IssueCategory Load (0.3ms) SELECT "issue_categories".* FROM "issue_categories" WHERE "issue_categories"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) [["id", 490], ["id", 672], ["id", 612], ["id", 669], ["id", 494], ["id", 493], ["id", 629], ["id", 576], ["id", 670], ["id", 574], ["id", 667]] [2022-08-03 00:24:03.676 +0300] (7919) INFO issues_controller.rb:54:in `block (2 levels) in index' Rendering issues/index.html.erb within layouts/base [2022-08-03 00:24:03.680 +0300] (7919) DEBUG query.rb:635:in `collect' IssueStatus Load (0.3ms) SELECT "issue_statuses".* FROM "issue_statuses" ORDER BY "issue_statuses"."position" ASC [2022-08-03 00:24:03.684 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "start_of_week"], ["LIMIT", 1]] [2022-08-03 00:24:03.685 +0300] (7919) INFO _query_form.html.erb:10:in `_app_views_queries__query_form_html_erb___3739772912959596206_150920' Rendered queries/_filters.html.erb (5.6ms) [2022-08-03 00:24:03.693 +0300] (7919) INFO queries_helper.rb:136:in `render_query_columns_selection' Rendered queries/_columns.html.erb (7.6ms) [2022-08-03 00:24:03.696 +0300] (7919) INFO index.html.erb:24:in `block in _app_views_issues_index_html_erb__4153315814078676898_150900' Rendered queries/_query_form.html.erb (18.3ms) [2022-08-03 00:24:03.703 +0300] (7919) DEBUG issue.rb:1456:in `css_classes' Group Load (0.5ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = $1 [["user_id", 16]] [2022-08-03 00:24:03.718 +0300] (7919) DEBUG version.rb:190:in `visible?' Project Load (0.3ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = $1 LIMIT $2 [["id", 249], ["LIMIT", 1]] [2022-08-03 00:24:03.719 +0300] (7919) DEBUG project.rb:1279:in `allowed_permissions' (0.2ms) SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1 [["project_id", 249]] [2022-08-03 00:24:03.741 +0300] (7919) INFO index.html.erb:32:in `_app_views_issues_index_html_erb__4153315814078676898_150900' Rendered issues/_list.html.erb (44.3ms) [2022-08-03 00:24:03.744 +0300] (7919) DEBUG user.rb:439:in `rss_key' Token Load (0.4ms) SELECT "tokens".* FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='feeds') LIMIT $2 [["user_id", 16], ["LIMIT", 1]] [2022-08-03 00:24:03.749 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.3ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "issues_export_limit"], ["LIMIT", 1]] [2022-08-03 00:24:03.751 +0300] (7919) DEBUG queries_helper.rb:438:in `sidebar_queries' IssueQuery Load (0.5ms) SELECT "queries".* FROM "queries" LEFT OUTER JOIN projects ON queries.project_id = projects.id WHERE "queries"."type" IN ('IssueQuery') AND (queries.project_id IS NULL OR (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking'))) AND (queries.visibility <> 0 OR queries.user_id = 16) AND "queries"."project_id" IS NULL ORDER BY "queries"."name" ASC, "queries"."id" ASC [2022-08-03 00:24:03.752 +0300] (7919) INFO index.html.erb:77:in `block in _app_views_issues_index_html_erb__4153315814078676898_150900' Rendered issues/_sidebar.html.erb (2.0ms) [2022-08-03 00:24:03.754 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "ui_theme"], ["LIMIT", 1]] [2022-08-03 00:24:03.754 +0300] (7919) INFO issues_controller.rb:54:in `block (2 levels) in index' Rendered issues/index.html.erb within layouts/base (77.9ms) [2022-08-03 00:24:03.757 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "app_title"], ["LIMIT", 1]] [2022-08-03 00:24:03.760 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "gravatar_enabled"], ["LIMIT", 1]] [2022-08-03 00:24:03.761 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "gravatar_default"], ["LIMIT", 1]] [2022-08-03 00:24:03.765 +0300] (7919) DEBUG user.rb:185:in `mail' EmailAddress Load (0.2ms) SELECT "email_addresses".* FROM "email_addresses" WHERE "email_addresses"."user_id" = $1 AND "email_addresses"."is_default" = $2 LIMIT $3 [["user_id", 16], ["is_default", true], ["LIMIT", 1]] [2022-08-03 00:24:03.771 +0300] (7919) DEBUG setting.rb:353:in `find_or_default' Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "new_item_menu_tab"], ["LIMIT", 1]] [2022-08-03 00:24:03.782 +0300] (7919) DEBUG application_helper.rb:510:in `projects_for_jump_box' Project Load (0.4ms) SELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND "projects"."status" != $2 AND "projects"."status" = $3 [["user_id", 16], ["status", 9], ["status", 1]] [2022-08-03 00:24:03.784 +0300] (7919) DEBUG project_jump_box.rb:41:in `bookmarked_projects' Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE 1=0 AND (projects.status <> 9) [2022-08-03 00:24:03.785 +0300] (7919) DEBUG project_jump_box.rb:35:in `recently_used_projects' Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN ($1, $2, $3) AND (projects.status <> 9) [["id", 61], ["id", 132], ["id", 170]] [2022-08-03 00:24:03.801 +0300] (7919) DEBUG redmine.rb:238:in `block (2 levels) in ' EnabledModule Exists (0.5ms) SELECT 1 AS one FROM "enabled_modules" WHERE "enabled_modules"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (projects.status <> 9)) AND "enabled_modules"."name" = $1 LIMIT $2 [["name", "issue_tracking"], ["LIMIT", 1]] [2022-08-03 00:24:03.802 +0300] (7919) DEBUG redmine.rb:248:in `block (2 levels) in ' EnabledModule Exists (0.4ms) SELECT 1 AS one FROM "enabled_modules" WHERE "enabled_modules"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (projects.status <> 9)) AND "enabled_modules"."name" = $1 LIMIT $2 [["name", "time_tracking"], ["LIMIT", 1]] [2022-08-03 00:24:03.803 +0300] (7919) DEBUG redmine.rb:259:in `block (2 levels) in ' EnabledModule Exists (0.2ms) SELECT 1 AS one FROM "enabled_modules" WHERE "enabled_modules"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (projects.status <> 9)) AND "enabled_modules"."name" = $1 LIMIT $2 [["name", "gantt"], ["LIMIT", 1]] [2022-08-03 00:24:03.805 +0300] (7919) DEBUG redmine.rb:269:in `block (2 levels) in ' EnabledModule Exists (0.2ms) SELECT 1 AS one FROM "enabled_modules" WHERE "enabled_modules"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (projects.status <> 9)) AND "enabled_modules"."name" = $1 LIMIT $2 [["name", "calendar"], ["LIMIT", 1]] [2022-08-03 00:24:03.806 +0300] (7919) DEBUG redmine.rb:278:in `block (2 levels) in ' EnabledModule Exists (0.2ms) SELECT 1 AS one FROM "enabled_modules" WHERE "enabled_modules"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (projects.status <> 9)) AND "enabled_modules"."name" = $1 LIMIT $2 [["name", "news"], ["LIMIT", 1]] [2022-08-03 00:24:03.807 +0300] (7919) INFO Completed 200 OK in 330ms (Views: 121.3ms | ActiveRecord: 72.3ms)