Bug #61546
quincy: barbican error: cannot create secret
0%
Description
from quincy run: http://qa-proxy.ceph.com/teuthology/yuriw-2023-05-30_20:22:01-rgw-wip-yuri5-testing-2023-05-30-0828-quincy-distro-default-smithi/7289972/teuthology.log
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers Traceback (most recent call last):
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1968, in exec_single_context
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers self.dialect.do_execute(
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
2023-05-30T21:01:25.604 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers cursor.execute(statement, parameters)
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers sqlite3.OperationalError: no such table: projects
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers The above exception was the direct cause of the following exception:
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers Traceback (most recent call last):
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/api/controllers/_init__.py", line 107, in handler
2023-05-30T21:01:25.605 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return fn(inst, *args, **kwargs)
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/api/controllers/__init__.py", line 93, in enforcer
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return fn(inst, *args, **kwargs)
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/api/controllers/__init__.py", line 155, in content_types_enforcer
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return fn(inst, *args, **kwargs)
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/api/controllers/secrets.py", line 440, in on_post
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers project = res.get_or_create_project(external_project_id)
2023-05-30T21:01:25.606 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/common/resources.py", line 43, in get_or_create_project
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers project = project_repo.find_by_external_project_id(project_id,
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/barbican/model/repositories.py", line 622, in find_by_external_project_id
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers entity = query.one()
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2797, in one
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return self._iter().one() # type: ignore
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
2023-05-30T21:01:25.607 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2232, in execute
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return self._execute_internal(
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2127, in _execute_internal
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers result: Result[Any] = compile_state_cls.orm_execute_statement(
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers result = conn.execute(
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
2023-05-30T21:01:25.608 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return meth(
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return connection._execute_clauseelement(
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers ret = self._execute_context(
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers return self._exec_single_context(
2023-05-30T21:01:25.609 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1987, in _exec_single_context
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers self._handle_dbapi_exception(
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2341, in _handle_dbapi_exception
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers raise newraise.with_traceback(exc_info2) from e
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers self.dialect.do_execute(
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers File "/home/ubuntu/cephtest/barbican/.barbicanenv/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
2023-05-30T21:01:25.610 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers cursor.execute(statement, parameters)
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: projects
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers [SQL: SELECT projects.external_id AS projects_external_id, projects.id AS projects_id, projects.created_at AS projects_created_at, projects.updated_at AS projects_updated_at, projects.deleted_at AS projects_deleted_at, projects.deleted AS projects_deleted, projects.status AS projects_status
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers FROM projects
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers WHERE projects.external_id = ?]
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers [parameters: ('24c98cf0a19e4d97a910cdd7d49746cc',)]
2023-05-30T21:01:25.611 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers (Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-05-30T21:01:25.612 INFO:tasks.barbican.client.0.smithi023.stdout:2023-05-30 21:01:25.593 40251 ERROR barbican.api.controllers [00m
2023-05-30T21:01:25.612 ERROR:teuthology.contextutil:Saw exception from nested tasks
Traceback (most recent call last):
File "/home/teuthworker/src/git.ceph.com_teuthology_fa97ddd17d12e6d74b49196948f66e54fa009130/teuthology/contextutil.py", line 31, in nested
vars.append(enter())
File "/usr/lib/python3.8/contextlib.py", line 113, in enter
return next(self.gen)
File "/home/teuthworker/src/github.com_ceph_ceph-c_e4419a8b005c655fde4f0588bbffe7fe5b9c5efb/qa/tasks/barbican.py", line 372, in create_secrets
raise Exception("Cannot create secret")
Exception: Cannot create secret
Related issues
History
#1 Updated by Casey Bodley 10 months ago
- Duplicates Bug #54247: rgw/crypt/barbican: Cannot create secret added
#2 Updated by Casey Bodley 10 months ago
- Status changed from New to Duplicate
hey Shilpa, this was fixed in https://tracker.ceph.com/issues/54247, but the pacific and quincy backports never happened. could you please handle those?