handler::update_auto_increment(): Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
High
|
Unassigned | |||
5.6 |
New
|
Undecided
|
Unassigned | |||
5.7 |
New
|
Undecided
|
Unassigned |
Bug Description
mysqld: /git/percona-
07:27:34 UTC - mysqld got signal 6 ;
+bt
#0 0x00007f171fc34741 in __pthread_kill (threadid=
#1 0x00000000007f9078 in my_write_core (sig=6) at /git/percona-
#2 0x00000000006b9296 in handle_fatal_signal (sig=6) at /git/percona-
#3 <signal handler called>
#4 0x00007f171e3eb5f7 in __GI_raise (sig=sig@entry=6) at ../nptl/
#5 0x00007f171e3ecce8 in __GI_abort () at abort.c:90
#6 0x00007f171e3e4566 in __assert_fail_base (fmt=0x7f171e534228 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=
#7 0x00007f171e3e4612 in __GI___assert_fail (assertion=0xb17508 "next_insert_id >= auto_inc_
#8 0x00000000006be649 in handler:
#9 0x0000000000a50ea9 in ha_partition:
#10 0x00000000006c24d2 in handler:
#11 0x00000000005800f9 in write_record (thd=thd@
#12 0x00000000005840bc in mysql_insert (thd=thd@
#13 0x0000000000598b97 in mysql_execute_
#14 0x000000000059dc13 in mysql_parse (thd=thd@
#15 0x000000000059f617 in dispatch_command (command=
#16 0x00000000005a142f in do_command (thd=0x7f16889a
#17 0x000000000064f906 in do_handle_
#18 0x000000000064f9fc in handle_
#19 0x00007f171fc2fdc5 in start_thread (arg=0x7f172024
#20 0x00007f171e4ac21d in clone () at ../sysdeps/
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT AUTO_INCREMENT,b CHAR (1),PRIMARY KEY (a))ENGINE=InnoDB PARTITION BY HASH (a) PARTITIONS 2;
insert t1 values(
First thought it may be connected with bug 1204381, but this code only reproduces in 5.5.
Does not reproduce in upstream.