[MDEV-17023] Crash during read_histogram_for_table with optimizer_use_condition_selectivity set to 4 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.0.37, 10.1.36, 10.2.18, 10.3.10, 10.4.0
Component/s: Optimizer
Labels:
None

Description

set @@optimizer_use_condition_selectivity=4;

set @@use_stat_tables= PREFERABLY;

explain

SELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user;

Attachments

Issue Links

is part of

MDEV-15253 Default optimizer setting changes for MariaDB 10.4

Closed

Activity

Ascending order - Click to sort in descending order

Varun Gupta (Inactive) created issue - 2018-08-20 12:03

Varun Gupta (Inactive) made changes - 2018-08-20 12:04

Field	Original Value	New Value
Assignee		Varun Gupta [ varun ]

Varun Gupta (Inactive) made changes - 2018-08-20 12:04

Description

{code:sql}
set @@optimizer_use_condition_selectivity=4;
set @@use_stat_tables= PREFERABLY;
explain
SELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR;
{code}

Varun Gupta (Inactive) made changes - 2018-08-20 12:05

Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]

Varun Gupta (Inactive) made changes - 2018-08-20 12:05

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]

Varun Gupta (Inactive) added a comment - 2018-08-20 12:05

#0  0x00007f9b5b0a0121 in pthread_kill () from /lib64/libpthread.so.0

#1  0x00007f9b5c6d16ae in my_write_core (sig=6) at /home/varun/varun/stable/mysys/stacktrace.c:481

#2  0x00007f9b5bf19006 in handle_fatal_signal (sig=6) at /home/varun/varun/stable/sql/signal_handler.cc:305

#3  <signal handler called>

#4  0x00007f9b595974c9 in raise () from /lib64/libc.so.6

#5  0x00007f9b59598958 in abort () from /lib64/libc.so.6

#6  0x00007f9b5c6d63d6 in safe_mutex_lock (mp=0x7f9b3800d2a0, my_flags=0, file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", line=2398) at /home/varun/varun/stable/mysys/thr_mutex.c:246

#7  0x00007f9b5bcd3426 in inline_mysql_mutex_lock (that=0x7f9b3800d2a0, src_file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", src_line=2398) at /home/varun/varun/stable/include/mysql/psi/mysql_thread.h:710

#8  0x00007f9b5bcd48ab in alloc_histograms_for_table_share (thd=0x7f9b38000b00, table_share=0x7f9b3800d0f0, is_safe=false) at /home/varun/varun/stable/sql/sql_statistics.cc:2398

#9  0x00007f9b5bcd62d9 in read_histograms_for_table (thd=0x7f9b38000b00, table=0x7f9b3800c558, stat_tables=0x7f9b540d3ba0) at /home/varun/varun/stable/sql/sql_statistics.cc:3204

#10 0x00007f9b5bcd6733 in read_statistics_for_tables_if_needed (thd=0x7f9b38000b00, tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_statistics.cc:3287

#11 0x00007f9b5bb8abff in open_and_lock_tables (thd=0x7f9b38000b00, options=..., tables=0x7f9b38015570, derived=true, flags=0, prelocking_strategy=0x7f9b540d4f60) at /home/varun/varun/stable/sql/sql_base.cc:4963

#12 0x00007f9b5bb4aca5 in open_and_lock_tables (thd=0x7f9b38000b00, tables=0x7f9b38015570, derived=true, flags=0) at /home/varun/varun/stable/sql/sql_base.h:500

#13 0x00007f9b5bc23a2c in execute_sqlcom_select (thd=0x7f9b38000b00, all_tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_parse.cc:6470

#14 0x00007f9b5bc1a5a4 in mysql_execute_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:3771

#15 0x00007f9b5bc27cc9 in mysql_parse (thd=0x7f9b38000b00, rawbuf=0x7f9b38014e88 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", length=105, parser_state=0x7f9b540d65f0, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:8078

#16 0x00007f9b5bc1501d in dispatch_command (command=COM_QUERY, thd=0x7f9b38000b00, packet=0x7f9b38092c61 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", packet_length=105, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:1850

#17 0x00007f9b5bc13a43 in do_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:1395

#18 0x00007f9b5bd7d926 in do_handle_one_connection (connect=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1402

#19 0x00007f9b5bd7d6aa in handle_one_connection (arg=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1308

#20 0x00007f9b5c149fb8 in pfs_spawn_thread (arg=0x7f9b5e22d7d0) at /home/varun/varun/stable/storage/perfschema/pfs.cc:1862

#21 0x00007f9b5b09b0db in start_thread () from /lib64/libpthread.so.0

#22 0x00007f9b59648e3d in clone () from /lib64/libc.so.6

Varun Gupta (Inactive) added a comment - 2018-08-20 12:05 #0 0x00007f9b5b0a0121 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00007f9b5c6d16ae in my_write_core (sig=6) at /home/varun/varun/stable/mysys/stacktrace.c:481 #2 0x00007f9b5bf19006 in handle_fatal_signal (sig=6) at /home/varun/varun/stable/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00007f9b595974c9 in raise () from /lib64/libc.so.6 #5 0x00007f9b59598958 in abort () from /lib64/libc.so.6 #6 0x00007f9b5c6d63d6 in safe_mutex_lock (mp=0x7f9b3800d2a0, my_flags=0, file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", line=2398) at /home/varun/varun/stable/mysys/thr_mutex.c:246 #7 0x00007f9b5bcd3426 in inline_mysql_mutex_lock (that=0x7f9b3800d2a0, src_file=0x7f9b5c7b5aa8 "/home/varun/varun/stable/sql/sql_statistics.cc", src_line=2398) at /home/varun/varun/stable/include/mysql/psi/mysql_thread.h:710 #8 0x00007f9b5bcd48ab in alloc_histograms_for_table_share (thd=0x7f9b38000b00, table_share=0x7f9b3800d0f0, is_safe=false) at /home/varun/varun/stable/sql/sql_statistics.cc:2398 #9 0x00007f9b5bcd62d9 in read_histograms_for_table (thd=0x7f9b38000b00, table=0x7f9b3800c558, stat_tables=0x7f9b540d3ba0) at /home/varun/varun/stable/sql/sql_statistics.cc:3204 #10 0x00007f9b5bcd6733 in read_statistics_for_tables_if_needed (thd=0x7f9b38000b00, tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_statistics.cc:3287 #11 0x00007f9b5bb8abff in open_and_lock_tables (thd=0x7f9b38000b00, options=..., tables=0x7f9b38015570, derived=true, flags=0, prelocking_strategy=0x7f9b540d4f60) at /home/varun/varun/stable/sql/sql_base.cc:4963 #12 0x00007f9b5bb4aca5 in open_and_lock_tables (thd=0x7f9b38000b00, tables=0x7f9b38015570, derived=true, flags=0) at /home/varun/varun/stable/sql/sql_base.h:500 #13 0x00007f9b5bc23a2c in execute_sqlcom_select (thd=0x7f9b38000b00, all_tables=0x7f9b38015570) at /home/varun/varun/stable/sql/sql_parse.cc:6470 #14 0x00007f9b5bc1a5a4 in mysql_execute_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:3771 #15 0x00007f9b5bc27cc9 in mysql_parse (thd=0x7f9b38000b00, rawbuf=0x7f9b38014e88 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", length=105, parser_state=0x7f9b540d65f0, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:8078 #16 0x00007f9b5bc1501d in dispatch_command (command=COM_QUERY, thd=0x7f9b38000b00, packet=0x7f9b38092c61 "explain\nSELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user WHERE password_expired = PAGE_FAULTS_MINOR", packet_length=105, is_com_multi=false, is_next_command=false) at /home/varun/varun/stable/sql/sql_parse.cc:1850 #17 0x00007f9b5bc13a43 in do_command (thd=0x7f9b38000b00) at /home/varun/varun/stable/sql/sql_parse.cc:1395 #18 0x00007f9b5bd7d926 in do_handle_one_connection (connect=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1402 #19 0x00007f9b5bd7d6aa in handle_one_connection (arg=0x7f9b5e2267f0) at /home/varun/varun/stable/sql/sql_connect.cc:1308 #20 0x00007f9b5c149fb8 in pfs_spawn_thread (arg=0x7f9b5e22d7d0) at /home/varun/varun/stable/storage/perfschema/pfs.cc:1862 #21 0x00007f9b5b09b0db in start_thread () from /lib64/libpthread.so.0 #22 0x00007f9b59648e3d in clone () from /lib64/libc.so.6

Varun Gupta (Inactive) made changes - 2018-08-21 21:44

Status

Open [ 1 ]

In Progress [ 3 ]

Varun Gupta (Inactive) made changes - 2018-08-21 22:00

Description

{code:sql}
set @@optimizer_use_condition_selectivity=4;
set @@use_stat_tables= PREFERABLY;
explain
SELECT * FROM INFORMATION_SCHEMA.PROFILING, mysql.user;
{code}

Varun Gupta (Inactive) added a comment - 2018-08-22 06:39

Patch
http://lists.askmonty.org/pipermail/commits/2018-August/012816.html

Varun Gupta (Inactive) added a comment - 2018-08-22 06:39 Patch http://lists.askmonty.org/pipermail/commits/2018-August/012816.html

Varun Gupta (Inactive) made changes - 2018-08-22 06:39

Link

This issue is part of ~~MDEV-15253~~ [ ~~MDEV-15253~~ ]

Varun Gupta (Inactive) made changes - 2018-08-22 06:40

Assignee	Varun Gupta [ varun ]	Sergei Petrunia [ psergey ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Petrunia added a comment - 2018-08-23 13:49

Ok to push.

Sergei Petrunia added a comment - 2018-08-23 13:49 Ok to push.

Sergei Petrunia made changes - 2018-08-23 13:49

Assignee	Sergei Petrunia [ psergey ]	Varun Gupta [ varun ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Varun Gupta (Inactive) made changes - 2018-08-23 14:51

Affects Version/s		10.0 [ 16000 ]
Affects Version/s		10.1 [ 16100 ]

Varun Gupta (Inactive) made changes - 2018-08-23 14:51

Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.1 [ 16100 ]

Varun Gupta (Inactive) made changes - 2018-08-23 20:30

Component/s		Optimizer [ 10200 ]
Fix Version/s		10.0.37 [ 22917 ]
Fix Version/s		10.1.36 [ 23117 ]
Fix Version/s		10.2.18 [ 23112 ]
Fix Version/s		10.3.10 [ 23140 ]
Fix Version/s		10.4.0 [ 23115 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:48

Workflow

MariaDB v3 [ 88995 ]

MariaDB v4 [ 154828 ]

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Varun Gupta (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-08-20 12:03

Updated:: 2018-08-27 09:22

Resolved:: 2018-08-23 20:30

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