API tools faq
paste
Guest User

Untitled

a guest
Feb 28th, 2013
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.92 KB | None | 0 0
raw download clone embed print report
  1. 2013-02-28 13:24:23,750 WARN [qtp1728933440-509] [jdbc.internal] Query slower than 10s threshold: actual execution time: 239.5328 seconds; Query: select results.* from (SELECT certname, resource, type, title, tags, exported, sourcefile, sourceline, rp.name, rp.value FROM (SELECT resource, sourceline, certname, exported, sourcefile, title, tags, catalog, type FROM catalog_resources JOIN certname_catalogs USING(catalog) WHERE (certname_catalogs.certname IN (SELECT name FROM certnames WHERE deactivated IS NULL)) AND ((catalog_resources.type = ?) AND (catalog_resources.exported = ?) AND (NOT (certname_catalogs.certname = ?)) AND (ARRAY[?::text] <@ tags))) subquery1 LEFT OUTER JOIN resource_params rp USING(resource)) results LIMIT 20001; Query Params: ('Concat::Fragment' - java.lang.String), (true - java.lang.Boolean), ('lxvcs03.mynetwork' - java.lang.String), ('git_dev_443' - java.lang.String)
  2. 2013-02-28 13:24:24,747 WARN [qtp1728933440-524] [jdbc.internal] Query slower than 10s threshold: actual execution time: 191.5323 seconds; Query: select results.* from (SELECT certname, resource, type, title, tags, exported, sourcefile, sourceline, rp.name, rp.value FROM (SELECT resource, sourceline, certname, exported, sourcefile, title, tags, catalog, type FROM catalog_resources JOIN certname_catalogs USING(catalog) WHERE (certname_catalogs.certname IN (SELECT name FROM certnames WHERE deactivated IS NULL)) AND ((catalog_resources.type = ?) AND (catalog_resources.exported = ?) AND (NOT (certname_catalogs.certname = ?)) AND (ARRAY[?::text] <@ tags))) subquery1 LEFT OUTER JOIN resource_params rp USING(resource)) results LIMIT 20001; Query Params: ('Firewall' - java.lang.String), (true - java.lang.Boolean), ('aicache01.mynetwork' - java.lang.String), ('allowmemcachetoforeman' - java.lang.String)
  3. 2013-02-28 13:24:25,518 WARN [qtp1728933440-523] [http.server] Use of unversioned APIs is deprecated; please use /v1/nodes
  4. 2013-02-28 13:24:27,359 WARN [qtp1728933440-523] [http.server] Use of unversioned APIs is deprecated; please use /v1/resources
  5. 2013-02-28 13:24:32,761 WARN [qtp1728933440-38] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4594.9261 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  6. 2013-02-28 13:25:09,846 WARN [qtp1728933440-525] [jdbc.internal] Query slower than 10s threshold: actual execution time: 122.9263 seconds; Query: select results.* from (SELECT certname, resource, type, title, tags, exported, sourcefile, sourceline, rp.name, rp.value FROM (SELECT resource, sourceline, certname, exported, sourcefile, title, tags, catalog, type FROM catalog_resources JOIN certname_catalogs USING(catalog) WHERE (certname_catalogs.certname IN (SELECT name FROM certnames WHERE deactivated IS NULL)) AND ((catalog_resources.type = ?) AND (catalog_resources.exported = ?) AND (NOT (certname_catalogs.certname = ?)) AND (ARRAY[?::text] <@ tags))) subquery1 LEFT OUTER JOIN resource_params rp USING(resource)) results LIMIT 20001; Query Params: ('Concat::Fragment' - java.lang.String), (true - java.lang.Boolean), ('apachelb01.mynetwork' - java.lang.String), ('puppet_balance' - java.lang.String)
  7. 2013-02-28 13:25:38,499 WARN [qtp1728933440-532] [jdbc.internal] Query slower than 10s threshold: actual execution time: 175.0572 seconds; Query: select results.* from (SELECT certname, resource, type, title, tags, exported, sourcefile, sourceline, rp.name, rp.value FROM (SELECT resource, sourceline, certname, exported, sourcefile, title, tags, catalog, type FROM catalog_resources JOIN certname_catalogs USING(catalog) WHERE (certname_catalogs.certname IN (SELECT name FROM certnames WHERE deactivated IS NULL)) AND ((catalog_resources.type = ?) AND (catalog_resources.exported = ?) AND (NOT (certname_catalogs.certname = ?)) AND (ARRAY[?::text] <@ tags))) subquery1 LEFT OUTER JOIN resource_params rp USING(resource)) results LIMIT 20001; Query Params: ('Database_grant' - java.lang.String), (true - java.lang.Boolean), ('myvoms01.mynetwork' - java.lang.String), ('voms_database_grant' - java.lang.String)
  8. 2013-02-28 13:26:12,173 WARN [qtp1728933440-36] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4604.5212 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  9. 2013-02-28 13:26:53,684 WARN [qtp1728933440-67] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4610.3362 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  10. 2013-02-28 13:28:12,111 WARN [qtp1728933440-54] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4631.3388 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  11. 2013-02-28 13:28:40,445 WARN [qtp1728933440-40] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4644.7623 seconds; Query: SELECT COUNT(*) AS c FROM (SELECT DISTINCT resource FROM catalog_resources cr, certname_catalogs cc, certnames c WHERE cr.catalog=cc.catalog AND cc.certname=c.name AND c.deactivated IS NULL) r; Query Params:
  12. 2013-02-28 13:28:41,805 WARN [qtp1728933440-59] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4635.7049 seconds; Query: SELECT COUNT(*) AS c FROM (SELECT DISTINCT resource FROM catalog_resources cr, certname_catalogs cc, certnames c WHERE cr.catalog=cc.catalog AND cc.certname=c.name AND c.deactivated IS NULL) r; Query Params:
  13. 2013-02-28 13:28:51,227 WARN [clojure-agent-send-off-pool-4] [jdbc.internal] Query slower than 10s threshold: actual execution time: 497.8848 seconds; Query: DELETE FROM catalogs WHERE NOT EXISTS (SELECT * FROM certname_catalogs cc WHERE cc.catalog=catalogs.hash); Query Params:
  14. 2013-02-28 13:29:01,350 WARN [qtp1728933440-336] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4596.0793 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  15. 2013-02-28 13:29:08,396 WARN [qtp1728933440-76] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4590.7424 seconds; Query: SELECT COUNT(*) AS c FROM (SELECT DISTINCT resource FROM catalog_resources cr, certname_catalogs cc, certnames c WHERE cr.catalog=cc.catalog AND cc.certname=c.name AND c.deactivated IS NULL) r; Query Params:
  16. 2013-02-28 13:29:25,980 WARN [qtp1728933440-63] [jdbc.internal] Query slower than 10s threshold: actual execution time: 4590.7316 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
  17. 2013-02-28 13:31:21,360 WARN [qtp1728933440-537] [jdbc.internal] Query slower than 10s threshold: actual execution time: 59.6775 seconds; Query: select results.* from (SELECT certname, resource, type, title, tags, exported, sourcefile, sourceline, rp.name, rp.value FROM (SELECT resource, sourceline, certname, exported, sourcefile, title, tags, catalog, type FROM catalog_resources JOIN certname_catalogs USING(catalog) WHERE (certname_catalogs.certname IN (SELECT name FROM certnames WHERE deactivated IS NULL)) AND ((catalog_resources.type = ?) AND (catalog_resources.exported = ?) AND (NOT (certname_catalogs.certname = ?)) AND (ARRAY[?::text] <@ tags))) subquery1 LEFT OUTER JOIN resource_params rp USING(resource)) results LIMIT 20001; Query Params: ('Concat::Fragment' - java.lang.String), (true - java.lang.Boolean), ('lxbsp2716.mynetwork' - java.lang.String), ('git_prod_443' - java.lang.String)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!