[MDEV-23312] MariaDB version 10.4.13 crashes while creating tables for openstack keystone Created: 2020-07-28  Updated: 2020-08-05  Resolved: 2020-08-05

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Create Table
Affects Version/s: 10.4.13
Fix Version/s: 10.5.4, 10.4.14

Type: Bug Priority: Blocker
Reporter: Kumar Biplab Singh Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

OS - RHEL 8.2
Hardware ppc64le , 50 G HDD 16G Memory


Attachments: Text File mariadb_crash.log    
Issue Links:
Duplicate
duplicates MDEV-22563 Segfault on duplicate free of Item_f... Closed

 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



 Comments   
Comment by Daniel Black [ 2020-07-28 ]

can you include the `show create table user` please.

Comment by Kumar Biplab Singh [ 2020-07-28 ]

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)

Comment by Alice Sherepa [ 2020-07-28 ]

Thanks! I repeated the crash, this is the same bug as MDEV-22563, fixed in 10.4.14 (which hasn't been released yet)

Generated at Thu Feb 08 09:21:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.