Not all version of ndb support foreign key. Wich version are you using? On Friday, April 26, 2019, Fernando Ruza Rodriguez <[email protected]> wrote:
> Hi, I'm trying to setup kea 1.6 with MySQL NDB Cluster backend. Has > someone experienced with them? > > I have changed the "ENGINE" in all create tables statements with > ENGINE=NDBCLUSTER in the script dhcpdb_create.mysql however when I run it I > get the following errors, I think, when created the tables > keadhcp.dhcp4_pool and keadhcp.dhcp6_pool for the foreign keys they have: > > ... > > ERROR 1215 (HY000): Cannot add foreign key constraint > Query OK, 0 rows affected (0,46 sec) > > Query OK, 0 rows affected (1,50 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > Query OK, 0 rows affected (1,77 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > Query OK, 0 rows affected (0,48 sec) > > ERROR 1146 (42S02): Table 'keadhcp.dhcp4_pool' doesn't exist > Query OK, 0 rows affected (0,48 sec) > > ... > > ERROR 1215 (HY000): Cannot add foreign key constraint > ERROR 1215 (HY000): Cannot add foreign key constraint > Query OK, 0 rows affected (1,65 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > Query OK, 0 rows affected (1,36 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > Query OK, 0 rows affected (0,57 sec) > > ERROR 1146 (42S02): Table 'keadhcp.dhcp6_pool' doesn't exist > Query OK, 1 row affected (0,03 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > > Thanks in advanced for any help. > > Regards, Fernando. > >
_______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
