Bug #46902 Assertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum()
Submitted: 24 Aug 2009 21:35 Modified: 4 Jan 2011 14:33
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.30-debug, 5.1.39-debug, 5.4.4-debug, 6.0.12-debug OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: assertion, regression

[24 Aug 2009 21:35] Shane Bester
Description:
inserting negative auto_increment values causes this error in debug binary;

Version: '5.1.39-debug'  socket: ''  port: 3306  Source distribution
Assertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum(), file .\handler.cc, line 2295

mysqld.exe!my_sigabrt_handler()[mysqld.cc:2029]
mysqld.exe!raise()[winsig.c:590]
mysqld.exe!abort()[abort.c:71]
mysqld.exe!_wassert()[assert.c:212]
mysqld.exe!handler::update_auto_increment()[handler.cc:2295]
mysqld.exe!ha_myisam::write_row()[ha_myisam.cc:769]
mysqld.exe!handler::ha_write_row()[handler.cc:4623]
mysqld.exe!write_record()[sql_insert.cc:1581]
mysqld.exe!mysql_insert()[sql_insert.cc:810]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3139]
mysqld.exe!mysql_parse()[sql_parse.cc:5931]
mysqld.exe!dispatch_command()[sql_parse.cc:1213]
mysqld.exe!do_command()[sql_parse.cc:854]
mysqld.exe!handle_one_connection()[sql_connect.cc:1127]
mysqld.exe!pthread_start()[my_winthread.c:87]
mysqld.exe!_callthreadstart()[thread.c:293]
mysqld.exe!_threadstart()[thread.c:277]
kernel32.dll!FlsSetValue()

5.0.86-debug was not affected.

How to repeat:
drop table if exists t1;
create table t1(a int auto_increment primary key)engine=myisam;
insert into t1 values (0),(-1),(-1);
[25 Aug 2009 4:22] Valeriy Kravchuk
Verified just as described, also - with recent 5.4.4 (next).
[4 Jan 2011 14:33] Jon Olav Hauglid
Closing this bug as a duplicate of Bug#50619.