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

MDEV-20250: bb-11.6-mdev20250-hf preliminary test results: various failures

Details

    Description

      This ticket lists various bugs found in bb-11.6-mdev20250-hf during preliminary testing for MDEV-20250. Issues observed (one per line):

      SIGSEGV|Field::check_assignability_from|Item::check_assignability_to|TABLE::check_assignability_explicit_fields|TABLE::check_assignability_opt_fields
      		 
      SIGSEGV|Field::check_assignability_from|TABLE::check_assignability_explicit_fields|TABLE::check_assignability_opt_fields|mysql_insert
      		 
      SIGSEGV|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command
      		 
      SIGSEGV|THD::pop_internal_handler|set_used_partition|Insert_prelocking_strategy::handle_end|open_tables
      		 
      SIGSEGV|THD::pop_internal_handler|set_used_partition|Insert_prelocking_strategy::handle_end|open_tables
      		 
      fixed()|SIGABRT|Item_func_hybrid_field_type::val_real|Item_func_set_user_var::check|Item_func_set_user_var::save_in_field|Item_func_set_user_var::save_in_field
      		 
      m_internal_handler != __null|SIGABRT|THD::pop_internal_handler|set_used_partition|Insert_prelocking_strategy::handle_end|open_tables
      		 
      marked_for_write_or_computed()|SIGABRT|Field_double::store|Field_double::store|Item::save_str_value_in_field|Item_string::save_in_field
      		 
      marked_for_write_or_computed()|SIGABRT|Field_long::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask
      		 
      marked_for_write_or_computed()|SIGABRT|Field_long::store|save_int_value_in_field|Item_int::save_in_field|fill_record_with_mask
      		 
      marked_for_write_or_computed()|SIGABRT|Field_longlong::store|save_int_value_in_field|Item_int::save_in_field|fill_record_with_mask
      		 
      marked_for_write_or_computed()|SIGABRT|Field_medium::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask
      		 
      marked_for_write_or_computed()|SIGABRT|Field_new_decimal::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask
      		 
      marked_for_write_or_computed()|SIGABRT|Field_varstring::store|Field_str::store|save_int_value_in_field|Item_int::save_in_field
      		 
      marked_for_write_or_computed()|SIGABRT|Field_varstring::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask
      		 
      s->visible_fields == values.elements|SIGABRT|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command
      		 
      strlen(Ptr) == str_length|SIGABRT|Binary_string::chop|Item_func_json_extract::read_json|Item_func_json_extract::val_str|Item_func_conv_charset::Item_func_conv_charset

      Revision tested: 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20250 Implement early partition pruning before statement start

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

          Activity

            Ascending order - Click to sort in descending order
            Roel Roel Van de Paar added a comment - - edited 

            CREATE TABLE t (a INT) ENGINE=MyISAM;
            		 
            REPLACE DELAYED INTO t (x,y) VALUES (0,0);

            Causes:

            bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug)

            		 
            SIGSEGV|Field::check_assignability_from|Item::check_assignability_to|TABLE::check_assignability_explicit_fields|TABLE::check_assignability_opt_fields

            Versus 11.6 trunk:

            11.6.1 05fe3f1c186a221c4455b4d83a9d59f09f2dfadb (Debug)

            		 
            11.6.1-dbg>REPLACE DELAYED INTO t (x,y) VALUES (0,0);
            		 
            ERROR 1054 (42S22): Unknown column 'x' in 'field list'

            Similar testcases and their stacks:

            CREATE TABLE t (pk0 VARCHAR(1),pk1 INT,c INT,UNIQUE (c) USING HASH) ENGINE=MEMORY;
            		 
            INSERT DELAYED INTO t VALUES ('','','');

            bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug)

            		 
            marked_for_write_or_computed()|SIGABRT|Field_varstring::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask


            SET storage_engine=MyISAM;
            		 
            CREATE TABLE t (c INT KEY,c2 CHAR,c3 DATE);
            		 
            INSERT DELAYED INTO t VALUES (1,0),(1,0),(1,0);

            bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug)

            		 
            s->visible_fields == values.elements|SIGABRT|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command

            Roel Roel Van de Paar added a comment - - edited CREATE TABLE t (a INT ) ENGINE=MyISAM; REPLACE DELAYED INTO t (x,y) VALUES (0,0); Causes: bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug) SIGSEGV|Field::check_assignability_from|Item::check_assignability_to|TABLE::check_assignability_explicit_fields|TABLE::check_assignability_opt_fields Versus 11.6 trunk: 11.6.1 05fe3f1c186a221c4455b4d83a9d59f09f2dfadb (Debug) 11.6.1-dbg>REPLACE DELAYED INTO t (x,y) VALUES (0,0); ERROR 1054 (42S22): Unknown column 'x' in 'field list' Similar testcases and their stacks: CREATE TABLE t (pk0 VARCHAR (1),pk1 INT ,c INT , UNIQUE (c) USING HASH) ENGINE=MEMORY; INSERT DELAYED INTO t VALUES ( '' , '' , '' ); bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug) marked_for_write_or_computed()|SIGABRT|Field_varstring::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask SET storage_engine=MyISAM; CREATE TABLE t (c INT KEY ,c2 CHAR ,c3 DATE ); INSERT DELAYED INTO t VALUES (1,0),(1,0),(1,0); bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug) s->visible_fields == values.elements|SIGABRT|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command
            Roel Roel Van de Paar added a comment - 

            # mysqld options required for replay: --log_bin 
            CREATE TABLE t (a INT signed) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,3,5,7,9,NULL),PARTITION p VALUES IN (2,4,6,8,0));
            		 
            INSERT INTO t VALUES (@var);

            Causes:

            bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug)

            		 
            m_internal_handler != __null|SIGABRT|THD::pop_internal_handler|set_used_partition|Insert_prelocking_strategy::handle_end|open_tables

            Versus 11.6 trunk:

            11.6.1 05fe3f1c186a221c4455b4d83a9d59f09f2dfadb (Debug)

            		 
            11.6.1-dbg>INSERT INTO t VALUES (@var);
            		 
            Query OK, 1 row affected (0.002 sec)

            Roel Roel Van de Paar added a comment - # mysqld options required for replay: --log_bin CREATE TABLE t (a INT signed) PARTITION BY LIST (a) (PARTITION p0 VALUES IN (1,3,5,7,9, NULL ),PARTITION p VALUES IN (2,4,6,8,0)); INSERT INTO t VALUES (@var); Causes: bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug) m_internal_handler != __null|SIGABRT|THD::pop_internal_handler|set_used_partition|Insert_prelocking_strategy::handle_end|open_tables Versus 11.6 trunk: 11.6.1 05fe3f1c186a221c4455b4d83a9d59f09f2dfadb (Debug) 11.6.1-dbg>INSERT INTO t VALUES (@var); Query OK, 1 row affected (0.002 sec)
            Roel Roel Van de Paar added a comment -

            On optimized:

            CREATE TABLE t (a CHAR,b CHAR,c DATE,KEY(c)) ENGINE=MEMORY;
            		 
            INSERT DELAYED INTO t VALUES (RAND());

            bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Optimized)

            		 
            SIGSEGV|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command

            Many of the bugs seem to revolve around DELAYED and MyISAM or MEMORY.

            Roel Roel Van de Paar added a comment - On optimized: CREATE TABLE t (a CHAR ,b CHAR ,c DATE , KEY (c)) ENGINE=MEMORY; INSERT DELAYED INTO t VALUES (RAND()); bb-11.6-mdev20250-hf 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Optimized) SIGSEGV|TABLE::check_assignability_all_visible_fields|TABLE::check_assignability_opt_fields|mysql_insert|mysql_execute_command Many of the bugs seem to revolve around DELAYED and MyISAM or MEMORY.
            Roel Roel Van de Paar added a comment - 

            CREATE TABLE t (c INT) ENGINE=MyISAM;
            		 
            INSERT DELAYED INTO t VALUES ('');

            11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug)

            		 
            marked_for_write_or_computed()|SIGABRT|Field_long::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask

            Roel Roel Van de Paar added a comment - CREATE TABLE t (c INT) ENGINE=MyISAM; INSERT DELAYED INTO t VALUES (''); 11.6.0 9cbcce5ff2f190e830a5d7bc78ea4ee315f9ee27 (Debug) marked_for_write_or_computed()|SIGABRT|Field_long::store|Item::save_str_value_in_field|Item_string::save_in_field|fill_record_with_mask
            ycp Yuchen Pei added a comment -

            See my comment in MDEV-20250 about this MDEV

            https://jira.mariadb.org/browse/MDEV-20250?focusedCommentId=294978&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-294978

            ycp Yuchen Pei added a comment - See my comment in MDEV-20250 about this MDEV https://jira.mariadb.org/browse/MDEV-20250?focusedCommentId=294978&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-294978
            Roel Roel Van de Paar added a comment -

            ycp Ack. If the patch is revised then indeed please close this ticket as/when you see fit, and I can start a new testrun on the revised patch when ready.

            Roel Roel Van de Paar added a comment - ycp Ack. If the patch is revised then indeed please close this ticket as/when you see fit, and I can start a new testrun on the revised patch when ready.

            People

              holyfoot Alexey Botchkov
              Roel Roel Van de Paar
              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.