Project

General

Profile

Actions

Bug #21340

open

multiple settings lookup for http proxy for every UI action

Added by Ohad Levy about 7 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

in the logs i see multiple times per request:

13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]
13:41:37 rails.1   | 2017-10-16T13:41:37 83156aca [sql] [D]   CACHE (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."name" ASC LIMIT ?  [["name", "http_proxy"], ["LIMIT", 1]]


Related issues 1 (0 open1 closed)

Related to Foreman - Feature #20201: Global HTTP proxy for outgoing requestsClosedSebastian GräßlActions
Actions

Also available in: Atom PDF