[Bug 1032633] Re: Keystone's token table grows unconditionally.

[Andrew Glen-Young]

** Description changed:

  Keystone's `token` table grows unconditionally with expired tokens.
  
  Keystone should provide a backend-agnostic method to find and delete
  these tokens. This could be run via a periodic task or supplied as a
  script to run as a cron job.
  
  An example SQL statement (if you're using a SQL backend) to workaround
  this problem:
  
      sql> DELETE FROM token WHERE expired <= NOW();
  
  It may be ideal to allow a date smear to allow older tokens to persist
  if needed.
+ 
+ System Information:
+ 
+ $ dpkg-query --show keystone
+ keystone        2012.1+stable~20120608-aff45d6-0ubuntu1
+ 
+ $ cat /etc/lsb-release 
+ DISTRIB_ID=Ubuntu
+ DISTRIB_RELEASE=12.04
+ DISTRIB_CODENAME=precise
+ DISTRIB_DESCRIPTION="Ubuntu 12.04 LTS"

** Summary changed:

- Keystone's token table grows unconditionally.
+ Keystone's token table grows unconditionally when using SQL backend.

** Description changed:

- Keystone's `token` table grows unconditionally with expired tokens.
+ Keystone's `token` table grows unconditionally with expired tokens when
+ using the SQL backend.
  
  Keystone should provide a backend-agnostic method to find and delete
  these tokens. This could be run via a periodic task or supplied as a
  script to run as a cron job.
  
  An example SQL statement (if you're using a SQL backend) to workaround
  this problem:
  
-     sql> DELETE FROM token WHERE expired <= NOW();
+     sql> DELETE FROM token WHERE expired <= NOW();
  
  It may be ideal to allow a date smear to allow older tokens to persist
  if needed.
+ 
+ Choosing the `memcache` backend may workaround this issue, but SQL is
+ the package default.
  
  System Information:
  
  $ dpkg-query --show keystone
  keystone        2012.1+stable~20120608-aff45d6-0ubuntu1
  
- $ cat /etc/lsb-release 
+ $ cat /etc/lsb-release
  DISTRIB_ID=Ubuntu
  DISTRIB_RELEASE=12.04
  DISTRIB_CODENAME=precise
  DISTRIB_DESCRIPTION="Ubuntu 12.04 LTS"

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to keystone in Ubuntu.
https://bugs.launchpad.net/bugs/1032633

Title:
  Keystone's token table grows unconditionally when using SQL backend.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keystone/+bug/1032633/+subscriptions