Assertion `!table->id' failed in btr_search_lazy_free

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_