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

Assertion `0' fails in net_end_statement(THD*) on concurrent DML and KILL with InnoDB and PBXT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 5.1.67, 5.2.14
    • 5.1.73, 5.2.15
    • None

    Description

      mysqld: protocol.cc:527: void net_end_statement(THD*): Assertion `0' failed.
      130401 18:36:18 [ERROR] mysqld got signal 6 ;

      #5  0x00007fb5acc7eb8b in __GI_abort () at abort.c:91
      #6  0x00007fb5acc740ee in __assert_fail_base (fmt=<optimized out>, assertion=0x117677e "0", file=0x1176612 "protocol.cc", line=<optimized out>, function=<optimized out>) at assert.c:94
      #7  0x00007fb5acc74192 in __GI___assert_fail (assertion=0x117677e "0", file=0x1176612 "protocol.cc", line=527, function=0x11771f0 "void net_end_statement(THD*)") at assert.c:103
      #8  0x000000000070be72 in net_end_statement (thd=0x48ecd08) at protocol.cc:527
      #9  0x00000000007417de in dispatch_command (command=COM_QUERY, thd=0x48ecd08, packet=0x496a869 "DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_innodb_int_autoinc` WHERE `col_int_key` IN ( 60 , 'h' , 'j' , 2236153856 , 7 ) ORDER BY `col_date`,`col_date_key`,`col_datetime`,`col_datetime_key`,`col_"..., packet_length=289) at sql_parse.cc:1743
      #10 0x000000000073dd17 in do_command (thd=0x48ecd08) at sql_parse.cc:906
      #11 0x0000000000738667 in handle_one_connection (arg=0x48ecd08) at sql_connect.cc:1238
      #12 0x00007fb5ad00be9a in start_thread (arg=0x7fb5add33700) at pthread_create.c:308
      #13 0x00007fb5acd38cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      bzr version-info
      revision-id: sergii@pisem.net-20130320202051-m8qdk6zvcci9vr5s
      revno: 3194
      branch-nick: 5.1

      Tried BUILD/compile-pentium-debug-max-no-ndb and BUILD/compile-pentium-gcov.
      Also reproducible on 5.2 (make sure to build PBXT there).
      Could not reproduce on 5.3, 5.5, 10.0.

      My server command line:

      /data/bzr/5.1/sql/mysqld --no-defaults --basedir=/data/bzr/5.1 --datadir=/data/bzr/5.1/data --language=/data/bzr/5.1/sql/share/english --character-sets-dir=/data/bzr/5.1/sql/share/charsets --core-file  --socket=/data/bzr/5.1/data/test.sock --pid-file=/data/bzr/5.1/data/mysql.pid

      RQG gendata file (assertion-0.zz):

      $tables = {
      	engines => [ 'InnoDB', 'PBXT' ]
      };

      RQG command line (assuming the server is running on port 3306):

       perl ./gentest.pl --duration=600 --queries=100M --threads=10 --grammar=conf/engines/engine_stress.yy --gendata=assertion-0.zz --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test --reporter=QueryTimeout --querytimeout=2

      RQG version (sometimes can be important):

      revision-id: roel.vandepaar@percona.com-20130316061535-rkxjl6xkn7bfu0zv
      revno: 829
      branch-nick: randgen

      Attachments

        Activity

          People

            Unassigned Unassigned
            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.