Description:

When creating Backup Cloud SQL, the predifinedbackup_retention_settings are the following

backup_configuration {backup_retention_settings {retained_backups=7retention_unit="COUNT"  }}

Issue:

Iftransaction_log_retention_days is set to a value greater than the number ofretained_backups, the following error occurs:

Error, failed to update instance settings for : googleapi: Error 400: Invalid request: backup retention should be > transaction log retention., invalid

Proposed Fix:

Updateretained_backups value whentransaction_log_retention_days is greater that predefined value (predefined: 7).