[MDEV-5060] Server crashes on EXPLAIN EXTENDED or EXPLAIN PARTITIONS with explain in slow_log - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.0.5
Component/s: None
Labels:
None

Description

SET log_slow_verbosity='query_plan,explain';

SET GLOBAL slow_query_log=1;

SET long_query_time=0.000001;

EXPLAIN PARTITIONS SELECT 1 ;

#3  <signal handler called>

#4  0x00000000006bd1ab in String::append (this=0x7fbefdd0fd70, s=0xa5a5a5a5a5a5a5a5 <Address 0xa5a5a5a5a5a5a5a5 out of bounds>) at 10.0-base-explain-slowquerylog/sql/sql_string.cc:444

#5  0x000000000069d45c in select_result_text_buffer::save_to (this=0x7fbefdd0fbf0, res=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/sql_show.cc:2453

#6  0x00000000007662e3 in QPF_query::print_explain_str (this=0x7fbef4011570, thd=0x3f7e6b0, out_str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:139

#7  0x0000000000766239 in print_qpf_query (lex=0x3f81b68, thd=0x3f7e6b0, str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:127

#8  0x00000000008c2545 in MYSQL_QUERY_LOG::write (this=0x3d21230, thd=0x3f7e6b0, current_time=1379963242, user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:2833

#9  0x00000000008bd6e0 in Log_to_file_event_handler::log_slow (this=0x3d20ce0, thd=0x3f7e6b0, current_time=..., user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:996

#10 0x00000000008be1b7 in LOGGER::slow_log_print (this=0x1588680, thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:1287

#11 0x00000000008ca4fd in slow_log_print (thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:5870

#12 0x000000000061dc5b in log_slow_statement (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1573

#13 0x000000000061d8ff in dispatch_command (command=COM_QUERY, thd=0x3f7e6b0, packet=0x3f83361 "", packet_length=28) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1495

#14 0x000000000061b8bd in do_command (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:812

#15 0x00000000007360b5 in do_handle_one_connection (thd_arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1266

#16 0x0000000000735e23 in handle_one_connection (arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181

#17 0x0000000000996c52 in pfs_spawn_thread (arg=0x3f79a90) at 10.0-base-explain-slowquerylog/storage/perfschema/pfs.cc:1015

#18 0x00007fbf023fde9a in start_thread (arg=0x7fbefdd11700) at pthread_create.c:308

#19 0x00007fbf016f1cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Seemingly identical stack trace is produced with EXPLAIN EXTENDED instead of EXPLAIN PARTITIONS

SET log_slow_verbosity='query_plan,explain';

SET GLOBAL slow_query_log=1;

SET long_query_time=0.000001;

EXPLAIN EXTENDED SELECT 1 ;

bzr version-info

revision-id: psergey@askmonty.org-20130923101756-6fbq7b20nxkhu1bc

revno: 3693

branch-nick: 10.0-base-explain-slowquerylog

Attachments

Issue Links

relates to

MDEV-407 Print EXPLAIN [ANALYZE] in the slow query log

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2013-09-23 22:09

Elena Stepanova made changes - 2013-09-23 22:09

Field	Original Value	New Value
Link		This issue relates to TODO-544 [ TODO-544 ]

Elena Stepanova made changes - 2013-09-23 22:09

Link

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

Elena Stepanova made changes - 2013-09-23 22:12

Summary

Server crashes on EXPLAIN PARTITIONS with explain in slow_log

Server crashes on EXPLAIN EXTENDED or EXPLAIN PARTITIONS with explain in slow_log

Elena Stepanova made changes - 2013-09-23 22:13

Description

{code:sql}
SET log_slow_verbosity='query_plan,explain';
SET GLOBAL slow_query_log=1;
SET long_query_time=0.000001;

EXPLAIN PARTITIONS SELECT 1 ;
{code}

{noformat}
#3 <signal handler called>
#4 0x00000000006bd1ab in String::append (this=0x7fbefdd0fd70, s=0xa5a5a5a5a5a5a5a5 <Address 0xa5a5a5a5a5a5a5a5 out of bounds>) at 10.0-base-explain-slowquerylog/sql/sql_string.cc:444
#5 0x000000000069d45c in select_result_text_buffer::save_to (this=0x7fbefdd0fbf0, res=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/sql_show.cc:2453
#6 0x00000000007662e3 in QPF_query::print_explain_str (this=0x7fbef4011570, thd=0x3f7e6b0, out_str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:139
#7 0x0000000000766239 in print_qpf_query (lex=0x3f81b68, thd=0x3f7e6b0, str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:127
#8 0x00000000008c2545 in MYSQL_QUERY_LOG::write (this=0x3d21230, thd=0x3f7e6b0, current_time=1379963242, user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:2833
#9 0x00000000008bd6e0 in Log_to_file_event_handler::log_slow (this=0x3d20ce0, thd=0x3f7e6b0, current_time=..., user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:996
#10 0x00000000008be1b7 in LOGGER::slow_log_print (this=0x1588680, thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:1287
#11 0x00000000008ca4fd in slow_log_print (thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:5870
#12 0x000000000061dc5b in log_slow_statement (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1573
#13 0x000000000061d8ff in dispatch_command (command=COM_QUERY, thd=0x3f7e6b0, packet=0x3f83361 "", packet_length=28) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1495
#14 0x000000000061b8bd in do_command (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:812
#15 0x00000000007360b5 in do_handle_one_connection (thd_arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1266
#16 0x0000000000735e23 in handle_one_connection (arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181
#17 0x0000000000996c52 in pfs_spawn_thread (arg=0x3f79a90) at 10.0-base-explain-slowquerylog/storage/perfschema/pfs.cc:1015
#18 0x00007fbf023fde9a in start_thread (arg=0x7fbefdd11700) at pthread_create.c:308
#19 0x00007fbf016f1cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
{noformat}

{noformat}
bzr version-info
revision-id: psergey@askmonty.org-20130923101756-6fbq7b20nxkhu1bc
revno: 3693
branch-nick: 10.0-base-explain-slowquerylog
{noformat}

{code:sql}
SET log_slow_verbosity='query_plan,explain';
SET GLOBAL slow_query_log=1;
SET long_query_time=0.000001;

EXPLAIN PARTITIONS SELECT 1 ;
{code}

{noformat}
#3 <signal handler called>
#4 0x00000000006bd1ab in String::append (this=0x7fbefdd0fd70, s=0xa5a5a5a5a5a5a5a5 <Address 0xa5a5a5a5a5a5a5a5 out of bounds>) at 10.0-base-explain-slowquerylog/sql/sql_string.cc:444
#5 0x000000000069d45c in select_result_text_buffer::save_to (this=0x7fbefdd0fbf0, res=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/sql_show.cc:2453
#6 0x00000000007662e3 in QPF_query::print_explain_str (this=0x7fbef4011570, thd=0x3f7e6b0, out_str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:139
#7 0x0000000000766239 in print_qpf_query (lex=0x3f81b68, thd=0x3f7e6b0, str=0x7fbefdd0fd70) at 10.0-base-explain-slowquerylog/sql/opt_qpf.cc:127
#8 0x00000000008c2545 in MYSQL_QUERY_LOG::write (this=0x3d21230, thd=0x3f7e6b0, current_time=1379963242, user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:2833
#9 0x00000000008bd6e0 in Log_to_file_event_handler::log_slow (this=0x3d20ce0, thd=0x3f7e6b0, current_time=..., user_host=0x7fbefdd10210 "root[root] @ localhost []", user_host_len=25, query_utime=697, lock_utime=0, is_command=false, sql_text=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", sql_text_len=27) at 10.0-base-explain-slowquerylog/sql/log.cc:996
#10 0x00000000008be1b7 in LOGGER::slow_log_print (this=0x1588680, thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:1287
#11 0x00000000008ca4fd in slow_log_print (thd=0x3f7e6b0, query=0x7fbef4011418 "EXPLAIN PARTITIONS SELECT 1", query_length=27, current_utime=84588211526) at 10.0-base-explain-slowquerylog/sql/log.cc:5870
#12 0x000000000061dc5b in log_slow_statement (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1573
#13 0x000000000061d8ff in dispatch_command (command=COM_QUERY, thd=0x3f7e6b0, packet=0x3f83361 "", packet_length=28) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:1495
#14 0x000000000061b8bd in do_command (thd=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_parse.cc:812
#15 0x00000000007360b5 in do_handle_one_connection (thd_arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1266
#16 0x0000000000735e23 in handle_one_connection (arg=0x3f7e6b0) at 10.0-base-explain-slowquerylog/sql/sql_connect.cc:1181
#17 0x0000000000996c52 in pfs_spawn_thread (arg=0x3f79a90) at 10.0-base-explain-slowquerylog/storage/perfschema/pfs.cc:1015
#18 0x00007fbf023fde9a in start_thread (arg=0x7fbefdd11700) at pthread_create.c:308
#19 0x00007fbf016f1cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
{noformat}

Seemingly identical stack trace is produced with {{EXPLAIN EXTENDED}} instead of {{EXPLAIN PARTITIONS}}

{code:sql}
SET log_slow_verbosity='query_plan,explain';
SET GLOBAL slow_query_log=1;
SET long_query_time=0.000001;

EXPLAIN EXTENDED SELECT 1 ;
{code}

{noformat}
bzr version-info
revision-id: psergey@askmonty.org-20130923101756-6fbq7b20nxkhu1bc
revno: 3693
branch-nick: 10.0-base-explain-slowquerylog
{noformat}

Sergei Petrunia made changes - 2013-09-25 15:56

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Petrunia made changes - 2013-09-25 22:25

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 29107 ]

MariaDB v2 [ 44047 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 44047 ]

MariaDB v3 [ 64227 ]

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

Workflow

MariaDB v3 [ 64227 ]

MariaDB v4 [ 147068 ]

People

Assignee:: Sergei Petrunia

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2013-09-23 22:09

Updated:: 2013-09-25 22:25

Resolved:: 2013-09-25 22:25

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