handle_fatal_signal (sig=11) in add_key_equal_fields at sql/sql_optimizer.cc:5087 on UPDATE query

Bug #1354011 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
Fix Released
High
Unassigned
5.6
Fix Released
High
Unassigned
5.7
Fix Released
High
Unassigned

Bug Description

========================= Error log:
11:42:19 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
----
----
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f042182f010): UPDATE `view_table10_innodb_int_autoinc` SET `c41` = 2 WHERE `c11` < ALL (SELECT `pk` FROM `table0_innodb` WHERE `c12` >= LOAD_FILE('/ssd/ramesh/randgen/data/earth2kb.jpg') OR ((( `c19` = 'quiwozrserpmqekmjvzjavtdltmsubzpnrjrifpglnsjrgaifdwihjxbkfzamegmqepldjpddyspjyipvoublnnamcunmgrbyrjfyvogsgtizunrywztpgmieypvxesqhqipqvljmhppgk' OR `c11` = (`c55` + `c26`) ) AND `c48` < NULL) AND (`c50` IS NOT NULL)))
Connection ID (thread ID): 11
Status: NOT_KILLED

========================= gdb :
+bt
#0 0x00007f045b0b7771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000067863a in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0
/sql/signal_handler.cc:254
#2 <signal handler called>
#3 add_key_field (key_fields=0x7f04247b0c40, and_level=6, cond=0x7f03d57db020, field=0x7f03dbe55010, eq_func=<optimized out>, value=0x7f03d57db0c0, num_val
ues=1, usable_tables=18446744073709551615, sargables=0x7f04247b0bb0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-serv
er-5.6.19-67.0/sql/sql_optimizer.cc:4954
#4 0x0000000000846c78 in add_key_equal_fields (key_fields=key_fields@entry=0x7f04247b0c40, and_level=6, cond=cond@entry=0x7f03d57db020, eq_func=<optimized
out>, val=0x7f03d57db0c0, num_values=1, usable_tables=18446744073709551615, sargables=0x7f04247b0bb0, field_item=<optimized out>, field_item=<optimized out>
) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_optimizer.cc:5087
#5 0x0000000000847412 in add_key_fields (join=join@entry=0x7f03d57da508, key_fields=key_fields@entry=0x7f04247b0c40, and_level=and_level@entry=0x7f04247b0c
20, cond=0x7f03d57db020, usable_tables=usable_tables@entry=18446744073709551615, sargables=sargables@entry=0x7f04247b0bb0) at /mnt/workspace/percona-server-
5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_optimizer.cc:5314
#6 0x0000000000846fb7 in add_key_fields (join=0x7f03d57da508, key_fields=key_fields@entry=0x7f04247b0c40, and_level=and_level@entry=0x7f04247b0c20, cond=co
nd@entry=0x7f03d57db1b8, usable_tables=usable_tables@entry=18446744073709551615, sargables=sargables@entry=0x7f04247b0bb0) at /mnt/workspace/percona-server-
5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_optimizer.cc:5146
#7 0x000000000084fffc in update_ref_and_keys (cond_equal=<optimized out>, sargables=0x7f04247b0bb0, select_lex=0x7f042182fd00, normal_tables=18446744073709
551615, cond=0x7f03d57db1b8, tables=1, join_tab=0x7f03d57dbe90, keyuse=0x7f03d57da730, thd=0x7f042379b000) at /mnt/workspace/percona-server-5.6-binaries-rel
ease/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_optimizer.cc:5879
#8 make_join_statistics (join=join@entry=0x7f03d57da508, tables_arg=<optimized out>, conds=<optimized out>, keyuse_array=keyuse_array@entry=0x7f03d57da730,
 first_optimization=first_optimization@entry=true) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql
/sql_optimizer.cc:3348
#9 0x0000000000852c17 in JOIN::optimize (this=0x7f03d57da508) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_optimizer.cc:382
#10 0x00000000007e3b4a in subselect_single_select_engine::exec (this=0x7f03d4c737f0) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item_subselect.cc:2747
#11 0x00000000007e4652 in Item_subselect::exec (this=0x7f03d4c73668) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item_subselect.cc:642
#12 0x00000000007e37b5 in Item_in_subselect::val_bool (this=0x7f03d4c73668) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item_subselect.cc:1400
#13 0x00000000005e247d in Item_in_optimizer::val_int (this=0x7f03d57dac98) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item_cmpfunc.cc:2099
#14 0x00000000005cba2c in Item::val_bool (this=0x7f03d57dac98) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item.cc:203
#15 0x00000000005ea70d in Item_func_not_all::val_int (this=0x7f03d4c73828) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/item_cmpfunc.cc:319
#16 0x00000000007662af in skip_record (this=0x7f03d57db608, skip_record={bool (SQL_SELECT * const, bool *, THD *)} 0x76629d <mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*)+6093>, thd=0x7f042379b000) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/opt_range.h:942
#17 mysql_update (thd=thd@entry=0x7f042379b000, table_list=0x7f042182f480, fields=..., values=..., conds=0x7f03d4c73828, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=found_return@entry=0x7f04247b1cc0, updated_return=updated_return@entry=0x7f04247b1d80) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_update.cc:637
#18 0x00000000006fb1dc in mysql_execute_command (thd=thd@entry=0x7f042379b000) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_parse.cc:3712
#19 0x00000000006fe5e8 in mysql_parse (thd=thd@entry=0x7f042379b000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f04247b3060) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_parse.cc:6746
#20 0x00000000006ffdc9 in dispatch_command (command=<optimized out>, thd=thd@entry=0x7f042379b000, packet=0x7f0423692001 "UPDATE `view_table10_innodb_int_autoinc` SET `c41` = 2 WHERE `c11` < ALL (SELECT `pk` FROM `table0_innodb` WHERE `c12` >= LOAD_FILE('/ssd/ramesh/randgen/data/earth2kb.jpg') OR ((( `c19` = 'quiwozrserpmqekmjvzjavtdltmsubzpnrjrifpglnsjrgaifdwihjxbkfzamegmqepldjpddyspjyipvoublnnamcunmgrbyrjfyvogsgtizunrywztpgmieypvxesqhqipqvljmhppgk' OR `c11` = (`c55` + `c26`) ) AND `c48` < NULL) AND (`c50` IS NOT NULL)))", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_parse.cc:1434
#21 0x0000000000701b29 in do_command (thd=thd@entry=0x7f042379b000) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/sql_parse.cc:1051
#22 0x0000000000789a08 in threadpool_process_request (thd=0x7f042379b000) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/threadpool_common.cc:319
#23 0x000000000078a9dd in handle_event (connection=0x7f0423bc4e50) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/threadpool_unix.cc:1550
#24 worker_main (param=param@entry=0x1339800 <all_groups+1536>) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/sql/threadpool_unix.cc:1603
#25 0x0000000000921693 in pfs_spawn_thread (arg=0x7f040ac12020) at /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos5-64/percona-server-5.6.19-67.0/storage/perfschema/pfs.cc:1860
#26 0x00007f045b0b2df3 in start_thread () from /lib64/libpthread.so.0
#27 0x00007f045972b3dd in clone () from /lib64/libc.so.6
(gdb) +set logging off

========================= version:
RQG: 974 <email address hidden>
PS : 622 <email address hidden>

Tags: upstream
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Ramesh, please reduce the testcase, reproduce with MySQL, and file a bug there.

tags: added: upstream
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-809

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

Other bug subscribers

Remote bug watches

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