[MDEV-18581] [Draft] Assertion `index->table == node->table' failed in row_purge_remove_sec_if_poss_leaf Created: 2019-02-14  Updated: 2023-06-18  Resolved: 2023-06-18

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

Filed just for the record for now.
Likely to be related to other open issues in row_purge_remove_sec_if_poss_leaf.
I probably have a coredump stored, but it will take some effort to set it up with all the libraries and environment, with the effect far from guaranteed; so I don't think it's worth the trouble at the moment, there are enough bugs to fix.

https://travis-ci.org/elenst/travis-tests/jobs/490163289 [2701 13 2]

10.4 f4f8dd6

mysqld: /home/travis/src/storage/innobase/row/row0purge.cc:544: bool row_purge_remove_sec_if_poss_leaf(purge_node_t*, dict_index_t*, const dtuple_t*): Assertion `index->table == node->table' failed.
190208  4:18:42 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f25dfe1fc82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x0000558037b5d0eb in row_purge_remove_sec_if_poss_leaf (node=0x55803b8d1aa0, index=0x7f25a015c158, entry=0x7f25a016f718) at /home/travis/src/storage/innobase/row/row0purge.cc:544
#9  0x0000558037b5d870 in row_purge_remove_sec_if_poss (node=0x55803b8d1aa0, index=0x7f25a015c158, entry=0x7f25a016f718) at /home/travis/src/storage/innobase/row/row0purge.cc:720
#10 0x0000558037b5e547 in row_purge_upd_exist_or_extern_func (thr=0x55803b8d19e8, node=0x55803b8d1aa0, undo_rec=0x7f25a008ea58 "\001\227\f\017c") at /home/travis/src/storage/innobase/row/row0purge.cc:922
#11 0x0000558037b5f255 in row_purge_record_func (node=0x55803b8d1aa0, undo_rec=0x7f25a008ea58 "\001\227\f\017c", thr=0x55803b8d19e8, updated_extern=false) at /home/travis/src/storage/innobase/row/row0purge.cc:1217
#12 0x0000558037b5f417 in row_purge (node=0x55803b8d1aa0, undo_rec=0x7f25a008ea58 "\001\227\f\017c", thr=0x55803b8d19e8) at /home/travis/src/storage/innobase/row/row0purge.cc:1261
#13 0x0000558037b5f7aa in row_purge_step (thr=0x55803b8d19e8) at /home/travis/src/storage/innobase/row/row0purge.cc:1347
#14 0x0000558037ae0364 in que_thr_step (thr=0x55803b8d19e8) at /home/travis/src/storage/innobase/que/que0que.cc:1042
#15 0x0000558037ae0597 in que_run_threads_low (thr=0x55803b8d19e8) at /home/travis/src/storage/innobase/que/que0que.cc:1104
#16 0x0000558037ae0788 in que_run_threads (thr=0x55803b8d19e8) at /home/travis/src/storage/innobase/que/que0que.cc:1144
#17 0x0000558037bcb250 in trx_purge (n_purge_threads=4, truncate=false) at /home/travis/src/storage/innobase/trx/trx0purge.cc:1325
#18 0x0000558037b9f897 in srv_do_purge (n_total_purged=0x7f25ae7fbed8) at /home/travis/src/storage/innobase/srv/srv0srv.cc:2577
#19 0x0000558037b9fcce in srv_purge_coordinator_thread (arg=0x0) at /home/travis/src/storage/innobase/srv/srv0srv.cc:2700
#20 0x00007f25e0c686ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#21 0x00007f25dfef941d in clone () from /lib/x86_64-linux-gnu/libc.so.6

elenst-jira-refs 71ecb04 Toolbox: fcb0bb8

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1549599504 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/partitioning/partition_pruning.yy --gendata=conf/partitioning/partition_pruning.zz --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff

Not reproducible right away.



 Comments   
Comment by Elena Stepanova [ 2019-03-20 ]

On 10.3:
https://travis-ci.org/elenst/travis-tests/jobs/506105012 [2960 21 2]

10.3 51e48b9

mysqld: /home/travis/src/storage/innobase/row/row0purge.cc:516: bool row_purge_remove_sec_if_poss_leaf(purge_node_t*, dict_index_t*, const dtuple_t*): Assertion `index->table == node->table' failed.
190315  9:56:55 [ERROR] mysqld got signal 6 ;
 
#2  0x00007f3bd4a1dbf6 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#3  0x00007f3bd4a1dca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#4  0x0000555a8fea6f2c in dict_table_get_first_index (table=0x0) at /home/travis/src/storage/innobase/include/dict0dict.ic:219
#5  0x0000555a8feab2d4 in row_purge_upd_exist_or_extern_func (thr=0x555a93674110, node=0x555a93674598, undo_rec=0x7f3b8c0159a8 "") at /home/travis/src/storage/innobase/row/row0purge.cc:904
#6  0x0000555a8feac039 in row_purge_record_func (node=0x555a93674598, undo_rec=0x7f3b8c0159a8 "", thr=0x555a93674110, updated_extern=false) at /home/travis/src/storage/innobase/row/row0purge.cc:1207
#7  0x0000555a8feac1db in row_purge (node=0x555a93674598, undo_rec=0x7f3b8c0159a8 "", thr=0x555a93674110) at /home/travis/src/storage/innobase/row/row0purge.cc:1251
#8  0x0000555a8feac419 in row_purge_step (thr=0x555a93674110) at /home/travis/src/storage/innobase/row/row0purge.cc:1312
#9  0x0000555a8fe2f794 in que_thr_step (thr=0x555a93674110) at /home/travis/src/storage/innobase/que/que0que.cc:1042
#10 0x0000555a8fe2f9c4 in que_run_threads_low (thr=0x555a93674110) at /home/travis/src/storage/innobase/que/que0que.cc:1104
#11 0x0000555a8fe2fbb4 in que_run_threads (thr=0x555a93674110) at /home/travis/src/storage/innobase/que/que0que.cc:1144
#12 0x0000555a8fef6dee in srv_task_execute () at /home/travis/src/storage/innobase/srv/srv0srv.cc:2449
#13 0x0000555a8fef6f90 in srv_worker_thread (arg=0x0) at /home/travis/src/storage/innobase/srv/srv0srv.cc:2497
#14 0x00007f3bd55df184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#15 0x00007f3bd4aebffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

elenst-jira-refs ba1b2f2 Toolbox: b7a399a

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1552643748 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=MyISAM --grammar=conf/runtime/WL5004_sql.yy --gendata=conf/runtime/WL5004_data.zz --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff

Comment by Elena Stepanova [ 2023-06-18 ]

Could not reproduce on the current 10.4, and the reported revision fails in other ways, likely due to problems fixed long time ago.

Generated at Thu Feb 08 08:45:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.