[Bug 2064117] Re: keystone/noble, now 2:25.0.0-0ubuntu1 keystone -manage db_sync

[Johan Bosch]

Yea that looks alot better then mine. il try to have some time tomorrow
and i nuke the cluster and make a clean install and do things in a bit
of a diffrent order i think

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

Title:
  keystone/noble,now 2:25.0.0-0ubuntu1 keystone -manage db_sync

Status in keystone package in Ubuntu:
  Incomplete

Bug description:
  Fresh ubuntu 24.04 install when running
  su -s /bin/sh -c "keystone-manage db_sync " keystone

  This ends up in /var/log/apache2/keystone.log

  2024-04-29 12:47:10.184549   File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
  2024-04-29 12:47:10.184554     err.raise_mysql_exception(self._data)
  2024-04-29 12:47:10.184572   File "/usr/lib/python3/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
  2024-04-29 12:47:10.184577     raise errorclass(errno, errval)
  2024-04-29 12:47:10.184629 sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'keystone.project' doesn't exist")
  2024-04-29 12:47:10.184634 [SQL: SELECT project.id AS project_id, project.name AS project_name, project.domain_id AS project_domain_id, project.description AS project_description, project.enabled AS project_enabled, project.extra AS project_extra, project.parent_id AS project_parent_id, project.is_domain AS project_is_domain
  2024-04-29 12:47:10.184640 FROM project
  2024-04-29 12:47:10.184644 WHERE project.name = %(name_1)s AND project.domain_id = %(domain_id_1)s]
  2024-04-29 12:47:10.184648 [parameters: {'name_1': 'Default', 'domain_id_1': '<<keystone.domain.root>>'}]

  
  after dbsync is run the project table does exist so i think things are just done in wrong order, result is that keystone dosnt work afterwards though

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