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

[Draft] Assertion `!rec_get_deleted_flag(rec, comp)' failed in row_search_mvcc

    XMLWordPrintable

Details

    Description

      https://travis-ci.org/elenst/travis-tests/jobs/487256422 [2651 29 3]

      10.3 14a58ce

      mysqld: /home/travis/src/storage/innobase/row/row0sel.cc:4387: dberr_t row_search_mvcc(byte*, page_cur_mode_t, row_prebuilt_t*, ulint, ulint): Assertion `!rec_get_deleted_flag(rec, comp)' failed.
      190201 12:23:36 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fadf5f71ca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005592bc78a9f6 in row_search_mvcc (buf=0x7fada017d280 "\374\377\n", mode=PAGE_CUR_GE, prebuilt=0x7fada01404f8, match_mode=1, direction=0) at /home/travis/src/storage/innobase/row/row0sel.cc:4387
      #9  0x00005592bc5fa738 in ha_innobase::index_read (this=0x7fada0125028, buf=0x7fada017d280 "\374\377\n", key_ptr=0x7fad8c2c26c0 "\v", key_len=4, find_flag=HA_READ_KEY_EXACT) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:9278
      #10 0x00005592bc5fb8b5 in ha_innobase::rnd_pos (this=0x7fada0125028, buf=0x7fada017d280 "\374\377\n", pos=0x7fad8c2c26c0 "\v") at /home/travis/src/storage/innobase/handler/ha_innodb.cc:9780
      #11 0x00005592bc3e5520 in handler::ha_rnd_pos (this=0x7fada0125028, buf=0x7fada017d280 "\374\377\n", pos=0x7fad8c2c26c0 "\v") at /home/travis/src/sql/handler.cc:2798
      #12 0x00005592bc565bd2 in rr_from_pointers (info=0x7fad8c02f5d0) at /home/travis/src/sql/records.cc:547
      #13 0x00005592bc04724f in READ_RECORD::read_record (this=0x7fad8c02f5d0) at /home/travis/src/sql/records.h:73
      #14 0x00005592bc15540c in sub_select (join=0x7fad8c02ce78, join_tab=0x7fad8c02f508, end_of_records=false) at /home/travis/src/sql/sql_select.cc:19415
      #15 0x00005592bc15489c in do_select (join=0x7fad8c02ce78, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18936
      #16 0x00005592bc12d5af in JOIN::exec_inner (this=0x7fad8c02ce78) at /home/travis/src/sql/sql_select.cc:4040
      #17 0x00005592bc12c9f8 in JOIN::exec (this=0x7fad8c02ce78) at /home/travis/src/sql/sql_select.cc:3834
      #18 0x00005592bc12dccb in mysql_select (thd=0x7fad8c015280, tables=0x7fad8c0b79c8, wild_num=0, fields=..., conds=0x0, og_num=2, order=0x0, group=0x7fad8c0b8738, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7fad8c02cd90, unit=0x7fad8c0b5c68, select_lex=0x7fad8c0b63d8) at /home/travis/src/sql/sql_select.cc:4239
      #19 0x00005592bc097506 in mysql_derived_fill (thd=0x7fad8c015280, lex=0x7fad8c0b36b8, derived=0x7fad8c0b50d0) at /home/travis/src/sql/sql_derived.cc:1165
      #20 0x00005592bc095183 in mysql_handle_single_derived (lex=0x7fad8c0b36b8, derived=0x7fad8c0b50d0, phases=96) at /home/travis/src/sql/sql_derived.cc:197
      #21 0x00005592bc1440fd in st_join_table::preread_init (this=0x7fad8c41de48) at /home/travis/src/sql/sql_select.cc:12575
      #22 0x00005592bc1551c1 in sub_select (join=0x7fad8c02bbd8, join_tab=0x7fad8c41de48, end_of_records=false) at /home/travis/src/sql/sql_select.cc:19364
      #23 0x00005592bc15489c in do_select (join=0x7fad8c02bbd8, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18936
      #24 0x00005592bc12d5af in JOIN::exec_inner (this=0x7fad8c02bbd8) at /home/travis/src/sql/sql_select.cc:4040
      #25 0x00005592bc12c9f8 in JOIN::exec (this=0x7fad8c02bbd8) at /home/travis/src/sql/sql_select.cc:3834
      #26 0x00005592bc12dccb in mysql_select (thd=0x7fad8c015280, tables=0x7fad8c0b50d0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552171997952, result=0x7fad8c0b5728, unit=0x7fad8c0b3780, select_lex=0x7fad8c0b3ef0) at /home/travis/src/sql/sql_select.cc:4239
      #27 0x00005592bc11fbe9 in handle_select (thd=0x7fad8c015280, lex=0x7fad8c0b36b8, result=0x7fad8c0b5728, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:385
      #28 0x00005592bc0ea5de in execute_sqlcom_select (thd=0x7fad8c015280, all_tables=0x7fad8c0b50d0) at /home/travis/src/sql/sql_parse.cc:6548
      #29 0x00005592bc0e0c3f in mysql_execute_command (thd=0x7fad8c015280) at /home/travis/src/sql/sql_parse.cc:3769
      #30 0x00005592bc10c01f in Prepared_statement::execute (this=0x7fad8c3bd640, expanded_query=0x7fadf4271360, open_cursor=false) at /home/travis/src/sql/sql_prepare.cc:4788
      #31 0x00005592bc10a446 in Prepared_statement::execute_loop (this=0x7fad8c3bd640, expanded_query=0x7fadf4271360, open_cursor=false, packet=0x7fad8c2e13aa "def", packet_end=0x7fad8c2e13aa "def") at /home/travis/src/sql/sql_prepare.cc:4216
      #32 0x00005592bc107c80 in mysql_stmt_execute_common (thd=0x7fad8c015280, stmt_id=4168, packet=0x7fad8c2e13aa "def", packet_end=0x7fad8c2e13aa "def", cursor_flags=0, bulk_op=false, read_types=false) at /home/travis/src/sql/sql_prepare.cc:3216
      #33 0x00005592bc107823 in mysqld_stmt_execute (thd=0x7fad8c015280, packet_arg=0x7fad8c2e13a1 "", packet_length=9) at /home/travis/src/sql/sql_prepare.cc:3114
      #34 0x00005592bc0db3ad in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7fad8c015280, packet=0x7fad8c2e13a1 "", packet_length=9, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1793
      #35 0x00005592bc0da18b in do_command (thd=0x7fad8c015280) at /home/travis/src/sql/sql_parse.cc:1396
      #36 0x00005592bc2430a0 in do_handle_one_connection (connect=0x5592bf6d1a50) at /home/travis/src/sql/sql_connect.cc:1402
      #37 0x00005592bc242e24 in handle_one_connection (arg=0x5592bf6d1a50) at /home/travis/src/sql/sql_connect.cc:1308
      #38 0x00007fadf6b33184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #39 0x00007fadf603fffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      elenst-jira-refs 56fe472 Toolbox: 1114257

      perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1549023757 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/acl.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/mariadb/functions.yy --ps-protocol --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff
      

      Not reproducible right away.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.