yahoo-eng-team team mailing list archive

[Dave Chen <wei.d.chen@xxxxxxxxx>]

Public bug reported:

MariaDB [keystone]> select * from endpoint where url = "http://10.239.1.1:5010/v2.0"; and interface = "admin";
+----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
| id                               | legacy_endpoint_id               | interface | service_id                       | url                         | extra | enabled | region_id |
+----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
| 38a55638f08c4be1afdd3172f15c4144 | 2dcb5c14c4da4a22a060c78f073decac | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
| a365f3fd58eb482fa44603fe83f8b2e0 | 26ef22b4dd8b487bb2f29f52cbbb2fec | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
| b0f41268a6b2438b92d977a464fd7f2d | 97b1ce4adc794b3598fb5a521e63276b | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
| dd3c0c9880e74d55b4d7de71ac5207ac | 6d994b06ed8942cda56bd2c03cbc56c8 | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
+----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
4 rows in set (0.00 sec)

These entries has the same interface, same url etc. except "id" and
"legacy_endpoint_id". User can create many redundant endpoints as long
as he/she wants to, just via the command like following:

keystone --debug endpoint-create --region RegionOne  --service
a1663c0dbba64425b5767688ac86fa10 --publicurl http://10.239.1.1:5010/v2.0
--adminurl http://10.239.1.1:5010/v2.0 --internalurl
http://10.239.1.1:5010/v2.0

I'm not sure whether this is an intentional behavior, existed endpoints
check to avoid redundant entries seems is needed here.

** Affects: keystone
     Importance: Undecided
     Assignee: Dave Chen (wei-d-chen)
         Status: New

** Changed in: keystone
     Assignee: (unassigned) => Dave Chen (wei-d-chen)

** Summary changed:

- Redundant endpoints found in table "endpoint"
+ Redundant endpoints found in the table "endpoint"

** Description changed:

  MariaDB [keystone]> select * from endpoint where url = "http://10.239.1.1:5010/v2.0"; and interface = "admin";
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  | id                               | legacy_endpoint_id               | interface | service_id                       | url                         | extra | enabled | region_id |
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  | 38a55638f08c4be1afdd3172f15c4144 | 2dcb5c14c4da4a22a060c78f073decac | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
  | a365f3fd58eb482fa44603fe83f8b2e0 | 26ef22b4dd8b487bb2f29f52cbbb2fec | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
  | b0f41268a6b2438b92d977a464fd7f2d | 97b1ce4adc794b3598fb5a521e63276b | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
  | dd3c0c9880e74d55b4d7de71ac5207ac | 6d994b06ed8942cda56bd2c03cbc56c8 | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  4 rows in set (0.00 sec)
  
- 
  These entries has the same interface, same url etc. except "id" and
  "legacy_endpoint_id". User can create many redundant endpoints as long
- as he/she wants, just via the command like following:
+ as he/she wants to, just via the command like following:
  
  keystone --debug endpoint-create --region RegionOne  --service
  a1663c0dbba64425b5767688ac86fa10 --publicurl http://10.239.1.1:5010/v2.0
  --adminurl http://10.239.1.1:5010/v2.0 --internalurl
  http://10.239.1.1:5010/v2.0
  
- 
- I'm not sure whether this is an intentional behavior, existed endpoints check to avoid redundant entries seems is needed here.
+ I'm not sure whether this is an intentional behavior, existed endpoints
+ check to avoid redundant entries seems is needed here.

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

Title:
  Redundant endpoints found in the table "endpoint"

Status in OpenStack Identity (Keystone):
  New

Bug description:
  MariaDB [keystone]> select * from endpoint where url = "http://10.239.1.1:5010/v2.0"; and interface = "admin";
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  | id                               | legacy_endpoint_id               | interface | service_id                       | url                         | extra | enabled | region_id |
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  | 38a55638f08c4be1afdd3172f15c4144 | 2dcb5c14c4da4a22a060c78f073decac | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
  | a365f3fd58eb482fa44603fe83f8b2e0 | 26ef22b4dd8b487bb2f29f52cbbb2fec | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
  | b0f41268a6b2438b92d977a464fd7f2d | 97b1ce4adc794b3598fb5a521e63276b | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | RegionOne |
  | dd3c0c9880e74d55b4d7de71ac5207ac | 6d994b06ed8942cda56bd2c03cbc56c8 | admin     | a1663c0dbba64425b5767688ac86fa10 | http://10.239.1.1:5010/v2.0 | {}    |       1 | regionOne |
  +----------------------------------+----------------------------------+-----------+----------------------------------+-----------------------------+-------+---------+-----------+
  4 rows in set (0.00 sec)

  These entries has the same interface, same url etc. except "id" and
  "legacy_endpoint_id". User can create many redundant endpoints as long
  as he/she wants to, just via the command like following:

  keystone --debug endpoint-create --region RegionOne  --service
  a1663c0dbba64425b5767688ac86fa10 --publicurl
  http://10.239.1.1:5010/v2.0 --adminurl http://10.239.1.1:5010/v2.0
  --internalurl http://10.239.1.1:5010/v2.0

  I'm not sure whether this is an intentional behavior, existed
  endpoints check to avoid redundant entries seems is needed here.

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