Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4932

[PS8QA] InnoDB: Assertion failure: rem0rec.cc:842:len <= dtype_get_len(type) + prtype_get_compression_extra(dtype_get_prtype(type)) || ...

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t0(a VARCHAR(0)COLUMN_FORMAT COMPRESSED) ROW_FORMAT=DYNAMIC;
      INSERT INTO t0 VALUES(0);
      ALTER TABLE t0 ADD COLUMN(c0 INT),ALGORITHM=INPLACE;
      INSERT INTO t0 SELECT * FROM t0; 

      Leads to;

      2018-10-14T18:39:00.791944Z 0 [System] [MY-010931] [Server] /sda/PS051018-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.12-1-debug'  socket: '/sda/PS051018-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock'  port: 13408  MySQL Community Server (GPL).
      2018-10-14T18:39:25.689193Z 8 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: rem0rec.cc:842:len <= dtype_get_len(type) + prtype_get_compression_extra(dtype_get_prtype(type)) || ((dtype_get_mtype(type)) == 5 || (dtype_get_mtype(type)) == 16 || (dtype_get_mtype(type)) == 14) || !strcmp(index->name, "FTS_INDEX_TABLE_IND")
      InnoDB: thread 140388497872640
      
      Core was generated by `/sda/PS051018-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld --no-defaul'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      [Current thread is 1 (Thread 0x7faebe8bd700 (LWP 25284))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055fe75fc67fd in my_write_core (sig=6) at /git/PS-8.0-trunk_dbg/mysys/stacktrace.cc:278
      #2  0x000055fe74d0d9d7 in handle_fatal_signal (sig=6) at /git/PS-8.0-trunk_dbg/sql/signal_handler.cc:254
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #5  0x00007faebe8fe801 in __GI_abort () at abort.c:79
      #6  0x000055fe76483b73 in ut_dbg_assertion_failed (
          expr=0x55fe776a1158 "len <= dtype_get_len(type) + prtype_get_compression_extra(dtype_get_prtype(type)) || ((dtype_get_mtype(type)) == 5 || (dtype_get_mtype(type)) == 16 || (dtype_get_mtype(type)) == 14) || !strcmp(index->"..., 
          file=0x55fe776a0ab0 "/git/PS-8.0-trunk_dbg/storage/innobase/rem/rem0rec.cc", line=842)
          at /git/PS-8.0-trunk_dbg/storage/innobase/ut/ut0dbg.cc:90
      #7  0x000055fe76346884 in rec_convert_dtuple_to_rec_comp (rec=0x7fae8bc9b4bf "", index=0x7fae8bc5d9b8, fields=0x7fae8bdcac08, 
          n_fields=5, v_entry=0x0, status=0, temp=false) at /git/PS-8.0-trunk_dbg/storage/innobase/rem/rem0rec.cc:839
      #8  0x000055fe76346c5f in rec_convert_dtuple_to_rec_new (buf=0x7fae8bc9b4b8 "", index=0x7fae8bc5d9b8, dtuple=0x7fae8bdcabb8)
          at /git/PS-8.0-trunk_dbg/storage/innobase/rem/rem0rec.cc:926
      #9  0x000055fe76346e65 in rec_convert_dtuple_to_rec (buf=0x7fae8bc9b4b8 "", index=0x7fae8bc5d9b8, dtuple=0x7fae8bdcabb8, n_ext=0)
          at /git/PS-8.0-trunk_dbg/storage/innobase/rem/rem0rec.cc:962
      #10 0x000055fe764cd25c in page_cur_tuple_insert (cursor=0x7faebe8b9598, tuple=0x7fae8bdcabb8, index=0x7fae8bc5d9b8, 
          offsets=0x7faebe8b9538, heap=0x7faebe8b9530, n_ext=0, mtr=0x7faebe8b9b40, use_cache=false)
          at /git/PS-8.0-trunk_dbg/storage/innobase/include/page0cur.ic:224
      #11 0x000055fe764d7bf7 in btr_cur_optimistic_insert (flags=0, cursor=0x7faebe8b9590, offsets=0x7faebe8b9538, heap=0x7faebe8b9530, 
          entry=0x7fae8bdcabb8, rec=0x7faebe8b9540, big_rec=0x7faebe8b9528, n_ext=0, thr=0x7fae8be5ba08, mtr=0x7faebe8b9b40)
          at /git/PS-8.0-trunk_dbg/storage/innobase/btr/btr0cur.cc:2906
      #12 0x000055fe7637097c in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fae8bc5d9b8, n_uniq=0, entry=0x7fae8bdcabb8, 
          n_ext=0, thr=0x7fae8be5ba08, dup_chk_only=false) at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:2523
      #13 0x000055fe76372972 in row_ins_clust_index_entry (index=0x7fae8bc5d9b8, entry=0x7fae8bdcabb8, thr=0x7fae8be5ba08, n_ext=0, 
          dup_chk_only=false) at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:3138
      #14 0x000055fe76372e85 in row_ins_index_entry (index=0x7fae8bc5d9b8, entry=0x7fae8bdcabb8, thr=0x7fae8be5ba08)
          at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:3269
      #15 0x000055fe76373492 in row_ins_index_entry_step (node=0x7fae8be5b710, thr=0x7fae8be5ba08)
          at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:3403
      #16 0x000055fe76373840 in row_ins (node=0x7fae8be5b710, thr=0x7fae8be5ba08)
          at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:3525
      #17 0x000055fe76373e7c in row_ins_step (thr=0x7fae8be5ba08) at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0ins.cc:3691
      #18 0x000055fe7639351e in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7fae8bcb2a28 "\376", prebuilt=0x7fae8be5b0b8)
          at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0mysql.cc:2032
      #19 0x000055fe76393b85 in row_insert_for_mysql (mysql_rec=0x7fae8bcb2a28 "\376", prebuilt=0x7fae8be5b0b8)
          at /git/PS-8.0-trunk_dbg/storage/innobase/row/row0mysql.cc:2161
      #20 0x000055fe761b47aa in ha_innobase::write_row (this=0x7fae8be92028, record=0x7fae8bcb2a28 "\376")
          at /git/PS-8.0-trunk_dbg/storage/innobase/handler/ha_innodb.cc:8313
      #21 0x000055fe74ea2283 in handler::ha_write_row (this=0x7fae8be92028, buf=0x7fae8bcb2a28 "\376")
          at /git/PS-8.0-trunk_dbg/sql/handler.cc:7836
      #22 0x000055fe75122b55 in write_record (thd=0x7fae8bc24000, table=0x7fae8bc40a20, info=0x7fae8be9c9f0, update=0x7fae8be9ca68)
          at /git/PS-8.0-trunk_dbg/sql/sql_insert.cc:1841
      #23 0x000055fe7512388e in Query_result_insert::send_data (this=0x7fae8be9c9a8, values=...)
          at /git/PS-8.0-trunk_dbg/sql/sql_insert.cc:2039
      #24 0x000055fe751049be in end_send (join=0x7fae8bdb2028, qep_tab=0x7fae8bdb2d70, end_of_records=false)
          at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:3056
      #25 0x000055fe75101286 in evaluate_join_record (join=0x7fae8bdb2028, qep_tab=0x7fae8bdb2bf8)
          at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:1853
      #26 0x000055fe7510e146 in QEP_tmp_table::end_send (this=0x7fae8bdb3098) at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:6313
      #27 0x000055fe750ffed0 in sub_select_op (join=0x7fae8bdb2028, qep_tab=0x7fae8bdb2bf8, end_of_records=true)
          at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:1281
      #28 0x000055fe75100065 in sub_select (join=0x7fae8bdb2028, qep_tab=0x7fae8bdb2a80, end_of_records=true)
          at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:1432
      #29 0x000055fe750ffb05 in do_select (join=0x7fae8bdb2028) at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:1172
      #30 0x000055fe750fcbdf in JOIN::exec (this=0x7fae8bdb2028) at /git/PS-8.0-trunk_dbg/sql/sql_executor.cc:294
      #31 0x000055fe74bb514a in Sql_cmd_dml::execute_inner (this=0x7fae8be9c908, thd=0x7fae8bc24000)
          at /git/PS-8.0-trunk_dbg/sql/sql_select.cc:652
      #32 0x000055fe74bb4bd7 in Sql_cmd_dml::execute (this=0x7fae8be9c908, thd=0x7fae8bc24000)
          at /git/PS-8.0-trunk_dbg/sql/sql_select.cc:555
      #33 0x000055fe74b51fea in mysql_execute_command (thd=0x7fae8bc24000, first_level=true)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:3371
      #34 0x000055fe74b57f2b in mysql_parse (thd=0x7fae8bc24000, parser_state=0x7faebe8bc2a0, update_userstat=false)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:5139
      #35 0x000055fe74b4d0b7 in dispatch_command (thd=0x7fae8bc24000, com_data=0x7faebe8bcc70, command=COM_QUERY)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1654
      #36 0x000055fe74b4b8a6 in do_command (thd=0x7fae8bc24000) at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1262
      #37 0x000055fe74cfa1fa in handle_connection (arg=0x7fae354259d0)
          at /git/PS-8.0-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:317
      #38 0x000055fe760b7f42 in pfs_spawn_thread (arg=0x7fae35423420) at /git/PS-8.0-trunk_dbg/storage/perfschema/pfs.cc:2836
      #39 0x00007faec05076db in start_thread (arg=0x7faebe8bd700) at pthread_create.c:463
      #40 0x00007faebe9df88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              roel.vandepaar Roel Van de Paar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 minutes
                  2m

                  Smart Checklist