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)
• Status: Duplicate
• 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.