| 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: | |
| 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 | |
[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)
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 = }