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

Changing aria block size to 1024 will break install_system_tables

    XMLWordPrintable

Details

    Description

      To reproduce uncomment #aria_block_size=1024
      I use docker lasted 10.4.5 

      [mariadb]
      		 
       
      		 
      aria_pagecache_buffer_size = 256M
      		 
      aria_group_commit = hard
      		 
      #aria_used_for_temp_tables = 1
      		 
      aria_pagecache_file_hash_size = 1024
      		 
      #aria_block_size=1024


      mysql_upgrade
      		 
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      		 
      ERROR 1071 (42000) at line 26: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 45: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 80: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 110: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 201: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 463: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 464: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 466: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 467: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 468: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1904 (HY000) at line 469: Key/Index cannot be defined on a virtual generated column
      		 
      ERROR 1071 (42000) at line 477: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 478: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 479: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 484: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 485: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 486: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 488: Specified key was too long; max key length is 209 bytes
      		 
      ERROR 1071 (42000) at line 549: Specified key was too long; max key length is 209 bytes
      		 
      FATAL ERROR: Upgrade failed

      There is a more generic question raised by Aria replacing MyISAM for temporary tables
      ARIA should at minimum support the same dictionary limits as MyISAM if not will it break many workload?

      I'd like to be wrong but if would probably means mean block size of 16K and that would be a pure no go for temporary table usage.

      Any advice to come back to MyISAM temp table in such case ?

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28311 aria_block_size minimum size 8192

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26688 Can no longer modify aria_block_size

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              monty Michael Widenius
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.