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

Bug #1402999 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
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
Triaged
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
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Nothing in the error log?

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

Please find the attached error log

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-857

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

Other bug subscribers

Bug attachments

Remote bug watches

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