SEGV in my_atomic_loadlint storage/innobase/include/sync0types.h:1131

Thread 3 received signal SIGSEGV, Segmentation fault.

[Switching to Thread 1968947.1970639]

0x000055ed4289732f in my_atomic_loadlint (A=0x2d8b3ed5dca0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0types.h:1131

1131      return ulint(my_atomic_loadlong(A));

(rr) bt

#0  0x000055ed4289732f in my_atomic_loadlint (A=0x2d8b3ed5dca0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0types.h:1131

#1  MutexDebug<TTASEventMutex<BlockMutexPolicy> >::is_owned (this=0x2d8b3ed5dc68) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0policy.h:200

#2  PolicyMutex<TTASEventMutex<BlockMutexPolicy> >::is_owned (this=0x2d8b3ed5dc58) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/ib0mutex.h:639

#3  buf_flush_or_remove_page (buf_pool=buf_pool@entry=0x61b000001580, bpage=<optimized out>, flush=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0lru.cc:387

#4  0x000055ed4289adb2 in buf_flush_or_remove_pages (buf_pool=buf_pool@entry=0x61b000001580, id=id@entry=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/buf0flu.h:355

#5  0x000055ed4289b4de in buf_flush_dirty_pages (buf_pool=0x61b000001580, id=id@entry=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0lru.cc:529

#6  0x000055ed4289bcc6 in buf_LRU_flush_or_remove_pages (id=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/buf0buf.ic:1097

#7  0x000055ed42879b89 in FlushObserver::flush (this=this@entry=0x6040000899d0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0flu.cc:3802

#8  0x000055ed4246d0f2 in row_merge_build_indexes (trx=<optimized out>, old_table=<optimized out>, new_table=new_table@entry=0x618000104908, online=<optimized out>, indexes=0x61d000384b58, key_numbers=<optimized out>, n_indexes=<optimized out>, 

    table=<optimized out>, defaults=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=..., skip_pk_sort=<optimized out>, stage=<optimized out>, add_v=<optimized out>, eval_table=<optimized out>, 

    allow_not_null=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/row/row0merge.cc:5044

#9  0x000055ed42161605 in ha_innobase::inplace_alter_table (this=0x61c00032b0a8, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/handler/handler0alter.cc:7154

#10 0x000055ed414455ea in handler::ha_inplace_alter_table (ha_alter_info=0x73fb0c09d920, altered_table=0x61f0003a3e88, this=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/handler.h:4207

#11 mysql_inplace_alter_table (thd=thd@entry=0x62a00024c208, table_list=<optimized out>, table=table@entry=0x61f0003a2288, altered_table=altered_table@entry=0x61f0003a3e88, ha_alter_info=ha_alter_info@entry=0x73fb0c09d920, 

    inplace_supported=inplace_supported@entry=HA_ALTER_INPLACE_COPY_LOCK, target_mdl_request=<optimized out>, alter_ctx=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_table.cc:7654

#12 0x000055ed41468297 in mysql_alter_table (thd=thd@entry=0x62a00024c208, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x73fb0c09f460, table_list=table_list@entry=0x62b00013b3f8, 

    alter_info=alter_info@entry=0x73fb0c09f360, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_table.cc:9946

#13 0x000055ed415ddeee in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_alter.cc:512

#14 0x000055ed411f1944 in mysql_execute_command (thd=thd@entry=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:6022

#15 0x000055ed411f617f in mysql_parse (thd=thd@entry=0x62a00024c208, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x73fb0c0a1f40, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)

    at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:7810

#16 0x000055ed411fd8bf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62a00024c208, 

    packet=packet@entry=0x629000a8c209 " ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */ ", packet_length=packet_length@entry=123, is_com_multi=is_com_multi@entry=false, 

    is_next_command=is_next_command@entry=false) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_class.h:1134

#17 0x000055ed412071d6 in do_command (thd=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:1393

#18 0x000055ed415d09d0 in do_handle_one_connection (connect=connect@entry=0x608000001328) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1403

#19 0x000055ed415d10de in handle_one_connection (arg=0x608000001328) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1308

#20 0x00007fff8d9bd609 in start_thread (arg=<optimized out>) at pthread_create.c:477

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

(rr)

Query (0x62b00013b228): ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */

# 2020-10-15T12:52:08 [1967283] | [rr 1968947 779414]

# 2020-10-15T12:52:08 [1967283] | Connection ID (thread ID): 66

# 2020-10-15T12:52:08 [1967283] | [rr 1968947 779416]Status: KILL_TIMEOUT[rr 1968947 764251]201015 12:43:46 [rr 1968947 764254][ERROR] mysqld got signal 11 ;

...

Query (0x62b00013b228): ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */

Connection ID (thread ID): 66

Status: KILL_TIMEOUT    <== Maybe important

origin/bb-10.3-MDEV-23072 8ebfe9811e805a9b508199bc0224a82f7fa69eb3 2020-10-15T13:26:18+05:30  compiled with debug + ASAN + Og

RQG

====

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

    origin/experimental e95247cfe20eb07f11c81bfa551e45571dd3637d 

perl rqg.pl \

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

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

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

--mysqld=--innodb_use_native_aio=1 \

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

--validators=None \

--mysqld=--log_output=none \

--mysqld=--log-bin \

--mysqld=--log_bin_trust_function_creators=1 \

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

--engine=InnoDB \

--restart_timeout=120 \

--duration=400 \

--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=400 \

--mysqld=--innodb_stats_persistent=on \

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

--threads=33 \

--mysqld=--innodb_page_size=64K \

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

--duration=400 \

--no_mask \

--workdir=<local settings> \

--vardir=<local settings> \

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

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Server \

--rr_options=--chaos

I hit this SEGV once on > 2500 RQG tests.