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

Assertion `! is_set() ' failed in Diagnostics_area::set_ok_status on killing CREATE OR REPLACE

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.12
    • 10.0.14
    • None
    • None

    Description

      Note: it might be related to MDEV-6525

      10.0/sql/sql_error.cc:377: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
      140811 20:45:36 [ERROR] mysqld got signal 6 ;

      #6  0x00007f4aad4616f1 in *__GI___assert_fail (assertion=0xf282af "! is_set()", file=<optimized out>, line=377, function=0xf28ec0 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:81
      #7  0x00000000006543ae in Diagnostics_area::set_ok_status (this=0x7f4aa1e180d8, affected_rows=0, last_insert_id=0, message=0x0) at 10.0/sql/sql_error.cc:377
      #8  0x0000000000611718 in my_ok (thd=0x7f4aa1e13070, affected_rows=0, id=0, message=0x0) at 10.0/sql/sql_class.h:3756
      #9  0x0000000000679ca4 in mysql_execute_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:3031
      #10 0x0000000000682ec3 in mysql_parse (thd=0x7f4aa1e13070, rawbuf=0x7f4a9a362088 "CREATE OR REPLACE TABLE t1 LIKE tmp", length=35, parser_state=0x7f4aaf399610) at 10.0/sql/sql_parse.cc:6411
      #11 0x0000000000675d78 in dispatch_command (command=COM_QUERY, thd=0x7f4aa1e13070, packet=0x7f4aa7249071 "CREATE OR REPLACE TABLE t1 LIKE tmp", packet_length=35) at 10.0/sql/sql_parse.cc:1307
      #12 0x000000000067511d in do_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:1004
      #13 0x00000000007913d2 in do_handle_one_connection (thd_arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1379
      #14 0x0000000000791125 in handle_one_connection (arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1293
      #15 0x0000000000cc3a52 in pfs_spawn_thread (arg=0x7f4aa72410f0) at 10.0/storage/perfschema/pfs.cc:1860
      #16 0x00007f4aaf01ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #17 0x00007f4aad51220d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Stack trace from:

      revision-id: bar@mariadb.org-20140811014545-jq6i8sft8g3lr37m
      revno: 4347
      branch-nick: 10.0

      Test case:

      # You might try to run it with --repeat if it does not fail at once
       
      --source include/have_innodb.inc
       
      CREATE TABLE t1 (col_int_nokey INT)  ENGINE=InnoDB;
       
      --let $con_id = `SELECT CONNECTION_ID()`
      CREATE OR REPLACE TEMPORARY TABLE tmp LIKE t1;
      LOCK TABLE t1 WRITE;
       
      --connect (con1,localhost,root,,test)
       
      --connection default
      --send
        CREATE OR REPLACE TABLE t1 LIKE tmp;
       
      --connection con1
      eval KILL QUERY $con_id;
       

      Attachments

        Activity

          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Description _Note: it might be related to MDEV-6525_

          {noformat}
          10.0/sql/sql_error.cc:377: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
          140811 20:45:36 [ERROR] mysqld got signal 6 ;
          {noformat}
          {noformat}
          #6 0x00007f4aad4616f1 in *__GI___assert_fail (assertion=0xf282af "! is_set()", file=<optimized out>, line=377, function=0xf28ec0 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:81
          #7 0x00000000006543ae in Diagnostics_area::set_ok_status (this=0x7f4aa1e180d8, affected_rows=0, last_insert_id=0, message=0x0) at 10.0/sql/sql_error.cc:377
          #8 0x0000000000611718 in my_ok (thd=0x7f4aa1e13070, affected_rows=0, id=0, message=0x0) at 10.0/sql/sql_class.h:3756
          #9 0x0000000000679ca4 in mysql_execute_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:3031
          #10 0x0000000000682ec3 in mysql_parse (thd=0x7f4aa1e13070, rawbuf=0x7f4a9a362088 "CREATE OR REPLACE TABLE t1 LIKE tmp", length=35, parser_state=0x7f4aaf399610) at 10.0/sql/sql_parse.cc:6411
          #11 0x0000000000675d78 in dispatch_command (command=COM_QUERY, thd=0x7f4aa1e13070, packet=0x7f4aa7249071 "CREATE OR REPLACE TABLE t1 LIKE tmp", packet_length=35) at 10.0/sql/sql_parse.cc:1307
          #12 0x000000000067511d in do_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:1004
          #13 0x00000000007913d2 in do_handle_one_connection (thd_arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1379
          #14 0x0000000000791125 in handle_one_connection (arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1293
          #15 0x0000000000cc3a52 in pfs_spawn_thread (arg=0x7f4aa72410f0) at 10.0/storage/perfschema/pfs.cc:1860
          #16 0x00007f4aaf01ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
          #17 0x00007f4aad51220d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
          {noformat}

          Stack trace from:
          {noformat}
          revision-id: bar@mariadb.org-20140811014545-jq6i8sft8g3lr37m
          revno: 4347
          branch-nick: 10.0
          {noformat}

          Test case:
          {code:sql}
          # You might try to run it with --repeat if it does not fail at once

          --source include/have_innodb.inc

          CREATE TABLE t1 (
            col_int_nokey INT
            ) ENGINE=InnoDB;

          --let $con_id = `SELECT CONNECTION_ID()`
          CREATE OR REPLACE TEMPORARY TABLE tmp LIKE t1;
          LOCK TABLE t1 WRITE;

          --connect (con1,localhost,root,,test)

          --connection default
          --send
            CREATE OR REPLACE TABLE t1 LIKE tmp;

          --connection con1
          eval KILL QUERY $con_id;

          {code}
          _Note: it might be related to MDEV-6525_

          {noformat}
          10.0/sql/sql_error.cc:377: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
          140811 20:45:36 [ERROR] mysqld got signal 6 ;
          {noformat}
          {noformat}
          #6 0x00007f4aad4616f1 in *__GI___assert_fail (assertion=0xf282af "! is_set()", file=<optimized out>, line=377, function=0xf28ec0 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:81
          #7 0x00000000006543ae in Diagnostics_area::set_ok_status (this=0x7f4aa1e180d8, affected_rows=0, last_insert_id=0, message=0x0) at 10.0/sql/sql_error.cc:377
          #8 0x0000000000611718 in my_ok (thd=0x7f4aa1e13070, affected_rows=0, id=0, message=0x0) at 10.0/sql/sql_class.h:3756
          #9 0x0000000000679ca4 in mysql_execute_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:3031
          #10 0x0000000000682ec3 in mysql_parse (thd=0x7f4aa1e13070, rawbuf=0x7f4a9a362088 "CREATE OR REPLACE TABLE t1 LIKE tmp", length=35, parser_state=0x7f4aaf399610) at 10.0/sql/sql_parse.cc:6411
          #11 0x0000000000675d78 in dispatch_command (command=COM_QUERY, thd=0x7f4aa1e13070, packet=0x7f4aa7249071 "CREATE OR REPLACE TABLE t1 LIKE tmp", packet_length=35) at 10.0/sql/sql_parse.cc:1307
          #12 0x000000000067511d in do_command (thd=0x7f4aa1e13070) at 10.0/sql/sql_parse.cc:1004
          #13 0x00000000007913d2 in do_handle_one_connection (thd_arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1379
          #14 0x0000000000791125 in handle_one_connection (arg=0x7f4aa1e13070) at 10.0/sql/sql_connect.cc:1293
          #15 0x0000000000cc3a52 in pfs_spawn_thread (arg=0x7f4aa72410f0) at 10.0/storage/perfschema/pfs.cc:1860
          #16 0x00007f4aaf01ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
          #17 0x00007f4aad51220d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
          {noformat}

          Stack trace from:
          {noformat}
          revision-id: bar@mariadb.org-20140811014545-jq6i8sft8g3lr37m
          revno: 4347
          branch-nick: 10.0
          {noformat}

          Test case:
          {code:sql}
          # You might try to run it with --repeat if it does not fail at once

          --source include/have_innodb.inc

          CREATE TABLE t1 (col_int_nokey INT) ENGINE=InnoDB;

          --let $con_id = `SELECT CONNECTION_ID()`
          CREATE OR REPLACE TEMPORARY TABLE tmp LIKE t1;
          LOCK TABLE t1 WRITE;

          --connect (con1,localhost,root,,test)

          --connection default
          --send
            CREATE OR REPLACE TABLE t1 LIKE tmp;

          --connection con1
          eval KILL QUERY $con_id;

          {code}
          monty Michael Widenius made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          monty Michael Widenius made changes -
          Fix Version/s 10.0.14 [ 17101 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 52303 ] MariaDB v3 [ 61721 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61721 ] MariaDB v4 [ 148111 ]

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.