Hi all We are trying to migrate backend database f...
# troubleshoot
s
Hi all We are trying to migrate backend database from mysql to postgres are there any ways to preserve all data ?
l
I haven’t tried it but have you taken a look at this? https://datahubproject.io/docs/advanced/no-code-upgrade/
s
i am already on helm chart 0.8.x
as far as i saw - recreating on mssql instanse (including backend persistent disk) not led to global data loss so i beleve pg will be the same
however when i’ve moved out from local elasticsearch to our company’s shared one - data has been lost from perspective of UI search and visualisation on main page
found in upgrade container:
Copy code
2022-07-21 12:12:59.480  INFO 1 --- [           main] c.l.g.f.k.SimpleKafkaConsumerFactory     : Simple KafkaListenerContainerFactory built successfully                 
2022-07-21 12:13:06.677  INFO 1 --- [           main] c.l.d.upgrade.UpgradeCliApplication      : Started UpgradeCliApplication in 40.9 seconds (JVM running for 43.271)  
Starting upgrade with id NoCodeDataMigration...                                                                                                                          
Cleanup has not been requested.                                                                                                                                          
Skipping Step 1/6: RemoveAspectV2TableStep...                                                                                                                            
Executing Step 2/6: GMSQualificationStep...                                                                                                                              
Completed Step 2/6: GMSQualificationStep successfully.                                                                                                                   
Executing Step 3/6: UpgradeQualificationStep...                                                                                                                          
-- V1 table does not exist                                                                                                                                               
Failed to qualify upgrade candidate. Aborting the upgrade...                                                                                                             
Step with id UpgradeQualificationStep requested an abort of the in-progress update. Aborting the upgrade...                                                              
Upgrade NoCodeDataMigration completed with result ABORTED. Exiting...
l
Oh you need to run a restore indices job
From your database. I had to do that when I switched between elastic servers. It will rebuild your indices from your Db
s
how to perform it?
will try to folow this doc
seems like retored
Copy code
Reading rows 70000 through 71000 from the aspects table.           
Successfully sent MAEs for 70418 rows                              
Completed Step 3/3: SendMAEStep successfully.                      
Success! Completed upgrade with id RestoreIndices successfully.    
Upgrade RestoreIndices completed with result SUCCEEDED. Exiting...
👍 1