Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17199

Assertion `pos < table->n_v_def' failed in dict_table_get_nth_v_col after upgrade from 10.1/10.0 to 10.2

    XMLWordPrintable

    Details

      Description

      10.2 c3124174c3e

      mysqld: /data/src/10.2/storage/innobase/include/dict0dict.ic:490: dict_v_col_t* dict_table_get_nth_v_col(const dict_table_t*, ulint): Assertion `pos < table->n_v_def' failed.
      180914 17:10:31 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f1741e79ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055f0f51c6701 in dict_table_get_nth_v_col (table=0x7f16d400c6c8, pos=0) at /data/src/10.2/storage/innobase/include/dict0dict.ic:490
      #9  0x000055f0f51d36d6 in build_template_field (prebuilt=0x7f16d402c508, clust_index=0x7f16d4035578, index=0x7f16d4035578, table=0x7f16d4020920, field=0x7f16d400b648, i=0, v_no=0) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:7511
      #10 0x000055f0f51d5299 in ha_innobase::build_template (this=0x7f16d4021528, whole_row=true) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8010
      #11 0x000055f0f51e280b in ha_innobase::check (this=0x7f16d4021528, thd=0x7f16d4000b00, check_opt=0x7f16d40055e8) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:14590
      #12 0x000055f0f4ec6d39 in handler::ha_check (this=0x7f16d4021528, thd=0x7f16d4000b00, check_opt=0x7f16d40055e8) at /data/src/10.2/sql/handler.cc:3973
      #13 0x000055f0f4da5dad in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f16d4000b00, tables=0x7f16d40111d0, check_opt=0x7f16d40055e8, operator_name=0x55f0f570d25c "check", lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x55f0f4ec6c14 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x55f0f4d412d5 <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>) at /data/src/10.2/sql/sql_admin.cc:798
      #14 0x000055f0f4da7f5e in Sql_cmd_check_table::execute (this=0x7f16d40117e0, thd=0x7f16d4000b00) at /data/src/10.2/sql/sql_admin.cc:1343
      #15 0x000055f0f4c50dd2 in mysql_execute_command (thd=0x7f16d4000b00) at /data/src/10.2/sql/sql_parse.cc:6225
      #16 0x000055f0f4c55bbe in mysql_parse (thd=0x7f16d4000b00, rawbuf=0x7f16d40110f8 "check table test.t1", length=19, parser_state=0x7f174014c250, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8009
      #17 0x000055f0f4c4363c in dispatch_command (command=COM_QUERY, thd=0x7f16d4000b00, packet=0x7f16d40191e1 "", packet_length=19, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
      #18 0x000055f0f4c41f9f in do_command (thd=0x7f16d4000b00) at /data/src/10.2/sql/sql_parse.cc:1378
      #19 0x000055f0f4d939ae in do_handle_one_connection (connect=0x55f0f9224940) at /data/src/10.2/sql/sql_connect.cc:1335
      #20 0x000055f0f4d9373b in handle_one_connection (arg=0x55f0f9224940) at /data/src/10.2/sql/sql_connect.cc:1241
      #21 0x00007f1743b50494 in start_thread (arg=0x7f174014d700) at pthread_create.c:333
      #22 0x00007f1741f3693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      An example of 10.1 datadir is attached (state of the datadir after normal shutdown on 10.1, before any attempt to run 10.2 on it): data.tar.gz

      • start 10.2 on the datadir, all default options should be sufficient;
      • run CHECK TABLE test.t1

      The problem blocks testing of changes made in the scope of MDEV-14046.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: