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

Failures on bb-10.2-compatibility tree which are not reproducible on current 10.2

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • N/A
    • Server
    • None
    • bb-10.2-compatibility

    Description

      This item is a collection of failures I encountered on bb-10.2-compatibility tree, which are not at the same time reproducible on 10.2 tree, but don't necessarily have directly corresponding closed JIRA items – most often they are secondary crashes caused by some previous problem which remained invisible on a release build, so the fixed JIRA item would be, for example, an ASAN failure, but on a release build it could (or could not) later cause various crashes. When possible, I will refer to the suspected fixed bug. The goal of the item is not to bring it to 'fixing' – only synchronizing bb-10.2-compatibility and 10.3 can achieve it – but provide information for JIRA searches and for making decisions what needs to be cherry-picked into bb-10.2-compatibility tree as long as it exists.

      === Suspected to be fixed in scope of MDEV-15746 ===

      Below are variations of stack traces which I encountered on bb-10.2-compatibility build 20620 release tree while running the attached test self2a.test.gz with the following options:

      --mem --mysqld=--innodb --mysqld=--default-storage-engine=InnoDB --mysqld=--partition --mysqld=--log_output=FILE --mysqld=--max-statement-time=8 --mysqld=--lock-wait-timeout=5 --mysqld=--loose-innodb-lock-wait-timeout=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--character-set-server=utf8 --mysqld=--collation-server=utf8_general_ci --mysqld=--binlog-format=ROW --mysqld=--innodb-buffer-pool-size=2G --mysqld=--innodb_buffer_pool_instances=8 --mysqld=--innodb_page_cleaners=4 --mysqld=--innodb_stats_sample_pages=32 --mysqld=--innodb_stats_transient_sample_pages=32 --mysqld=--join_buffer_size=4M --mysqld=--join_cache_level=6 --mysqld=--key_buffer_size=64M --mysqld=--log_bin_trust_function_creators=ON --mysqld=--log_slow_verbosity=innodb,query_plan --mysqld=--lower_case_table_names=1 --mysqld=--optimizer_search_depth=0 --mysqld=--optimizer_switch=index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=on,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on --mysqld=--transaction_isolation=READ-COMMITTED --mysqld=--use_stat_tables=PREFERABLY --mysqld=--userstat=ON --mysqld=--sql_mode=STRICT_TRANS_TABLE
      

      At least some of them are reproducible on the current bb-10.2-compatibility f20d3ddf1e.
      I couldn't reproduce any of them on the current 10.2 3e5162d814 or on 10.2 92a13148e8 (MDEV-15746). At least some of them are reproducible on 10.2 commit prior to 92a13148e8. It's theoretically possible that some of them were fixed earlier by different commits.

      bb-10.2-compatibility 20620 non-debug

      #2  <signal handler called>
      #3  0x000056231465722a in delete_self (this=0x7f11d4175920) at /data/src/bb-10.2-compatibility-20620/sql/item.h:1847
      #4  Query_arena::free_items (this=0x7f11d45e4920) at /data/src/bb-10.2-compatibility-20620/sql/sql_class.cc:3695
      #5  0x000056231473438e in closefrm (table=table@entry=0x7f11d40f2b58) at /data/src/bb-10.2-compatibility-20620/sql/table.cc:3460
      #6  0x00005623147db73d in intern_close_table (table=0x7f11d40f2b58) at /data/src/bb-10.2-compatibility-20620/sql/table_cache.cc:222
      #7  0x00005623147db88d in tc_remove_table (table=table@entry=0x7f11d40f2b58) at /data/src/bb-10.2-compatibility-20620/sql/table_cache.cc:260
      #8  0x00005623147dbc86 in tc_release_table (table=table@entry=0x7f11d40f2b58) at /data/src/bb-10.2-compatibility-20620/sql/table_cache.cc:461
      #9  0x000056231463fcb0 in close_thread_table (thd=thd@entry=0x7f11d40009a8, table_ptr=table_ptr@entry=0x7f11d4000a90) at /data/src/bb-10.2-compatibili
      ty-20620/sql/sql_base.cc:900
      #10 0x0000562314640cb4 in close_all_tables_for_name (thd=thd@entry=0x7f11d40009a8, share=<optimized out>, extra=HA_EXTRA_NOT_USED, skip_table=skip_tab
      le@entry=0x0) at /data/src/bb-10.2-compatibility-20620/sql/sql_base.cc:674
      #11 0x000056231471d873 in mysql_inplace_alter_table (target_mdl_request=0x7f12c42acfd0, alter_ctx=0x7f12c42adb90, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, ha_alter_info=0x7f12c42acf40, altered_table=0x7f11d40c52b8, table=0x7f11d40f2b58, table_list=0x7f11d45b2fd0, thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:7251
      #12 mysql_alter_table (thd=0x7f11d40009a8, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f11d45b2fd0, alter_info=<optimized out>, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9245
      #13 0x0000562314765bd5 in Sql_cmd_alter_table::execute (this=0x7f11d4175920, thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #14 0x000056231468f9e2 in mysql_execute_command (thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #15 0x00005623146a8827 in Prepared_statement::execute (this=0x7f11d45c9298, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #16 0x00005623146a896e in Prepared_statement::execute_loop (this=0x7f12c42b0b60, expanded_query=0x1, open_cursor=11, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4172
      #17 0x00005623146a8e52 in mysql_sql_stmt_execute (thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #18 0x00005623146914ff in mysql_execute_command (thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #19 0x000056231469630d in mysql_parse (thd=0x7f11d40009a8, rawbuf=<optimized out>, length=22, parser_state=0x7f12c42b2260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #20 0x0000562314698d71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f11d40009a8, packet=packet@entry=0x7f11d402bbc9 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #21 0x0000562314699613 in do_command (thd=0x7f11d40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #22 0x0000562314762ed4 in do_handle_one_connection (connect=connect@entry=0x56231b617f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #23 0x0000562314763074 in handle_one_connection (arg=0x56231b617f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #24 0x00007f12da9d0494 in start_thread (arg=0x7f12c42b3700) at pthread_create.c:333
      #25 0x00007f12d8db693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      #2  <signal handler called>
      #3  0x0000564bb1d583c9 in Item::print_parenthesised (this=0x7f0f3008ac40, str=0x7f10240810c0, query_type=665, parent_prec=LOWEST_PRECEDENCE) at /data/src/bb-10.2-compatibility-20620/sql/item.cc:557
      #4  0x0000564bb1c37d6b in print_for_table_def (str=0x7f10240810c0, this=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/item.h:1336
      #5  print (this=0x7f0f3008acc8, str=0x7f10240810c0) at /data/src/bb-10.2-compatibility-20620/sql/item.h:6429
      #6  pack_expression (buf=0x7f10240810c0, vcol=0x7f0f3008acc8, field_nr=<optimized out>, type=VCOL_GENERATED_STORED) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:553
      #7  0x0000564bb1c37f32 in pack_vcols (check_constraint_list=0x7f1024084720, create_fields=..., buf=0x7f10240810c0) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:574
      #8  build_frm_image (thd=0x7f0f300009a8, table=0x7f0f30565b68 "t5", create_info=0x7f1024084770, create_fields=..., keys=4, key_info=0x7f0f30029518, db_file=0x7f0f30028da0) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:131
      #9  0x0000564bb1c07388 in mysql_create_frm_image (thd=0x7f0f300009a8, db=0x7f10240810c0 "\340\020\b$\020\177", db@entry=0x7f0f305661b0 "test", table_name=0x299 <error: Cannot access memory at address 0x299>, table_name@entry=0x7f0f30565b68 "t5", create_info=0x0, create_info@entry=0x7f1024084770, alter_info=0x1, alter_info@entry=0x7f10240846c0, create_table_mode=809092784, create_table_mode@entry=-2, key_info=0x7f1024082ea0, key_count=0x7f1024082e7c, frm=0x7f1024082eb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4527
      #10 0x0000564bb1c0af7e in create_table_impl (thd=thd@entry=0x7f0f300009a8, orig_db=0x7f0f305661b0 "test", orig_table_name=0x7f0f30565b68 "t5", db=0x7f0f305661b0 "test", table_name=table_name@entry=0x7f1024083bd0 "#sql-af7_10", path=path@entry=0x7f102408443c "./test/#sql-af7_10", options=..., create_info=0x7f1024084770, alter_info=0x7f10240846c0, create_table_mode=-2, is_trans=0x0, key_info=0x7f1024082ea0, key_count=0x7f1024082e7c, frm=0x7f1024082
      eb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4763
      #11 0x0000564bb1c0d3f5 in mysql_alter_table (thd=0x7f0f300009a8, new_db=<optimized out>, new_name=<optimized out>, create_info=0x7f1024084770, table_list=0x7f0f30565ba0, alter_info=0x7f10240846c0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9095
      #12 0x0000564bb1c56bd5 in Sql_cmd_alter_table::execute (this=0x7f0f3008ac40, thd=0x7f0f300009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #13 0x0000564bb1b809e2 in mysql_execute_command (thd=0x7f0f300009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #14 0x0000564bb1b99827 in Prepared_statement::execute (this=0x7f0f3017c058, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #15 0x0000564bb1b9996e in Prepared_statement::execute_loop (this=0x7f1024086b60, expanded_query=0x1, open_cursor=153, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4172
      #16 0x0000564bb1b99e52 in mysql_sql_stmt_execute (thd=0x7f0f300009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #17 0x0000564bb1b824ff in mysql_execute_command (thd=0x7f0f300009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #18 0x0000564bb1b8730d in mysql_parse (thd=0x7f0f300009a8, rawbuf=<optimized out>, length=22, parser_state=0x7f1024088260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #19 0x0000564bb1b89d71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f0f300009a8, packet=packet@entry=0x7f0f30195b09 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #20 0x0000564bb1b8a613 in do_command (thd=0x7f0f300009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #21 0x0000564bb1c53ed4 in do_handle_one_connection (connect=connect@entry=0x564bb8c7af78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #22 0x0000564bb1c54074 in handle_one_connection (arg=0x564bb8c7af78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #23 0x00007f1029011494 in start_thread (arg=0x7f1024089700) at pthread_create.c:333
      #24 0x00007f10273f793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      2018-12-02 23:42:25 0x7fc540cfa700  InnoDB: Assertion failure in file /data/src/bb-10.2-compatibility-20620/storage/innobase/handler/ha_innodb.cc line 7687
      InnoDB: Failing assertion: templ->clust_rec_field_no != ULINT_UNDEFINED
       
      #4  0x00007fc5e10ab3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #5  0x00005649adde4131 in ut_dbg_assertion_failed (expr=expr@entry=0x5649ae6b8608 "templ->clust_rec_field_no != ULINT_UNDEFINED", file=file@entry=0x5649ae6b7f48 "/data/src/bb-10.2-compatibility-20620/storage/innobase/handle
      r/ha_innodb.cc", line=line@entry=7687) at /data/src/bb-10.2-compatibility-20620/storage/innobase/ut/ut0dbg.cc:61
      #6  0x00005649ae26c5d3 in build_template_field (prebuilt=0x7fc4e404ded0, clust_index=<optimized out>, index=0x7fc4e40de270, table=<optimized out>, fie
      ld=0x7fc4e41efca0, i=<optimized out>, v_no=<optimized out>) at /data/src/bb-10.2-compatibility-20620/storage/innobase/handler/ha_innodb.cc:7687
      #7  0x00005649ae27540d in ha_innobase::build_template (this=0x4, whole_row=32, whole_row@entry=false) at /data/src/bb-10.2-compatibility-20620/storage/innobase/handler/ha_innodb.cc:8123
      #8  0x00005649ae276d00 in ha_innobase::change_active_index (this=this@entry=0x7fc4e41881c0, keynr=0) at /data/src/bb-10.2-compatibility-20620/storage/innobase/handler/ha_innodb.cc:9805
      #9  0x00005649ae276f0b in ha_innobase::rnd_init (this=0x7fc4e41881c0, scan=<optimized out>) at /data/src/bb-10.2-compatibility-20620/storage/innobase/handler/ha_innodb.cc:10004
      #10 0x00005649ae0719a6 in ha_rnd_init (scan=scan@entry=true, this=0x7fc4e41881c0) at /data/src/bb-10.2-compatibility-20620/sql/handler.h:2881
      #11 handler::ha_rnd_init_with_error (this=0x7fc4e41881c0, scan=scan@entry=true) at /data/src/bb-10.2-compatibility-20620/sql/handler.cc:2920
      #12 0x00005649ae170241 in init_read_record (info=info@entry=0x7fc540cf34b0, thd=thd@entry=0x7fc4e40009a8, table=table@entry=0x7fc4e4186978, select=select@entry=0x0, filesort=filesort@entry=0x0, use_record_cache=use_record_cache@entry=1, print_error=<optimized out>, disable_rr_cache=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/records.cc:299
      #13 0x00005649addda86e in copy_data_between_tables (thd=thd@entry=0x7fc4e40009a8, from=from@entry=0x7fc4e4186978, to=to@entry=0x7fc4e41d2858, create=..., ignore=ignore@entry=false, order_num=order_num@entry=0, order=0x0, copied=0x7fc540cf3e90, deleted=0x7fc540cf3e98, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7fc540cf4b90) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9819
      #14 0x00005649adf3938a in mysql_alter_table (thd=<optimized out>, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7fc4e410f050, alter_info=0x7fc540cf56c0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9376
      #15 0x00005649adf80bd5 in Sql_cmd_alter_table::execute (this=0x2, thd=0x7fc4e40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #16 0x00005649adeaa9e2 in mysql_execute_command (thd=0x7fc4e40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #17 0x00005649adec3827 in Prepared_statement::execute (this=0x7fc4e41d36c8, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #18 0x00005649adec396e in Prepared_statement::execute_loop (this=0x7fc540cf7b60, expanded_query=0x1, open_cursor=false, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4172
      #19 0x00005649adec3e52 in mysql_sql_stmt_execute (thd=0x7fc4e40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #20 0x00005649adeac4ff in mysql_execute_command (thd=0x7fc4e40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #21 0x00005649adeb130d in mysql_parse (thd=0x7fc4e40009a8, rawbuf=<optimized out>, length=22, parser_state=0x7fc540cf9260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #22 0x00005649adeb3d71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc4e40009a8, packet=packet@entry=0x7fc4e402bbc9 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #23 0x00005649adeb4613 in do_command (thd=0x7fc4e40009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #24 0x00005649adf7ded4 in do_handle_one_connection (connect=connect@entry=0x5649b3b29f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #25 0x00005649adf7e074 in handle_one_connection (arg=0x5649b3b29f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #26 0x00007fc5e2d79494 in start_thread (arg=0x7fc540cfa700) at pthread_create.c:333
      #27 0x00007fc5e115f93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      #2  <signal handler called>
      #3  0x0000565132d88690 in Item_field::print (this=0x7f4838008260, str=0x7f492c09b0c0, query_type=665) at /data/src/bb-10.2-compatibility-20620/sql/item.cc:7482
      #4  0x0000565132c67d6b in print_for_table_def (str=0x7f492c09b0c0, this=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/item.h:1336
      #5  print (this=0x7f4838008368, str=0x7f492c09b0c0) at /data/src/bb-10.2-compatibility-20620/sql/item.h:6429
      #6  pack_expression (buf=0x7f492c09b0c0, vcol=0x7f4838008368, field_nr=<optimized out>, type=VCOL_GENERATED_STORED) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:553
      #7  0x0000565132c67f32 in pack_vcols (check_constraint_list=0x7f492c09e720, create_fields=..., buf=0x7f492c09b0c0) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:574
      #8  build_frm_image (thd=0x7f48380009a8, table=0x7f4838075698 "t5", create_info=0x7f492c09e770, create_fields=..., keys=5, key_info=0x7f4838029bc0, db_file=0x7f4838029448) at /data/src/bb-10.2-compatibility-20620/sql/unireg
      .cc:131
      #9  0x0000565132c37388 in mysql_create_frm_image (thd=0x7f48380009a8, db=0x7f492c09b0c0 "\340\260\t,I\177", db@entry=0x7f4838075ce0 "test", table_name=0x299 <error: Cannot access memory at address 0x299>, table_name@entry=0
      x7f4838075698 "t5", create_info=0x0, create_info@entry=0x7f492c09e770, alter_info=0x1, alter_info@entry=0x7f492c09e6c0, create_table_mode=939835105, create_table_mode@entry=-2, key_info=0x7f492c09cea0, key_count=0x7f492c09c
      e7c, frm=0x7f492c09ceb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4527
      #10 0x0000565132c3af7e in create_table_impl (thd=thd@entry=0x7f48380009a8, orig_db=0x7f4838075ce0 "test", orig_table_name=0x7f4838075698 "t5", db=0x7f4838075ce0 "test", table_name=table_name@entry=0x7f492c09dbd0 "#sql-afa_9
      ", path=path@entry=0x7f492c09e43c "./test/#sql-afa_9", options=..., create_info=0x7f492c09e770, alter_info=0x7f492c09e6c0, create_table_mode=-2, is_trans=0x0, key_info=0x7f492c09cea0, key_count=0x7f492c09ce7c, frm=0x7f492c0
      9ceb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4763
      #11 0x0000565132c3d3f5 in mysql_alter_table (thd=0x7f48380009a8, new_db=<optimized out>, new_name=<optimized out>, create_info=0x7f492c09e770, table_list=0x7f48380756d0, alter_info=0x7f492c09e6c0, order_num=0, order=0x0, ig
      nore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9095
      #12 0x0000565132c86bd5 in Sql_cmd_alter_table::execute (this=0x7f4838008260, thd=0x7f48380009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #13 0x0000565132bb09e2 in mysql_execute_command (thd=0x7f48380009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #14 0x0000565132bc9827 in Prepared_statement::execute (this=0x7f4838025f08, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #15 0x0000565132bc996e in Prepared_statement::execute_loop (this=0x7f492c0a0b60, expanded_query=0x1, open_cursor=153, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prep
      are.cc:4172
      #16 0x0000565132bc9e52 in mysql_sql_stmt_execute (thd=0x7f48380009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #17 0x0000565132bb24ff in mysql_execute_command (thd=0x7f48380009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #18 0x0000565132bb730d in mysql_parse (thd=0x7f48380009a8, rawbuf=<optimized out>, length=22, parser_state=0x7f492c0a2260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20
      620/sql/sql_parse.cc:7978
      #19 0x0000565132bb9d71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f48380009a8, packet=packet@entry=0x7f48380b6ff9 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_c
      om_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #20 0x0000565132bba613 in do_command (thd=0x7f48380009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #21 0x0000565132c83ed4 in do_handle_one_connection (connect=connect@entry=0x565138814f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #22 0x0000565132c84074 in handle_one_connection (arg=0x565138814f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #23 0x00007f4930520494 in start_thread (arg=0x7f492c0a3700) at pthread_create.c:333
      #24 0x00007f492e90693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      #3  0x0000000000000000 in ?? ()
      #4  0x0000561cd89a44b7 in TABLE::mark_virtual_col (this=this@entry=0x7fefcc11d878, field=field@entry=0x7fefcc11f938) at /data/src/bb-10.2-compatibility-20620/sql/table.cc:6593
      #5  0x0000561cd88a4de7 in update_field_dependencies (thd=thd@entry=0x7fefcc0009a8, field=field@entry=0x7fefcc11f938, table=table@entry=0x7fefcc11d878) at /data/src/bb-10.2-compatibility-20620/sql/sql_base.cc:5329
      #6  0x0000561cd88ac5f8 in update_field_dependencies (table=0x7fefcc11d878, field=0x7fefcc11f938, thd=0x7fefcc0009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_base.cc:5317
      #7  find_field_in_table (thd=thd@entry=0x7fefcc0009a8, table=0x7fefcc11d878, name=name@entry=0x7fefcc125d80 "vcol_varchar", length=length@entry=12, allow_rowid=<optimized out>, cached_field_index_ptr=cached_field_index_ptr@
      entry=0x7ff0b8082d10) at /data/src/bb-10.2-compatibility-20620/sql/sql_base.cc:5642
      #8  0x0000561cd88acedc in find_field_in_table_ref (thd=0x7fefcc0009a8, table_list=0x7fefcc125eb8, name=0x7fefcc125d80 "vcol_varchar", length=12, item_name=0x7fefcc125d80 "vcol_varchar", db_name=0x0, table_name=0x0, ref=0x0,
       check_privileges=true, allow_rowid=false, cached_field_index_ptr=0x7ff0b8082d10, register_tree_change=false, actual_table=0x7ff0b8082d40) at /data/src/bb-10.2-compatibility-20620/sql/sql_base.cc:5764
      #9  0x0000561cd889f6a5 in mysql_table_grant (thd=0x7fefcc0009a8, table_list=0x351, user_list=..., columns=..., rights=0, revoke_grant=16) at /data/src/bb-10.2-compatibility-20620/sql/sql_acl.cc:6506
      #10 0x0000561cd88faf43 in mysql_execute_command (thd=0x7fefcc0009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:5468
      #11 0x0000561cd890f827 in Prepared_statement::execute (this=0x7fefcc139b68, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #12 0x0000561cd890f96e in Prepared_statement::execute_loop (this=0x7ff0b8087b60, expanded_query=0x1, open_cursor=false, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_pr
      epare.cc:4172
      #13 0x0000561cd890fe52 in mysql_sql_stmt_execute (thd=0x7fefcc0009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #14 0x0000561cd88f84ff in mysql_execute_command (thd=0x7fefcc0009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #15 0x0000561cd88fd30d in mysql_parse (thd=0x7fefcc0009a8, rawbuf=<optimized out>, length=22, parser_state=0x7ff0b8089260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #16 0x0000561cd88ffd71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fefcc0009a8, packet=packet@entry=0x7fefcc0db989 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #17 0x0000561cd8900613 in do_command (thd=0x7fefcc0009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #18 0x0000561cd89c9ed4 in do_handle_one_connection (connect=connect@entry=0x561cde5ccf78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #19 0x0000561cd89ca074 in handle_one_connection (arg=0x561cde5ccf78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #20 0x00007ff0be49b494 in start_thread (arg=0x7ff0b808a700) at pthread_create.c:333
      #21 0x00007ff0bc88193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      #2  <signal handler called>
      #3  0x00005613bc4e522a in delete_self (this=0x7f3c841930e0) at /data/src/bb-10.2-compatibility-20620/sql/item.h:1847
      #4  Query_arena::free_items (this=0x7f3c8409e910) at /data/src/bb-10.2-compatibility-20620/sql/sql_class.cc:3695
      #5  0x00005613bc5c238e in closefrm (table=table@entry=0x7f3c84211b88) at /data/src/bb-10.2-compatibility-20620/sql/table.cc:3460
      #6  0x00005613bc66973d in intern_close_table (table=0x7f3c84211b88) at /data/src/bb-10.2-compatibility-20620/sql/table_cache.cc:222
      #7  0x00005613bc669f5d in tdc_remove_table (thd=thd@entry=0x7f3c840009a8, remove_type=remove_type@entry=TDC_RT_REMOVE_NOT_OWN_KEEP_SHARE, db=<optimized out>, table_name=<optimized out>, kill_delayed_threads=kill_delayed_threads@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/table_cache.cc:1134
      #8  0x00005613bc5abbd9 in mysql_inplace_alter_table (target_mdl_request=0x7f3cebf6afd0, alter_ctx=0x7f3cebf6bb90, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, ha_alter_info=0x7f3cebf6af40, altered_table=0x7f3c840eb2e8, table=0x7f3c841e5978, table_list=0x7f3c840f1400, thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:7133
      #9  mysql_alter_table (thd=0x7f3c840009a8, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f3c840f1400, alter_info=<optimized out>, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9245
      #10 0x00005613bc5f3bd5 in Sql_cmd_alter_table::execute (this=0x7f3c841930e0, thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #11 0x00005613bc51d9e2 in mysql_execute_command (thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #12 0x00005613bc536827 in Prepared_statement::execute (this=0x7f3c842020c8, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #13 0x00005613bc53696e in Prepared_statement::execute_loop (this=0x7f3cebf6eb60, expanded_query=0x1, open_cursor=8, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4172
      #14 0x00005613bc536e52 in mysql_sql_stmt_execute (thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #15 0x00005613bc51f4ff in mysql_execute_command (thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #16 0x00005613bc52430d in mysql_parse (thd=0x7f3c840009a8, rawbuf=<optimized out>, length=22, parser_state=0x7f3cebf70260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #17 0x00005613bc526d71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f3c840009a8, packet=packet@entry=0x7f3c8402bbc9 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      #18 0x00005613bc527613 in do_command (thd=0x7f3c840009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1383
      #19 0x00005613bc5f0ed4 in do_handle_one_connection (connect=connect@entry=0x5613c2107f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1335
      #20 0x00005613bc5f1074 in handle_one_connection (arg=0x5613c2107f78) at /data/src/bb-10.2-compatibility-20620/sql/sql_connect.cc:1241
      #21 0x00007f3d8caa1494 in start_thread (arg=0x7f3cebf71700) at pthread_create.c:333
      #22 0x00007f3d8ae8793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      #4  0x000056431308ad51 in memcpy (__len=140597164232992, __src=<optimized out>, __dest=<optimized out>) at /usr/include/x86_64-linux-gnu/bits/string3.h:53
      #5  q_append (this=0x7fe0741a00c0, this=0x7fe0741a00c0, data_len=140597164232992, data=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_string.h:573
      #6  pack_expression (buf=0x7fe0741a00c0, vcol=0x7fdf5407d198, field_nr=<optimized out>, type=VCOL_GENERATED_STORED) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:551
      #7  0x000056431308af32 in pack_vcols (check_constraint_list=0x7fe0741a3720, create_fields=..., buf=0x7fe0741a00c0) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:574
      #8  build_frm_image (thd=0x7fdf540009a8, table=0x7fdf54075b10 "t5", create_info=0x7fe0741a3770, create_fields=..., keys=4, key_info=0x7fdf540297d0, db_file=0x7fdf54029058) at /data/src/bb-10.2-compatibility-20620/sql/unireg.cc:131
      #9  0x000056431305a388 in mysql_create_frm_image (thd=0x7fdf540009a8, db=0x7fdf54058040 "vcol_timestamp", db@entry=0x7fdf54076158 "test", table_name=0x7fdf5407d120 "", table_name@entry=0x7fdf54075b10 "t5", create_info=0x35, create_info@entry=0x7fe0741a3770, alter_info=0xffffffffffffffff, alter_info@entry=0x7fe0741a36c0, create_table_mode=0, create_table_mode@entry=-2, key_info=0x7fe0741a1ea0, key_count=0x7fe0741a1e7c, frm=0x7fe0741a1eb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4527
      #10 0x000056431305df7e in create_table_impl (thd=thd@entry=0x7fdf540009a8, orig_db=0x7fdf54076158 "test", orig_table_name=0x7fdf54075b10 "t5", db=0x7fdf54076158 "test", table_name=table_name@entry=0x7fe0741a2bd0 "#sql-71a9_9", path=path@entry=0x7fe0741a343c "./test/#sql-71a9_9", options=..., create_info=0x7fe0741a3770, alter_info=0x7fe0741a36c0, create_table_mode=-2, is_trans=0x0, key_info=0x7fe0741a1ea0, key_count=0x7fe0741a1e7c, frm=0x7fe0741a1eb0) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:4763
      #11 0x00005643130603f5 in mysql_alter_table (thd=0x7fdf540009a8, new_db=<optimized out>, new_name=<optimized out>, create_info=0x7fe0741a3770, table_list=0x7fdf54075b48, alter_info=0x7fe0741a36c0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_table.cc:9095
      #12 0x00005643130a9bd5 in Sql_cmd_alter_table::execute (this=0x7fdefff8204e, thd=0x7fdf540009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_alter.cc:330
      #13 0x0000564312fd39e2 in mysql_execute_command (thd=0x7fdf540009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:6254
      #14 0x0000564312fec827 in Prepared_statement::execute (this=0x7fdf540c9098, expanded_query=<optimized out>, open_cursor=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4742
      #15 0x0000564312fec96e in Prepared_statement::execute_loop (this=0x7fe0741a5b60, expanded_query=0x1, open_cursor=32, packet_end=<optimized out>, packet=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:4172
      #16 0x0000564312fece52 in mysql_sql_stmt_execute (thd=0x7fdf540009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_prepare.cc:3278
      #17 0x0000564312fd54ff in mysql_execute_command (thd=0x7fdf540009a8) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:3752
      #18 0x0000564312fda30d in mysql_parse (thd=0x7fdf540009a8, rawbuf=<optimized out>, length=22, parser_state=0x7fe0741a7260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:7978
      #19 0x0000564312fdcd71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fdf540009a8, packet=packet@entry=0x7fdf54006fd9 "EXECUTE converter_stmt", packet_length=packet_length@entry=22, is_com_multi=is_c
      om_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility-20620/sql/sql_parse.cc:1835
      

      Attachments

        1. self2a.test.gz
          1.01 MB
          Elena Stepanova

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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