[MDEV-5421] Assertion `! is_set()' fails on INSERT IGNORE when a table has no partition for a value Created: 2013-12-09  Updated: 2014-01-29  Resolved: 2014-01-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.34, 10.0.6
Fix Version/s: 5.5.35, 10.0.8

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: partioning


 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.



 Comments   
Comment by Daniel Bartholomew [ 2014-01-29 ]

http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4024

Generated at Thu Feb 08 07:04:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.