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

Assertion `dict_index_is_clust(index) || !dict_index_is_online_ddl(index)' failed in lock_rec_create_low

    XMLWordPrintable

Details

    Description

      commit 4c0f3b3be76343c155b00feff3309d91e1e11441 origin/bb-10.2-marko
      containing a fix for MDEV-19114 but IIRC I have seen that assert some time ago
       
      Version: '10.2.33-MariaDB-debug-log'  socket:...
      mysqld: /home/mleich/bb-10.2-marko_2/storage/innobase/lock/lock0lock.cc:1408: ib_lock_t* lock_rec_create_low(ib_lock_t*, que_thr_t*, ulint, ulint, ulint, const ib_page_t*, ulint, dict_index_t*, trx_t*, bool): Assertion `dict_index_is_clust(index) || !dict_index_is_online_ddl(index)' failed.
      ...
      lock/lock0lock.cc:1414(lock_rec_create_low(ib_lock_t*, que_thr_t*, unsigned long, unsigned long, unsigned long, unsigned char const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc95ac08]
      include/lock0lock.ic:133(lock_rec_create(ib_lock_t*, que_thr_t*, unsigned long, buf_block_t const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc9785ec]
      lock/lock0lock.cc:1954(lock_rec_add_to_queue(unsigned long, buf_block_t const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc83dc32]
      page/page0page.cc:777(page_copy_rec_list_end(buf_block_t*, buf_block_t*, unsigned char*, dict_index_t*, mtr_t*))[0x5607fc64a0e2]
      /home/mleich/Server_bin/bb-10.2-marko_2_debug/bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0xdd1)[0x5607fc3a0cfc]
      /home/mleich/Server_bin/bb-10.2-marko_2_debug/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x10fe)[0x5607fc39e7b8]
      btr/btr0btr.cc:2995(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0x5607fc3c50ab]
      btr/btr0cur.cc:3414(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x5607fc3d07f1]
      row/row0ins.cc:2723(row_ins_clust_index_entry_low(unsigned long, unsigned long, dict_index_t*, unsigned long, dtuple_t*, unsigned long, que_thr_t*))[0x5607fc3beb24]
      row/row0ins.cc:3274(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x5607fc3bd5a1]
      row/row0ins.cc:3425(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x5607fc512317]
      row/row0ins.cc:3562(row_ins(ins_node_t*, que_thr_t*))[0x5607fc512082]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7fc67459c6db]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc67398688f]
       
      Query: INSERT INTO t3 (col1,col2, col_int, col_string, col_text) VALUES ....
      Connection ID (thread ID): 46
      Status: NOT_KILLED
       
      RQG branch:
      git clone https://github.com/mleich1/rqg --branch experimental RQG_mleich
       
      perl rqg.pl \                    
      --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
      --grammar=conf/mariadb/table_stress_innodb.yy \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --engine=Innodb \
      --reporters=Deadlock1,ErrorLog,Backtrace \
      --mysqld=--connect_timeout=60 \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--lock_wait_timeout=86400 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--wait_timeout=28800 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--loose-max-statement-time=30 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --mysqld=--log-output=none \
      --duration=300 \
      --seed=random \
      --sqltrace=MarkErrors \
      --threads=33 \
      --mysqld=--innodb_adaptive_hash_index=OFF \
      --mysqld=--innodb_page_size=8K \
      --mysqld=--innodb-buffer-pool-size=256M \
      --no_mask \
      --workdir=<local settings> \
       
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --basedir2=<local settings> \
      --script_debug=_nix_ \
      --rr=Server
      
      

      Attachments

        Issue Links

          Activity

            People

              mleich Matthias Leich
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.