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

MariaDB fail to execute CONVERT TO CHARACTER

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.5.10
    • N/A
    • Server
    • None
    • Ubuntu 20.04, Ubuntu 18.04, CentOS 8, Debian 10

    Description

      After switching our CI to mariadb 10.5.10 from 10.5.9 we started seing frequent but still interminent errors during execution of the service database alembic migrtations.
      Migration always fail on the exact same query:

      Error during database migration: (pymysql.err.OperationalError) (1054, "Unknown column '`cinder`.`consistencygroups_1`.`deleted`' in 'CHECK'")
      		 
      [SQL: ALTER TABLE consistencygroups CONVERT TO CHARACTER SET utf8]
      		 
      (Background on this error at: http://sqlalche.me/e/13/e3q8)

      In mariadb-server journal I see only pretty much the same message:

      [Warning] WSREP: Ignoring error 'Unknown column '`cinder`.`consistencygroups_1`.`deleted`' in 'CHECK'' on query. Default database: 'cinder'. Query: 'ALTER TABLE consistencygroups CONVERT TO CHARACTER SET utf8', Error_code: 1054

      This stopped happening once we reverted MariaDB version back to 10.5.9 in CI.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25091 CREATE TABLE: field references qualified by a wrong table name succeed

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25672 table alias from previous statement interferes later commands

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              noonedeadpunk Dmitriy Rabotyagov
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.