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

[Draft] Protocol assertion failure upon multi-delete from sequence

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Trivial
    • Resolution: Unresolved
    • 10.11
    • N/A
    • Sequences
    • None

    Description

      Reproducible on 10.6-11.4 (including older releases), needs cleaning. Could not reproduce on 11.8+.
      Set to trivial, because we currently have ~13 open bugs for protocol assertion failures which nobody is fixing, and on top of that DELETE from a sequence is not a normal real-life scenario.

      The above-mentioned open bugs don't immediately resemble this one (assuming they would have "Sequences" among components if they did), but still needs double-checking for duplicates.

      # Remaining options: --mysqld=--loose-plugin-partition
      # Search pattern(s): (?^s:Protocol::end_statement)
       
      --disable_abort_on_error
      GRANT ALL ON *.* TO rqg@localhost;
      CREATE DATABASE IF NOT EXISTS simple_db;
      CREATE TABLE simple_db.D (pk INTEGER AUTO_INCREMENT,
      col_int_key INTEGER,
      col_varchar_key VARCHAR(1),
      PRIMARY KEY (pk DESC),
      KEY (col_varchar_key ASC, col_int_key DESC)
      );
      CREATE DATABASE IF NOT EXISTS innodb_partition_db;
      USE innodb_partition_db;
      CREATE TABLE tp004 (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
      c03 VARCHAR(1024) NOT NULL DEFAULT '',
      PRIMARY KEY (id)) row_format=compact /*!50100 PARTITION BY hash(id) partitions 2 */;
      CREATE TABLE tp017 (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
      c03 VARCHAR(1024) NOT NULL DEFAULT '',
      c02 CHAR(3) NOT NULL DEFAULT '',
      PRIMARY KEY (id)) row_format=compressed key_block_size=2 /*!50100 PARTITION BY hash(id) partitions 2 */;
      --connect (con24_0,localhost,root,,)
      CREATE SEQUENCE seq99 NO MAXVALUE;
      DELETE IGNORE alias1 FROM (test.seq9 AS alias1 LEFT JOIN simple_db.D AS alias2 ON ((alias2.col_int_key = alias1.next_not_cached_value) OR ((alias2.pk < alias1.maximum_value) AND (alias2.pk >= alias1.minimum_value)))) WHERE (alias2.col_varchar_key = ANY (SELECT SQ1_alias1.c03 AS SQ1_cfield1 FROM (innodb_partition_db.tp017 AS SQ1_alias1 INNER JOIN innodb_partition_db.tp004 AS SQ1_alias2 ON (SQ1_alias2.c03 = SQ1_alias1.c02)))) OR (alias1.maximum_value BETWEEN 223 AND (223 + 156) OR (alias1.start_value BETWEEN 223 AND (223 + 148) OR (alias1.cache_size > 'r' OR alias1.cache_size BETWEEN 223 AND (223 + 110)))) OR (alias1.cache_size > alias1.cycle_option AND alias1.start_value = alias1.cycle_count);
      

      {c

      Attachments

        Activity

          People

            elenst Elena Stepanova
            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.