yahoo-eng-team team mailing list archive

[David Hill <1371801@xxxxxxxxxxxxxxxxxx>]

This bug may be affecting only heat when using trust delegation with a
domain other than default.  Perhaps I didn't read something somewhere
warning us about that...

** Also affects: heat
   Importance: Undecided
       Status: New

** Tags added: heat

** Tags removed: nova openstack

** Tags added: mysql

-- 
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):
  New
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