Upgrade to v0.9.6
Add Helm repo in UMHLens / OpenLens
Check if the UMH Helm repository is added in UMHLens / OpenLens.
To do so, from the top-left menu, select FIle > Preferences (or press
CTRL + ,).
Click on the Kubernetes tab and check if the Helm Chart section contains
If it doesn’t, click the Add Custom Helm Repo button and fill in the following values:
- Helm repo name: united-manufacturing-hub
- URL: https://repo.umh.app
Then click Add.
Add new index to the database
In this version, a new index has been added to the
allowing to speed up the queries.
Open a shell in the database
From the Pod section in UMHLens / OpenLens, click on united-manufacturing-hub-timescaledb-0 to open the details page.
Click the Pod Shell button to open a shell in the container.
Enter the postgres shell:
Connect to the database:
Create the index
Execute the following query:
CREATE INDEX ON processvaluetable(valuename, asset_id) WITH (timescaledb.transaction_per_chunk); REINDEX TABLE processvaluetable;
This command could take a while to complete, especially on larger tables.
exit to close the shell.
Some workloads need to be deleted before upgrading. This process do not delete any data. If a workload is missing, it means that it was not enabled in your cluster, therefore you can skip it.
To delete a resource, you can select it using the box on the left of the resource name and click the - button on the bottom right corner.
- Open the Workloads tab.
- From the Deployment section, delete the following deployments:
- From the StatefulSet section, delete the following statefulsets:
Upgrade Helm Chart
Now everything is ready to upgrade the Helm chart.
- Navigate to the Helm > Releases tab.
- Select the united-manufacturing-hub release and click Upgrade.
- In the Helm Upgrade window, make sure that the
Upgrade versionfield contains the version you want to upgrade to.
- You can also change the values of the Helm chart, if needed.
- Click Upgrade.
The upgrade process can take a few minutes. The upgrade is complete when the Status field of the release is Deployed.