Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
Note: it might be a duplicate of MDEV-13540. The same assertion fails on a debug build, but stack traces are essentially different, test cases too, and non-debug build crashes in different ways, so I'm filing it separately just in case.
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (c VARCHAR(500) COMPRESSED) ENGINE=InnoDB; |
INSERT INTO t1 VALUES ('foo'),('bar'); |
|
SELECT DISTINCT c FROM t1; |
|
# Cleanup
|
DROP TABLE t1; |
bb-10.3-svoj debug f1a3cd40 |
mysqld: /data/src/bb-10.3-svoj/sql/field.h:3222: virtual Field* Field_varstring_compressed::new_key_field(MEM_ROOT*, TABLE*, uchar*, uint32, uchar*, uint): Assertion `0' failed.
|
170816 1:26:42 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fe2031ecee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055c0dc0aaed3 in Field_varstring_compressed::new_key_field (this=0x7fe1ac155a68, root=0x7fe1ac154f50, new_table=0x7fe1ac154498, new_ptr=0x7fe1ac1557b9 '\245' <repeats 200 times>..., length=501, new_null_ptr=0x7fe1ac1789a8 "\377", new_null_bit=2) at /data/src/bb-10.3-svoj/sql/field.h:3222
|
#9 0x000055c0dbe7cd74 in create_tmp_table (thd=0x7fe1ac000b00, param=0x7fe1ac016d40, fields=..., group=0x7fe1ac016ce8, distinct=false, save_sum_fields=false, select_options=2147748609, rows_limit=18446744073709551615, table_alias=0x55c0dc8c2915 "", do_not_open=true, keep_row_order=false) at /data/src/bb-10.3-svoj/sql/sql_select.cc:16886
|
#10 0x000055c0dbe5867d in JOIN::create_postjoin_aggr_table (this=0x7fe1ac0151c0, tab=0x7fe1ac016558, table_fields=0x7fe1ac0154d8, table_group=0x7fe1ac016ce8, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2831
|
#11 0x000055c0dbe56a4a in JOIN::make_aggr_tables_info (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2405
|
#12 0x000055c0dbe55c2f in JOIN::optimize_inner (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2160
|
#13 0x000055c0dbe52154 in JOIN::optimize (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:1084
|
#14 0x000055c0dbe5af26 in mysql_select (thd=0x7fe1ac000b00, tables=0x7fe1ac014ac8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609, result=0x7fe1ac0151a0, unit=0x7fe1ac0046b8, select_lex=0x7fe1ac004df0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:3651
|
#15 0x000055c0dbe4fa6e in handle_select (thd=0x7fe1ac000b00, lex=0x7fe1ac0045f0, result=0x7fe1ac0151a0, setup_tables_done_option=0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:373
|
#16 0x000055c0dbe1bf1b in execute_sqlcom_select (thd=0x7fe1ac000b00, all_tables=0x7fe1ac014ac8) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:6450
|
#17 0x000055c0dbe122cf in mysql_execute_command (thd=0x7fe1ac000b00) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:3574
|
#18 0x000055c0dbe1f90d in mysql_parse (thd=0x7fe1ac000b00, rawbuf=0x7fe1ac0148d8 "SELECT DISTINCT c FROM t1", length=25, parser_state=0x7fe1f45f2210, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:7897
|
#19 0x000055c0dbe0d687 in dispatch_command (command=COM_QUERY, thd=0x7fe1ac000b00, packet=0x7fe1ac173951 "SELECT DISTINCT c FROM t1", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:1814
|
#20 0x000055c0dbe0c02b in do_command (thd=0x7fe1ac000b00) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:1377
|
#21 0x000055c0dbf57f31 in do_handle_one_connection (connect=0x55c0dfcc4dd0) at /data/src/bb-10.3-svoj/sql/sql_connect.cc:1354
|
#22 0x000055c0dbf57cbe in handle_one_connection (arg=0x55c0dfcc4dd0) at /data/src/bb-10.3-svoj/sql/sql_connect.cc:1260
|
#23 0x000055c0dc3b0e29 in pfs_spawn_thread (arg=0x55c0dfc0c490) at /data/src/bb-10.3-svoj/storage/perfschema/pfs.cc:1862
|
#24 0x00007fe204f26494 in start_thread (arg=0x7fe1f45f3700) at pthread_create.c:333
|
#25 0x00007fe2032a993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
bb-10.3-svoj non-debug f1a3cd40 |
#2 <signal handler called>
|
#3 0x000055bceba5be57 in next_breadth_first_tab (first_top_tab=first_top_tab@entry=0x7fd000012b50, n_top_tabs_count=n_top_tabs_count@entry=1, tab=tab@entry=0x7fd000012f00) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:8476
|
#4 0x000055bceba7348d in JOIN::cleanup (this=this@entry=0x7fd000011b68, full=full@entry=true) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:12015
|
#5 0x000055bceba73abd in JOIN::destroy (this=0x7fd000011b68) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:3496
|
#6 0x000055bcebacd460 in st_select_lex::cleanup (this=this@entry=0x7fd000004b58) at /data/src/bb-10.3-svoj-rel/sql/sql_union.cc:1708
|
#7 0x000055bceba8bfce in mysql_select (thd=thd@entry=0x7fd0000009a8, tables=0x7fd000011470, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609, result=0x7fd000011b48, unit=0x7fd000004420, select_lex=0x7fd000004b58) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:3677
|
#8 0x000055bceba8c8d0 in handle_select (thd=thd@entry=0x7fd0000009a8, lex=lex@entry=0x7fd000004358, result=result@entry=0x7fd000011b48, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:373
|
#9 0x000055bceba30906 in execute_sqlcom_select (thd=0x7fd0000009a8, all_tables=0x7fd000011470) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:6450
|
#10 0x000055bceba3cbed in mysql_execute_command (thd=0x7fd0000009a8) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:3574
|
#11 0x000055bceba401cf in mysql_parse (thd=0x7fd0000009a8, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7fd04c390250, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:7897
|
#12 0x000055bceba42d6b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd0000009a8, packet=packet@entry=0x7fd000008f19 "SELECT DISTINCT c FROM t1", packet_length=packet_length@entry=25, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:1814
|
#13 0x000055bceba435c7 in do_command (thd=0x7fd0000009a8) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:1377
|
#14 0x000055bcebb072f4 in do_handle_one_connection (connect=connect@entry=0x55bcee2f4e78) at /data/src/bb-10.3-svoj-rel/sql/sql_connect.cc:1354
|
#15 0x000055bcebb07494 in handle_one_connection (arg=arg@entry=0x55bcee2f4e78) at /data/src/bb-10.3-svoj-rel/sql/sql_connect.cc:1260
|
#16 0x000055bcebdfd794 in pfs_spawn_thread (arg=0x55bcee2f50d8) at /data/src/bb-10.3-svoj-rel/storage/perfschema/pfs.cc:1862
|
#17 0x00007fd054c42494 in start_thread (arg=0x7fd04c391700) at pthread_create.c:333
|
#18 0x00007fd052fc593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- blocks
-
MDEV-11371 Big column compressed
- Closed
- relates to
-
MDEV-13540 Server crashes in copy or Assertion `0' failed in virtual Field* Field_varstring_compressed::new_key_field
- Closed
-
MDEV-13342 Testing for MDEV-11371 (Big column compressed)
- Closed
-
MDEV-21005 Assertion `0' failed in Field_blob_compressed::new_key_field
- Closed