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

ANALYZE TABLE produces "Partition returned error" under tx_read_only

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
      --source include/have_innodb.inc
       
      SET @tx= @@global.tx_read_only;
       
      CREATE TABLE t (a INT) ENGINE=InnoDB PARTITION BY RANGE (a) (PARTITION p VALUES LESS THAN MAXVALUE);
      SET GLOBAL tx_read_only = ON;
      --connect (con1,localhost,root,,)
      ANALYZE TABLE t;
       
      # Cleanup
      --disconnect con1
      connection default;
      DROP TABLE t;
      SET GLOBAL tx_read_only = @tx;
      

      10.6 686865e112fa4840376745194349845f8d00a2a7

      ANALYZE TABLE t;
      Table	Op	Msg_type	Msg_text
      test.t	analyze	error	Partition p returned error
      test.t	analyze	status	Engine-independent statistics collected
      test.t	analyze	status	Operation failed
      

      (Engine-independed statistics is irrelevant here, it's just collected in MTR by default. The partition error happens without it as well).
      Not reproducible on 10.5.

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.