# Bug OP-14084 - Timeouts as non privileged users Project: OpenProject Status: closed URL: https://community.openproject.org/work_packages/OP-14084 ## Open points _No work packages_ ## Details | Attribute | Value | | --- | --- | | Date | | | Priority | Immediate | | Module | | | Target versions | 13.3.0 | | Observed in versions | 13.1.0 | | Sprint | 13.3.0 | | Backlog bucket | | | Bug found in version (deprecated) | 13.1.x | | Found in mobile app version | | | Follow-up feedback e-mail | | | Requires doc change | No | | Accessibility | No | | Pull preview | | | List | | | Labels | | ## People | Attribute | Value | | --- | --- | | Assignee | | | Accountable | | | Product manager | | | Developers | | | Designer | | | Ordered by | | | Signed off by | | | Interest by | | ## Planning | Attribute | Value | | --- | --- | | Relevance | | ## Costs | Attribute | Value | | --- | --- | | Votes | | | Work | | | Labor costs | | ## Description ### Before filing a report *We are running OpenProject 13.1.2, an omnibus installation with a local postgresql 15.5 database on a ubuntu 22.04 installation all packages crrent.* ### Steps to reproduce 1. Login as a user with permissions to manage members in project 1. The user has no admin rights 2. the user tries to go to project 1, let's call it FOO, which has quite some subprojects and a lot of work packages as user with admin right the problem does not occur. ### What is the buggy behavior? The user sees a blank screen, for a very long time, and the an errir 500 message. The same does not apply for users wit admin rights. Annotation: We also see, that non provileged users often complain  about long waiting times, between 10 and 20 seconds on actions, where users with admin rights are happy with the performance. ### What is the expected behavior? 1. Users without admin privileges mus be able to work, even with projects with al lot of work packages 2. Users without admin  provileges shall have the same or similar response times on actions as users with admin rights have. As it is now, it renders openproject to be unusable by non admin users. ### Important note *Please note that unless you are a contributor to OpenProject, you can no longer edit this bug report after saving. You can still add new comments, but no longer add any new images or other attachments. Please make sure that all necessary information and attachments are added, and the following attributes are set:* ### **Logs** *Are there errors in the browser console? (*[*Click here for information on how to open your browser's console*](https://webmasters.stackexchange.com/a/77337)*) For a local installation: Are there relevant logs output by* `_openproject logs_` *(packaged installation) (*[*click here for details*](https://docs.openproject.org/installation-and-operations/operation/monitoring/#show-logs)*) or in a log/production.log or /var/log/openproject/ ? Pleas* ``` text Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.252798 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] WorkPackage Exists? (90016.9ms) SELECT 1 AS one FROM "work_packages" WHERE "work_packages"."id" IN (( (SELECT "work_packages"."id" FROM "m embers" INNER JOIN "work_packages" ON "members"."entity_id" = "work_packages"."id" INNER JOIN "projects" ON "projects"."active" = TRUE AND "projects"."id" = "work_packages"."project_id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('c osts') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'vie w_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_type" = 'WorkPackage') UNION ALL (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."id" IN ( ( (SELECT "projects"."id" FROM "members" INNER JOIN "projects" ON "projects"."active" = TRUE AND "members"."project_id" = "projects"."id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL) UNION ALL (SELECT "projects"."id" FROM "projects" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects "."active" = TRUE INNER JOIN "roles" ON "roles"."builtin" = 1 AND "projects"."active" AND "projects"."public" AND NOT (EXISTS (SELECT 1 FROM "members" WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL AND "members"."project_id" = "projects"."id")) I NNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs')) )))) )) AND "work_packages"."project_id" = $1 LIMIT $2 [["project_id", 1], ["LIMIT", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: W, [2024-01-05T15:21:01.258862 #293420] WARN -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] user=4344 Encountered slow SQL (90020.8457 ms): SELECT 1 AS one FROM "work_packages" WHERE "work_packages"."id" IN (( (SELECT "work_packages" ."id" FROM "members" INNER JOIN "work_packages" ON "members"."entity_id" = "work_packages"."id" INNER JOIN "projects" ON "projects"."active" = TRUE AND "projects"."id" = "work_packages"."project_id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules". "name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permi ssion" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_type" = 'WorkPackage') UNION ALL (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projec ts"."id" IN (( (SELECT "projects"."id" FROM "members" INNER JOIN "projects" ON "projects"."active" = TRUE AND "members"."project_id" = "projects"."id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TR UE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_mo dules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL) UNION ALL (SELECT "projects"."id" FROM "projects" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "roles" ON "roles"."builtin" = 1 AND "projects"."active" AND "projects"."public" AND NOT (EXISTS (SELECT 1 FROM "members" WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL AND "members"."project_id" = "proje cts"."id")) INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs')) )))) )) AND "work_packages"."project_id" = $1 LIMIT $2 Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: E, [2024-01-05T15:21:01.281007 #293420] ERROR -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] user=4344 PG::QueryCanceled: FEHLER: storniere Anfrage wegen Zeitüberschreitung der Anfrage Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: : PG::QueryCanceled: FEHLER: storniere Anfrage wegen Zeitüberschreitung der Anfrage Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.281238 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] [ActionView::Template::Error] PG::QueryCanceled: FEHLER: storniere Anfrage wegen Zeitüberschreitung der Anfrage Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: : app/services/authorization/user_permissible_service.rb:61:in `allowed_in_any_entity?'; app/models/users/permission_checks.rb:79:in `allowed_in_any_entity?'; app/models/users/permission_checks.rb:46:in `block (3 levels) in '; app/models/users/permission_checks.rb:135:in `block in allowed_based_on_permission_context?'; app/models/users/permission_checks.rb:125:in `any?'; app/models/users/permission_checks.rb:125:in `allowed_based_on_permission_context?'; lib/redmine/menu_manager/menu_helper.rb:423:in `n ode_action_allowed?'; lib/redmine/menu_manager/menu_helper.rb:404:in `allowed_project_node?'; lib/redmine/menu_manager/menu_helper.rb:396:in `allowed_node?'; lib/redmine/menu_manager/menu_helper.rb:374:in `block in menu_items_for'; lib/redmine/menu_manager/menu_helper.rb:371:in `each'; lib/redmine/men u_manager/menu_helper.rb:371:in `menu_items_for'; lib/redmine/menu_manager/menu_helper.rb:263:in `first_level_menu_items_for'; lib/redmine/menu_manager/menu_helper.rb:59:in `render_menu'; lib/redmine/menu_manager/menu_helper.rb:50:in `render_main_menu'; app/views/layouts/base.html.erb:66; app/views/la youts/angular/angular.html.erb:45; modules/grids/app/controllers/grids/base_in_project_controller.rb:7:in `show' Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.339401 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE (0.1ms) SELECT MAX(union_query.max_updated_at) Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: FROM ((SELECT MAX(updated_at) AS max_updated_at FROM statuses) UNION (SELECT MAX(updated_at) AS max_updated_at FROM enumerations) UNION (SELECT MAX(updated_at) AS max_updated_at FROM types)) Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: AS union_query Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.362360 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE MenuItems::WikiMenuItem Exists? (0.0ms) SELECT 1 AS one FROM "menu_items" WHERE "menu_items"."type" = $1 AND "menu_items"."[26/1904] le_id" = $2 AND "menu_items"."parent_id" IS NULL LIMIT $3 [["type", "MenuItems::WikiMenuItem"], ["navigatable_id", 1], ["LIMIT", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.363320 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE MenuItems::WikiMenuItem Load (0.0ms) SELECT "menu_items".* FROM "menu_items" WHERE "menu_items"."type" = $1 AND "menu_items"."naviga table_id" = $2 AND "menu_items"."parent_id" IS NULL ORDER BY title ASC [["type", "MenuItems::WikiMenuItem"], ["navigatable_id", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.368579 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE MenuItem Load (0.0ms) SELECT "menu_items".* FROM "menu_items" WHERE "menu_items"."parent_id" = $1 ORDER BY id ASC [["parent_id", 1] ] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.382614 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE WikiPage Exists? (0.0ms) SELECT 1 AS one FROM "wiki_pages" WHERE "wiki_pages"."wiki_id" = $1 LIMIT $2 [["wiki_id", 1], ["LIMIT", 1] ] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.412026 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."lft" <= 102 AND "projects"."rgt" >= 121 AND "projects"."p arent_id" IS NULL ORDER BY "projects"."lft" ASC LIMIT $1 [["LIMIT", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.424457 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE Version Exists? (0.0ms) SELECT 1 AS one FROM "versions" LEFT OUTER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHER E ("projects"."id" = $1 OR "projects"."active" = $2 AND "versions"."sharing" = $3 OR "projects"."active" = $4 AND "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."lft" >= 49 AND "projects"."lft" < 224 ORDER BY "projects"."lft" ASC) AND "versions"."sharing" = $5 OR "projects "."active" = $6 AND "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."lft" <= 102 AND "projects"."rgt" >= 121 AND ("projects"."id" != 1) ORDER BY "projects"."lft" ASC) AND "versions"."sharing" IN ($7, $8) OR "projects"."active" = $9 AND "projects"."id" IN (SELECT "projects". "id" FROM "projects" WHERE "projects"."lft" >= 102 AND "projects"."lft" < 121 ORDER BY "projects"."lft" ASC) AND "versions"."sharing" = $10) LIMIT $11 [["id", 1], ["active", true], ["sharing", "system"], ["active", true], ["sharing", "tree"], ["active", true], ["sharing", "hierarchy"], ["sharing", "d escendants"], ["active", true], ["sharing", "hierarchy"], ["LIMIT", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.431034 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."lft" <= 102 AND "projects"."rgt" >= 121 AND "projects"."p arent_id" IS NULL ORDER BY "projects"."lft" ASC LIMIT $1 [["LIMIT", 1]] Jan 05 15:21:01 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:01.435722 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE Version Exists? (0.0ms) SELECT 1 AS one FROM "versions" LEFT OUTER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHER E ("projects"."id" = $1 OR "projects"."active" = $2 AND "versions"."sharing" = $3 OR "projects"."active" = $4 AND "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."lft" >= 49 AND "projects"."lft" < 224 ORDER BY "projects"."lft" ASC) AND "versions"."sharing" = $5 OR "projects "."active" = $6 AND "projects"."id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."lft" <= 102 AND "projects"."rgt" >= 121 AND ("projects"."id" != 1) ORDER BY "projects"."lft" ASC) AND "versions"."sharing" IN ($7, $8) OR "projects"."active" = $9 AND "projects"."id" IN (SELECT "projects". "id" FROM "projects" WHERE "projects"."lft" >= 102 AND "projects"."lft" < 121 ORDER BY "projects"."lft" ASC) AND "versions"."sharing" = $10) LIMIT $11 [["id", 1], ["active", true], ["sharing", "system"], ["active", true], ["sharing", "tree"], ["active", true], ["sharing", "hierarchy"], ["sharing", "d escendants"], ["active", true], ["sharing", "hierarchy"], ["LIMIT", 1]] Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:30.753416 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] WorkPackage Exists? (29257.5ms) SELECT 1 AS one FROM "work_packages" WHERE "work_packages"."id" IN (( (SELECT "work_packages"."id" FROM "m embers" INNER JOIN "work_packages" ON "members"."entity_id" = "work_packages"."id" INNER JOIN "projects" ON "projects"."active" = TRUE AND "projects"."id" = "work_packages"."project_id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('c osts') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'vie w_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_type" = 'WorkPackage') UNION ALL (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."id" IN ( ( (SELECT "projects"."id" FROM "members" INNER JOIN "projects" ON "projects"."active" = TRUE AND "members"."project_id" = "projects"."id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL) UNION ALL (SELECT "projects"."id" FROM "projects" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects "."active" = TRUE INNER JOIN "roles" ON "roles"."builtin" = 1 AND "projects"."active" AND "projects"."public" AND NOT (EXISTS (SELECT 1 FROM "members" WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL AND "members"."project_id" = "projects"."id")) I NNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs')) )))) )) AND "work_packages"."project_id" = $1 LIMIT $2 [["project_id", 1], ["LIMIT", 1]] Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: W, [2024-01-05T15:21:30.759367 #293420] WARN -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] user=4344 Encountered slow SQL (29263.4403 ms): SELECT 1 AS one FROM "work_packages" WHERE "work_packages"."id" IN (( (SELECT "work_packages" ."id" FROM "members" INNER JOIN "work_packages" ON "members"."entity_id" = "work_packages"."id" INNER JOIN "projects" ON "projects"."active" = TRUE AND "projects"."id" = "work_packages"."project_id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules". "name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permi ssion" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_type" = 'WorkPackage') UNION ALL (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projec ts"."id" IN (( (SELECT "projects"."id" FROM "members" INNER JOIN "projects" ON "projects"."active" = TRUE AND "members"."project_id" = "projects"."id" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TR UE INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_mo dules"."name" = 'costs') WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL) UNION ALL (SELECT "projects"."id" FROM "projects" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('costs') AND "projects"."active" = TRUE INNER JOIN "roles" ON "roles"."builtin" = 1 AND "projects"."active" AND "projects"."public" AND NOT (EXISTS (SELECT 1 FROM "members" WHERE "members"."user_id" = 4344 AND "members"."entity_id" IS NULL AND "members"."entity_type" IS NULL AND "members"."project_id" = "proje cts"."id")) INNER JOIN "role_permissions" ON "roles"."id" = "role_permissions"."role_id" AND (FALSE OR "role_permissions"."permission" = 'view_own_time_entries' AND "enabled_modules"."name" = 'costs')) )))) )) AND "work_packages"."project_id" = $1 LIMIT $2 Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: I, [2024-01-05T15:21:30.771584 #293420] INFO -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] method=GET path=/projects/1 format=html controller=Overviews::OverviewsController action=show status=500 error='Rack::Timeout::RequestTimeout Exception: Request ran for longer than 120000ms , sending SIGTERM to process 293420' allocations=126203 duration=120015.43 view=0.00 db=119348.73 user=4344 Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: F, [2024-01-05T15:21:30.783977 #293420] FATAL -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] Rack::Timeout::RequestTimeoutException (Request ran for longer than 120000ms , sending SIGTERM to process 293420): Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/services/authorization/user_permissible_service.rb:61:in `allowed_in_any_entity?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/models/users/permission_checks.rb:79:in `allowed_in_any_entity?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/models/users/permission_checks.rb:46:in `block (3 levels) in ' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/models/users/permission_checks.rb:135:in `block in allowed_based_on_permission_context?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/models/users/permission_checks.rb:125:in `any?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/models/users/permission_checks.rb:125:in `allowed_based_on_permission_context?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:423:in `node_action_allowed?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:404:in `allowed_project_node?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:396:in `allowed_node?' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:374:in `block in menu_items_for' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:371:in `each' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:371:in `menu_items_for' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:263:in `first_level_menu_items_for' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:59:in `render_menu' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] lib/redmine/menu_manager/menu_helper.rb:50:in `render_main_menu' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/views/layouts/base.html.erb:66 Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/views/layouts/no_menu.html.erb:30 Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/helpers/errors_helper.rb:97:in `block (2 levels) in render_error' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/helpers/errors_helper.rb:95:in `render_error' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/helpers/errors_helper.rb:57:in `render_500' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: [6b1be5e9-99ad-47ab-be06-72eed521798a] app/controllers/application_controller.rb:119:in `block in ' Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: D, [2024-01-05T15:21:30.885829 #293420] DEBUG -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] CACHE (0.1ms) SELECT MAX(union_query.max_updated_at) Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: FROM ((SELECT MAX(updated_at) AS max_updated_at FROM statuses) UNION (SELECT MAX(updated_at) AS max_updated_at FROM enumerations) UNION (SELECT MAX(updated_at) AS max_updated_at FROM types)) Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: AS union_query Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: Jan 05 15:21:30 openproject-upgrade openproject-web-1.service[293420]: I, [2024-01-05T15:21:30.905622 #293420] INFO -- : [6b1be5e9-99ad-47ab-be06-72eed521798a] method=GET path=/500 format=html controller=ErrorsController action=internal_error status=500 allocations=5002 duration=105.06 view=96.73 db= 0.13 user=4344 ``` *e attach error output in these log files if applicable* ### ### Screenshots and other files *If you have screenshots of the application's bug behavior or other relevant files, please drag them into this place or attach them using the "Files" section.* ### Environment information Postgresql 15.5 and postresql 16.x, both on localhost, same behaviour **OpenProject installation type** - [ ] Hosted cloud edition - [x] Packaged installation - Ubunt~~oia~~U22.04 - [ ] Docker All-in-one container - [ ] Docker-compose installation - [ ] Other (please specify) **OpenProject version** *13.1.2* **Browser** - [x] Chrome - [x] Firefox - [x] Safari - [x] Mobile Safari - [x] Other (please specify) **Language** *Different browser languages don't change anything*