Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Duplicate
-
10.4.13
-
None
-
OS - RHEL 8.2
Hardware ppc64le , 50 G HDD 16G Memory
Description
As part of db sync in openstack keystone below par of code is in execution
/usr/bin/keystone-manage db_sync
from where it goes and hit following function
/usr/lib/python3.6/site-packages/keystone/common/sql/upgrades.py(226)offline_sync_database_to_version() where it tries to run
"expand_schema()" function that is where the db crashes.
Attaching the logs
Attachments
Issue Links
- duplicates
-
-
- Closed
-
Activity
Here is the output of show create table user
MariaDB [keystone]> show create table user;
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user | CREATE TABLE `user` ( `id` varchar(64) NOT NULL, `name` varchar(255) NOT NULL, `extra` text DEFAULT NULL, `password` varchar(128) DEFAULT NULL, `enabled` tinyint(1) DEFAULT NULL, `domain_id` varchar(64) NOT NULL, `default_project_id` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ixu_user_name_domain_id` (`domain_id`,`name`), CONSTRAINT `CONSTRAINT_1` CHECK (`enabled` in (0,1)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
Thanks! I repeated the crash, this is the same bug as MDEV-22563, fixed in 10.4.14 (which hasn't been released yet)
can you include the `show create table user` please.