Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.4.13
-
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) |