Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.41
-
None
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
Issue Links
- relates to
-
MDEV-22456 Dropping the adaptive hash index may cause DDL to lock up InnoDB
- Closed