[MDEV-23181]  Can't create table in 10.4.13 Created: 2020-07-15  Updated: 2020-09-06  Resolved: 2020-09-06

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.4.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alexey Shabalin Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

ALT Linux p9 branch
Python 3.7.4, Nova 20.3, python3-module-SQLAlchemy-1.3.8-alt1, python3-module-alembic-1.3.1-alt1, python3-module-pymysql-0.9.3-alt1


 Description   

Deploy openstack-nova with mariadb-10.4.13 have a error. Setup with mariadb-10.4.12 work fine.

CREATE DATABASE nova;
 
GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' IDENTIFIED BY '123456';
 
GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' IDENTIFIED BY '123456';

After that 

# su -s /bin/sh -c "nova-manage db sync" nova
 
#

Error:

oslo_db.exception.DBError: (pymysql.err.InternalError) (1005, 'Can\'t create table `aggregate_hosts`.`alembic_version` (errno: 165 "Table is read only")')
 
[SQL: 
CREATE TABLE alembic_version (
 
	version_num VARCHAR(32) NOT NULL, 
	CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
 
)
 
 
 
]
 
(Background on this error at: http://sqlalche.me/e/2j85)



 Comments   
Comment by Elena Stepanova [ 2020-08-04 ]

Could you please run the same CREATE statement on the same MariaDB server directly from the command line client? Thanks.

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