========================= 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>
Ramesh, please reduce the testcase, reproduce with MySQL, and file a bug there.