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

aria_block_size minimum size 8192

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Storage Engine - Aria
    • None
    • Linux

    Description

      According to KB aria-system-variables/#aria_block_size and MDEV-19805 I should be able to set `aria_block_size` to 4096 but this causes an initialization failure:

      ERROR 1071 (42000) at line 31 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes
      		 
      ERROR 1071 (42000) at line 103 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes
      		 
      ERROR 1071 (42000) at line 114 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes
      		 
      ERROR 1071 (42000) at line 121 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes
      		 
      ERROR 1071 (42000) at line 152 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes
      		 
      ERROR 1071 (42000) at line 297 in file: 'scripts/mysql_system_tables.sql': Specified key was too long; max key length is 1233 bytes

      Attachments

        Issue Links

          duplicates

          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
          is caused by

          Task - A task that needs to be done. MDEV-24312 master_host has 60 character limit, increase to 255 bytes

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19805 Changing aria block size to 1024 will break install_system_tables

          • Major - Major loss of function.
          • Closed

          Activity

            People

              monty Michael Widenius
              mg MG
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.