yahoo-eng-team team mailing list archive

[David Hill <1371801@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: keystone
     Importance: Undecided
         Status: New


** Tags: keystone nova openstack slow

-- 
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 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/keystone/+bug/1371801/+subscriptions