Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.13
Description
origin/10.6 f169dfb41adcb637732507ed56d3038003170a15 2023-03-10T09:35:50+02:00
|
with a provisional patch for MDEV-29835 Partial server freeze compiled with RelWithDebInfo or without setting CMAKE_BUILD_TYPE.
|
|
[rr 1648082 36725]2023-03-17 10:51:48 0x96a74e80700[rr 1648082 36728] InnoDB: Assertion failure in file /data/Server/10.6-patched/storage/innobase/row/row0upd.cc line 2149
|
[rr 1648082 36730]InnoDB: Failing assertion: rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG)
|
|
(rr) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x00006c4a50654859 in __GI_abort () at abort.c:79
|
#2 0x00005577f41bf87e in ut_dbg_assertion_failed (expr=expr@entry=0x5577f4c6eb60 "rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG)",
|
file=file@entry=0x5577f4c6eae8 "/data/Server/10.6-patched/storage/innobase/row/row0upd.cc", line=line@entry=2149) at /data/Server/10.6-patched/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x00005577f41b6ed0 in row_upd_clust_rec_by_insert_inherit_func (rec=0xb2cfedbc1e8 "\200", entry=<optimized out>, update=<optimized out>) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2149
|
#4 0x00005577f482da96 in row_upd_clust_rec_by_insert (mtr=0x96a74e7e570, foreign=false, referenced=true, thr=0x34e05c01e550, index=0x34e05c01c6a8, node=0x34e05c01e190)
|
at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2263
|
#5 row_upd_clust_step (node=0x34e05c01e190, thr=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2682
|
#6 0x00005577f482eb06 in row_upd (thr=0x34e05c01e550, node=0x34e05c01e190) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2758
|
#7 row_upd_step (thr=thr@entry=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2900
|
#8 0x00005577f480e7c0 in row_update_for_mysql (prebuilt=0x34e05c01da78) at /data/Server/10.6-patched/storage/innobase/row/row0mysql.cc:1685
|
#9 0x00005577f477c16c in ha_innobase::update_row (this=0x34e05c0178e0, old_row=0x34e05c019428 "\376R", new_row=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/storage/innobase/handler/ha_innodb.cc:8657
|
#10 0x00005577f4507a09 in handler::ha_update_row (this=0x34e05c0178e0, old_data=0x34e05c019428 "\376R", new_data=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/sql/handler.cc:7674
|
#11 0x00005577f43a5428 in mysql_update (thd=thd@entry=0x34e05c000c58, table_list=<optimized out>, fields=..., values=..., conds=<optimized out>, order_num=<optimized out>, order=<optimized out>,
|
limit=18446744073709551615, ignore=<optimized out>, found_return=<optimized out>, updated_return=<optimized out>) at /data/Server/10.6-patched/sql/sql_update.cc:1087
|
#12 0x00005577f42e91aa in mysql_execute_command (thd=0x34e05c000c58, is_called_from_prepared_stmt=<optimized out>) at /data/Server/10.6-patched/sql/sql_limit.h:85
|
#13 0x00005577f42d8936 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x34e05c000c58) at /data/Server/10.6-patched/sql/sql_parse.cc:8021
|
#14 mysql_parse (thd=0x34e05c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/Server/10.6-patched/sql/sql_parse.cc:7943
|
#15 0x00005577f42e4a32 in dispatch_command (command=COM_QUERY, thd=0x34e05c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/Server/10.6-patched/sql/sql_class.h:1388
|
#16 0x00005577f42e684e in do_command (thd=0x34e05c000c58, blocking=blocking@entry=true) at /data/Server/10.6-patched/sql/sql_parse.cc:1409
|
#17 0x00005577f43e6447 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5577f7040618, put_in_cache=put_in_cache@entry=true) at /data/Server/10.6-patched/sql/sql_connect.cc:1416
|
#18 0x00005577f43e672d in handle_one_connection (arg=0x5577f7040618) at /data/Server/10.6-patched/sql/sql_connect.cc:1318
|
#19 0x000000006ffe3609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#20 0x00006c4a50751293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
(rr)
|
|
pluto:/data/results/1679050301/TBR-1807$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio
|
|
RQG
|
===
|
# git clone https://github.com/mleich1/rqg --branch <pick the right branch> RQG
|
#
|
# GIT_SHOW: HEAD -> master, origin/master, origin/HEAD ac05579ae482f23fbdf082d9c7972d66c3ed826c 2023-03-16T18:58:29+01:00
|
# rqg.pl : Version 4.2.1 (2022-12)
|
#
|
# $RQG_HOME/rqg.pl \
|
# --duration=300 \
|
# --queries=10000000 \
|
# --no_mask \
|
# --seed=random \
|
# --gendata_sql=conf/mariadb/table_stress.sql \
|
# --engine=InnoDB \
|
# --gendata=conf/mariadb/table_stress.zz \
|
# --rpl_mode=none \
|
# --max_gd_duration=1200 \
|
# --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
|
# --mysqld=--slave_net_timeout=60 \
|
# --mysqld=--innodb_file_per_table=0 \
|
# --mysqld=--net_read_timeout=30 \
|
# --mysqld=--loose_innodb_change_buffering=none \
|
# --mysqld=--log_bin_trust_function_creators=1 \
|
# --mysqld=--sync-binlog=1 \
|
# --mysqld=--log-output=none \
|
# --mysqld=--innodb-lock-wait-timeout=50 \
|
# --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
|
# --mysqld=--wait_timeout=28800 \
|
# --mysqld=--innodb_undo_log_truncate=OFF \
|
# --mysqld=--loose-table_lock_wait_timeout=50 \
|
# --mysqld=--loose-plugin-load-add=provider_lz4.so \
|
# --mysqld=--loose-max-statement-time=30 \
|
# --mysqld=--log-bin \
|
# --mysqld=--loose-idle_write_transaction_timeout=0 \
|
# --mysqld=--lock-wait-timeout=86400 \
|
# --mysqld=--loose-innodb_read_only_compressed=OFF \
|
# --mysqld=--interactive_timeout=28800 \
|
# --mysqld=--net_write_timeout=60 \
|
# --mysqld=--loose-idle_readonly_transaction_timeout=0 \
|
# --mysqld=--connect_timeout=60 \
|
# --mysqld=--innodb-buffer-pool-size=256M \
|
# --mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
|
# --mysqld=--plugin-load-add=file_key_management.so \
|
# --mysqld=--loose-innodb_compression_level=1 \
|
# --mysqld=--innodb_page_size=16K \
|
# --mysqld=--loose-idle_transaction_timeout=0 \
|
# --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
|
# --mysqld=--loose-innodb-sync-debug \
|
# --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \
|
# --reporters=Backtrace,Deadlock,None \
|
# --validators=None \
|
# --grammar=TBR-1807.yy \
|
# --threads=2 \
|
# --grammar=/data/results/1679050301/c00000.yy \
|
# --rr=Extended \
|
# --rr_options=--chaos --wait \
|
# <local settings>
|
Attachments
Issue Links
- is caused by
-
MDEV-29181 Potential corruption on Foreign key update on a table with vcol index
-
- Stalled
-
-
MDEV-30021 FK actions are ignored after tc_purge and COMMIT
-
- Stalled
-
- is duplicated by
-
MDEV-31441 BLOB corruption on UPDATE of PRIMARY KEY with FOREIGN KEY
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{noformat} origin/10.6 f169dfb41adcb637732507ed56d3038003170a15 2023-03-10T09:35:50+02:00 with a provisional patch for [rr 1648082 36725]2023-03-17 10:51:48 0x96a74e80700[rr 1648082 36728] InnoDB: Assertion failure in file /data/Server/10.6-patched/storage/innobase/row/row0upd.cc line 2149 [rr 1648082 36730]InnoDB: Failing assertion: rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG) (rr) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x00006c4a50654859 in __GI_abort () at abort.c:79 #2 0x00005577f41bf87e in ut_dbg_assertion_failed (expr=expr@entry=0x5577f4c6eb60 "rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG)", file=file@entry=0x5577f4c6eae8 "/data/Server/10.6-patched/storage/innobase/row/row0upd.cc", line=line@entry=2149) at /data/Server/10.6-patched/storage/innobase/ut/ut0dbg.cc:60 #3 0x00005577f41b6ed0 in row_upd_clust_rec_by_insert_inherit_func (rec=0xb2cfedbc1e8 "\200", entry=<optimized out>, update=<optimized out>) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2149 #4 0x00005577f482da96 in row_upd_clust_rec_by_insert (mtr=0x96a74e7e570, foreign=false, referenced=true, thr=0x34e05c01e550, index=0x34e05c01c6a8, node=0x34e05c01e190) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2263 #5 row_upd_clust_step (node=0x34e05c01e190, thr=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2682 #6 0x00005577f482eb06 in row_upd (thr=0x34e05c01e550, node=0x34e05c01e190) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2758 #7 row_upd_step (thr=thr@entry=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2900 #8 0x00005577f480e7c0 in row_update_for_mysql (prebuilt=0x34e05c01da78) at /data/Server/10.6-patched/storage/innobase/row/row0mysql.cc:1685 #9 0x00005577f477c16c in ha_innobase::update_row (this=0x34e05c0178e0, old_row=0x34e05c019428 "\376R", new_row=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/storage/innobase/handler/ha_innodb.cc:8657 #10 0x00005577f4507a09 in handler::ha_update_row (this=0x34e05c0178e0, old_data=0x34e05c019428 "\376R", new_data=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/sql/handler.cc:7674 #11 0x00005577f43a5428 in mysql_update (thd=thd@entry=0x34e05c000c58, table_list=<optimized out>, fields=..., values=..., conds=<optimized out>, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551615, ignore=<optimized out>, found_return=<optimized out>, updated_return=<optimized out>) at /data/Server/10.6-patched/sql/sql_update.cc:1087 #12 0x00005577f42e91aa in mysql_execute_command (thd=0x34e05c000c58, is_called_from_prepared_stmt=<optimized out>) at /data/Server/10.6-patched/sql/sql_limit.h:85 #13 0x00005577f42d8936 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x34e05c000c58) at /data/Server/10.6-patched/sql/sql_parse.cc:8021 #14 mysql_parse (thd=0x34e05c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/Server/10.6-patched/sql/sql_parse.cc:7943 #15 0x00005577f42e4a32 in dispatch_command (command=COM_QUERY, thd=0x34e05c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/Server/10.6-patched/sql/sql_class.h:1388 #16 0x00005577f42e684e in do_command (thd=0x34e05c000c58, blocking=blocking@entry=true) at /data/Server/10.6-patched/sql/sql_parse.cc:1409 #17 0x00005577f43e6447 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5577f7040618, put_in_cache=put_in_cache@entry=true) at /data/Server/10.6-patched/sql/sql_connect.cc:1416 #18 0x00005577f43e672d in handle_one_connection (arg=0x5577f7040618) at /data/Server/10.6-patched/sql/sql_connect.cc:1318 #19 0x000000006ffe3609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #20 0x00006c4a50751293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 (rr) pluto:/data/results/1679050301/TBR-1807$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio RQG === # git clone https://github.com/mleich1/rqg --branch <pick the right branch> RQG # # GIT_SHOW: HEAD -> master, origin/master, origin/HEAD ac05579ae482f23fbdf082d9c7972d66c3ed826c 2023-03-16T18:58:29+01:00 # rqg.pl : Version 4.2.1 (2022-12) # # $RQG_HOME/rqg.pl \ # --duration=300 \ # --queries=10000000 \ # --no_mask \ # --seed=random \ # --gendata_sql=conf/mariadb/table_stress.sql \ # --engine=InnoDB \ # --gendata=conf/mariadb/table_stress.zz \ # --rpl_mode=none \ # --max_gd_duration=1200 \ # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # --mysqld=--slave_net_timeout=60 \ # --mysqld=--innodb_file_per_table=0 \ # --mysqld=--net_read_timeout=30 \ # --mysqld=--loose_innodb_change_buffering=none \ # --mysqld=--log_bin_trust_function_creators=1 \ # --mysqld=--sync-binlog=1 \ # --mysqld=--log-output=none \ # --mysqld=--innodb-lock-wait-timeout=50 \ # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \ # --mysqld=--wait_timeout=28800 \ # --mysqld=--innodb_undo_log_truncate=OFF \ # --mysqld=--loose-table_lock_wait_timeout=50 \ # --mysqld=--loose-plugin-load-add=provider_lz4.so \ # --mysqld=--loose-max-statement-time=30 \ # --mysqld=--log-bin \ # --mysqld=--loose-idle_write_transaction_timeout=0 \ # --mysqld=--lock-wait-timeout=86400 \ # --mysqld=--loose-innodb_read_only_compressed=OFF \ # --mysqld=--interactive_timeout=28800 \ # --mysqld=--net_write_timeout=60 \ # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # --mysqld=--connect_timeout=60 \ # --mysqld=--innodb-buffer-pool-size=256M \ # --mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \ # --mysqld=--plugin-load-add=file_key_management.so \ # --mysqld=--loose-innodb_compression_level=1 \ # --mysqld=--innodb_page_size=16K \ # --mysqld=--loose-idle_transaction_timeout=0 \ # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # --mysqld=--loose-innodb-sync-debug \ # --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \ # --reporters=Backtrace,Deadlock,None \ # --validators=None \ # --grammar=TBR-1807.yy \ # --threads=2 \ # --grammar=/data/results/1679050301/c00000.yy \ # --rr=Extended \ # --rr_options=--chaos --wait \ # <local settings> {noformat} |
{noformat}
origin/10.6 f169dfb41adcb637732507ed56d3038003170a15 2023-03-10T09:35:50+02:00 with a provisional patch for [rr 1648082 36725]2023-03-17 10:51:48 0x96a74e80700[rr 1648082 36728] InnoDB: Assertion failure in file /data/Server/10.6-patched/storage/innobase/row/row0upd.cc line 2149 [rr 1648082 36730]InnoDB: Failing assertion: rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG) (rr) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x00006c4a50654859 in __GI_abort () at abort.c:79 #2 0x00005577f41bf87e in ut_dbg_assertion_failed (expr=expr@entry=0x5577f4c6eb60 "rec == NULL || !(data[BTR_EXTERN_LEN] & BTR_EXTERN_OWNER_FLAG)", file=file@entry=0x5577f4c6eae8 "/data/Server/10.6-patched/storage/innobase/row/row0upd.cc", line=line@entry=2149) at /data/Server/10.6-patched/storage/innobase/ut/ut0dbg.cc:60 #3 0x00005577f41b6ed0 in row_upd_clust_rec_by_insert_inherit_func (rec=0xb2cfedbc1e8 "\200", entry=<optimized out>, update=<optimized out>) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2149 #4 0x00005577f482da96 in row_upd_clust_rec_by_insert (mtr=0x96a74e7e570, foreign=false, referenced=true, thr=0x34e05c01e550, index=0x34e05c01c6a8, node=0x34e05c01e190) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2263 #5 row_upd_clust_step (node=0x34e05c01e190, thr=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2682 #6 0x00005577f482eb06 in row_upd (thr=0x34e05c01e550, node=0x34e05c01e190) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2758 #7 row_upd_step (thr=thr@entry=0x34e05c01e550) at /data/Server/10.6-patched/storage/innobase/row/row0upd.cc:2900 #8 0x00005577f480e7c0 in row_update_for_mysql (prebuilt=0x34e05c01da78) at /data/Server/10.6-patched/storage/innobase/row/row0mysql.cc:1685 #9 0x00005577f477c16c in ha_innobase::update_row (this=0x34e05c0178e0, old_row=0x34e05c019428 "\376R", new_row=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/storage/innobase/handler/ha_innodb.cc:8657 #10 0x00005577f4507a09 in handler::ha_update_row (this=0x34e05c0178e0, old_data=0x34e05c019428 "\376R", new_data=0x34e05c019418 "\376\001") at /data/Server/10.6-patched/sql/handler.cc:7674 #11 0x00005577f43a5428 in mysql_update (thd=thd@entry=0x34e05c000c58, table_list=<optimized out>, fields=..., values=..., conds=<optimized out>, order_num=<optimized out>, order=<optimized out>, limit=18446744073709551615, ignore=<optimized out>, found_return=<optimized out>, updated_return=<optimized out>) at /data/Server/10.6-patched/sql/sql_update.cc:1087 #12 0x00005577f42e91aa in mysql_execute_command (thd=0x34e05c000c58, is_called_from_prepared_stmt=<optimized out>) at /data/Server/10.6-patched/sql/sql_limit.h:85 #13 0x00005577f42d8936 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x34e05c000c58) at /data/Server/10.6-patched/sql/sql_parse.cc:8021 #14 mysql_parse (thd=0x34e05c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/Server/10.6-patched/sql/sql_parse.cc:7943 #15 0x00005577f42e4a32 in dispatch_command (command=COM_QUERY, thd=0x34e05c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/Server/10.6-patched/sql/sql_class.h:1388 #16 0x00005577f42e684e in do_command (thd=0x34e05c000c58, blocking=blocking@entry=true) at /data/Server/10.6-patched/sql/sql_parse.cc:1409 #17 0x00005577f43e6447 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5577f7040618, put_in_cache=put_in_cache@entry=true) at /data/Server/10.6-patched/sql/sql_connect.cc:1416 #18 0x00005577f43e672d in handle_one_connection (arg=0x5577f7040618) at /data/Server/10.6-patched/sql/sql_connect.cc:1318 #19 0x000000006ffe3609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #20 0x00006c4a50751293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 (rr) pluto:/data/results/1679050301/TBR-1807$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio RQG === # git clone https://github.com/mleich1/rqg --branch <pick the right branch> RQG # # GIT_SHOW: HEAD -> master, origin/master, origin/HEAD ac05579ae482f23fbdf082d9c7972d66c3ed826c 2023-03-16T18:58:29+01:00 # rqg.pl : Version 4.2.1 (2022-12) # # $RQG_HOME/rqg.pl \ # --duration=300 \ # --queries=10000000 \ # --no_mask \ # --seed=random \ # --gendata_sql=conf/mariadb/table_stress.sql \ # --engine=InnoDB \ # --gendata=conf/mariadb/table_stress.zz \ # --rpl_mode=none \ # --max_gd_duration=1200 \ # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \ # --mysqld=--slave_net_timeout=60 \ # --mysqld=--innodb_file_per_table=0 \ # --mysqld=--net_read_timeout=30 \ # --mysqld=--loose_innodb_change_buffering=none \ # --mysqld=--log_bin_trust_function_creators=1 \ # --mysqld=--sync-binlog=1 \ # --mysqld=--log-output=none \ # --mysqld=--innodb-lock-wait-timeout=50 \ # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \ # --mysqld=--wait_timeout=28800 \ # --mysqld=--innodb_undo_log_truncate=OFF \ # --mysqld=--loose-table_lock_wait_timeout=50 \ # --mysqld=--loose-plugin-load-add=provider_lz4.so \ # --mysqld=--loose-max-statement-time=30 \ # --mysqld=--log-bin \ # --mysqld=--loose-idle_write_transaction_timeout=0 \ # --mysqld=--lock-wait-timeout=86400 \ # --mysqld=--loose-innodb_read_only_compressed=OFF \ # --mysqld=--interactive_timeout=28800 \ # --mysqld=--net_write_timeout=60 \ # --mysqld=--loose-idle_readonly_transaction_timeout=0 \ # --mysqld=--connect_timeout=60 \ # --mysqld=--innodb-buffer-pool-size=256M \ # --mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \ # --mysqld=--plugin-load-add=file_key_management.so \ # --mysqld=--loose-innodb_compression_level=1 \ # --mysqld=--innodb_page_size=16K \ # --mysqld=--loose-idle_transaction_timeout=0 \ # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \ # --mysqld=--loose-innodb-sync-debug \ # --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \ # --reporters=Backtrace,Deadlock,None \ # --validators=None \ # --grammar=TBR-1807.yy \ # --threads=2 \ # --grammar=/data/results/1679050301/c00000.yy \ # --rr=Extended \ # --rr_options=--chaos --wait \ # <local settings> {noformat} |
Link | This issue blocks MDEV-29181 [ MDEV-29181 ] |
Priority | Major [ 3 ] | Critical [ 2 ] |
Link |
This issue blocks |
Link | This issue is caused by MDEV-30021 [ MDEV-30021 ] |
Link |
This issue is duplicated by |
Link |
This issue blocks |
Assignee | Nikita Malyavin [ nikitamalyavin ] | Marko Mäkelä [ marko ] |
Assignee | Marko Mäkelä [ marko ] | Nikita Malyavin [ nikitamalyavin ] |
Assignee | Nikita Malyavin [ nikitamalyavin ] | Matthias Leich [ mleich ] |
Assignee | Matthias Leich [ mleich ] | Nikita Malyavin [ nikitamalyavin ] |
Priority | Critical [ 2 ] | Major [ 3 ] |
Labels | rr-profile | foreign-keys rr-profile |
Link | This issue is caused by MDEV-29181 [ MDEV-29181 ] |
Link | This issue blocks MDEV-29181 [ MDEV-29181 ] |
./RR_REPLAY_SIMP.sh TBR-1807.cfg <path to your MariaDB install>
The shellscript stops if 10 rr traces are achieved.
./util/SUMMARY.sh gives an overview about the size of the remains of the test runs.
Just pick the smallest. Maybe "rr replay" based on it is faster.
The same test harvests on some
bb-10.6-pkgtest + cherrypicked commit 718a3512ec19ae9dc98699fbbd24aa71cab4ca7d (HEAD)
MDEV-30021 FK actions are ignored after tc_purge and COMMIT
[rr 1859521 44301]mysqld: /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2132: bool row_upd_clust_rec_by_insert_inherit_func(const rec_t*, dict_index_t*, const rec_offs*, dtuple_t*, const upd_t*): Assertion `!(rec_data[12U] & 128U)' failed.
(rr) bt
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x00002603153f3859 in __GI_abort () at abort.c:79
#2 0x00002603153f3729 in __assert_fail_base (fmt=0x260315589588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55d566218540 "!(rec_data[12U] & 128U)",
file=0x55d56621c960 "/data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc", line=2132, function=<optimized out>) at assert.c:92
#3 0x0000260315404f36 in __GI___assert_fail (assertion=assertion@entry=0x55d566218540 "!(rec_data[12U] & 128U)",
file=file@entry=0x55d56621c960 "/data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc", line=line@entry=2132,
function=function@entry=0x55d566218100 "bool row_upd_clust_rec_by_insert_inherit_func(const rec_t*, dict_index_t*, const rec_offs*, dtuple_t*, const upd_t*)") at assert.c:101
#4 0x000055d5652adc0c in row_upd_clust_rec_by_insert_inherit_func (rec=rec@entry=0x15c164664107 "\200", index=index@entry=0x616001c57008, offsets=offsets@entry=0x7f3133148a40, entry=entry@entry=0x61900047d208,
update=0x620000129a98) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2132
#5 0x000055d5652bf906 in row_upd_clust_rec_by_insert (node=node@entry=0x620000129888, index=index@entry=0x616001c57008, thr=thr@entry=0x620000129c78, referenced=referenced@entry=true, foreign=foreign@entry=false,
mtr=mtr@entry=0x7f3133149130) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2263
#6 0x000055d5652c40b0 in row_upd_clust_step (node=node@entry=0x620000129888, thr=thr@entry=0x620000129c78) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2682
#7 0x000055d5652c48a1 in row_upd (node=node@entry=0x620000129888, thr=thr@entry=0x620000129c78) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2758
#8 0x000055d5652c54d9 in row_upd_step (thr=thr@entry=0x620000129c78) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0upd.cc:2900
#9 0x000055d5651f51f0 in row_update_for_mysql (prebuilt=0x620000129108) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/row/row0mysql.cc:1693
#10 0x000055d564e1760b in ha_innobase::update_row (this=0x61d0007e04b8, old_row=<optimized out>, new_row=<optimized out>) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/storage/innobase/handler/ha_innodb.cc:8657
#11 0x000055d56444fd6e in handler::ha_update_row (this=0x61d0007e04b8, old_data=0x6190004772d8 "\376{\001", new_data=0x6190004772c8 "\376\001") at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/handler.cc:7674
#12 0x000055d563edcb25 in mysql_update (thd=thd@entry=0x62b0000bd218, table_list=<optimized out>, fields=..., values=..., conds=<optimized out>, order_num=<optimized out>, order=<optimized out>,
limit=18446744073709551615, ignore=<optimized out>, found_return=<optimized out>, updated_return=<optimized out>) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_update.cc:1087
#13 0x000055d563bb423c in mysql_execute_command (thd=thd@entry=0x62b0000bd218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_limit.h:85
#14 0x000055d563b75788 in mysql_parse (thd=thd@entry=0x62b0000bd218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f313314b130)
at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_parse.cc:8021
#15 0x000055d563ba4035 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b0000bd218, packet=packet@entry=0x629000bd6219 "UPDATE test.t_p SET col1 = 1 /* E_R Thread1 QNO 47 CON_ID 16 */ ",
packet_length=packet_length@entry=64, blocking=blocking@entry=true) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_class.h:1385
#16 0x000055d563baad1c in do_command (thd=0x62b0000bd218, blocking=blocking@entry=true) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_parse.cc:1409
#17 0x000055d563fe33e7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002ab8, put_in_cache=put_in_cache@entry=true) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_connect.cc:1416
#18 0x000055d563fe3f30 in handle_one_connection (arg=0x608000002ab8) at /data/Server/bb-10.6-pkgtest-MDEV-29835-FK/sql/sql_connect.cc:1318
#19 0x000010d206d74609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#20 0x00002603154f0293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
(rr)
pluto:/data/results/1679056336/TBR-1808$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio