Foreign Key violation - not sure why
When I looked at the DDL per Brian's suggestion the problem immediately became clear: The usr_cookbook_status table was using MyISAM engine.  I switched it to InnoDB and everything works now.