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

Assertion Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' or `! is_set()' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0(EOL), 10.1(EOL), 10.2(EOL)
    • 10.0.33, 10.1.27, 10.2.9
    • Views
    • None

    Description

      SET sql_mode= 'STRICT_ALL_TABLES';
      CREATE TABLE t1 (f1 INT DEFAULT 0, f2 INT);
      CREATE ALGORITHM = MERGE VIEW v1 AS SELECT f1, f2 FROM t1 WHERE f1 = '' WITH CHECK OPTION;
      REPLACE INTO v1 SET f2 = 1;
       
      # Cleanup
      DROP VIEW v1;
      DROP TABLE t1;
      

      10.2 5ff2db7f67401511b30dbd3fc69a1ea87d7e8cc4

      mysqld: /data/src/10.2/sql/sql_error.cc:380: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
      170711  2:14:22 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f1067baa312 in __GI___assert_fail (assertion=0x7f106aec3db0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x7f106aec3ce8 "/data/src/10.2/sql/sql_error.cc", line=380, function=0x7f106aec4200 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x00007f106a435d3d in Diagnostics_area::set_ok_status (this=0x7f1050005b18, affected_rows=1, last_insert_id=0, message=0x0) at /data/src/10.2/sql/sql_error.cc:380
      #9  0x00007f106a3e914d in my_ok (thd=0x7f1050000b00, affected_rows=1, id=0, message=0x0) at /data/src/10.2/sql/sql_class.h:4334
      #10 0x00007f106a43e28f in mysql_insert (thd=0x7f1050000b00, table_list=0x7f1050012460, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /data/src/10.2/sql/sql_insert.cc:1215
      #11 0x00007f106a464d44 in mysql_execute_command (thd=0x7f1050000b00) at /data/src/10.2/sql/sql_parse.cc:4416
      #12 0x00007f106a46fd88 in mysql_parse (thd=0x7f1050000b00, rawbuf=0x7f1050012378 "REPLACE INTO v1 SET f2 = 1", length=26, parser_state=0x7f1062059200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879
      #13 0x00007f106a45de34 in dispatch_command (command=COM_QUERY, thd=0x7f1050000b00, packet=0x7f10501631c1 "REPLACE INTO v1 SET f2 = 1", packet_length=26, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817
      #14 0x00007f106a45c775 in do_command (thd=0x7f1050000b00) at /data/src/10.2/sql/sql_parse.cc:1362
      #15 0x00007f106a5a84e7 in do_handle_one_connection (connect=0x7f106d7b69f0) at /data/src/10.2/sql/sql_connect.cc:1354
      #16 0x00007f106a5a8274 in handle_one_connection (arg=0x7f106d7b69f0) at /data/src/10.2/sql/sql_connect.cc:1260
      #17 0x00007f106a8ef870 in pfs_spawn_thread (arg=0x7f106d8510a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #18 0x00007f1069a7f064 in start_thread (arg=0x7f106205a700) at pthread_create.c:309
      #19 0x00007f1067c6462d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      10.1 9e11e055ce1461caecbb30e8300dfdcd48af22f1

      mysqld: /data/src/10.1/sql/sql_error.cc:378: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
      170711  2:13:38 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f155fcb8266 in __assert_fail_base (fmt=0x7f155fdf0f18 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f1562ddc6c0 "! is_set()", file=file@entry=0x7f1562ddc5f8 "/data/src/10.1/sql/sql_error.cc", line=line@entry=378, function=function@entry=0x7f1562ddcac0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
      #7  0x00007f155fcb8312 in __GI___assert_fail (assertion=0x7f1562ddc6c0 "! is_set()", file=0x7f1562ddc5f8 "/data/src/10.1/sql/sql_error.cc", line=378, function=0x7f1562ddcac0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x00007f156249a50a in Diagnostics_area::set_ok_status (this=0x7f1558ffee90, affected_rows=1, last_insert_id=0, message=0x0) at /data/src/10.1/sql/sql_error.cc:378
      #9  0x00007f1562453c25 in my_ok (thd=0x7f1558ffa070, affected_rows=1, id=0, message=0x0) at /data/src/10.1/sql/sql_class.h:4071
      #10 0x00007f15624a23ae in mysql_insert (thd=0x7f1558ffa070, table_list=0x7f1557043170, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /data/src/10.1/sql/sql_insert.cc:1196
      #11 0x00007f15624c5ee1 in mysql_execute_command (thd=0x7f1558ffa070) at /data/src/10.1/sql/sql_parse.cc:3925
      #12 0x00007f15624d0871 in mysql_parse (thd=0x7f1558ffa070, rawbuf=0x7f1557043088 "REPLACE INTO v1 SET f2 = 1", length=26, parser_state=0x7f15633db5e0) at /data/src/10.1/sql/sql_parse.cc:7339
      #13 0x00007f15624bf85c in dispatch_command (command=COM_QUERY, thd=0x7f1558ffa070, packet=0x7f155a93e071 "REPLACE INTO v1 SET f2 = 1", packet_length=26) at /data/src/10.1/sql/sql_parse.cc:1490
      #14 0x00007f15624be5bb in do_command (thd=0x7f1558ffa070) at /data/src/10.1/sql/sql_parse.cc:1109
      #15 0x00007f15625f6125 in do_handle_one_connection (thd_arg=0x7f1558ffa070) at /data/src/10.1/sql/sql_connect.cc:1349
      #16 0x00007f15625f5e89 in handle_one_connection (arg=0x7f1558ffa070) at /data/src/10.1/sql/sql_connect.cc:1261
      #17 0x00007f15628da1bc in pfs_spawn_thread (arg=0x7f155f427ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1860
      #18 0x00007f1561bba064 in start_thread (arg=0x7f15633dcb00) at pthread_create.c:309
      #19 0x00007f155fd7262d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Not reproducible on 10.0, MySQL 5.6/5.7.

      Note: there is MDEV-11779 which seems to have the same exact assertion failures; but there is also difference – MDEV-11779 is said to be reproducible on 10.0, it happens upon CREATE TABLE, and stack trace is also somewhat different. Given all that, I'm filing this one separately.

      Attachments

        Activity

          People

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