Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23181

Can't create table in 10.4.13

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.4.13
    • N/A
    • OTHER
    • 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)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            shaba Alexey Shabalin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.