Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
10.2.33, 10.3(EOL), 10.4(EOL), 10.5, 10.6
Description
commit 4c0f3b3be76343c155b00feff3309d91e1e11441 origin/bb-10.2-marko
|
containing a fix for MDEV-19114 but IIRC I have seen that assert some time ago
|
|
Version: '10.2.33-MariaDB-debug-log' socket:...
|
mysqld: /home/mleich/bb-10.2-marko_2/storage/innobase/lock/lock0lock.cc:1408: ib_lock_t* lock_rec_create_low(ib_lock_t*, que_thr_t*, ulint, ulint, ulint, const ib_page_t*, ulint, dict_index_t*, trx_t*, bool): Assertion `dict_index_is_clust(index) || !dict_index_is_online_ddl(index)' failed.
|
...
|
lock/lock0lock.cc:1414(lock_rec_create_low(ib_lock_t*, que_thr_t*, unsigned long, unsigned long, unsigned long, unsigned char const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc95ac08]
|
include/lock0lock.ic:133(lock_rec_create(ib_lock_t*, que_thr_t*, unsigned long, buf_block_t const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc9785ec]
|
lock/lock0lock.cc:1954(lock_rec_add_to_queue(unsigned long, buf_block_t const*, unsigned long, dict_index_t*, trx_t*, bool))[0x5607fc83dc32]
|
page/page0page.cc:777(page_copy_rec_list_end(buf_block_t*, buf_block_t*, unsigned char*, dict_index_t*, mtr_t*))[0x5607fc64a0e2]
|
/home/mleich/Server_bin/bb-10.2-marko_2_debug/bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0xdd1)[0x5607fc3a0cfc]
|
/home/mleich/Server_bin/bb-10.2-marko_2_debug/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x10fe)[0x5607fc39e7b8]
|
btr/btr0btr.cc:2995(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0x5607fc3c50ab]
|
btr/btr0cur.cc:3414(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x5607fc3d07f1]
|
row/row0ins.cc:2723(row_ins_clust_index_entry_low(unsigned long, unsigned long, dict_index_t*, unsigned long, dtuple_t*, unsigned long, que_thr_t*))[0x5607fc3beb24]
|
row/row0ins.cc:3274(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x5607fc3bd5a1]
|
row/row0ins.cc:3425(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x5607fc512317]
|
row/row0ins.cc:3562(row_ins(ins_node_t*, que_thr_t*))[0x5607fc512082]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7fc67459c6db]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc67398688f]
|
|
Query: INSERT INTO t3 (col1,col2, col_int, col_string, col_text) VALUES ....
|
Connection ID (thread ID): 46
|
Status: NOT_KILLED
|
|
RQG branch:
|
git clone https://github.com/mleich1/rqg --branch experimental RQG_mleich
|
|
perl rqg.pl \
|
--mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
|
--grammar=conf/mariadb/table_stress_innodb.yy \
|
--gendata=conf/mariadb/table_stress.zz \
|
--gendata_sql=conf/mariadb/table_stress.sql \
|
--engine=Innodb \
|
--reporters=Deadlock1,ErrorLog,Backtrace \
|
--mysqld=--connect_timeout=60 \
|
--mysqld=--net_read_timeout=30 \
|
--mysqld=--net_write_timeout=60 \
|
--mysqld=--loose-idle_readonly_transaction_timeout=0 \
|
--mysqld=--loose-idle_transaction_timeout=0 \
|
--mysqld=--loose-idle_write_transaction_timeout=0 \
|
--mysqld=--interactive_timeout=28800 \
|
--mysqld=--lock_wait_timeout=86400 \
|
--mysqld=--innodb-lock-wait-timeout=50 \
|
--mysqld=--loose-table_lock_wait_timeout=50 \
|
--mysqld=--wait_timeout=28800 \
|
--mysqld=--slave_net_timeout=60 \
|
--mysqld=--loose-max-statement-time=30 \
|
--mysqld=--loose-debug_assert_on_not_freed_memory=0 \
|
--mysqld=--log-output=none \
|
--duration=300 \
|
--seed=random \
|
--sqltrace=MarkErrors \
|
--threads=33 \
|
--mysqld=--innodb_adaptive_hash_index=OFF \
|
--mysqld=--innodb_page_size=8K \
|
--mysqld=--innodb-buffer-pool-size=256M \
|
--no_mask \
|
--workdir=<local settings> \
|
|
--vardir=<local settings> \
|
--mtr-build-thread=<local settings> \
|
--basedir1=<local settings> \
|
--basedir2=<local settings> \
|
--script_debug=_nix_ \
|
--rr=Server
|
|
Attachments
Issue Links
- relates to
-
MDEV-20605 Awaken transaction can miss inserted by other transaction records due to wrong persistent cursor restoration
- Closed
-
MDEV-22618 Assertion `!dict_index_is_online_ddl(lock->index) || lock->index->is_primary()' failed. in lock_table_locks_lookup
- Closed