yahoo-eng-team team mailing list archive

[sean mooney <1940555@xxxxxxxxxxxxxxxxxx>]

** Also affects: nova
   Importance: Undecided
       Status: New

** Changed in: nova
       Status: New => Triaged

** Changed in: nova
   Importance: Undecided => Critical

** Changed in: nova
     Assignee: (unassigned) => sean mooney (sean-k-mooney)

-- 
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/1940555

Title:
  Compute Component: Error: (pymysql.err.ProgrammingError) (1146, "Table
  'nova_api.cell_mappings' doesn't exist")

Status in OpenStack Compute (nova):
  Triaged
Status in tripleo:
  Triaged

Bug description:
  https://logserver.rdoproject.org/openstack-component-
  compute/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-
  centos-8-standalone-compute-
  master/7dac4e0/logs/undercloud/var/log/extra/podman/containers/nova_db_sync/stdout.log.txt.gz

  Is [api_database]/connection set in nova.conf?
  Is the cell0 database connection URL correct?
  Error: (pymysql.err.ProgrammingError) (1146, "Table 'nova_api.cell_mappings' doesn't exist")
  [SQL: SELECT cell_mappings.created_at AS cell_mappings_created_at, cell_mappings.updated_at AS cell_mappings_updated_at, cell_mappings.id AS cell_mappings_id, cell_mappings.uuid AS cell_mappings_uuid, cell_mappings.name AS cell_mappings_name, cell_mappings.transport_url AS cell_mappings_transport_url, cell_mappings.database_connection AS cell_mappings_database_connection, cell_mappings.disabled AS cell_mappings_disabled 
  FROM cell_mappings 
  WHERE cell_mappings.uuid = %(uuid_1)s 
   LIMIT %(param_1)s]
  [parameters: {'uuid_1': '00000000-0000-0000-0000-000000000000', 'param_1': 1}]
  (Background on this error at: http://sqlalche.me/e/14/f405)

  
  https://logserver.rdoproject.org/openstack-component-compute/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-centos-8-standalone-compute-master/7dac4e0/logs/undercloud/home/zuul/standalone_deploy.log.txt.gz

  + echo 'Running command: '\''/usr/bin/bootstrap_host_exec nova_conductor su nova -s /bin/bash -c '\''/usr/bin/nova-manage db sync '\'''\'''
  + exec /usr/bin/bootstrap_host_exec nova_conductor su nova -s /bin/bash -c ''\''/usr/bin/nova-manage' db sync \'
  2021-08-19 08:17:33.982762 | fa163e06-c6d2-5dfd-0459-00000000197e |      FATAL | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_3 | standalone | error={"changed": false, "msg": "Failed containers: nova_api_db_sync, nova_api_map_cell0, nova_api_ensure_default_cell, nova_db_sync"}
  2021-08-19 08:17:33.983320 | fa163e06-c6d2-5dfd-0459-00000000197e |     TIMING | tripleo_container_manage : Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_3 | standalone | 0:19:23.159835 | 41.20s

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