MySQL Forums
Forum List  »  NDB clusters

Re: Cannot Create more than 6 or 8 tables
Posted by: Andrew Sillifant
Date: March 09, 2021 08:18AM

all of the tables are created using ts_1 - apologies I mixed up and copied some old versions of the table definitions.
This is what I have for trying to create the new table after the other 6 have alreadey been created :

mysql> CREATE TABLE WebPagesUnicode_X01
-> (PageId INT NOT NULL PRIMARY KEY,
-> ModifiedOn TIMESTAMP DEFAULT NULL NULL,
-> Updates INT DEFAULT 0 NOT NULL,
-> URL_Length INT NULL,
-> URL VARCHAR(1000) NULL,
-> HTML_Length INT NULL,
-> HTML VARCHAR(1000) NULL,
-> URL_B64S_Length INT NULL,
-> URL_B64S VARCHAR(1000) NULL,
-> HTML_B64S_Length INT NULL,
-> HTML_B64S VARCHAR(1000) NULL)
-> TABLESPACE ts_1 STORAGE DISK ENGINE=NDB;
ERROR 1005 (HY000): Can't create table 'WebPagesUnicode_X01'
Warning (Code 1296): Got error 851 'Fixed-size column offset exceeded max.Use VARCHAR or COLUMN_FORMAT DYNAMIC for memory-stored columns' from NDB
Warning (Code 1296): Failed to commit NDB schema transaction
Error (Code 1005): Can't create table 'WebPagesUnicode_X01'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot Create more than 6 or 8 tables
164
March 09, 2021 08:18AM


Sorry, only registered users may post in this forum.

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.