[MDEV-34780] MDEV-20250: bb-11.6-mdev20250-hf preliminary test results: various failures - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: N/A
Fix Version/s: N/A
Component/s: Optimizer, Partitioning
Labels:
None

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

MDEV-20250 Implement early partition pruning before statement start

In Progress

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar added a comment - 2024-08-19 23:06 - 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 Van de Paar added a comment - 2024-08-19 23:06 - 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 Van de Paar added a comment - 2024-08-19 23:07

# 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 Van de Paar added a comment - 2024-08-19 23:07 # 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 Van de Paar added a comment - 2024-08-19 23:39

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 Van de Paar added a comment - 2024-08-19 23:39 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 Van de Paar added a comment - 2024-08-24 02:57

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 Van de Paar added a comment - 2024-08-24 02:57 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

Yuchen Pei added a comment - 2025-02-11 23:37

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

Yuchen Pei added a comment - 2025-02-11 23:37 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 Van de Paar added a comment - 2025-02-12 02:48

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 Van de Paar added a comment - 2025-02-12 02:48 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

Assignee:: Alexey Botchkov

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2024-08-19 23:05

Updated:: 2025-02-12 09:13

Git Integration

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

MariaDB Server