Bug #75057 Assertion `auto_increment_value' failed in ha_partition::info
Submitted: 1 Dec 2014 11:10 Modified: 2 Dec 2014 5:25
Reporter: Ramesh Sivaraman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:5.6.21, 5.6.23, 5.7.6 OS:Linux (CentOS 7)
Assigned to: CPU Architecture:Any
Tags: debug

[1 Dec 2014 11:10] Ramesh Sivaraman 
Description:
*** GDB info

#0  0x00007f380a93c771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a954ea in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000726494 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f38097485c9 in raise () from /lib64/libc.so.6
#5  0x00007f3809749cd8 in abort () from /lib64/libc.so.6
#6  0x00007f3809741536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f38097415e2 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000000e1537c in ha_partition::info (this=0x7f3808c18610, flag=64) at /ssd/ramesh/mysql-server/mysql-5.6/sql/ha_partition.cc:6404
#9  0x0000000000e0ffb0 in ha_partition::write_row (this=0x7f3808c18610, buf=0x7f3765c97e40 "\f") at /ssd/ramesh/mysql-server/mysql-5.6/sql/ha_partition.cc:3926
#10 0x00000000006449e3 in handler::ha_write_row (this=0x7f3808c18610, buf=0x7f3765c97e40 "\f") at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:7273
#11 0x00000000007b4300 in write_record (thd=0x7f377775d000, table=0x7f3765c53e00, info=0x7f380aef0b00, update=0x7f380aef0b80) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1921
#12 0x00000000007b2191 in mysql_insert (thd=0x7f377775d000, table_list=0x7f3765c1f108, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1072
#13 0x00000000007d43b7 in mysql_execute_command (thd=0x7f377775d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:3443
#14 0x00000000007dbdbc in mysql_parse (thd=0x7f377775d000, rawbuf=0x7f3765c1f010 "INSERT INTO t1 VALUES(123.4567e-1)", length=34, parser_state=0x7f380aef1e70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245
#15 0x00000000007cf36f in dispatch_command (command=COM_QUERY, thd=0x7f377775d000, packet=0x7f376c266001 "INSERT INTO t1 VALUES(123.4567e-1)", packet_length=34) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332
#16 0x00000000007ce45e in do_command (thd=0x7f377775d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034
#17 0x0000000000796879 in do_handle_one_connection (thd_arg=0x7f377775d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982
#18 0x0000000000796362 in handle_one_connection (arg=0x7f377775d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898
#19 0x0000000000d71288 in pfs_spawn_thread (arg=0x7f3806ffea60) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860
#20 0x00007f380a937df3 in start_thread () from /lib64/libpthread.so.0
#21 0x00007f380980901d in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET storage_engine=MEMORY;
create table t1(id serial);
ALTER TABLE t1 PARTITION BY HASH(id)PARTITIONS 1;
insert into t1 values(9999999999999999999999999.000);
ALTER TABLE t1 ROW_FORMAT=DYNAMIC;
INSERT INTO t1 VALUES(123.4567e-1);
[1 Dec 2014 21:17] Roel Van de Paar 
Note that this bug is not confined to MEMORY only. Ref https://bugs.launchpad.net/percona-server/+bug/1384684 for info.
[2 Dec 2014 2:41] Ramesh Sivaraman 
Changed severity to S2
[2 Dec 2014 5:25] MySQL Verification Team 
Hello Ramesh Sivaraman,

Thank you for the report and test case.
Confirmed that 5.6.23/5.7.6 debug builds are affected.

Thanks,
Umesh
[2 Dec 2014 5:26] MySQL Verification Team 
// start up

scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/75057
bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/75057 --core-file --socket=/tmp/75057.sock  --port=15000 --log-error=/export/umesh/mysql-5.6.23/75057/log.err 2>&1 &

// 5.6.23 - only debug build affected

(gdb) bt
#0  0x00007f64d6420771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000b0070b in my_write_core (sig=6) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/mysys/stacktrace.c:422
#2  0x000000000077ec8c in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f64d50265c9 in raise () from /lib64/libc.so.6
#5  0x00007f64d5027cd8 in abort () from /lib64/libc.so.6
#6  0x00007f64d501f536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f64d501f5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000000e8a022 in ha_partition::info (this=0x7f647c010270, flag=64) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/ha_partition.cc:6439
#9  0x0000000000e84cab in ha_partition::write_row (this=0x7f647c010270, buf=0x7f647c011a00 "\f") at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/ha_partition.cc:3961
#10 0x0000000000699b14 in handler::ha_write_row (this=0x7f647c010270, buf=0x7f647c011a00 "\f") at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/handler.cc:7273
#11 0x000000000080f368 in write_record (thd=0x36109f0, table=0x7f647c017cf0, info=0x7f64abde7f00, update=0x7f64abde7e80)
    at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_insert.cc:1921
#12 0x000000000080d16f in mysql_insert (thd=0x36109f0, table_list=0x7f647c0050c8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false)
    at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_insert.cc:1072
#13 0x000000000082fe15 in mysql_execute_command (thd=0x36109f0) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_parse.cc:3443
#14 0x0000000000838085 in mysql_parse (thd=0x36109f0, rawbuf=0x7f647c004fd0 "INSERT INTO t1 VALUES(123.4567e-1)", length=34, parser_state=0x7f64abde9700)
    at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_parse.cc:6357
#15 0x000000000082aa07 in dispatch_command (command=COM_QUERY, thd=0x36109f0, packet=0x373ef11 "INSERT INTO t1 VALUES(123.4567e-1)", packet_length=34)
    at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1332
#16 0x0000000000829a6c in do_command (thd=0x36109f0) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1034
#17 0x00000000007f0e5f in do_handle_one_connection (thd_arg=0x36109f0) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_connect.cc:982
#18 0x00000000007f0930 in handle_one_connection (arg=0x36109f0) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/sql/sql_connect.cc:898
#19 0x0000000000e652e1 in pfs_spawn_thread (arg=0x37027a0) at /pb2/build/sb_0-13700644-1416330726.69/mysqlcom-pro-5.6.23/storage/perfschema/pfs.cc:1860
#20 0x00007f64d641bdf3 in start_thread () from /lib64/libpthread.so.0
#21 0x00007f64d50e747d in clone () from /lib64/libc.so.6

commit: df34098068ae4a07f245ad13a4819ca01bde71df
date: 2014-11-18 09:54:31 +0530
build-date: 2014-11-18 18:01:47 +0100
short: df34098
branch: mysql-5.6

MySQL source 5.6.23
[2 Dec 2014 5:26] MySQL Verification Team 
// 5.7.6 - debug only

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75057 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75057 --core-file --socket=/tmp/75057.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.6/75057/log.err 2>&1 &

(gdb) bt
#0  0x00007f40bf515771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000f70894 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2  0x00000000009206ce in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x00007f40be11b5c9 in raise () from /lib64/libc.so.6
#5  0x00007f40be11ccd8 in abort () from /lib64/libc.so.6
#6  0x00007f40be114536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f40be1145e2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000013c00ba in ha_partition::info (this=0x7f4044036f10, flag=64) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/ha_partition.cc:6639
#9  0x00000000013ba52e in ha_partition::write_row (this=0x7f4044036f10, buf=0x7f40440394d8 "\f")
    at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/ha_partition.cc:4009
#10 0x0000000000990170 in handler::ha_write_row (this=0x7f4044036f10, buf=0x7f40440394d8 "\f") at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/handler.cc:7351
#11 0x0000000000e6caa9 in write_record (thd=0x7f4044011d80, table=0x7f4044040090, info=0x7f40a97fd8e0, update=0x7f40a97fd960)
    at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:1684
#12 0x0000000000e6a42d in mysql_insert (thd=0x7f4044011d80, table_list=0x7f404403e9f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR)
    at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:712
#13 0x0000000000c9a3b4 in mysql_execute_command (thd=0x7f4044011d80) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3334
#14 0x0000000000ca039f in mysql_parse (thd=0x7f4044011d80, parser_state=0x7f40a97feea0) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5386
#15 0x0000000000c950db in dispatch_command (command=COM_QUERY, thd=0x7f4044011d80, packet=0x7f40440095c1 "INSERT INTO t1 VALUES(123.4567e-1)", packet_length=34)
    at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#16 0x0000000000c93df5 in do_command (thd=0x7f4044011d80) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#17 0x0000000000d9d9ea in handle_connection (arg=0x46373d0) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#18 0x0000000000fa0dc7 in pfs_spawn_thread (arg=0x463d450) at /export/home/pb2/build/sb_0-13761755-1417089283.97/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#19 0x00007f40bf510df3 in start_thread () from /lib64/libpthread.so.0
#20 0x00007f40be1dc47d in clone () from /lib64/libc.so.6

// build used

commit: 1982dd7ab813e3cdb28d3bb119cc7b706cf01b15
date: 2014-11-27 13:27:39 +0300
build-date: 2014-11-27 12:38:45 +0100
short: 1982dd7
branch: mysql-trunk

MySQL source 5.7.6