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

mysql_upgrade from 10.4.6 10.4.7 failure

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.7
    • N/A
    • Character Sets
    • None
    • Windows 10 x64

    Description

      We recently upgraded our test environment from 10.4.6 to 10.4.7. We always run mysql_upgrade after an upgrade to make sure everything work fine.

      With the recent update from 10.4.6 10.4.7 this upgrade job fails at "mysql_fix_privilege_tables" with following error messages.

      Phase 4/7: Running 'mysql_fix_privilege_tables'
      		 
      ERROR 1267 (HY000) at line 7: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 59: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 168: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 179: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 195: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 322: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 393: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 400: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      ERROR 1267 (HY000) at line 407: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp850_general_ci,COERCIBLE) for operation 'like'
      		 
      FATAL ERROR: Upgrade failed

      We cannot get this upgrade to work through the end. When we revert back to 10.4.6 and calling mysql_upgrade --force to simulate an upgrade everything work fine.

      The server run fine as far as we can see, but the error is weird. We cannot find out what table or column is invoked in this problem.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20228 `mysql_upgrade` fails on every version upgrade: "ERROR 1267 (HY000) at line 7: Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'"

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              bar Alexander Barkov
              BrainFooLong Roland
              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.