Hi I am receiving below error while creating a partition table in YSQLSH. Its 12 Tserver and 3 Master with replication factor 3. ERROR: Invalid table definition: Error creating table db.test_202403 on the master: Not enough live tablet servers to create table with replication factor 3. Need at le…

I have just removed that additional placement info I was adding. then I saw it put all the nodes in primary cluster and I was able to create tables. Thanks Subhankar

As the error suggeests, you don have tservers in all azs based on your cluster config. Can you share the cluster config and master and tserver list from web ui?

Hi Yogi PFB. [image] [image] [image]

Hi, can you check that you have no 'tablespace" clause in the create table statement and that default_tablespace is not set? show default_tablespace; select * from pg_tablespace;

Hi image got cutoff. But can you post output for the command that @FranckPachot posted.

In your cluster, you are looking for 3 replicas, but you have only provided on replica config. That is the problem, I suppose. How are you creating this cluster? Using yugabyted command or yb-master yb-tserver commands directly?

Also share exact create table command… feel free to anonymize object and col names if its a concern.

No, tablespace clause is there. [image]

I have created using yb-master, yb-tserver command.

I see too many underreplicated tables as below. [image] [image] Also some of the tablets does not have 2 followers: yugabyte@xxxxxxxxx:/pg_data_master/yugabyte/yugabyte-2.20.1.3$ bin/yb-admin --master_addresses xx.xx.xx.71:7100,xx.xx.xx.72:7100,xx.xx.xx.73:7100 list_tablets ysql.dldb test incl…

We need to see the yb-tserver commands because what is displayed is strange. The UUID should a uuid - not the placement flags, and it seems you have nodes seen as read replicas but with tablet leaders :confused:

Create Table Error - YSQLSH

General

subh14 April 19, 2024, 5:18am 3

Hi Yogi
PFB.

Topic		Replies	Views
Create geo partition table error on multi-region setup General	3	2888	October 25, 2024
Create database test' it's giving error: table system.transactions not found :object_not_found General	5	4744	August 21, 2024
Read replica cluster setup in manual deployment gives error for creating new table General	1	3056	December 21, 2021
Error while apply full schema dump General	4	2224	February 20, 2024
Two tablets stuck in Creation mode General	4	772	August 10, 2026

Create Table Error - YSQLSH

Related topics