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

LP:616236 - Aria assertion "!pinned_page->changed || undo_lsn != ((LSN)0) || !info->s->now_transactional

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      When executing a DML workload with multiple indexes, aria asserted as follows:

      #2 0x00000000006729f7 in handle_segfault (sig=6) at mysqld.cc:2728
      #3 <signal handler called>
      #4 0x000000307b6329c5 in raise (sig=6)
      at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
      #5 0x000000307b6341a5 in abort () at abort.c:92
      #6 0x000000307b62b945 in __assert_fail (
      assertion=0xd763b8 "!pinned_page->changed || undo_lsn != ((LSN)0) || !info->s->now_transactional", file=<value optimized out>, line=68,
      function=<value optimized out>) at assert.c:81
      #7 0x00000000009823cb in _ma_unpin_all_pages (info=0x7f910004ec68,
      undo_lsn=0) at ma_key_recover.c:67
      #8 0x0000000000996620 in _ma_unpin_all_pages_and_finalize_row (
      info=0x7f910004ec68, undo_lsn=0) at ma_key_recover.h:102
      #9 0x000000000099f3cd in _ma_update_block_record2 (info=0x7f910004ec68,
      record_pos=1545, oldrec=0x7f91000413f0 "\367\237\377",
      record=0x7f910003ffb0 "\367\233\377", undo_lsn=1) at ma_blockrec.c:3713
      #10 0x000000000099f9a6 in _ma_update_block_record (info=0x7f910004ec68,
      record_pos=1545, orig_rec=0x7f91000413f0 "\367\237\377",
      new_rec=0x7f910003ffb0 "\367\233\377") at ma_blockrec.c:3850
      #11 0x00000000009ae79d in maria_update (info=0x7f910004ec68,
      oldrec=0x7f91000413f0 "\367\237\377",
      newrec=0x7f910003ffb0 "\367\233\377") at ma_update.c:160
      #12 0x000000000096a103 in ha_maria::update_row (this=0x7f9100012230,
      old_data=0x7f91000413f0 "\367\237\377",
      new_data=0x7f910003ffb0 "\367\233\377") at ha_maria.cc:2113
      #13 0x00000000007cee75 in handler::ha_update_row (this=0x7f9100012230,
      old_data=0x7f91000413f0 "\367\237\377",
      new_data=0x7f910003ffb0 "\367\233\377") at handler.cc:4869
      #14 0x00000000007d7eba in ha_partition::update_row (this=0x7f91000114e0,
      old_data=0x7f91000413f0 "\367\237\377",
      new_data=0x7f910003ffb0 "\367\233\377") at ha_partition.cc:3162
      #15 0x00000000007cee75 in handler::ha_update_row (this=0x7f91000114e0,
      old_data=0x7f91000413f0 "\367\237\377",
      new_data=0x7f910003ffb0 "\367\233\377") at handler.cc:4869
      #16 0x0000000000742a62 in mysql_update (thd=0x3ab8b18,
      table_list=0x7f911c014ec8, fields=..., values=..., conds=0x7f911c0159d0,
      order_num=0, order=0x0, limit=18446744073709551511,
      handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:652
      #17 0x000000000068849e in mysql_execute_command (thd=0x3ab8b18)
      at sql_parse.cc:3120
      #18 0x000000000069151e in mysql_parse (thd=0x3ab8b18,
      inBuf=0x7f911c014bf0 "UPDATE `table100_maria_key_pk_parts_2_int_autoinc` SET `col_varchar_255_utf8_key` = REPEAT( _LATIN1 0x176 , 190 ) WHERE `col_varchar_255_ucs2_key` <> REPEAT( _UCS2 0x55 , 50 )", length=175,
      found_semicolon=0x7f912bffec88) at sql_parse.cc:6055
      #19 0x00000000006834e2 in dispatch_command (command=COM_QUERY, thd=0x3ab8b18,
      packet=0x3b581e9 "UPDATE `table100_maria_key_pk_parts_2_int_autoinc` SET `col_varchar_255_utf8_key` = REPEAT( _LATIN1 0x176 , 190 ) WHERE `col_varchar_255_ucs2_key` <> REPEAT( _UCS2 0x55 , 50 ) ", packet_length=176)
      at sql_parse.cc:1204
      #20 0x00000000006828a8 in do_command (thd=0x3ab8b18) at sql_parse.cc:898
      #21 0x000000000067f898 in handle_one_connection (arg=0x3ab8b18)
      at sql_connect.cc:1154
      #22 0x000000307ba07761 in start_thread (arg=0x7f912bfff710)
      at pthread_create.c:301
      #23 0x000000307b6e150d in clone ()

      rqg command line:

      /home/buildbot/randgen/runall.pl \
      --basedir=. \
      --vardir=../../vardir-maria_many_indexes \
      --grammar=/home/buildbot/randgen/conf/engines/many_indexes.yy \
      --gendata=/home/buildbot/randgen/conf/engines/many_indexes.zz \
      --rows=10000 \
      --reporter=Backtrace,ErrorLog,Recovery,Shutdown \
      --duration=240 \
      --queries=1M \
      --engine=Maria \
      --rows=10000 \
      -mysqld=-maria-checkpoint-interval=0 \
      -mysqld=-log-output=file \
      --seed=time

      Attachments

        Activity

          People

            monty Michael Widenius
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.