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

Assertion `! is_set()' fails on INSERT IGNORE when a table has no partition for a value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.34, 10.0.6
    • 5.5.35, 10.0.8
    • None

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (i INT) ENGINE=MyISAM
      PARTITION BY RANGE (i) (
        PARTITION p00 VALUES LESS THAN (1),
        PARTITION p01 VALUES LESS THAN (2)
      );
       
      INSERT IGNORE INTO t1 VALUES (3);

      Version: '5.5.35-MariaDB-debug-log'  socket: '5.5/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      mysqld: 5.5/sql/sql_error.cc:362: void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
      131209 19:50:00 [ERROR] mysqld got signal 6 ;

      #6  0x00007f56eb341621 in *__GI___assert_fail (assertion=0xd67486 "! is_set()", file=<optimized out>, line=362, function=0xd67f40 "void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*)") at assert.c:81
      #7  0x000000000060c265 in Diagnostics_area::set_ok_status (this=0x7f56e6a7f690, thd=0x7f56e6a7b060, affected_rows_arg=0, last_insert_id_arg=0, message_arg=0x0) at 5.5/sql/sql_error.cc:362
      #8  0x00000000005c9b54 in my_ok (thd=0x7f56e6a7b060, affected_rows=0, id=0, message=0x0) at 5.5/sql/sql_class.h:3163
      #9  0x0000000000612f46 in mysql_insert (thd=0x7f56e6a7b060, table_list=0x7f56e60d9168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at 5.5/sql/sql_insert.cc:1135
      #10 0x0000000000630c32 in mysql_execute_command (thd=0x7f56e6a7b060) at 5.5/sql/sql_parse.cc:2971
      #11 0x0000000000638622 in mysql_parse (thd=0x7f56e6a7b060, rawbuf=0x7f56e60d9078 "INSERT IGNORE INTO t1 VALUES (3)", length=32, parser_state=0x7f56ecc6e630) at 5.5/sql/sql_parse.cc:5798
      #12 0x000000000062c643 in dispatch_command (command=COM_QUERY, thd=0x7f56e6a7b060, packet=0x7f56e6bd7061 "INSERT IGNORE INTO t1 VALUES (3)", packet_length=32) at 5.5/sql/sql_parse.cc:1078
      #13 0x000000000062b7e6 in do_command (thd=0x7f56e6a7b060) at 5.5/sql/sql_parse.cc:793
      #14 0x000000000072ce2a in do_handle_one_connection (thd_arg=0x7f56e6a7b060) at 5.5/sql/sql_connect.cc:1266
      #15 0x000000000072c8e9 in handle_one_connection (arg=0x7f56e6a7b060) at 5.5/sql/sql_connect.cc:1181
      #16 0x0000000000984bd1 in pfs_spawn_thread (arg=0x7f56e6a82a80) at 5.5/storage/perfschema/pfs.cc:1015
      #17 0x00007f56ec8a1b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #18 0x00007f56eb3f0a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      revision-id: monty@askmonty.org-20131202202243-4cmcfmthkyggmpw5
      date: 2013-12-02 22:22:43 +0200
      build-date: 2013-12-09 19:51:09 +0400
      revno: 3993
      branch-nick: 5.5

      Could not reproduce on MySQL 5.5 or 5.6.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            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.