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

          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.