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

upgrades from 11.4 to 11.5 don't work

Details

    Description

      The failure happens in the bb-11.5-bar-MDEV-25829 branch.

      See the failed "major-upgrade-server" step for the preview branch in buildbot, the output looks like, e.g.

      Phase 3/8: Running 'mysql_fix_privilege_tables'
      		 
      ERROR 1267 (HY000) at line 675: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
      		 
      ERROR 1064 (42000) at line 676: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
      		 
      ERROR 1243 (HY000) at line 677: Unknown prepared statement handler (stmt) given to EXECUTE
      		 
      ERROR 1243 (HY000) at line 678: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
      		 
      ERROR 1267 (HY000) at line 679: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
      		 
      ERROR 1064 (42000) at line 680: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
      		 
      ERROR 1243 (HY000) at line 681: Unknown prepared statement handler (stmt) given to EXECUTE
      		 
      ERROR 1243 (HY000) at line 682: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
      		 
      FATAL ERROR: Upgrade failed

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25829 Change default Unicode collation to uca1400_ai_ci

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

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Description see the failed "major-upgrade-server" step in buildbot, the output looks like, e.g.
            {noformat}
            Phase 3/8: Running 'mysql_fix_privilege_tables'
            ERROR 1267 (HY000) at line 675: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 676: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 677: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 678: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            ERROR 1267 (HY000) at line 679: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 680: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 681: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 682: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            FATAL ERROR: Upgrade failed
            {noformat}             		see the failed "major-upgrade-server" step for the preview branch in buildbot, the output looks like, e.g.
            {noformat}
            Phase 3/8: Running 'mysql_fix_privilege_tables'
            ERROR 1267 (HY000) at line 675: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 676: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 677: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 678: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            ERROR 1267 (HY000) at line 679: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 680: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 681: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 682: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            FATAL ERROR: Upgrade failed
            {noformat}
            bar Alexander Barkov made changes -
            Description see the failed "major-upgrade-server" step for the preview branch in buildbot, the output looks like, e.g.
            {noformat}
            Phase 3/8: Running 'mysql_fix_privilege_tables'
            ERROR 1267 (HY000) at line 675: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 676: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 677: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 678: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            ERROR 1267 (HY000) at line 679: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 680: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 681: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 682: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            FATAL ERROR: Upgrade failed
            {noformat}             		The failure happens in the bb-11.5-bar-MDEV-25829 branch.

            See the failed "major-upgrade-server" step for the preview branch in buildbot, the output looks like, e.g.
            {noformat}
            Phase 3/8: Running 'mysql_fix_privilege_tables'
            ERROR 1267 (HY000) at line 675: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 676: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 677: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 678: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            ERROR 1267 (HY000) at line 679: Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            ERROR 1064 (42000) at line 680: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL' at line 1
            ERROR 1243 (HY000) at line 681: Unknown prepared statement handler (stmt) given to EXECUTE
            ERROR 1243 (HY000) at line 682: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
            FATAL ERROR: Upgrade failed
            {noformat}
            bar Alexander Barkov added a comment -

            The problem is repeatable with this script:

            SET @have_csv = (SELECT support FROM information_schema.engines WHERE engine = 'CSV');
            		 
            SELECT @have_csv ='YES';


            ERROR 1267 (HY000): Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='

            bar Alexander Barkov added a comment - The problem is repeatable with this script: SET @have_csv = ( SELECT support FROM information_schema.engines WHERE engine = 'CSV' ); SELECT @have_csv = 'YES' ; ERROR 1267 (HY000): Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (utf8mb3_uca1400_ai_ci,COERCIBLE) for operation '='
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            JIraAutomate JiraAutomate made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            bar Alexander Barkov made changes -
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 11.6.0 [ 29839 ]
            Fix Version/s 11.5 [ 29506 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            People

              bar Alexander Barkov
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.