Background

When running a manual or automated RackSpace database backup using our Database Manager ServerTemplates, you may see the recipe or script fail and you may see errors such as these in the audit entries or in the /var/log/messages file:

E, [2012-11-07T20:43:10.575316 #18138] ERROR -- : Error 100 while uploading file
E, [2012-11-07T20:43:10.575503 #18138] ERROR -- : Error output: 'curl: (28) Operation timed out after 157 seconds
 with 0 bytes received
E, [2012-11-07T20:15:42.278057 #16537] ERROR -- : Error running curl --silent --show-error --location --write-out '
%{http_code}' --output /dev/stderr --upload-file - --max-time 157 --header 'Transfer-Encoding:' --header 'Content-L
ength: 10485760' --header 'content-type: text/plain' --header 'accept: application/json' --header 'x-storage-token:
 (redacted for safety)' 'https://snet-storage101.dfw1.clouddrive.com:443/v1/CloudFS_40433311-196-4a03-9f-f64af9d/pr
 od-db/prod-db-20121107/200727.tgz.part00037': 'Broken pipe'

These errors could possibly be caused by a large number of backups being held in your RackSpace Cloudfiles containers, causing the broken pipe and timeout errors seen above.

Answer

We are unable to utilize storage volumes with RackSpace clouds for the current time, so when RightScale takes a backup of your database on a RackSpace cloud, we compress and split up the database directory and upload all of those chunks to a Cloudfiles container that is specified in the DB server's inputs.

Normally, our backup process contains a section whereby we cleanup old backups. Depending on your input settings, you can define the number of daily, weekly, monthly and yearly backups that are kept.

In the case of RackSpace, this feature is not available though, so we will not cleanup old database backups for RackSpace database servers. Thus, in order to resolve this issue, you will want to either manually cleanup many of your old Cloudfiles DB backups, or create a script that dynamically cleans up any old backups that you do not wish to keep.

Have further questions?

Feel free to call us at (866) 787-2253 or open a ticket from the dashboard using the Support -> Email link in the top right corner and we will be happy to further assist.