yahoo-eng-team team mailing list archive

[Steve Baker <sbaker@xxxxxxxxxx>]

This looks like a keystone tuning issue

** Changed in: heat
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1371801

Title:
  Clouds with high usage gets slower because of token table size getting
  bigger

Status in Orchestration API (Heat):
  Invalid
Status in OpenStack Identity (Keystone):
  New

Bug description:
  Hi guys,

      Clouds with high usage gets slower because of token table size
  getting bigger and bigger without any automated cleanup of any kind.
  The problem affects keystone but also nova-network (where the security
  group listing will get increasingly slower because there're no
  automated cleanup either).

  This request has been running for 394 seconds and everything is locked in the cloud when this happens:
  | 82659 | keystone | 192.168.2.121:56197 | keystone | Query   |  394 | Sending data | SELECT token.id AS token_id, token.expires AS token_expires, token.extra AS token_extra, token.valid AS token_valid, token.user_id AS token_user_id, token.trust_id AS token_trust_id
  FROM token
  WHERE token.valid = 1 AND token.expires > '2014-09-19 21:15:25' AND token.trust_id = '6297a1b419b04813a77c9d56c93f7eb4' |

  Dave

To manage notifications about this bug go to:
https://bugs.launchpad.net/heat/+bug/1371801/+subscriptions