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

Server crashes in reinit_stmt_before_use on 2nd execution of PS or SP

    XMLWordPrintable

    Details

      Description

      Stack trace from 10.2 1168e2fa54

      #3  <signal handler called>
      #4  0x00007f674460336b in reinit_stmt_before_use (thd=0x7f6739016070, lex=0x7f67391d0090) at /data/src/10.2/sql/sql_prepare.cc:2817
      #5  0x00007f6744606cbf in Prepared_statement::execute (this=0x7f6739156470, expanded_query=0x7f674553a180, open_cursor=false) at /data/src/10.2/sql/sql_prepare.cc:4256
      #6  0x00007f6744605c25 in Prepared_statement::execute_loop (this=0x7f6739156470, expanded_query=0x7f674553a180, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.2/sql/sql_prepare.cc:3912
      #7  0x00007f6744603c71 in mysql_sql_stmt_execute (thd=0x7f6739016070) at /data/src/10.2/sql/sql_prepare.cc:3039
      #8  0x00007f67445de79f in mysql_execute_command (thd=0x7f6739016070) at /data/src/10.2/sql/sql_parse.cc:3387
      #9  0x00007f67445ec0d7 in mysql_parse (thd=0x7f6739016070, rawbuf=0x7f6739064088 "EXECUTE stmt", length=12, parser_state=0x7f674553add0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7774
      #10 0x00007f67445da4c5 in dispatch_command (command=COM_QUERY, thd=0x7f6739016070, packet=0x7f6739058071 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805
      #11 0x00007f67445d8ef6 in do_command (thd=0x7f6739016070) at /data/src/10.2/sql/sql_parse.cc:1365
      #12 0x00007f67447147ba in do_handle_one_connection (connect=0x7f674146d410) at /data/src/10.2/sql/sql_connect.cc:1354
      #13 0x00007f6744714547 in handle_one_connection (arg=0x7f674146d410) at /data/src/10.2/sql/sql_connect.cc:1260
      #14 0x00007f6744a22b26 in pfs_spawn_thread (arg=0x7f67414519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #15 0x00007f6743c5d0a4 in start_thread (arg=0x7f674553c300) at pthread_create.c:309
      #16 0x00007f6741e1587d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Test case

      CREATE FUNCTION f (in1 INT) RETURNS INT RETURN in1;
      CREATE OR REPLACE VIEW v AS SELECT 1;
      PREPARE stmt FROM "SELECT * FROM v WHERE f(0)";
      EXECUTE stmt;
      EXECUTE stmt;
      

      The problem started happening after recent merges, but I can't point at the exact commit which caused it.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration