| 2020-10-08 22:48:24 |
David Ames |
bug |
|
|
added bug |
| 2020-10-09 13:45:48 |
Corey Bryant |
barbican (Ubuntu): status |
New |
Triaged |
|
| 2020-10-09 13:45:54 |
Corey Bryant |
barbican (Ubuntu): importance |
Undecided |
Critical |
|
| 2020-10-09 13:47:52 |
Corey Bryant |
nominated for series |
|
Ubuntu Groovy |
|
| 2020-10-09 13:47:52 |
Corey Bryant |
bug task added |
|
barbican (Ubuntu Groovy) |
|
| 2020-10-09 13:47:52 |
Corey Bryant |
nominated for series |
|
Ubuntu Focal |
|
| 2020-10-09 13:47:52 |
Corey Bryant |
bug task added |
|
barbican (Ubuntu Focal) |
|
| 2020-10-09 13:47:59 |
Corey Bryant |
barbican (Ubuntu Focal): status |
New |
Triaged |
|
| 2020-10-09 13:48:01 |
Corey Bryant |
barbican (Ubuntu Focal): importance |
Undecided |
Critical |
|
| 2020-10-09 13:50:35 |
Chris MacNaughton |
barbican (Ubuntu Focal): assignee |
|
Chris MacNaughton (chris.macnaughton) |
|
| 2020-10-09 13:50:37 |
Chris MacNaughton |
barbican (Ubuntu Groovy): assignee |
|
Chris MacNaughton (chris.macnaughton) |
|
| 2020-10-09 13:57:02 |
Chris MacNaughton |
barbican (Ubuntu Groovy): status |
Triaged |
Fix Released |
|
| 2020-10-13 11:06:45 |
Chris MacNaughton |
summary |
barbican-manage db upgrade fails with MySQL8 |
[SRU] barbican-manage db upgrade fails with MySQL8 |
|
| 2020-10-13 11:12:57 |
Chris MacNaughton |
description |
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters
ERROR: (pymysql.err.InternalError) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https://github.com/sqlalchemy/alembic/issues/699 |
[Impact]
New installations of OpenStack Barbican with Mysql8 fail with a traceback when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Barbican on Ubuntu Focal. Using Focal is expected to have a traceback and with this change is expected to setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently does not work at all with mysql8 which ships with Ubuntu Focal.
The proposed change is a minimal change that merely removes a constraint creation that is only added by the relevant libraries with Mysql8.
-----------------------------------------------------
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters
ERROR: (pymysql.err.InternalError) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https://github.com/sqlalchemy/alembic/issues/699 |
|
| 2020-11-10 13:27:13 |
Chris MacNaughton |
tags |
|
in-stable-ussuri |
|
| 2021-01-28 08:17:54 |
Chris MacNaughton |
description |
[Impact]
New installations of OpenStack Barbican with Mysql8 fail with a traceback when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Barbican on Ubuntu Focal. Using Focal is expected to have a traceback and with this change is expected to setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently does not work at all with mysql8 which ships with Ubuntu Focal.
The proposed change is a minimal change that merely removes a constraint creation that is only added by the relevant libraries with Mysql8.
-----------------------------------------------------
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters
ERROR: (pymysql.err.InternalError) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https://github.com/sqlalchemy/alembic/issues/699 |
[Impact]
New installations of OpenStack Barbican with Mysql8 fail with a traceback when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Barbican on Ubuntu Focal. Using Focal is expected to have a traceback and with this change is expected to setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently does not work at all with mysql8 which ships with Ubuntu Focal.
The proposed change is a cherry-pick from upstream that resolves this issue by rebasing the old migrations into a single larger migration. This
only affects new deploys that would normally step through all of the old
migrations so shouldn't affect running deploys.
-----------------------------------------------------
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters
ERROR: (pymysql.err.InternalError) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https://github.com/sqlalchemy/alembic/issues/699 |
|
| 2021-02-16 19:54:46 |
Brian Murray |
barbican (Ubuntu Focal): status |
Triaged |
Fix Committed |
|
| 2021-02-16 19:54:48 |
Brian Murray |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
| 2021-02-16 19:54:51 |
Brian Murray |
bug |
|
|
added subscriber SRU Verification |
| 2021-02-16 19:54:55 |
Brian Murray |
tags |
in-stable-ussuri |
in-stable-ussuri verification-needed verification-needed-focal |
|
| 2021-03-12 10:59:33 |
Chris MacNaughton |
tags |
in-stable-ussuri verification-needed verification-needed-focal |
in-stable-ussuri verification-failed verification-failed-focal |
|
| 2021-03-18 19:03:57 |
Łukasz Zemczak |
tags |
in-stable-ussuri verification-failed verification-failed-focal |
in-stable-ussuri verification-needed verification-needed-focal |
|
| 2021-03-22 15:10:16 |
David Ames |
tags |
in-stable-ussuri verification-needed verification-needed-focal |
in-stable-ussuri verification-done-focal |
|
| 2021-03-25 10:33:26 |
Launchpad Janitor |
barbican (Ubuntu Focal): status |
Fix Committed |
Fix Released |
|
| 2021-03-25 10:33:30 |
Łukasz Zemczak |
removed subscriber Ubuntu Stable Release Updates Team |
|
|
|
| 2021-03-29 14:10:56 |
Chris MacNaughton |
tags |
in-stable-ussuri verification-done-focal |
in-stable-ussuri verification-done-focal verification-ussuri-needed |
|
| 2021-03-30 16:23:11 |
David Ames |
tags |
in-stable-ussuri verification-done-focal verification-ussuri-needed |
in-stable-ussuri verification-done-focal verification-done-ussuri |
|
| 2021-04-01 12:46:47 |
Chris MacNaughton |
bug task added |
|
cloud-archive |
|
| 2021-04-01 12:46:54 |
Chris MacNaughton |
cloud-archive: status |
New |
Fix Committed |
|
| 2021-04-01 12:47:01 |
Chris MacNaughton |
nominated for series |
|
cloud-archive/ussuri |
|
| 2021-04-01 12:47:01 |
Chris MacNaughton |
bug task added |
|
cloud-archive/ussuri |
|
| 2021-04-01 12:47:14 |
Chris MacNaughton |
nominated for series |
|
cloud-archive/victoria |
|
| 2021-04-01 12:47:14 |
Chris MacNaughton |
bug task added |
|
cloud-archive/victoria |
|
| 2021-04-01 12:47:51 |
Chris MacNaughton |
cloud-archive/victoria: status |
New |
Fix Released |
|
| 2021-04-01 12:47:54 |
Chris MacNaughton |
cloud-archive/ussuri: status |
New |
Fix Committed |
|
| 2021-04-01 12:47:58 |
Chris MacNaughton |
cloud-archive: status |
Fix Committed |
Invalid |
|
| 2021-04-06 08:36:24 |
Chris MacNaughton |
cloud-archive/ussuri: status |
Fix Committed |
Fix Released |
|
