Error in EFA backup

[Neeraj_Singh]

I am having issue with EFA backup here is the error . please suggest .

Error : An error occurred while taking backup of database 'dcapp_tenant'. Error: exit status 2 - mysqldump: Got error: 1030: "Got error 194 "Tablespace is missing for a table" from storage engine InnoDB" when using LOCK TABLES

[Michael_Morey · Accepted solution]

Neeraj,

Unfortunately it sounds like there is an issue or corruption with your DB structure.

I hope you are using periodic backups, if so I would take the last known good backup and restore it to a fresh deployment

1.) Upload backup to remote server

2a.) If using TPVM you can simply re-deploy the TPVM to start fresh, it is a little faster than uninstalling/reinstalling.

2b.) If using a Standalone server, use the deployment.sh script to uninstall XCO

3.) Reinstall XCO

4.) Download backup to fresh XCO (place it into the backups folder)

5.) Restore the backup

6.) Refresh the SLX-OS Certificates with:
efa certificate device install --fabric [fabric_name] --force

7.) Perform a device update to confirm XCO can communicate with fabric devices:
efa inventory device update --fabric [fabric_name]

Alternatively I would open a case with TAC (with your SSV attached) to have us look into the issue deeper and see if there is any other workaround.

[Neeraj_Singh]

Thank you so much Michael. we can try EFA restore may be .