Bug #84361 Incorrect SHOW ENGINE INNODB STATUS for partitioned table
Submitted: 28 Dec 2016 16:18 Modified: 29 Dec 2016 6:51
Reporter: Василий Лукьянчиков Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6, 5.6.35, 5.7.17 OS:Any
Assigned to: CPU Architecture:Any

[28 Dec 2016 16:18] Василий Лукьянчиков
Description:
If we are trying to split the parent table on sections, the error message in "SHOW ENGINE INNODB STATUS" not content section " LATEST FOREIGN KEY ERROR".

How to repeat:
create table t1 (a int, index(a)) engine=innodb;

create table t2 (a int, foreign key (a) references t1(a)) engine=innodb;

alter table t1 PARTITION BY HASH(a) PARTITIONS 8;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

show engine innodb status;
[29 Dec 2016 6:51] Umesh Shastry
Hello!

Thank you for the report.
Verified as described with 5.6.35.

Thanks,
Umesh