Bug #75834 rqg_alter_online_part run into assertion: node->entry == null (row0ins.cc)
Submitted: 10 Feb 2015 7:46 Modified: 12 May 2015 8:11
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.7.6-m16 OS:Any
Assigned to: CPU Architecture:Any

[10 Feb 2015 7:46] Horst Hunger
Description:
Seems to be a regression caused by a change post-push fix for wl#4807 & wl#6035.

2015-02-09 12:53:39 0x7fe394ec8700  InnoDB: Assertion failure in thread 140615432832768 in file row0ins.cc line 3646
InnoDB: Failing assertion: node->entry == __null

The stacktrace:
# 2015-02-09T12:53:44 #2  0x00000000016f843f in ut_dbg_assertion_failed (expr=0x1d1d5a3 "node->entry == __null", file=0x1d1c2a0 "/export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc", line=3646) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
# 2015-02-09T12:53:44 #3  0x000000000161adcf in row_ins (node=0x7fe310016580, thr=0x7fe310016820) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3646
# 2015-02-09T12:53:44 #4  0x000000000161b0d4 in row_ins_step (thr=0x7fe310016820) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3750
# 2015-02-09T12:53:44 #5  0x0000000001637f25 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7fe310011240 "\374\001", prebuilt=0x7fe310015ff8) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1676
# 2015-02-09T12:53:44 #6  0x000000000163844c in row_insert_for_mysql (mysql_rec=0x7fe310011240 "\374\001", prebuilt=0x7fe310015ff8) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1787
# 2015-02-09T12:53:44 #7  0x000000000150832b in ha_innobase::write_row (this=0x7fe31001a450, record=0x7fe310011240 "\374\001") at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:6715
# 2015-02-09T12:53:44 #8  0x00000000015299bc in ha_innopart::write_row_in_part (this=0x7fe31001a450, part_id=1, record=0x7fe310011240 "\374\001") at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innopart.cc:1545
# 2015-02-09T12:53:44 #9  0x000000000100307e in Partition_helper::ph_write_row (this=0x7fe31001a730, buf=0x7fe310011240 "\374\001") at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/partitioning/partition_handler.cc:508
# 2015-02-09T12:53:44 #10 0x000000000152f83a in ha_innopart::write_row (this=0x7fe31001a450, record=0x7fe310011240 "\374\001") at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innopart.h:1074
# 2015-02-09T12:53:44 #11 0x0000000000c5621e in handler::ha_write_row (this=0x7fe31001a450, buf=0x7fe310011240 "\374\001") at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/handler.cc:7441
# 2015-02-09T12:53:44 #12 0x00000000012cdd49 in write_record (thd=0x7fe310000bb0, table=0x7fe310026780, info=0x7fe394d3f940, update=0x7fe394d3f9c0) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:1755
# 2015-02-09T12:53:44 #13 0x00000000012cb016 in Sql_cmd_insert::mysql_insert (this=0x7fe310007170, thd=0x7fe310000bb0, table_list=0x7fe310020740) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:687
# 2015-02-09T12:53:44 #14 0x00000000012d1831 in Sql_cmd_insert::execute (this=0x7fe310007170, thd=0x7fe310000bb0) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:3007
# 2015-02-09T12:53:44 #15 0x00000000010d5819 in mysql_execute_command (thd=0x7fe310000bb0) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3204
# 2015-02-09T12:53:44 #16 0x00000000010daeb2 in mysql_parse (thd=0x7fe310000bb0, parser_state=0x7fe394d40e40) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5129
# 2015-02-09T12:53:44 #17 0x00000000010d0bbc in dispatch_command (command=COM_QUERY, thd=0x7fe310000bb0, packet=0x7fe310009ce1 " INSERT INTO t1 (col1,col2,col3,col4) VALUES /* 1 */ (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) , (1,1,1,REPEAT(CAST(1 AS CHAR(1)),@fill_amount)) ", packet_length=151) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
# 2015-02-09T12:53:44 #18 0x00000000010cf8ee in do_command (thd=0x7fe310000bb0) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:835
# 2015-02-09T12:53:44 #19 0x00000000011f25b9 in handle_connection (arg=0x4906c90) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
# 2015-02-09T12:53:44 #20 0x000000000145ee25 in pfs_spawn_thread (arg=0x4906960) at /export/home/pb2/build/sb_0-14366248-1423476223.94/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2147
# 2015-02-09T12:53:44 #21 0x00007fe3a075cdf3 in start_thread () from /lib64/libpthread.so.0

How to repeat:
Run mentioned rqg test.
[12 May 2015 8:11] Jon Stephens
Documented fix in the 5.7.8 changelog as follows:

        ALTER TABLE ADD UNIQUE INDEX failed when run concurrently with
        an INSERT on the same partitioned InnoDB table.
      
Closed.