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

Performance schema incompatible with PL/SQL objects

    XMLWordPrintable

Details

    Description

      SET sql_mode= ORACLE;
       
      --delimiter $
      CREATE PACKAGE pkg IS PROCEDURE sp; END $
      CREATE PACKAGE BODY pkg IS PROCEDURE sp AS BEGIN END; END $
      --delimiter ;
       
      SELECT * FROM performance_schema.objects_summary_global_by_type;
       
      # Cleanup
      DROP PACKAGE pkg;
      

      10.5 279d0120

      mariadbd: /data/src/10.5/storage/perfschema/table_helper.cc:558: void set_field_object_type(Field*, enum_object_type): Assertion `false' failed.
      230512  2:38:29 [ERROR] mysqld got signal 6 ;
       
      #8  0x00007fafa2574df2 in __GI___assert_fail (assertion=0x55eb1a75cba3 "false", file=0x55eb1a8d6df8 "/data/src/10.5/storage/perfschema/table_helper.cc", line=558, function=0x55eb1a8d6e90 "void set_field_object_type(Field*, enum_object_type)") at ./assert/assert.c:101
      #9  0x000055eb1a28484c in set_field_object_type (f=<optimized out>, object_type=<optimized out>) at /data/src/10.5/storage/perfschema/table_helper.cc:558
      #10 0x000055eb1a2865d9 in table_os_global_by_type::read_row_values (buf=<optimized out>, read_all=<optimized out>, fields=0x7faf8c195880, table=0x7faf8c1a6598, this=0x7faf8c1a6990) at /data/src/10.5/storage/perfschema/table_os_global_by_type.cc:277
      #11 table_os_global_by_type::read_row_values (this=0x7faf8c1a6990, table=0x7faf8c1a6598, buf=<optimized out>, fields=<optimized out>, read_all=false) at /data/src/10.5/storage/perfschema/table_os_global_by_type.cc:256
      #12 0x000055eb1a22f152 in ha_perfschema::rnd_next (buf=0x7faf8c101020 "", this=0x7faf8c1a5180) at /data/src/10.5/storage/perfschema/ha_perfschema.cc:361
      #13 ha_perfschema::rnd_next (this=0x7faf8c1a5180, buf=0x7faf8c101020 "") at /data/src/10.5/storage/perfschema/ha_perfschema.cc:347
      #14 0x000055eb19fb4ebf in handler::ha_rnd_next (this=0x7faf8c1a5180, buf=0x7faf8c101020 "") at /data/src/10.5/sql/handler.cc:3110
      #15 0x000055eb1a109870 in rr_sequential (info=0x7faf8c1041b0) at /data/src/10.5/sql/records.cc:519
      #16 0x000055eb19dd6ed9 in READ_RECORD::read_record (this=0x7faf8c1041b0) at /data/src/10.5/sql/records.h:80
      #17 sub_select (join=0x7faf8c0148d0, join_tab=0x7faf8c1040e8, end_of_records=<optimized out>) at /data/src/10.5/sql/sql_select.cc:21168
      #18 0x000055eb19e07176 in do_select (procedure=0x0, join=0x7faf8c0148d0) at /data/src/10.5/sql/sql_select.cc:20669
      #19 JOIN::exec_inner (this=this@entry=0x7faf8c0148d0) at /data/src/10.5/sql/sql_select.cc:4587
      #20 0x000055eb19e074e7 in JOIN::exec (this=this@entry=0x7faf8c0148d0) at /data/src/10.5/sql/sql_select.cc:4367
      #21 0x000055eb19e05526 in mysql_select (thd=thd@entry=0x7faf8c000c68, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /data/src/10.5/sql/sql_select.cc:4844
      #22 0x000055eb19e05f14 in handle_select (thd=thd@entry=0x7faf8c000c68, lex=lex@entry=0x7faf8c004b90, result=result@entry=0x7faf8c0148a8, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.5/sql/sql_select.cc:450
      #23 0x000055eb19d8b120 in execute_sqlcom_select (thd=thd@entry=0x7faf8c000c68, all_tables=0x7faf8c010ca0) at /data/src/10.5/sql/sql_parse.cc:6331
      #24 0x000055eb19d9a477 in mysql_execute_command (thd=thd@entry=0x7faf8c000c68) at /data/src/10.5/sql/sql_parse.cc:4008
      #25 0x000055eb19d9be1c in mysql_parse (thd=0x7faf8c000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_parse.cc:8106
      #26 0x000055eb19d9e275 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7faf8c000c68, packet=packet@entry=0x7faf8c0080b9 "", packet_length=packet_length@entry=63, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:1990
      #27 0x000055eb19da0852 in do_command (thd=0x7faf8c000c68) at /data/src/10.5/sql/sql_parse.cc:1375
      #28 0x000055eb19ea4dc1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55eb1dd37e38, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1416
      #29 0x000055eb19ea5245 in handle_one_connection (arg=arg@entry=0x55eb1dd37e38) at /data/src/10.5/sql/sql_connect.cc:1318
      #30 0x000055eb1a232fe4 in pfs_spawn_thread (arg=0x55eb1dccd318) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #31 0x00007fafa25c8fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #32 0x00007fafa26495bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Both debug- and non-debug builds are affected, since it's a non-debug assertion.
      Reproducible on 10.5+, including older minor releases.
      Not reproducible on 10.4.

      To reproduce outside MTR, the server should be started with --performance-schema=on, other options can remain default.

      Attachments

        Activity

          People

            bar Alexander Barkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.