Assertion failure in row0sel.cc line 4071 | sig 6 abort in row_search_for_mysql

Bug #1402999 reported by Ramesh Sivaraman on 2014-12-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
High
Unassigned

Bug Description

*** Testcase

CREATE TABLE t1(a TIME)PARTITION BY HASH (EXTRACT(MICROSECOND FROM a));
SET @@global.table_open_cache=-1;
SET @@session.max_statement_time=TRUE;
INSERT INTO t1 VALUES(1),(1),(1),('1a'),(1),(0);
SELECT CONVERT_TZ(1,1,a)FROM t1;

May be we need to run the testcase twice to reproduce the bug.

*** GDB

#0 0x00007f38bfe63771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000067679d in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.
6.21-70.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00007f38bea675c9 in raise () from /lib64/libc.so.6
#4 0x00007f38bea68cd8 in abort () from /lib64/libc.so.6
#5 0x00000000009b7751 in row_search_for_mysql (buf=buf@entry=0x7f3806483020 <incomplete sequence \375\200>, mode=<optimized out>, mode@entry=0, pre
built=0x7f380652ce68, match_mode=match_mode@entry=0, direction=direction@entry=1) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/
centos6-64/percona-server-5.6.21-70.0/storage/innobase/row/row0sel.cc:4071
#6 0x00000000009084d6 in ha_innobase::general_fetch (this=0x7f38064b1110, buf=0x7f3806483020 <incomplete sequence \375\200>, direction=1, match_mod
e=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/innobase/handler/ha_innodb.cc:8500
#7 0x00000000005bc114 in handler::ha_rnd_next (this=this@entry=0x7f38064b1110, buf=buf@entry=0x7f3806483020 <incomplete sequence \375\200>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/handler.cc:2883
#8 0x0000000000b63b6a in ha_partition::rnd_next (this=0x7f38064a0d10, buf=0x7f3806483020 <incomplete sequence \375\200>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/ha_partition.cc:4708
#9 0x00000000005bc0dd in handler::ha_rnd_next (this=0x7f38064a0d10, buf=0x7f3806483020 <incomplete sequence \375\200>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/handler.cc:2883
#10 0x0000000000820320 in rr_sequential (info=0x7f380641e8f8) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/records.cc:488
#11 0x00000000006d4891 in sub_select (join=0x7f380641db28, join_tab=0x7f380641e868, end_of_records=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_executor.cc:1259
#12 0x00000000006d3b08 in do_select (join=0x7f380641db28) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_executor.cc:933
#13 JOIN::exec (this=0x7f380641db28) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_executor.cc:194
#14 0x000000000071c965 in mysql_execute_select (free_join=true, select_lex=0x7f382f737c30, thd=0x7f382f735000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_select.cc:1100
#15 mysql_select (thd=thd@entry=0x7f382f735000, tables=0x7f380641d4e8, wild_num=0, fields=..., conds=0x0, order=order@entry=0x7f382f737df8, group=group@entry=0x7f382f737d30, having=0x0, select_options=2147748608, result=result@entry=0x7f380641db00, unit=unit@entry=0x7f382f7375e8, select_lex=select_lex@entry=0x7f382f737c30) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_select.cc:1221
#16 0x000000000071d1c5 in handle_select (thd=thd@entry=0x7f382f735000, result=result@entry=0x7f380641db00, setup_tables_done_option=setup_tables_done_option@entry=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_select.cc:110
#17 0x000000000057e6d2 in execute_sqlcom_select (thd=thd@entry=0x7f382f735000, all_tables=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:5601
#18 0x00000000006f6e99 in mysql_execute_command (thd=thd@entry=0x7f382f735000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:2959
#19 0x00000000006fc0e8 in mysql_parse (thd=thd@entry=0x7f382f735000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f38c0419270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:6777
#20 0x00000000006fd859 in dispatch_command (command=<optimized out>, thd=0x7f382f735000, packet=0x7f38237a8001 "", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1432
#21 0x00000000006ff5b9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1049
#22 0x00000000006cb3c2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f382f735000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1532
#23 0x00000000006cb4b0 in handle_one_connection (arg=arg@entry=0x7f382f735000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1443
#24 0x0000000000af86d3 in pfs_spawn_thread (arg=0x7f382f74b3e0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/perfschema/pfs.cc:1860
#25 0x00007f38bfe5edf3 in start_thread () from /lib64/libpthread.so.0
#26 0x00007f38beb2801d in clone () from /lib64/libc.so.6

Tags: qa Edit Tag help

Nothing in the error log?

Ramesh Sivaraman (rameshvs02) wrote :

Please find the attached error log

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

Other bug subscribers

Bug attachments