[MDEV-16846] [Draft] Assertion `context' failed in Item_field::fix_fields Created: 2018-07-29  Updated: 2018-08-13  Resolved: 2018-08-13

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.3
Fix Version/s: N/A

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

Issue Links:
Duplicate
duplicates MDEV-16549 Server crashes in Item_field::fix_fie... Closed

 Description   

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

10.3 255328d3931e8526c4248ec2af1f554911376c1b

mysqld: /home/travis/src/sql/item.cc:6150: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.
180729  5:07:26 [ERROR] mysqld got signal 6 ;
 
Query (0x7fd138156a40): SELECT col_tinyint, `col_tinyint` FROM v1_trans_unsafe_for_sbr_6262 /* table0_int table0_myisam_int_autoinc table0_innodb_int_autoinc */ WHERE col_tinyint BETWEEN 98 AND 102 + 2 /**/ AND ( `col_tinyint` IS NULL OR `col_varchar_257_utf8` <> CURRENT_USER ) FOR UPDATE  /* QNO 3717 CON_ID 17 */
Connection ID (thread ID): 17
Status: NOT_KILLED

#6  0x00007fd185ac3bf6 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x00007fd185ac3ca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x0000561dd1cff75b in Item_field::fix_fields (this=0x7fd1380237b0, thd=0x7fd13800b210, reference=0x7fd1380237a8) at /home/travis/src/sql/item.cc:6150
#9  0x0000561dd18e9f9e in Item::fix_fields_if_needed (this=0x7fd1380237b0, thd=0x7fd13800b210, ref=0x7fd1380237a8) at /home/travis/src/sql/item.h:822
#10 0x0000561dd1d08151 in Item_direct_view_ref::fix_fields (this=0x7fd138023690, thd=0x7fd13800b210, reference=0x7fd138022cc0) at /home/travis/src/sql/item.cc:9043
#11 0x0000561dd18e9f9e in Item::fix_fields_if_needed (this=0x7fd138023690, thd=0x7fd13800b210, ref=0x7fd138022cc0) at /home/travis/src/sql/item.h:822
#12 0x0000561dd1d55a05 in Item_func::fix_fields (this=0x7fd138022b80, thd=0x7fd13800b210, ref=0x7fd138023070) at /home/travis/src/sql/item_func.cc:363
#13 0x0000561dd18e9f9e in Item::fix_fields_if_needed (this=0x7fd138022b80, thd=0x7fd13800b210, ref=0x7fd138023070) at /home/travis/src/sql/item.h:822
#14 0x0000561dd18e9fcb in Item::fix_fields_if_needed_for_scalar (this=0x7fd138022b80, thd=0x7fd13800b210, ref=0x7fd138023070) at /home/travis/src/sql/item.h:826
#15 0x0000561dd1963531 in Item::fix_fields_if_needed_for_bool (this=0x7fd138022b80, thd=0x7fd13800b210, ref=0x7fd138023070) at /home/travis/src/sql/item.h:830
#16 0x0000561dd1d24e22 in Item_cond::fix_fields (this=0x7fd138022a70, thd=0x7fd13800b210, ref=0x7fd138021460) at /home/travis/src/sql/item_cmpfunc.cc:4603
#17 0x0000561dd1a26aa7 in JOIN::optimize_inner (this=0x7fd138021058) at /home/travis/src/sql/sql_select.cc:1658
#18 0x0000561dd1a25ee9 in JOIN::optimize (this=0x7fd138021058) at /home/travis/src/sql/sql_select.cc:1448
#19 0x0000561dd1999205 in mysql_derived_optimize (thd=0x7fd13800b210, lex=0x7fd1381552c8, derived=0x7fd138156ff0) at /home/travis/src/sql/sql_derived.cc:935
#20 0x0000561dd19977cd in mysql_handle_single_derived (lex=0x7fd1381552c8, derived=0x7fd138156ff0, phases=4) at /home/travis/src/sql/sql_derived.cc:197
#21 0x0000561dd1a26dcb in JOIN::optimize_inner (this=0x7fd13801ff58) at /home/travis/src/sql/sql_select.cc:1705
#22 0x0000561dd1a25ee9 in JOIN::optimize (this=0x7fd13801ff58) at /home/travis/src/sql/sql_select.cc:1448
#23 0x0000561dd1a2fa79 in mysql_select (thd=0x7fd13800b210, tables=0x7fd138156ff0, wild_num=0, fields=..., conds=0x7fd13801fc38, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552172521984, result=0x7fd138158330, unit=0x7fd138155390, select_lex=0x7fd138155b00) at /home/travis/src/sql/sql_select.cc:4213
#24 0x0000561dd1a21a15 in handle_select (thd=0x7fd13800b210, lex=0x7fd1381552c8, result=0x7fd138158330, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
#25 0x0000561dd19ec3eb in execute_sqlcom_select (thd=0x7fd13800b210, all_tables=0x7fd138156ff0) at /home/travis/src/sql/sql_parse.cc:6543
#26 0x0000561dd19e2b07 in mysql_execute_command (thd=0x7fd13800b210) at /home/travis/src/sql/sql_parse.cc:3765
#27 0x0000561dd1a0de8f in Prepared_statement::execute (this=0x7fd138065650, expanded_query=0x7fd1840e6360, open_cursor=false) at /home/travis/src/sql/sql_prepare.cc:4763
#28 0x0000561dd1a0c2b6 in Prepared_statement::execute_loop (this=0x7fd138065650, expanded_query=0x7fd1840e6360, open_cursor=false, packet=0x7fd139064aba "", packet_end=0x7fd139064aba "") at /home/travis/src/sql/sql_prepare.cc:4191
#29 0x0000561dd1a09af6 in mysql_stmt_execute_common (thd=0x7fd13800b210, stmt_id=3718, packet=0x7fd139064aba "", packet_end=0x7fd139064aba "", cursor_flags=0, bulk_op=false, read_types=false) at /home/travis/src/sql/sql_prepare.cc:3191
#30 0x0000561dd1a09699 in mysqld_stmt_execute (thd=0x7fd13800b210, packet_arg=0x7fd139064ab1 "\206\016", packet_length=9) at /home/travis/src/sql/sql_prepare.cc:3089
#31 0x0000561dd19dd28e in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7fd13800b210, packet=0x7fd139064ab1 "\206\016", packet_length=9, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1789
#32 0x0000561dd19dc06c in do_command (thd=0x7fd13800b210) at /home/travis/src/sql/sql_parse.cc:1392
#33 0x0000561dd1b43349 in do_handle_one_connection (connect=0x561dd4989980) at /home/travis/src/sql/sql_connect.cc:1402
#34 0x0000561dd1b430cd in handle_one_connection (arg=0x561dd4989980) at /home/travis/src/sql/sql_connect.cc:1308
#35 0x00007fd186685184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#36 0x00007fd185b91ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

dev fa73b076aae2ad6cc4f822a4d7af2ed488f23f84

perl /home/travis/rqg/runall-new.pl --vardir=/home/travis/logs/vardir --basedir=/home/travis/server --duration=350 --threads=6 --seed=1532840656 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.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 --grammar=conf/replication/replication-ddl_sql.yy --gendata=conf/replication/replication-ddl_data.zz --ps-protocol --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsSPTwice


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