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

Assertion `f->real_type() == MYSQL_TYPE_VARCHAR' failed in PFS_engine_table::set_field_varchar_utf8 upon querying perfschema under 'test_completely_invisible'

    XMLWordPrintable

Details

    • 10.3.6-1

    Description

      CREATE TABLE t1 (i INT);
      SET debug_dbug= "+d,test_completely_invisible";
      SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name STRAIGHT_JOIN t1 ON ( i = SUM_TIMER_WAIT );
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 926adcfeea

      mysqld: /data/src/10.3/storage/perfschema/pfs_engine_table.cc:377: static void PFS_engine_table::set_field_varchar_utf8(Field*, const char*, uint): Assertion `f->real_type() == MYSQL_TYPE_VARCHAR' failed.
      180131  0:16:37 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8cbfff0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055ea0ae6386e in PFS_engine_table::set_field_varchar_utf8 (f=0x7f8ca8117458, str=0x55ea0e1f7110 "stage/sql/After apply log event", len=31) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:377
      #9  0x000055ea0ae75441 in PFS_event_name_row::set_field (this=0x7f8ca8073650, f=0x7f8ca8117458) at /data/src/10.3/storage/perfschema/table_helper.h:165
      #10 0x000055ea0ae75287 in table_esgs_by_account_by_event_name::read_row_values (this=0x7f8ca8073460, table=0x7f8ca80fe670, buf=0x7f8ca8116c68 "\002", fields=0x7f8ca8117248, read_all=false) at /data/src/10.3/storage/perfschema/table_esgs_by_account_by_event_name.cc:181
      #11 0x000055ea0ae6341b in PFS_engine_table::read_row (this=0x7f8ca8073460, table=0x7f8ca80fe670, buf=0x7f8ca8116c68 "\002", fields=0x7f8ca8117238) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:271
      #12 0x000055ea0ae600fc in ha_perfschema::rnd_next (this=0x7f8ca81183c8, buf=0x7f8ca8116c68 "\002") at /data/src/10.3/storage/perfschema/ha_perfschema.cc:347
      #13 0x000055ea0ab80bf8 in handler::ha_rnd_next (this=0x7f8ca81183c8, buf=0x7f8ca8116c68 "\002") at /data/src/10.3/sql/handler.cc:2760
      #14 0x000055ea0acfe1be in rr_sequential (info=0x7f8ca814b4f0) at /data/src/10.3/sql/records.cc:485
      #15 0x000055ea0a8072c1 in READ_RECORD::read_record (this=0x7f8ca814b4f0) at /data/src/10.3/sql/records.h:73
      #16 0x000055ea0a90a783 in join_init_read_record (tab=0x7f8ca814b428) at /data/src/10.3/sql/sql_select.cc:20222
      #17 0x000055ea0a908544 in sub_select (join=0x7f8ca8018d10, join_tab=0x7f8ca814b428, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:19296
      #18 0x000055ea0a907b0f in do_select (join=0x7f8ca8018d10, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18839
      #19 0x000055ea0a8e0d0e in JOIN::exec_inner (this=0x7f8ca8018d10) at /data/src/10.3/sql/sql_select.cc:4061
      #20 0x000055ea0a8dff7a in JOIN::exec (this=0x7f8ca8018d10) at /data/src/10.3/sql/sql_select.cc:3844
      #21 0x000055ea0a8e13f3 in mysql_select (thd=0x7f8ca8000b00, tables=0x7f8ca8014f60, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8ca8018cf0, unit=0x7f8ca8004890, select_lex=0x7f8ca8004fe8) at /data/src/10.3/sql/sql_select.cc:4260
      #22 0x000055ea0a8d3316 in handle_select (thd=0x7f8ca8000b00, lex=0x7f8ca80047c8, result=0x7f8ca8018cf0, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
      #23 0x000055ea0a89e112 in execute_sqlcom_select (thd=0x7f8ca8000b00, all_tables=0x7f8ca8014f60) at /data/src/10.3/sql/sql_parse.cc:6531
      #24 0x000055ea0a8947fc in mysql_execute_command (thd=0x7f8ca8000b00) at /data/src/10.3/sql/sql_parse.cc:3752
      #25 0x000055ea0a8a1a66 in mysql_parse (thd=0x7f8ca8000b00, rawbuf=0x7f8ca8014c38 "SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name STRAIGHT_JOIN t1 ON ( i = SUM_TIMER_WAIT )", length=122, parser_state=0x7f8cba25f5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7988
      #26 0x000055ea0a88f27f in dispatch_command (command=COM_QUERY, thd=0x7f8ca8000b00, packet=0x7f8ca800b141 "", packet_length=122, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
      #27 0x000055ea0a88dcb3 in do_command (thd=0x7f8ca8000b00) at /data/src/10.3/sql/sql_parse.cc:1370
      #28 0x000055ea0a9f5796 in do_handle_one_connection (connect=0x55ea0e4e7dd0) at /data/src/10.3/sql/sql_connect.cc:1401
      #29 0x000055ea0a9f5523 in handle_one_connection (arg=0x55ea0e4e7dd0) at /data/src/10.3/sql/sql_connect.cc:1307
      #30 0x000055ea0ae930b8 in pfs_spawn_thread (arg=0x55ea0e5035b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #31 0x00007f8cc1cc7494 in start_thread (arg=0x7f8cba260700) at pthread_create.c:333
      #32 0x00007f8cc00ad93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      I also had this one, probably the same cause:

      mysqld: /home/travis/src/storage/perfschema/pfs_engine_table.cc:361: static void PFS_engine_table::set_field_ulonglong(Field*, ulonglong): Assertion `f->real_type() == MYSQL_TYPE_LONGLONG' failed.
      180130 18:36:54 [ERROR] mysqld got signal 6 ;
      

      Attachments

        Issue Links

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              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.