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

Assertion `slave == 0' failed in st_select_lex_node::attach_single

Details

    Description

      CREATE TABLE t (a INT);
      INSERT t WITH cte AS (SELECT 1) SELECT * FROM cte RETURNING *;
       
      # Cleanup
      DROP TABLE t;
      

      10.5 3a211624

      mariadbd: /data/src/10.5/sql/sql_lex.cc:3049: void st_select_lex_node::attach_single(st_select_lex_node*): Assertion `slave == 0' failed.
      221003 13:11:11 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8a461fe662 in __GI___assert_fail (assertion=0x5574478aac80 "slave == 0", file=0x55744789d5a0 "/data/src/10.5/sql/sql_lex.cc", line=3049, function=0x5574478aacc0 "void st_select_lex_node::attach_single(st_select_lex_node*)") at assert.c:101
      #8  0x00005574458a54d9 in st_select_lex_node::attach_single (this=0x62b000086a40, slave_arg=0x62b000088018) at /data/src/10.5/sql/sql_lex.cc:3049
      #9  0x0000557445fc3792 in MYSQLparse (thd=0x62b00007e218) at /data/src/10.5/sql/sql_yacc.yy:13367
      #10 0x000055744594eb72 in parse_sql (thd=0x62b00007e218, parser_state=0x7f8a25a4ec30, creation_ctx=0x0, do_pfs_digest=true) at /data/src/10.5/sql/sql_parse.cc:10472
      #11 0x000055744593fada in mysql_parse (thd=0x62b00007e218, rawbuf=0x62b000085238 "INSERT t WITH cte AS (SELECT 1) SELECT * FROM cte RETURNING *", length=61, parser_state=0x7f8a25a4ec30, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8039
      #12 0x0000557445916612 in dispatch_command (command=COM_QUERY, thd=0x62b00007e218, packet=0x629000267219 "INSERT t WITH cte AS (SELECT 1) SELECT * FROM cte RETURNING *", packet_length=61, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
      #13 0x000055744591302f in do_command (thd=0x62b00007e218) at /data/src/10.5/sql/sql_parse.cc:1375
      #14 0x0000557445d4e3f3 in do_handle_one_connection (connect=0x608000002538, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1416
      #15 0x0000557445d4dd90 in handle_one_connection (arg=0x6080000024b8) at /data/src/10.5/sql/sql_connect.cc:1318
      #16 0x0000557446972d5c in pfs_spawn_thread (arg=0x61500000c618) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #17 0x00007f8a466dcea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #18 0x00007f8a462c9aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      The failure started happening on 10.5 branch after this merge

      commit 3a2116241b128b811ee2455845ff9710da3115ac (HEAD -> 10.5, origin/bb-10.5-serg, origin/10.5)
      Merge: e29fb956145 d4f6d2f08f2
      Author: Sergei Golubchik
      Date:   Sun Oct 2 14:38:13 2022 +0200
       
          Merge branch '10.4' into 10.5
      

      but since the test case is not applicable to earlier versions due to the use of INSERT .. RETURNING, I can't bisect inside the merge. There are a couple commits in there which look to me as they could be related.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              sanja Oleksandr Byelkin
              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.