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

Unexpected "aria_sort_buffer_size is too small" error with aria_repair_threads>1

    XMLWordPrintable

Details

    Description

      --source include/have_sequence.inc
       
      SET GLOBAL aria_repair_threads= 2;
       
      CREATE TABLE t (a INT, b INT, c VARCHAR(2000), PRIMARY KEY (a), KEY(b), KEY(c)) ENGINE=Aria ROW_FORMAT=DYNAMIC;
      INSERT INTO t SELECT seq, seq, 'x' FROM seq_1_to_100;
      ALTER TABLE t MODIFY a BIGINT;
      select @@aria_sort_buffer_size;
       
      # Cleanup
      DROP TABLE t;
      

      10.5 ea0b1ccd

      select @@aria_sort_buffer_size;
      @@aria_sort_buffer_size
      268434432
      DROP TABLE t;
      bug.aria2                                [ fail ]  Found warnings/errors in server log file!
              Test ended at 2023-11-11 01:06:08
      line
      2023-11-11  1:06:08 0 [ERROR] mariadbd: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 21845  rows: 101  sort_length: 2010
      

      Something goes wrong there, as aria_sort_buffer_size=256M, but the error claims it to be 21845.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.