[MDEV-17053] [Draft] Assertion `!sync_check_iterate(sync_check())' failed in row_sel Created: 2018-08-23  Updated: 2018-08-23

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2
Fix Version/s: None

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


 Description   

https://travis-ci.org/elenst/travis-tests/jobs/419414595

10.2 5d650d366dbcbd49679bf8b0884b63056053fb44

mysqld: /home/travis/src/storage/innobase/row/row0sel.cc:2259: dberr_t row_sel(sel_node_t*, que_thr_t*): Assertion `!sync_check_iterate(sync_check())' failed.
180823  3:05:10 [ERROR] mysqld got signal 6 ;
 
Query (0x7f08d80111d8): INSERT INTO `t3` SELECT * FROM `t6` /* QNO 2368 CON_ID 16 */
Connection ID (thread ID): 16
Status: NOT_KILLED

#7  0x00007f09215f1ca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x00005569af0db8a4 in row_sel (node=0x7f08d80ee948, thr=0x7f08d80efaa8) at /home/travis/src/storage/innobase/row/row0sel.cc:2259
#9  0x00005569af0dbde3 in row_sel_step (thr=0x7f08d80efaa8) at /home/travis/src/storage/innobase/row/row0sel.cc:2401
#10 0x00005569af05b743 in que_thr_step (thr=0x7f08d80efaa8) at /home/travis/src/storage/innobase/que/que0que.cc:1027
#11 0x00005569af05ba53 in que_run_threads_low (thr=0x7f08d80efaa8) at /home/travis/src/storage/innobase/que/que0que.cc:1111
#12 0x00005569af05bbfd in que_run_threads (thr=0x7f08d80efaa8) at /home/travis/src/storage/innobase/que/que0que.cc:1151
#13 0x00005569af2b87ed in fts_eval_sql (trx=0x7f09209c8998, graph=0x7f08d80ef9d0) at /home/travis/src/storage/innobase/fts/fts0sql.cc:240
#14 0x00005569af29c216 in fts_doc_fetch_by_doc_id (get_doc=0x0, doc_id=1, index_to_use=0x7f08f0115428, option=2, callback=0x5569af2a41ee <fts_init_recover_doc(void*, void*)>, arg=0x7f08f00c6dc8) at /home/travis/src/storage/innobase/fts/fts0fts.cc:3884
#15 0x00005569af2a4850 in fts_init_index (table=0x7f08f0061508, has_cache_lock=0) at /home/travis/src/storage/innobase/fts/fts0fts.cc:7655
#16 0x00005569af29b4c3 in fts_add_doc_by_id (ftt=0x7f08d816d448, doc_id=1, fts_indexes=0x0) at /home/travis/src/storage/innobase/fts/fts0fts.cc:3508
#17 0x00005569af29a099 in fts_add (ftt=0x7f08d816d448, row=0x7f08d80ed8a0) at /home/travis/src/storage/innobase/fts/fts0fts.cc:2910
#18 0x00005569af29a81b in fts_commit_table (ftt=0x7f08d816d448) at /home/travis/src/storage/innobase/fts/fts0fts.cc:3082
#19 0x00005569af29a90f in fts_commit (trx=0x7f09209c33a8) at /home/travis/src/storage/innobase/fts/fts0fts.cc:3131
#20 0x00005569af1672e1 in trx_commit_low (trx=0x7f09209c33a8, mtr=0x7f09204cbb30) at /home/travis/src/storage/innobase/trx/trx0trx.cc:1820
#21 0x00005569af1674bf in trx_commit (trx=0x7f09209c33a8) at /home/travis/src/storage/innobase/trx/trx0trx.cc:1912
#22 0x00005569af167d3e in trx_commit_for_mysql (trx=0x7f09209c33a8) at /home/travis/src/storage/innobase/trx/trx0trx.cc:2121
#23 0x00005569aef6990a in innobase_commit_low (trx=0x7f09209c33a8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:4519
#24 0x00005569aef69c6e in innobase_commit_ordered_2 (trx=0x7f09209c33a8, thd=0x7f08d8000c90) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:4636
#25 0x00005569aef6a0c9 in innobase_commit (hton=0x5569b14b1fe0, thd=0x7f08d8000c90, commit_trx=false) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:4752
#26 0x00005569aed61446 in commit_one_phase_2 (thd=0x7f08d8000c90, all=false, trans=0x7f08d8003f68, is_real_trans=true) at /home/travis/src/sql/handler.cc:1569
#27 0x00005569aed6134f in ha_commit_one_phase (thd=0x7f08d8000c90, all=false) at /home/travis/src/sql/handler.cc:1550
#28 0x00005569aed60c1d in ha_commit_trans (thd=0x7f08d8000c90, all=false) at /home/travis/src/sql/handler.cc:1417
#29 0x00005569aec45236 in trans_commit_stmt (thd=0x7f08d8000c90) at /home/travis/src/sql/transaction.cc:510
#30 0x00005569aeaebd48 in mysql_execute_command (thd=0x7f08d8000c90) at /home/travis/src/sql/sql_parse.cc:6294
#31 0x00005569aeaf087a in mysql_parse (thd=0x7f08d8000c90, rawbuf=0x7f08d80111d8 "INSERT INTO `t3` SELECT * FROM `t6` /* QNO 2368 CON_ID 16 */", length=60, parser_state=0x7f09204cd210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
#32 0x00005569aeade311 in dispatch_command (command=COM_QUERY, thd=0x7f08d8000c90, packet=0x7f08d8008961 "INSERT INTO `t3` SELECT * FROM `t6` /* QNO 2368 CON_ID 16 */ ", packet_length=61, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1824
#33 0x00005569aeadcc74 in do_command (thd=0x7f08d8000c90) at /home/travis/src/sql/sql_parse.cc:1378
#34 0x00005569aec2f36a in do_handle_one_connection (connect=0x5569b1ec0e60) at /home/travis/src/sql/sql_connect.cc:1335
#35 0x00005569aec2f0f7 in handle_one_connection (arg=0x5569b1ec0e60) at /home/travis/src/sql/sql_connect.cc:1241
#36 0x00007f09221b3184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#37 0x00007f09216bfffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

dev 539d817245163ef1be726695ffc5851e5879e959

perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1534993199 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.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=--innodb-sync-debug --grammar=conf/mariadb/optimizer.yy --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice

1630,13,2

Not reproducible right away.


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