MySQL Forums
Forum List  »  NDB clusters

Can't create table
Posted by: Maurice Sobiera
Date: April 14, 2021 01:57PM

I would like to create a table on a ndbcluster but i keep getting errors:

My SQL:


mysql> CREATE TABLE IF NOT EXISTS `blocks2` (
-> `id` bigint(20) NOT NULL AUTO_INCREMENT,
-> `hash` varchar(66) DEFAULT NULL,
-> `block_number` bigint(20) DEFAULT NULL,
-> `parent_hash` varchar(66) DEFAULT NULL,
-> `miner` varchar(42) DEFAULT NULL,
-> `difficulty` bigint(20) DEFAULT NULL,
-> `size` bigint(20) DEFAULT NULL COMMENT 'size in bytes',
-> `gas_limit` bigint(20) DEFAULT NULL,
-> `gas_used` bigint(20) DEFAULT NULL,
-> `time_stamp` datetime DEFAULT NULL,
-> `transactions` bigint(20) DEFAULT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE=ndbcluster AUTO_INCREMENT=12394243 DEFAULT CHARSET=utf16 COLLATE=utf16_bin;


The error code:

ERROR 1005 (HY000): Can't create table 'blocks2'
mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't create table
1242
April 14, 2021 01:57PM
515
April 14, 2021 02:51PM
505
April 15, 2021 03:51AM
536
April 15, 2021 06:02AM
529
April 16, 2021 08:01AM
537
April 16, 2021 11:31AM
438
April 17, 2021 04:33AM
495
April 17, 2021 03:29PM
417
April 28, 2021 10:50AM
473
April 28, 2021 11:51AM
762
April 28, 2021 02:18PM
473
April 28, 2021 02:59PM
454
April 29, 2021 12:56AM
418
April 29, 2021 02:49AM


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.