yahoo-eng-team team mailing list archive

[Launchpad Bug Tracker <1832817@xxxxxxxxxxxxxxxxxx>]

[Expired for OpenStack Compute (nova) because there has been no activity
for 60 days.]

** Changed in: nova
       Status: Incomplete => Expired

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1832817

Title:
  Multiple entries for the same host allowed in the services table

Status in OpenStack Compute (nova):
  Expired

Bug description:
  it has been noticed that it is possible to have multiple entries in
  the services table for the same host with diferent versions, leading
  to API failures

  MariaDB [nova]> select host, services.binary, version from services where host="cc-compute01-kna1"
      -> ;
  +-------------------+--------------+---------+
  | host | binary | version |
  +-------------------+--------------+---------+
  | cc-compute01-kna1 | nova-compute | 35 |
  | cc-compute01-kna1 | nova-compute | 0 |
  +-------------------+--------------+---------+

  although a general code issue

  MariaDB [nova]> desc services;
  +-----------------+--------------+------+-----+---------+----------------+
  | Field           | Type         | Null | Key | Default | Extra          |
  +-----------------+--------------+------+-----+---------+----------------+
  | created_at      | datetime     | YES  |     | NULL    |                |
  | updated_at      | datetime     | YES  |     | NULL    |                |
  | deleted_at      | datetime     | YES  |     | NULL    |                |
  | id              | int(11)      | NO   | PRI | NULL    | auto_increment |
  | host            | varchar(255) | YES  | MUL | NULL    |                |
  | binary          | varchar(255) | YES  |     | NULL    |                |
  | topic           | varchar(255) | YES  |     | NULL    |                |
  | report_count    | int(11)      | NO   |     | NULL    |                |
  | disabled        | tinyint(1)   | YES  |     | NULL    |                |
  | deleted         | int(11)      | YES  |     | NULL    |                |
  | disabled_reason | varchar(255) | YES  |     | NULL    |                |
  | last_seen_up    | datetime     | YES  |     | NULL    |                |
  | forced_down     | tinyint(1)   | YES  |     | NULL    |                |
  | version         | int(11)      | YES  |     | NULL    |                |
  | uuid            | varchar(36)  | YES  | UNI | NULL    |                |
  +-----------------+--------------+------+-----+---------+----------------+

  as per the host column, it has a MUL key, as multiple services can run
  per hosts this is ok; however can the combination of binary and host
  may be considered?

  anecdotally i am informed that when multiple service versions exist,
  the lowest is chosen - is it anticipated that multiple service
  versions could be in place (and in use) simultaneously?

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