Bug #71794 MysqlFabric foreign key error when omitting group in sharding create_definition
Submitted: 21 Feb 2014 20:41 Modified: 24 Feb 2014 9:18
Reporter: Andres Eduardo Sanchez Rodriguez Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Fabric Severity:S3 (Non-critical)
Version:1.4.0 OS:Linux (2.6.39-200.24.1.el6uek.x86_64)
Assigned to: CPU Architecture:Any

[21 Feb 2014 20:41] Andres Eduardo Sanchez Rodriguez
Description:
Sharding create_definition throws foreign key error when omitting group parameter

How to repeat:
-bash-4.1$ mysqlfabric help sharding create_definition
sharding create_definition type_name group_id  [--SYNCHRONOUS=TRUE]  

Define a shard mapping.

-bash-4.1$ mysqlfabric sharding create_definition RANGE
Procedure :
{ uuid        = 3fbc44b8-2b2e-4d6f-920d-f1bc660b3906,
  finished    = True,
  success     = False,
  return      = DatabaseError: ("Command (INSERT INTO shard_maps(type_name, global_group) VALUES(%s, %s), ('RANGE', True)) failed: 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`fabric`.`shard_maps`, CONSTRAINT `fk_shard_mapping_global_group` FOREIGN KEY (`global_group`) REFERENCES `groups` (`group_id`))", 1452),
  activities  = 
}
[24 Feb 2014 9:18] Mats Kindahl
Thank you for the bug report. It looks like the error messages need to be improved. Verified as described.
[6 Jul 2017 19:19] Bugs System
Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)