MS Bug 79794 asserts differently on PS | InnoDB: Failing assertion: len <= col->len || ((col->mtype) == 5 || (col->mtype) == 16 || (col->mtype) == 14) || (((col->mtype) == 15 || (col->mtype) == 16) && len == 2 * 2 * sizeof(double)) || ((col->mtype == 1 || col->mtype == 4 || col->mtype == 12) && (col->len == 0 || len <= col->len + prtype_get_compression_extra(col->prtype)))

[Roel Van de Paar]

Version: '5.7.17-11-debug' socket: '/sda/PS200317-percona-server-5.7.17-11-linux-x86_64-debug/socket.sock' port: 15643 MySQL Community Server (GPL)
2017-03-23 09:17:57 0x7ff817574700 InnoDB: Assertion failure in thread 140703520212736 in file rem0rec.cc line 872
InnoDB: Failing assertion: len <= col->len || ((col->mtype) == 5 || (col->mtype) == 16 || (col->mtype) == 14) || (((col->mtype) == 15 || (col->mtype) == 16) && len == 2 * 2 * sizeof(double)) || ((col->mtype == 1 || col->mtype == 4 || col->mtype == 12) && (col->len == 0 || len <= col->len + prtype_get_compression_extra(col->prtype)))

#0 __pthread_kill (threadid=<optimised out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1 0x00005596c9aacdb4 in my_write_core (sig=6) at /git/PS57_dbg/mysys/stacktrace.c:249
#2 0x00005596c903bace in handle_fatal_signal (sig=6) at /git/PS57_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58
#5 0x00007ff81523f3ea in __GI_abort () at abort.c:89
#6 0x00005596c9d672b1 in ut_dbg_assertion_failed (
    expr=0x5596ca4770c0 "len <= col->len || ((col->mtype) == 5 || (col->mtype) == 16 || (col->mtype) == 14) || (((col->mtype) == 15 || (col->mtype) == 16) && len == 2 * 2 * sizeof(double)) || ((col->mtype == 1 || col->mtype ="..., file=0x5596ca476df8 "/git/PS57_dbg/storage/innobase/rem/rem0rec.cc", line=872)
    at /git/PS57_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x00005596c9c2f7f7 in rec_get_converted_size_comp_prefix_low (index=0x7ff7d64375a0, fields=0x7ff7d647ffe8, n_fields=4, v_entry=0x0, extra=0x0,
    temp=false) at /git/PS57_dbg/storage/innobase/rem/rem0rec.cc:864
#8 0x00005596c9c2ff45 in rec_get_converted_size_comp (index=0x7ff7d64375a0, status=0, fields=0x7ff7d647ffe8, n_fields=4, extra=0x0)
    at /git/PS57_dbg/storage/innobase/rem/rem0rec.cc:1024
#9 0x00005596c9d904c3 in rec_get_converted_size (index=0x7ff7d64375a0, dtuple=0x7ff7d647ffa0, n_ext=0)
    at /git/PS57_dbg/storage/innobase/include/rem0rec.ic:1653
#10 0x00005596c9d9bbcc in btr_cur_optimistic_insert (flags=3, cursor=0x7ff817571030, offsets=0x7ff817570fe8, heap=0x7ff817570fe0, entry=0x7ff7d647ffa0,
    rec=0x7ff817570ff0, big_rec=0x7ff817570ff8, n_ext=0, thr=0x7ff7d64ab858, mtr=0x7ff7d6462f28) at /git/PS57_dbg/storage/innobase/btr/btr0cur.cc:3171
#11 0x00005596c9c57cec in row_ins_sorted_clust_index_entry (mode=2, index=0x7ff7d64375a0, entry=0x7ff7d647ffa0, n_ext=0, thr=0x7ff7d64ab858)
    at /git/PS57_dbg/storage/innobase/row/row0ins.cc:2737
#12 0x00005596c9c59834 in row_ins_clust_index_entry (index=0x7ff7d64375a0, entry=0x7ff7d647ffa0, thr=0x7ff7d64ab858, n_ext=0, dup_chk_only=false)
    at /git/PS57_dbg/storage/innobase/row/row0ins.cc:3305
#13 0x00005596c9c7c33f in row_insert_for_mysql_using_cursor (mysql_rec=0x7ff7d64bfe48 "\376\024\060\060\060\060-00-00 00:00:0", prebuilt=0x7ff7d64ab0a0)
    at /git/PS57_dbg/storage/innobase/row/row0mysql.cc:2133
#14 0x00005596c9c7d07b in row_insert_for_mysql (mysql_rec=0x7ff7d64bfe48 "\376\024\060\060\060\060-00-00 00:00:0", prebuilt=0x7ff7d64ab0a0)
    at /git/PS57_dbg/storage/innobase/row/row0mysql.cc:2399
#15 0x00005596c9b0531f in ha_innobase::intrinsic_table_write_row (this=0x7ff7d64b0830, record=0x7ff7d64bfe48 "\376\024\060\060\060\060-00-00 00:00:0")
    at /git/PS57_dbg/storage/innobase/handler/ha_innodb.cc:8002
#16 0x00005596c9b053f9 in ha_innobase::write_row (this=0x7ff7d64b0830, record=0x7ff7d64bfe48 "\376\024\060\060\060\060-00-00 00:00:0")
    at /git/PS57_dbg/storage/innobase/handler/ha_innodb.cc:8026
#17 0x00005596c90e3f70 in handler::ha_write_row (this=0x7ff7d64b0830, buf=0x7ff7d64bfe48 "\376\024\060\060\060\060-00-00 00:00:0")
    at /git/PS57_dbg/sql/handler.cc:8381
#18 0x00005596c9706cc4 in end_write_group (join=0x7ff7d648f2f8, qep_tab=0x7ff7d648fe50, end_of_records=true) at /git/PS57_dbg/sql/sql_executor.cc:3569
#19 0x00005596c9709e77 in QEP_tmp_table::put_record (this=0x7ff7d6490438, end_of_records=true) at /git/PS57_dbg/sql/sql_executor.cc:4645
#20 0x00005596c9709edb in QEP_tmp_table::end_send (this=0x7ff7d6490438) at /git/PS57_dbg/sql/sql_executor.cc:4666
#21 0x00005596c97008b2 in sub_select_op (join=0x7ff7d648f2f8, qep_tab=0x7ff7d648fe50, end_of_records=true) at /git/PS57_dbg/sql/sql_executor.cc:1063
#22 0x00005596c9700a0c in sub_select (join=0x7ff7d648f2f8, qep_tab=0x7ff7d648fcd8, end_of_records=true) at /git/PS57_dbg/sql/sql_executor.cc:1220
#23 0x00005596c9700524 in do_select (join=0x7ff7d648f2f8) at /git/PS57_dbg/sql/sql_executor.cc:946
#24 0x00005596c96fe2ed in JOIN::exec (this=0x7ff7d648f2f8) at /git/PS57_dbg/sql/sql_executor.cc:199
#25 0x00005596c97a3ed9 in handle_query (thd=0x7ff7d6419000, lex=0x7ff7d641b5f8, result=0x7ff7d642cfd0, added_options=0, removed_options=0)
    at /git/PS57_dbg/sql/sql_select.cc:185
#26 0x00005596c9751f61 in execute_sqlcom_select (thd=0x7ff7d6419000, all_tables=0x7ff7d642c858) at /git/PS57_dbg/sql/sql_parse.cc:5482
#27 0x00005596c974a694 in mysql_execute_command (thd=0x7ff7d6419000, first_level=true) at /git/PS57_dbg/sql/sql_parse.cc:2941
#28 0x00005596c9753043 in mysql_parse (thd=0x7ff7d6419000, parser_state=0x7ff8175734a0) at /git/PS57_dbg/sql/sql_parse.cc:5927
#29 0x00005596c9746eb7 in dispatch_command (thd=0x7ff7d6419000, com_data=0x7ff817573da0, command=COM_QUERY) at /git/PS57_dbg/sql/sql_parse.cc:1493
#30 0x00005596c9745c54 in do_command (thd=0x7ff7d6419000) at /git/PS57_dbg/sql/sql_parse.cc:1021
#31 0x00005596c9896c28 in handle_connection (arg=0x7ff7eefaaa60) at /git/PS57_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
#32 0x00005596c9f95949 in pfs_spawn_thread (arg=0x7ff80efc8020) at /git/PS57_dbg/storage/perfschema/pfs.cc:2188
#33 0x00007ff815e7e6ca in start_thread (arg=0x7ff817574700) at pthread_create.c:333
#34 0x00007ff8153100af in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105

# mysqld options required for replay: --sql_mode=
DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@session.sql_buffer_result=ON;
CREATE TEMPORARY TABLE t1(c1 TIMESTAMP);
insert INTO t1 values(repeat(0,0));
SELECT GROUP_CONCAT(c1 ORDER BY c1)FROM t1 GROUP BY c1 COLLATE ucs2_latvian_ci;

Note that the assertion message is different. I expect that this is only because of added PS features? If so, feel free to set this bug as dup of MS 79794.

[Laurynas Biveinis (laurynas-biveinis)]

The assert was adjusted for compressed columns

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1078