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

MariaDB fail to execute CONVERT TO CHARACTER

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.5.10
    • Fix Version/s: N/A
    • Component/s: Server
    • Labels:
      None
    • Environment:
      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

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              noonedeadpunk Dmitriy Rabotyagov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration