Bug #93092 Assertion `Geometry::is_valid_geotype(gt)' failed | sql/spatial.h:1194
Submitted: 6 Nov 2018 5:50 Modified: 6 Nov 2018 6:25
Reporter: Ramesh Sivaraman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S6 (Debug Builds)
Version:5.7.24 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[6 Nov 2018 5:50] Ramesh Sivaraman
Description:
GDB Info

#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1  0x00000000019813b2 in my_write_core (sig=6) at /qa/binaries/MS-57_dbg/mysys/stacktrace.c:249
#2  0x0000000000f1546f in handle_fatal_signal (sig=6) at /qa/binaries/MS-57_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f9971fc8428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5  0x00007f9971fca02a in __GI_abort () at abort.c:89
#6  0x00007f9971fc0bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x1f59be8 "Geometry::is_valid_geotype(gt)", file=file@entry=0x1f59ba0 "/qa/binaries/MS-57_dbg/sql/spatial.h", line=line@entry=1194, function=function@entry=0x1f61480 <get_wkb_geotype(void const*)::__PRETTY_FUNCTION__> "Geometry::wkbType get_wkb_geotype(const void*)") at assert.c:92
#7  0x00007f9971fc0c82 in __GI___assert_fail (assertion=0x1f59be8 "Geometry::is_valid_geotype(gt)", file=0x1f59ba0 "/qa/binaries/MS-57_dbg/sql/spatial.h", line=1194, function=0x1f61480 <get_wkb_geotype(void const*)::__PRETTY_FUNCTION__> "Geometry::wkbType get_wkb_geotype(const void*)") at assert.c:101
#8  0x00000000010600b1 in get_wkb_geotype (p0=0x7f993544f0a5) at /qa/binaries/MS-57_dbg/sql/spatial.h:1194
#9  0x00000000010597bd in Item_func_spatial_collection::val_str (this=0x7f9935427ca8, str=0x7f99354fc9b8) at /qa/binaries/MS-57_dbg/sql/item_geofunc.cc:3557
#10 0x0000000000f80170 in Item::str_result (this=0x7f9935427ca8, tmp=0x7f99354fc9b8) at /qa/binaries/MS-57_dbg/sql/item.h:1602
#11 0x0000000000fcfb4e in Item_cache_str::cache_value (this=0x7f99354fc8a0) at /qa/binaries/MS-57_dbg/sql/item.cc:10186
#12 0x00000000014a575a in Item_singlerow_subselect::store (this=0x7f99354fb7f8, i=0, item=0x7f9935427ca8) at /qa/binaries/MS-57_dbg/sql/item_subselect.cc:1167
#13 0x00000000014a452a in Query_result_scalar_subquery::send_data (this=0x7f9935428fa0, items=...) at /qa/binaries/MS-57_dbg/sql/item_subselect.cc:832
#14 0x00000000015cf1ef in end_send (join=0x7f9935500218, qep_tab=0x7f9935500a70, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:2913
#15 0x00000000015cbda9 in evaluate_join_record (join=0x7f9935500218, qep_tab=0x7f99355008f8) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:1645
#16 0x00000000015cb159 in sub_select (join=0x7f9935500218, qep_tab=0x7f99355008f8, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:1297
#17 0x00000000015ca958 in do_select (join=0x7f9935500218) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:950
#18 0x00000000015c873a in JOIN::exec (this=0x7f9935500218) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:199
#19 0x00000000014abf99 in subselect_single_select_engine::exec (this=0x7f9935428fc8) at /qa/binaries/MS-57_dbg/sql/item_subselect.cc:3159
#20 0x00000000014a3bc1 in Item_subselect::exec (this=0x7f99354fb7f8) at /qa/binaries/MS-57_dbg/sql/item_subselect.cc:620
#21 0x00000000014a5cbd in Item_singlerow_subselect::val_str (this=0x7f99354fb7f8, str=0x7f99354fb808) at /qa/binaries/MS-57_dbg/sql/item_subselect.cc:1282
#22 0x0000000000fc562a in Item::save_in_field_inner (this=0x7f99354fb7f8, field=0x7f99354af120, no_conversions=true) at /qa/binaries/MS-57_dbg/sql/item.cc:6836
#23 0x0000000000fc50a8 in Item::save_in_field (this=0x7f99354fb7f8, field=0x7f99354af120, no_conversions=true) at /qa/binaries/MS-57_dbg/sql/item.cc:6751
#24 0x0000000000fd5a8f in Item_result_field::save_in_result_field (this=0x7f99354fb7f8, no_conversions=true) at /qa/binaries/MS-57_dbg/sql/item.h:4004
#25 0x00000000015c9979 in copy_funcs (func_ptr=0x7f99354aec30, thd=0x7f9935419000) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:562
#26 0x00000000015d065f in end_write (join=0x7f99354ff030, qep_tab=0x7f99354ff7a8, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:3360
#27 0x00000000015d4195 in QEP_tmp_table::put_record (this=0x7f99354fcfb8, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:4639
#28 0x00000000015d4edf in QEP_tmp_table::put_record (this=0x7f99354fcfb8) at /qa/binaries/MS-57_dbg/sql/sql_executor.h:248
#29 0x00000000015cadbf in sub_select_op (join=0x7f99354ff030, qep_tab=0x7f99354ff7a8, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:1083
#30 0x00000000015cbda9 in evaluate_join_record (join=0x7f99354ff030, qep_tab=0x7f99354ff630) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:1645
#31 0x00000000015cb159 in sub_select (join=0x7f99354ff030, qep_tab=0x7f99354ff630, end_of_records=false) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:1297
#32 0x00000000015ca958 in do_select (join=0x7f99354ff030) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:950
#33 0x00000000015c873a in JOIN::exec (this=0x7f99354ff030) at /qa/binaries/MS-57_dbg/sql/sql_executor.cc:199
#34 0x0000000001669d66 in handle_query (thd=0x7f9935419000, lex=0x7f993541b318, result=0x7f99354fc060, added_options=0, removed_options=0) at /qa/binaries/MS-57_dbg/sql/sql_select.cc:184
#35 0x000000000161a193 in execute_sqlcom_select (thd=0x7f9935419000, all_tables=0x7f99354fb8f8) at /qa/binaries/MS-57_dbg/sql/sql_parse.cc:5144
#36 0x000000000161337e in mysql_execute_command (thd=0x7f9935419000, first_level=true) at /qa/binaries/MS-57_dbg/sql/sql_parse.cc:2816
#37 0x000000000161b112 in mysql_parse (thd=0x7f9935419000, parser_state=0x7f997450d510) at /qa/binaries/MS-57_dbg/sql/sql_parse.cc:5570
#38 0x000000000161007d in dispatch_command (thd=0x7f9935419000, com_data=0x7f997450ddc0, command=COM_QUERY) at /qa/binaries/MS-57_dbg/sql/sql_parse.cc:1484
#39 0x000000000160ef0c in do_command (thd=0x7f9935419000) at /qa/binaries/MS-57_dbg/sql/sql_parse.cc:1025
#40 0x00000000017528a1 in handle_connection (arg=0x7f99493bf6c0) at /qa/binaries/MS-57_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#41 0x0000000001e44dfa in pfs_spawn_thread (arg=0x7f995a7dfa20) at /qa/binaries/MS-57_dbg/storage/perfschema/pfs.cc:2190
#42 0x00007f9972c056ba in start_thread (arg=0x7f997450e700) at pthread_create.c:333
#43 0x00007f997209a41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

How to repeat:
CREATE DATABASE test;
USE test;
create TABLE t1 (a blob, key (a(10)));
SELECT IS_IPV6('0000:0000:0000:0000:0000:0000:0000:0001');
INSERT INTO t1 VALUES ('838:59:58.000016');
SELECT (SELECT MULTILINESTRING(d.a, d.a, d.a) FROM t1 ) FROM t1  AS d GROUP BY d.a;
[6 Nov 2018 5:56] MySQL Verification Team
Hello Ramesh,

Thank you for the report and testcase.
observed that 5.7.24 debug build is affected.

thanks,
Umesh
[6 Nov 2018 6:00] Ramesh Sivaraman
I think it is a duplicate of 92868
[6 Nov 2018 6:25] MySQL Verification Team
Thank you for confirming, marking this as duplicate of Bug #92868