{question}
How to troubleshoot the following BACKUP DATABASE error:
ERROR 2205 (HY000): Backup subprocess nonzero exit value. MalformedACLError: The XML you provided was not well-formed or did not validate against our published schema.
{question}
{answer}
Receiving a MalformedACLError error after attempting to Backup to an S3 Compatible Storage Provider generally means the storage provider doesn't support part of the full S3 API.
Troubleshooting Steps
- Specify
"compatibility_mode": true
in the configuration_json in the BACKUP DATABASE command.
For example:
BACKUP DATABASE test_db TO S3 "my_storage"
CONFIG
'{"compatibility_mode":true, "endpoint_url": "http://my.storage.com"}'
CREDENTIALS
'{"aws_access_key_id": "xxxxxxxxxxxxxxxxxx",
"aws_secret_access_key": "xxxxxxxxxxxxxxxxxxxx"
}' - Confirm you are following the syntax as provided in the Backup to an S3 Compatible Storage Provider documentation.
- To use the
compatibility_mode
setting in the backup database command you must be on SingleStore version 6.8.16 or higher.
{answer}