[Kea-users] Kea 1.6 with MySQL Cluster

[Philippe Havard]

Not all version of ndb support foreign key. Wich version are you using?

On Friday, April 26, 2019, Fernando Ruza Rodriguez <fernandor at sescam.jccm.es>
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.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190426/dae38366/attachment.htm>