mysqld: storage/innobase/buf/buf0flu.cc:786: void buf_flush_init_for_writing(const buf_block_t*, byte*, void*, lsn_t, bool): Assertion `!newest_lsn || fil_page_get_type(page)' failed.

Assert hit during RQG testing

mysqld: storage/innobase/buf/buf0flu.cc:786: void buf_flush_init_for_writing(const buf_block_t*, byte*, void*, lsn_t, bool): Assertion `!newest_lsn || fil_page_get_type(page)' failed.

[ERROR] mysqld got signal 6 ;

(rr) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51

#1  0x00007ff322a288b1 in __GI_abort () at abort.c:79

#2  0x00007ff322a1842a in __assert_fail_base (fmt=0x7ff322b9fa38 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x562dae4e99e0 "!newest_lsn || fil_page_get_type(page)", 

    file=file@entry=0x562dae4e9898 "/home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc", line=line@entry=786, 

    function=function@entry=0x562dae4ebac0 <buf_flush_init_for_writing(buf_block_t const*, unsigned char*, void*, unsigned long, bool)::__PRETTY_FUNCTION__> "void buf_flush_init_for_writing(const buf_block_t*, byte*, void*, lsn_t, bool)") at assert.c:92

#3  0x00007ff322a184a2 in __GI___assert_fail (assertion=assertion@entry=0x562dae4e99e0 "!newest_lsn || fil_page_get_type(page)", file=file@entry=0x562dae4e9898 "/home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc", line=line@entry=786, 

    function=function@entry=0x562dae4ebac0 <buf_flush_init_for_writing(buf_block_t const*, unsigned char*, void*, unsigned long, bool)::__PRETTY_FUNCTION__> "void buf_flush_init_for_writing(const buf_block_t*, byte*, void*, lsn_t, bool)")

    at assert.c:101

#4  0x0000562dade0a493 in buf_flush_init_for_writing (block=block@entry=0x7ff323a877c0, page=0x7ff323bd8000 "", page_zip_=0x0, newest_lsn=900817, use_full_checksum=<optimized out>) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:786

#5  0x0000562dade0dbf0 in buf_flush_write_block_low (bpage=bpage@entry=0x7ff323a877c0, flush_type=flush_type@entry=BUF_FLUSH_LIST, sync=sync@entry=false) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1019

#6  0x0000562dade10ace in buf_flush_page (buf_pool=buf_pool@entry=0x562db0ac68d0, bpage=bpage@entry=0x7ff323a877c0, flush_type=flush_type@entry=BUF_FLUSH_LIST, sync=sync@entry=false) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1197

#7  0x0000562dade12877 in buf_flush_try_neighbors (page_id=page_id@entry=..., flush_type=flush_type@entry=BUF_FLUSH_LIST, n_flushed=4, n_to_flush=n_to_flush@entry=8) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1423

#8  0x0000562dade12b2b in buf_flush_page_and_try_neighbors (bpage=bpage@entry=0x7ff323a877c0, flush_type=flush_type@entry=BUF_FLUSH_LIST, n_to_flush=n_to_flush@entry=8, count=count@entry=0x7ff303bfea38)

    at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1497

#9  0x0000562dade12ddf in buf_do_flush_list_batch (buf_pool=buf_pool@entry=0x562db0ac68d0, min_n=min_n@entry=8, lsn_limit=lsn_limit@entry=18446744073709551615) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1756

#10 0x0000562dade13a09 in buf_flush_batch (buf_pool=buf_pool@entry=0x562db0ac68d0, flush_type=flush_type@entry=BUF_FLUSH_LIST, min_n=min_n@entry=8, lsn_limit=lsn_limit@entry=18446744073709551615, n=n@entry=0x7ff303bfeca0)

    at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1826

#11 0x0000562dade13d44 in buf_flush_do_batch (buf_pool=buf_pool@entry=0x562db0ac68d0, type=type@entry=BUF_FLUSH_LIST, min_n=8, lsn_limit=18446744073709551615, n=n@entry=0x7ff303bfeca0) at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:1984

#12 0x0000562dade1442a in pc_flush_slot () at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:2783

#13 0x0000562dade159e3 in buf_flush_page_cleaner_coordinator () at /home/mleich/bb-10.4-thiru/storage/innobase/buf/buf0flu.cc:3196

#14 0x00007ff322de06db in start_thread (arg=0x7ff303bff700) at pthread_create.c:463

#15 0x00007ff322b09a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

(rr)

origin/bb-10.4-thiru a13662dac1df224c607983815b2fe85ee72749c2 2020-07-17T22:49:03+05:30

RQG

git clone https://github.com/mleich1/rqg --branch experimental RQG

origin/experimental f3d72ce51b150ee1f52a93d18f2024af293d925e 2020-07-13T20:46:53+02:00

perl rqg.pl \                        

--grammar=conf/mariadb/table_stress_innodb_nocopy.yy \

--gendata=conf/mariadb/table_stress.zz \

--gendata_sql=conf/mariadb/table_stress.sql \

--mysqld=--innodb_use_native_aio=0 \

--mysqld=--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 \

--reporters=CrashRecovery1 \

--validators=None \

--mysqld=--log_output=none \

--mysqld=--log-bin \

--mysqld=--log_bin_trust_function_creators=1 \

--mysqld=--loose-max-statement-time=30 \

--mysqld=--loose-debug_assert_on_not_freed_memory=0 \

--engine=InnoDB \

--restart_timeout=120 \

--duration=300 \

--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \

--threads=9 \

--mysqld=--innodb_page_size=4K \

--mysqld=--innodb-buffer-pool-size=5M \

--duration=300 \

--no_mask \

--workdir=<local settings> \

--vardir=<local settings> \

--mtr-build-thread=<local settings> \

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Server \

--rr_options=--chaos