Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Do
-
None
-
None
-
2018-20, 2018-21
Description
If you have a script that is checking for the cluster to be active in parallel to a postConfigure then mcsadmin getSystemStatus will show the system as active before the system catalog has been created. If you try to create a table in this window you'll get error:
ERROR 1815 (HY000) at line 1: Internal error: CAL0009: Error while calling getSysCatDBRoot
My proposal is to not update the system status to active until all postConfigure steps (including replication setup) are complete. I think it would be a good idea to add a new mcsadmin status such as 'PostConfig' for the interim state between mysqld up and the cluster fully configured.
My workaround for this is to create a columnstore table and loop until it works.