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

sql/protocol.cc:532: void Protocol::end_statement(): Assertion `0' failed

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.18, 10.1, 10.2
    • Fix Version/s: 10.1.20, 10.1.21
    • Component/s: Optimizer
    • Labels:
      None
    • Sprint:
      10.2.4-1

      Description

      How to repeat
      Start server with @@optimizer_use_condition_selectivity=4 and execute the following commands:

      --source include/have_innodb.inc
       
      drop table if exists t1, t2;
      drop view if exists v1;
       
      create table t1 (a int not null, b int, c int) engine=InnoDB;
      create trigger trgi before insert on t1 for each row set new.a=if(new.a is null,new.b,new.c);
       
      create table t2 (d int, e int) engine=InnoDB;
      update t1, t2 set a=NULL, b=2, c=NULL where b=d and e=200;
       
      create view v1 as select * from t1, t2 where d=2;
      insert v1 (a,c) values (NULL, 20);
      

      Stacktrace

      mysqld: /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532: void Protocol::end_statement(): Assertion `0' failed.
       
      Thread 28 "mysqld" received signal SIGABRT, Aborted.
      [Switching to Thread 0x7fffec473b00 (LWP 7029)]
      0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      54	../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
      (gdb) bt
      #0  0x00007ffff6498418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #1  0x00007ffff649a01a in __GI_abort () at abort.c:89
      #2  0x00007ffff6490bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x555556362f2f "0", 
          file=file@entry=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc", 
          line=line@entry=532, 
          function=function@entry=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()") at assert.c:92
      #3  0x00007ffff6490c82 in __GI___assert_fail (assertion=0x555556362f2f "0", 
          file=0x555556363020 "/home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc", line=532, 
          function=0x555556363960 <Protocol::end_statement()::__PRETTY_FUNCTION__> "void Protocol::end_statement()")
          at assert.c:101
      #4  0x000055555596b24c in Protocol::end_statement (this=0x555557a17540)
          at /home/nirbhay/project/git-repo/mariadb/10.1/sql/protocol.cc:532
      #5  0x0000555555a211d7 in dispatch_command (command=COM_QUERY, thd=0x555557a16fb0, 
          packet=0x555557a1d811 "insert v1 (a,c) values (NULL, 20)", packet_length=33)
          at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1940
      #6  0x0000555555a1e90d in do_command (thd=0x555557a16fb0)
          at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_parse.cc:1108
      #7  0x0000555555b54ddb in do_handle_one_connection (thd_arg=0x555557a16fb0)
          at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1350
      #8  0x0000555555b54b2a in handle_one_connection (arg=0x555557a16fb0)
          at /home/nirbhay/project/git-repo/mariadb/10.1/sql/sql_connect.cc:1262
      #9  0x00007ffff6ebe6fa in start_thread (arg=0x7fffec473b00) at pthread_create.c:333
      #10 0x00007ffff6569b5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      The following tests in the main suite also fail due to this issue (when started with -mysqld=-optimizer_use_condition_selectivity=4):

      • main.strict
      • main.gis
      • main.ps_2myisam
      • main.ps_3innodb
      • main.ps_4heap
      • main.trigger_null-8605
      • main.view

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                varun Varun Gupta
                Reporter:
                nirbhay_c Nirbhay Choubey (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: