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

Server crashes in JOIN::prepare / setup_fields on 2nd execution of PS

    XMLWordPrintable

    Details

      Description

      Note: The problem seems to be reproducible only with system_versioning_force; if I use explicit WITH SYSTEM VERSIONING clauses instead, it stops crashing. So, if it's only about the implementation of the variable, and if the variable is going to be present only in debug builds, please feel free to decrease the priority (although it should be eventually fixed anyway).

      SET system_versioning_force= ON;
       
      CREATE OR REPLACE TABLE t1 (i int);
       
      PREPARE ps FROM 'CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1';
      EXECUTE ps;
      EXECUTE ps;
       
      # Cleanup
      DROP TABLE IF EXISTS t1, t2;
      

      bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8

      #3  <signal handler called>
      #4  setup_fields (thd=0x7f3c5c000b00, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7f3c5c0153a0, pre_fix=0x7f3c5c081c78, allow_sum_func=true) at /data/src/bb-10.3-temporal/sql/sql_base.cc:7160
      #5  0x000055940709aa69 in JOIN::prepare (this=0x7f3c5c015080, tables_init=0x7f3c5c0832d0, wild_num=0, conds_init=0x7f3c5c083bd8, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f3c5c081b40, unit_arg=0x7f3c5c0813e8) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1233
      #6  0x00005594070a57f1 in mysql_select (thd=0x7f3c5c000b00, tables=0x7f3c5c0832d0, wild_num=0, fields=..., conds=0x7f3c5c083bd8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f3c5c014f88, unit=0x7f3c5c0813e8, select_lex=0x7f3c5c081b40) at /data/src/bb-10.3-temporal/sql/sql_select.cc:4236
      #7  0x000055940709793e in handle_select (thd=0x7f3c5c000b00, lex=0x7f3c5c081320, result=0x7f3c5c014f88, setup_tables_done_option=0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:382
      #8  0x000055940705a408 in mysql_execute_command (thd=0x7f3c5c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:4220
      #9  0x0000559407084003 in Prepared_statement::execute (this=0x7f3c5c006960, expanded_query=0x7f3c6d686430, open_cursor=false) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4682
      #10 0x0000559407082420 in Prepared_statement::execute_loop (this=0x7f3c5c006960, expanded_query=0x7f3c6d686430, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4111
      #11 0x000055940708006e in mysql_sql_stmt_execute (thd=0x7f3c5c000b00) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:3218
      #12 0x000055940705912a in mysql_execute_command (thd=0x7f3c5c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3765
      #13 0x00005594070663f6 in mysql_parse (thd=0x7f3c5c000b00, rawbuf=0x7f3c5c014c48 "EXECUTE ps", length=10, parser_state=0x7f3c6d6875f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991
      #14 0x0000559407053b97 in dispatch_command (command=COM_QUERY, thd=0x7f3c5c000b00, packet=0x7f3c5c11f161 "EXECUTE ps", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825
      #15 0x00005594070525cb in do_command (thd=0x7f3c5c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
      #16 0x00005594071ba354 in do_handle_one_connection (connect=0x5594096860b0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
      #17 0x00005594071ba0e1 in handle_one_connection (arg=0x5594096860b0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
      #18 0x0000559407654c5a in pfs_spawn_thread (arg=0x5594096a1490) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
      #19 0x00007f3c750ef494 in start_thread (arg=0x7f3c6d688700) at pthread_create.c:333
      #20 0x00007f3c734d593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Also reproducible on tempesta-tech/mariadb 6d2583f5955315f9c8c1d51b39712c5949af34ae.
      Reproducible with at least MyISAM and InnoDB.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: