yahoo-eng-team team mailing list archive

[Robert Colvin <1832817@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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?

** Affects: nova
     Importance: Undecided
         Status: New

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

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