handle_fatal_signal (sig=11) in handler::ha_index_or_rnd_end - sql/handler.h:2038

Bug #1384656 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Triaged
High
Unassigned
5.7
Fix Released
High
Unassigned

Bug Description

** GDB info

#0 0x00007f8203df8771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000064deee in handler::ha_index_or_rnd_end (this=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.h:2038
#5 0x00000000007bc3d7 in mysql_ha_close_table (thd=0x2c5b5b0, tables=0x7f81a8951690) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_handler.cc:135
#6 0x00000000007be9f0 in mysql_ha_flush (thd=0x2c5b5b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_handler.cc:985
#7 0x0000000000774586 in open_tables (thd=0x2c5b5b0, start=0x2c5db08, counter=0x7f81e4620bf8, flags=0, prelocking_strategy=0x7f81e4620b70) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5137
#8 0x00000000007bee75 in open_tables (thd=0x2c5b5b0, tables=0x2c5db08, counter=0x7f81e4620bf8, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.h:456
#9 0x0000000000853db8 in mysql_create_table (thd=0x2c5b5b0, create_table=0x7f81a8005198, create_info=0x7f81e4621280, alter_info=0x7f81e4620d20) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:5106
#10 0x00000000007e41ee in mysql_execute_command (thd=0x2c5b5b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:3469
#11 0x00000000007ed193 in mysql_parse (thd=0x2c5b5b0, rawbuf=0x7f81a80050a0 "CREATE TABLE t84 (c1 VARCHAR(10))", length=33, parser_state=0x7f81e4621e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#12 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2c5b5b0, packet=0x3461f31 "CREATE TABLE t84 (c1 VARCHAR(10));", packet_length=34) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#13 0x00000000007de528 in do_command (thd=0x2c5b5b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#14 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x2c5b5b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#15 0x00000000007a5fed in handle_one_connection (arg=0x2c5b5b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#16 0x0000000000dc5bac in pfs_spawn_thread (arg=0x3413310) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#17 0x00007f8203df3df3 in start_thread () from /lib64/libpthread.so.0
#18 0x00007f8202abd01d in clone () from /lib64/libc.so.6

** Crashing query

 CREATE TABLE t84 (c1 VARCHAR(10))

Tags: qa upstream
tags: added: qa
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

description: updated
tags: added: upstream
Revision history for this message
Roel Van de Paar (roel11) wrote :

Valerii is correct, the stack produced with comment #4 (confirmed on my end) results in Z18mysql_ha_rm_tablesP3 as the first visible frame in the error log. Besides the otherwise different stack, this indeed also does not match the bundle uploaded in #1 in which the first visible frame is ZN7handler19ha_index_or_rnd_endEv (error log), with a bit later Z14mysql_ha_flushP3THD (error log secondary visible frame AND known_bugs.strings). Removing unrelated bug comments. Ramesh, setting back to you - can you check?

Changed in mysql-server:
importance: Unknown → Undecided
status: Unknown → New
Revision history for this message
Roel Van de Paar (roel11) wrote :

ps-dbg ZN7handler19ha_index_or_rnd_endEv
ms-dbg ZN7handler19ha_index_or_rnd_endEv
ms-opt Z18mysql_ha_rm_tables
ps-opt Z18mysql_ha_rm_tablesP3THDP10TABLE_LIST

Revision history for this message
Roel Van de Paar (roel11) wrote :

Okay, filtering ZN7handler19ha_index_or_rnd_endEv and Z18mysql_ha_rm_tables based on bugs http://bugs.mysql.com/bug.php?id=74584 and http://bugs.mysql.com/bug.php?id=74583. When these are fixed and lines removed from filter list, we can see if we run into other stacks.

Changed in mysql-server:
importance: Undecided → Unknown
status: New → Unknown
Revision history for this message
Roel Van de Paar (roel11) wrote :

Yet another crashing stack. This bug is all over the place.

Z14mysql_ha_flushP3THD ## http://bugs.mysql.com/bug.php?id=74583, 74584, and LP #1384656, PS/MS
ZN7handler19ha_index_or_rnd_endEv ## http://bugs.mysql.com/bug.php?id=74583, 74584, and LP #1384656, PS-dbg
Z18mysql_ha_rm_tables ## http://bugs.mysql.com/bug.php?id=74583, 74584, and LP #1384656, ?
ZNK10MDL_ticket28has_pending_conflicting_lockEv ## http://bugs.mysql.com/bug.php?id=74584, PS-dbg with reducer/pquery_mod

Revision history for this message
Roel Van de Paar (roel11) wrote :

For that last stack (ZNK10MDL_ticket28has_pending_conflicting_lockEv) see bug 1384570

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

execute at CLI and also using pquery

export LD_LIBRARY_PATH=${PWD}/lib
~/percona-qa/pquery/pquery-ms --infile=./testcase.sql --database=test --threads=1 --no-shuffle --user=root --socket=./socket.sock

Revision history for this message
Roel Van de Paar (roel11) wrote :

May have to repeat testcase 1-3 times.

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

See also bug 1417382

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-836

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.