[MDEV-31143] Crash for query using ROWNUM() over view with ORDER BY - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.11.3, 11.0.2, 10.6.13, 10.8.8, 10.9.6, 10.10.4
Component/s: Views
Labels:
- regression

Description

regression after 5bada1246de48ef4a18fa30388f, repeatable after ~~MDEV-31073~~ fix:

CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);

SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;

Version: '10.6.13-MariaDB-debug-log'

230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]

sigaction.c:0(__restore_rt)[0x7fef4eb59420]

maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]

sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]

sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]

sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]

sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]

sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]

sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]

sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]

sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]

sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]

sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]

sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]

sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]

sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]

nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1

CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);

CREATE  VIEW  v1 AS SELECT  sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;

Attachments

Issue Links

relates to

MDEV-31073 Server crash, assertion `table != 0 && view->field_translation != 0' failure with ROWNUM and view

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2023-04-27 15:25

Alice Sherepa made changes - 2023-04-28 09:29

Field	Original Value	New Value
Description	{noformat} [ERROR] mysqld got signal 11 ; Server version: 10.6.13-MariaDB-debug-log source revision: 4a668c18926eca055a45b4153467bc6a5c50ff19 sql/signal_handler.cc:241(handle_fatal_signal)[0x55faba2f852d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f016ee33730] maria/ha_maria.cc:1106(ha_maria::scan_time())[0x55faba9604fc] sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x55faba6ea36c] sql/sql_select.cc:5113(get_quick_record_count(THD, SQL_SELECT, TABLE, Bitmap<64u> const, unsigned long long))[0x55fab9b7454c] sql/sql_select.cc:5840(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x55fab9b7b35a] sql/sql_select.cc:2509(JOIN::optimize_inner())[0x55fab9b59467] sql/sql_select.cc:1848(JOIN::optimize())[0x55fab9b52499] sql/sql_derived.cc:1045(mysql_derived_optimize(THD, LEX, TABLE_LIST))[0x55fab99b5629] sql/sql_derived.cc:200(mysql_handle_single_derived(LEX, TABLE_LIST, unsigned int))[0x55fab99afdf7] sql/sql_select.cc:2327(JOIN::optimize_inner())[0x55fab9b57904] sql/sql_select.cc:1848(JOIN::optimize())[0x55fab9b52499] sql/sql_select.cc:5055(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55fab9b73c9e] sql/sql_select.cc:559(handle_select(THD, LEX, select_result, unsigned long))[0x55fab9b44191] sql/sql_parse.cc:6273(execute_sqlcom_select(THD, TABLE_LIST))[0x55fab9aa9521] sql/sql_parse.cc:3949(mysql_execute_command(THD, bool))[0x55fab9a97e04] sql/sql_parse.cc:8036(mysql_parse(THD, char, unsigned int, Parser_state))[0x55fab9ab435a] sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x55fab9a8a8a1] sql/sql_parse.cc:1409(do_command(THD, bool))[0x55fab9a875a1] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55fab9eee104] sql/sql_connect.cc:1320(handle_one_connection)[0x55fab9eeda5a] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55fababf684f] nptl/pthread_create.c:487(start_thread)[0x7f016ee28fa3] {noformat} {noformat}	{code:sql} CREATE TABLE t1 (id int NOT NULL PRIMARY KEY); SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1; {code} {noformat} Version: '10.6.13-MariaDB-debug-log' 230428 11:26:28 [ERROR] mysqld got signal 11 ; Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9 sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716] sigaction.c:0(__restore_rt)[0x7fef4eb59420] maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4] sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67] sql/sql_select.cc:5113(get_quick_record_count(THD, SQL_SELECT, TABLE, Bitmap<64u> const, unsigned long long))[0x56401838665b] sql/sql_select.cc:5840(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x56401838d400] sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171] sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf] sql/sql_select.cc:5055(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x564018385d68] sql/sql_select.cc:559(handle_select(THD, LEX, select_result, unsigned long))[0x564018355b9f] sql/sql_parse.cc:6273(execute_sqlcom_select(THD, TABLE_LIST))[0x5640182b6e8e] sql/sql_parse.cc:3949(mysql_execute_command(THD, bool))[0x5640182a57fb] sql/sql_parse.cc:8036(mysql_parse(THD, char, unsigned int, Parser_state))[0x5640182c21b9] sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD, char, unsigned int, bool))[0x56401829803a] sql/sql_parse.cc:1409(do_command(THD, bool))[0x564018294d85] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT, bool))[0x564018710df9] sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44] nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133] Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1 {noformat} {code:sql} CREATE TABLE t1 (id int NOT NULL PRIMARY KEY); CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait; SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1; {code}

Alice Sherepa made changes - 2023-04-28 09:29

Summary

[draft] Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_selec

Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_select

Alice Sherepa made changes - 2023-04-28 09:29

Assignee

Alice Sherepa [ alice ]

Oleksandr Byelkin [ sanja ]

Alice Sherepa made changes - 2023-04-28 09:30

Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]

Alice Sherepa made changes - 2023-04-28 09:30

Fix Version/s

10.6 [ 24028 ]

Alice Sherepa made changes - 2023-04-28 09:30

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2023-04-28 09:57

Labels

regression

Alice Sherepa made changes - 2023-04-28 09:59

Description

{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

{noformat}
Version: '10.6.13-MariaDB-debug-log'
230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]
sigaction.c:0(__restore_rt)[0x7fef4eb59420]
maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]
sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]
sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]
sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]
sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]
sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]
sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]
sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]
sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]
sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]
sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]
sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]
sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]
nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1
{noformat}
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

regression after 5bada1246de48ef4a18fa30388f, repeatable after ~~MDEV-31073~~ fix:
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

{noformat}
Version: '10.6.13-MariaDB-debug-log'
230428 11:26:28 [ERROR] mysqld got signal 11 ;

Server version: 10.6.13-MariaDB-debug-log source revision: 2eb7bf1ec301d43a7e72b8720f6ee153dc52b6c9

sql/signal_handler.cc:241(handle_fatal_signal)[0x564018b2e716]
sigaction.c:0(__restore_rt)[0x7fef4eb59420]
maria/ha_maria.cc:1106(ha_maria::scan_time())[0x564019102df4]
sql/opt_range.cc:2714(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool))[0x564018f39b67]
sql/sql_select.cc:5113(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x56401838665b]
sql/sql_select.cc:5840(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x56401838d400]
sql/sql_select.cc:2509(JOIN::optimize_inner())[0x56401836b171]
sql/sql_select.cc:1848(JOIN::optimize())[0x5640183641cf]
sql/sql_select.cc:5055(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x564018385d68]
sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x564018355b9f]
sql/sql_parse.cc:6273(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5640182b6e8e]
sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x5640182a57fb]
sql/sql_parse.cc:8036(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5640182c21b9]
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56401829803a]
sql/sql_parse.cc:1409(do_command(THD*, bool))[0x564018294d85]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x564018710df9]
sql/sql_connect.cc:1320(handle_one_connection)[0x564018710756]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5640193a8d44]
nptl/pthread_create.c:478(start_thread)[0x7fef4eb4d609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fef4e71e133]

Query (0x62b0000c42a8): SELECT t1.id AS fld1 FROM sys.schema_index_statistics , t1 WHERE rownum() = 1 GROUP BY fld1
{noformat}
{code:sql}
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY);
CREATE VIEW v1 AS SELECT sys.format_time(tb.sum_timer_fetch) FROM performance_schema.table_io_waits_summary_by_index_usage tb ORDER BY tb.sum_timer_wait;

SELECT t1.id AS fld1 FROM v1, t1 WHERE rownum() = 1 GROUP BY fld1;
{code}

Alice Sherepa made changes - 2023-04-28 09:59

Priority

Major [ 3 ]

Blocker [ 1 ]

Alice Sherepa made changes - 2023-04-28 09:59

Link

This issue relates to ~~MDEV-31073~~ [ ~~MDEV-31073~~ ]

Oleksandr Byelkin made changes - 2023-04-28 17:26

Assignee

Oleksandr Byelkin [ sanja ]

Igor Babaev [ igor ]

Igor Babaev (Inactive) made changes - 2023-04-29 07:01

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Igor Babaev (Inactive) made changes - 2023-04-30 04:39

Summary

Server crashes in ha_maria::scan_time/QL_SELECT::test_quick_select

Crash for query using ROWNUM() over view with ORDER BY

Igor Babaev (Inactive) made changes - 2023-04-30 07:20

Status

In Progress [ 3 ]

In Review [ 10002 ]

Igor Babaev (Inactive) made changes - 2023-04-30 07:22

Assignee

Igor Babaev [ igor ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2023-04-30 15:30

Assignee	Oleksandr Byelkin [ sanja ]	Igor Babaev [ igor ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Igor Babaev (Inactive) made changes - 2023-05-01 06:24

Component/s		Views [ 10111 ]
Fix Version/s		10.6.13 [ 28514 ]
Fix Version/s		10.9.6 [ 28520 ]
Fix Version/s		10.10.4 [ 28522 ]
Fix Version/s		10.11.3 [ 28524 ]
Fix Version/s		10.8.8 [ 28518 ]
Fix Version/s		11.0.2 [ 28706 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2023-04-27 15:25

Updated:: 2023-05-02 07:58

Resolved:: 2023-05-01 06:24

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration