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

Assertion `!table->id' failed in btr_search_lazy_free

    XMLWordPrintable

Details

    Description

      origin/10.2 d09426f9e60fd93296464ec9eb5f9d85566437d3 2021-09-10T19:15:41+03:00
       
      # 2021-09-10T15:05:26 [580588] | mysqld: /data/Server/10.2/storage/innobase/btr/btr0sea.cc:266: void btr_search_lazy_free(dict_index_t*): Assertion `!table->id' failed.
      ...
      # 2021-09-10T15:05:26 [580588] Thread 1 (Thread 0x7f05b4f83700 (LWP 585128)):
      # 2021-09-10T15:05:26 [580588] #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      # 2021-09-10T15:05:26 [580588] #1  0x0000563c36b2a2db in my_write_core (sig=6) at /data/Server/10.2/mysys/stacktrace.c:382
      # 2021-09-10T15:05:26 [580588] #2  0x0000563c35a7892b in handle_fatal_signal (sig=6) at /data/Server/10.2/sql/signal_handler.cc:355
      # 2021-09-10T15:05:26 [580588] #3  <signal handler called>
      # 2021-09-10T15:05:26 [580588] #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      # 2021-09-10T15:05:26 [580588] #5  0x00007f05c9d70859 in __GI_abort () at abort.c:79
      # 2021-09-10T15:05:26 [580588] #6  0x00007f05c9d70729 in __assert_fail_base (fmt=0x7f05c9f06588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x563c372569e0 "!table->id", file=0x563c37256820 "/data/Server/10.2/storage/innobase/btr/btr0sea.cc", line=266, function=<optimized out>) at assert.c:92
      # 2021-09-10T15:05:26 [580588] #7  0x00007f05c9d81f36 in __GI___assert_fail (assertion=0x563c372569e0 "!table->id", file=0x563c37256820 "/data/Server/10.2/storage/innobase/btr/btr0sea.cc", line=266, function=0x563c37256940 "void btr_search_lazy_free(dict_index_t*)") at assert.c:101
      # 2021-09-10T15:05:26 [580588] #8  0x0000563c3641d324 in btr_search_lazy_free (index=0x618000170508) at /data/Server/10.2/storage/innobase/btr/btr0sea.cc:266
      # 2021-09-10T15:05:26 [580588] #9  0x0000563c36422631 in btr_search_drop_page_hash_index (block=0x7f05bc396e00) at /data/Server/10.2/storage/innobase/btr/btr0sea.cc:1279
      # 2021-09-10T15:05:26 [580588] #10 0x0000563c3649ebdf in buf_LRU_free_page (bpage=0x7f05bc396e00, zip=true) at /data/Server/10.2/storage/innobase/buf/buf0lru.cc:1615
      # 2021-09-10T15:05:26 [580588] #11 0x0000563c364865d4 in buf_flush_LRU_list_batch (buf_pool=0x61b000001580, max=375, n=0x7f05b4f824f0) at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:1656
      # 2021-09-10T15:05:26 [580588] #12 0x0000563c36486d4e in buf_do_LRU_batch (buf_pool=0x61b000001580, max=375, n=0x7f05b4f824f0) at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:1727
      # 2021-09-10T15:05:26 [580588] #13 0x0000563c36487b10 in buf_flush_batch (buf_pool=0x61b000001580, flush_type=BUF_FLUSH_LRU, min_n=375, lsn_limit=0, n=0x7f05b4f824f0) at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:1855
      # 2021-09-10T15:05:26 [580588] #14 0x0000563c364887fa in buf_flush_do_batch (buf_pool=0x61b000001580, type=BUF_FLUSH_LRU, min_n=375, lsn_limit=0, n=0x7f05b4f824f0) at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:2028
      # 2021-09-10T15:05:26 [580588] #15 0x0000563c36489b42 in buf_flush_LRU_list (buf_pool=0x61b000001580) at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:2299
      # 2021-09-10T15:05:26 [580588] #16 0x0000563c3648de64 in pc_flush_slot () at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:2820
      # 2021-09-10T15:05:26 [580588] #17 0x0000563c364905d8 in buf_flush_page_cleaner_coordinator () at /data/Server/10.2/storage/innobase/buf/buf0flu.cc:3256
      # 2021-09-10T15:05:26 [580588] #18 0x00007f05ca294609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      # 2021-09-10T15:05:26 [580588] #19 0x00007f05c9e6d293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
       
      RQG
      ====
      # git clone https://github.com/mleich1/rqg --branch experimental RQG
      #
      # GIT_SHOW: HEAD -> experimental, origin/experimental 342ad0f5b93055a0c1fdd93c9b8a250113599fc2 2021-09-10T15:06:41+02:00
      # rqg.pl  : Version 3.4 (2021-09)
      #
      # $RQG_HOME/rqg.pl \
      # --grammar=conf/mariadb/partitions_innodb.yy \
      # --gendata-advanced \
      # --skip-gendata \
      # --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
      # --mysqld=--loose-idle_write_transaction_timeout=0 \
      # --mysqld=--loose-idle_transaction_timeout=0 \
      # --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      # --mysqld=--connect_timeout=60 \
      # --mysqld=--interactive_timeout=28800 \
      # --mysqld=--slave_net_timeout=60 \
      # --mysqld=--net_read_timeout=30 \
      # --mysqld=--net_write_timeout=60 \
      # --mysqld=--loose-table_lock_wait_timeout=50 \
      # --mysqld=--wait_timeout=28800 \
      # --mysqld=--lock-wait-timeout=86400 \
      # --mysqld=--innodb-lock-wait-timeout=50 \
      # --no-mask \
      # --queries=10000000 \
      # --seed=random \
      # --reporters=Backtrace \
      # --reporters=ErrorLog \
      # --reporters=Deadlock1 \
      # --validators=None \
      # --mysqld=--log_output=none \
      # --mysqld=--log_bin_trust_function_creators=1 \
      # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      # --engine=InnoDB \
      # --restart_timeout=240 \
      # --mysqld=--plugin-load-add=file_key_management.so \
      # --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
      # --duration=300 \
      # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      # --mysqld=--innodb_stats_persistent=on \
      # --mysqld=--innodb_adaptive_hash_index=on \
      # --mysqld=--log-bin \
      # --mysqld=--sync-binlog=1 \
      # --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
      # --mysqld=--loose-max-statement-time=30 \
      # --threads=33 \
      # --mysqld=--innodb_use_native_aio=1 \
      # --mysqld=--innodb_page_size=64K \
      # --mysqld=--innodb-buffer-pool-size=24M \
      # --no_mask \
      # --workdir=<local settings> \
      # --vardir=<local settings> \
      # --mtr-build-thread=<local settings> \
      # --basedir1=<local settings> \
      # --script_debug=_nix_
      

      Attachments

        1. rqg.log
          687 kB
          Matthias Leich

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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