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

Can't create table in 10.4.13

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.4.13
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:
    • 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)
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration