Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16846

[Draft] Assertion `context' failed in Item_field::fix_fields

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3
    • N/A
    • N/A
    • None

    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
      

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.