Skip to end of metadata
Go to start of metadata

Symptom


MySQL's tmp space may be filled up under certain circumstances. The tmp directory may have limited space if it is put in a non-default location. CDP does not restore all necessary files, and the task fails.

1. Log in to CDP Server.
2. Click "Recovery Points” in the main menu.
3. Select the Agent and the Disk Safe.
4. Select the databases.
5. Click “Restore Selected.”
6. Click “Temporary Instance,” and then select “Specify an Alternate Temp Directory.”
7. Provide a “Temp Directory,” e.g., /temporal250mb, with no more than 250 MB of free space.
8. Click "Restore."
9. Review the logs during file restoration.
10. CDP does not restore all necessary files, and the task fails.
11. Review Agent logs:

ERROR],[10.230.106.211:49211],File not restored: '/temporal/r1soft-mysql-restore-tmp-58325331-6c6d-4366-8e8a-505f776b4566/bInnoDB9/table1300.ibd' due to write error: No space left on device ERROR],[10.230.106.211:49211],file restore error: File System Full ! Restore aborted 12. Review Server Logs ERROR - TASK(10.230.106.204-Restore Databases)-AGENT: File not restored: '/temporal/r1soft-mysql-restore-tmp-58325331-6c6d-4366-8e8a-505f776b4566/bInnoDB9/table1300.ibd' due to write error: No space left on device WARN - TASK(Restore Databases): Error restoring file '/var/lib/mysql/bInnoDB9/table1301.frm' Error sending file data

Current Result:

There is no reduction when the tmp directory has limited space; the task fails.

Resolution


The issue has been corrected in CDP 4.0.0.

Related Articles


Page: Adding a MySQL Instance to a Policy in Data Center Console (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: CDP for Databases (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Adding a MySQL Instance to a Policy (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Browsing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Allowing Remote Connections to MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Editing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Enabling and Disabling MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Testing MySQL Instance Connection (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Deleting MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: MySQL Restore in Large Deployment (CDP) Labels: mysql
Page: MySQL InnoDB File Per Table Restore (CDP) Labels: mysql
Page: MySQL Test Connection Fails when the Instance is Started with skip-innodb (CDP) Labels: mysql
Page: Solved Issue with Publishing MySQL Password (CDP) Labels: mysql
Page: MySQL Instance with a Non-Default tmp Directory (CDP) Labels: mysql
Page: Adding a MySQL Instance to a Policy on a PVC Container (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Protecting MySQL (CDP) Labels: mysql
Page: Multi-Threaded MySQL Restore (CDP) Labels: mysql
Page: System Requirements - CDP for Databases (CDP) Labels: mysql, sql, exchange
Page: Protecting MySQL MariaDB and Percona Server (CDP) Labels: mysql
Labels:
mysql mysql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.