從 4.x 匯入後，PowerScale InsightIQ 5.x 會將上次更新時間戳記顯示為 2020 或 2021 年

這是由於 system_workload 資料庫中自 2020 年或 2021 年以來不再更新或使用的表。這只會在較舊的匯入資料存放區上看到。 

修復 system_workload 2020 資料擷取延遲問題。

檢查資料庫的儲存位置： 

# kubectl get pvc -A | grep storage

根據儲存裝置類型，前往正確的章節：

本機儲存裝置：

# kubectl get pods -A | grep ha-cmo 
 # kubectl exec -it postgres-ha-cmo1-xxxx-x -n atlantic -- psql 
 # \l
 # \c clustername_guid   <<<< get the clustername_guid from \l above for the cluster in question >>>>>>
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;
 # delete from data_time where api='system_workload';
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;
 # \q

大約5-10分鐘後刷新螢幕，並驗證日期是否正常。如果日期不正常，請重新檢查表以驗證 system_workload 未重新建立：

# kubectl exec -it postgres-ha-cmo1-xxxx-x -n atlantic -- psql 
 # \l
 # \c clustername_guid   <<<< get the clustername_guid from \l above for the cluster in question >>>>>>
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;

網路檔案系統 （NFS） 儲存：

# kubectl get pods -A | grep iiqsm  
 # kubectl exec -it iiqsm-psql-XXXX-xxxx -n atlantic -- psql -U iiqsm -h localhost -d postgres
 # \l
 # \c clustername_guid  <<<< get the clustername_guid from \l above for the cluster in question >>>>>>
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;
 # delete from data_time where api='system_workload';
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;
 # \q

大約5-10分鐘後刷新螢幕，並驗證日期是否正常。如果日期不正常，請重新檢查表以驗證 system_workload 未重新創建。

# kubectl exec -it iiqsm-psql-XXXX-xxxxx -n atlantic -- psql -U iiqsm -h localhost -d postgres
 # \l
 # \c clustername_guid  <<<< clustername_guid from \l above >>>>>>
 # SELECT api, time FROM data_time WHERE resolution = 5 AND api NOT LIKE 'cluster_%%%%' order by time;