MySQL Forums
Forum List  »  NDB clusters

Can't create table (error 1005) on MySql Cluster 8.0.20
Posted by: Alberto Pastore
Date: July 03, 2020 09:27AM

I've just setup a fresh new test installation of MySQL Cluster 8.0.20.
I have one management node, two sql nodes and four data nodes (all of them are running version 8.0.20 on Linux Debian 10 virtual machines on vSphere 7).

I'm trying to create a very simple table in a database with the following statement:

CREATE TABLE `webmessages` (
`Id` int NOT NULL AUTO_INCREMENT,
`CreatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ModifiedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`Lang_it` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
PRIMARY KEY (`Id`) USING BTREE
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


I get the error "1005 - Can't create table 'webmessages'".

If I remove either of the timestamps fields, the creation succeeds.
If I remove the mediumtext field and keep the two timestamps, the creation succeeds.

The statement succeeds as long as I leave two of the three fields (CreatedAt, ModifiedAt, Lang_It) in any combination, but fails when I keep all the three of them.

I've tried to use disk tablespaces but this seems to be unrelated.

I've no clue at all. What is causing the error?

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't create table (error 1005) on MySql Cluster 8.0.20
561
July 03, 2020 09:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.