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

Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon event with NOWAIT and SET STATEMENT

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t1 (a INT);
      CREATE PROCEDURE sp() BEGIN END;
      --delimiter $
      CREATE EVENT ev ON SCHEDULE EVERY 1 SECOND 
      DO 
        CALL sp;
        ALTER TABLE t1 NOWAIT;
        SET STATEMENT lock_wait_timeout=1 FOR ALTER TABLE t1 ADD b INT
      $
      --delimiter ;
       
      # Cleanup
      DROP EVENT ev;
      DROP PROCEDURE sp;
      DROP TABLE t1;
      

      10.3 e1dc05a69

      mysqld: /data/src/10.3/sql/sql_lex.cc:4926: bool LEX::set_arena_for_set_stmt(Query_arena*): Assertion `arena_for_set_stmt== 0' failed.
      181114 13:31:22 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fbe97844ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000056302da982d8 in LEX::set_arena_for_set_stmt (this=0x7fbe800048e8, backup=0x7fbe919ea6d0) at /data/src/10.3/sql/sql_lex.cc:4926
      #9  0x000056302dabd05e in mysql_execute_command (thd=0x7fbe80000b00) at /data/src/10.3/sql/sql_parse.cc:3481
      #10 0x000056302dacba09 in mysql_parse (thd=0x7fbe80000b00, rawbuf=0x7fbe80014d28 "SET STATEMENT lock_wait_timeout=1 FOR ALTER TABLE t1 ADD b INT", length=62, parser_state=0x7fbe919eb5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
      #11 0x000056302dab9081 in dispatch_command (command=COM_QUERY, thd=0x7fbe80000b00, packet=0x7fbe8000b1e1 "", packet_length=143, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1940
      #12 0x000056302dab75f3 in do_command (thd=0x7fbe80000b00) at /data/src/10.3/sql/sql_parse.cc:1395
      #13 0x000056302dc1f07a in do_handle_one_connection (connect=0x5630315fdb30) at /data/src/10.3/sql/sql_connect.cc:1402
      #14 0x000056302dc1edfe in handle_one_connection (arg=0x5630315fdb30) at /data/src/10.3/sql/sql_connect.cc:1308
      #15 0x000056302e0b3053 in pfs_spawn_thread (arg=0x563031611490) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #16 0x00007fbe99300494 in start_thread (arg=0x7fbe919ec700) at pthread_create.c:333
      #17 0x00007fbe9790193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      No visible effect on non-debug builds.
      The test case is not applicable to 10.2 and earlier, because they don't have NOWAIT, and I don't know what it could be replaced with to keep the test failing.

        Attachments

          Activity

            People

            • Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: