example s3-import-mysql errors

[oc-stephen-bennett]

Description

downloading the latest version from master and running a terraform init / apply in the example/s3-import-mysql errors.

I have made the change to update the engine_version to "8.0.36" but when running it after, it gets stuck on `module.db.module.db_instance.aws_db_instance.this[0]: Still creating...' for 45 mins then errors:

module.db.module.db_instance.aws_db_instance.this[0]: Still creating... [40m0s elapsed]
╷
│ Error: creating S3 Bucket (s3-import-20240508145118559500000005) ACL: operation error S3: PutBucketAcl, https response error StatusCode: 400, RequestID: 5YJ2DDTJEZXWPM9N, HostID: hjBX10fkNJieKp1iYA/EF+3dPW1Iufq60defSyojljEUR7/fLo9uWObtpU6rEPONGHVcLd7BjKI=, api error AccessControlListNotSupported: The bucket does not allow ACLs
│ 
│   with module.import_s3_bucket.aws_s3_bucket_acl.this[0],
│   on .terraform/modules/import_s3_bucket/main.tf line 45, in resource "aws_s3_bucket_acl" "this":
│   45: resource "aws_s3_bucket_acl" "this" {
│ 
╵
╷
│ Error: waiting for RDS DB Instance (s3-import) create: timeout while waiting for state to become 'available, storage-optimization' (last state: 'creating', timeout: 40m0s)
│ 
│   with module.db.module.db_instance.aws_db_instance.this[0],
│   on .terraform/modules/db/modules/db_instance/main.tf line 29, in resource "aws_db_instance" "this":
│   29: resource "aws_db_instance" "this" {
│ 
╵

If you update the s3 bucket to remove the acl = private you still get the error:

╷
│ Error: waiting for RDS DB Instance (s3-import) create: timeout while waiting for state to become 'available, storage-optimization' (last state: 'creating', timeout: 40m0s)
│ 
│   with module.db.module.db_instance.aws_db_instance.this[0],
│   on .terraform/modules/db/modules/db_instance/main.tf line 29, in resource "aws_db_instance" "this":
│   29: resource "aws_db_instance" "this" {
│ 

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open 30 days with no activity. Remove stale label or comment or this issue will be closed in 10 days

[BradleyYeo]

I am working on this :)

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open 30 days with no activity. Remove stale label or comment or this issue will be closed in 10 days

[github-actions[bot]]

This issue was automatically closed because of stale in 10 days

[github-actions[bot]]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.