Has no master instance

Help Procedural SQL
1

HI Team

In memsql column store table create in dev env table name mass_upload_master while updating using join or when exit condition it is getting below error message

update mass_upload_master suma
SET
v_error_message = ’ id & id is not found in header’,
updated_date = CURRENT_DATE() ,
updated_by = ‘abc’
where EXISTS (select 1 from sp_header sqh
where
suma. id = sqh.id
);

SQL Error [1777] [HY000]: (conn=9659915) Partition dsc_dpe:0 has no master instance. This is likely because the node or nodes that hold a copy of the partition are down. Check for offline leaf nodes by running SHOW LEAVES and bring them back online to restore access to the partition

2

Hi Sumanamara,

Could you share across the output of SHOW LEAVES?

Your developer environment should have at least 1 Master Aggregator and 1 Leaf Node at a minimum to operate as a successful cluster.

Thanks in advance!
David Yakobovitch
SingleStore Education

3

I don’t have any access to show leaves…
Access denied;

4

Hi Sumanamara,

Can you let us know more about your technology setup, for why you might be receiving Access denied? Where are you running these commands from?

From your Master Aggregator in your SQL environment, can you share the output of SHOW AGGREGATORS;?

Thank you,
David