Error: Your query returned no results. Please change your search criteria and try again.

[edmooneyvtx]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

• Terraform version: 0.12.7
• terraform-provider-aws_v2.50.0_x4"

Affected Resource(s)

• aws_db_snapshot

Terraform Configuration Files

data "aws_db_snapshot" "db_snapshot" {
  most_recent            = true
  db_instance_identifier = "test08-2020-03-09-14-10"
  snapshot_type          = "manual"

}

Debug Output

https://gist.github.com/edmooneyvtx/31b4dd52b13ba35e14ab0d02d819d564

Panic Output

Expected Behavior

Snapshot should have been found

Actual Behavior

Snapshot was not found

Steps to Reproduce

1. terraform init
2. terraform plan

Important Factoids

Some files do show and others don't - there are 480 snapshots it's going through

References

• #0000

[justinretzolk]

Hey @edmooneyvtx 👋 Thank you for taking the time to file this issue. Given that there's been a number of AWS Provider releases since you initially filed it, can you confirm whether you're still experiencing this behavior?

[lystopad]

Hi
Does not work with latest aws provider 4.38.0
I can see snapshot with "aws cli" but data source returns error.

[mt-ttmy]

Hi, I'm encountering the very same issue:

data "aws_db_snapshot" "target_snapshot" {
  db_snapshot_identifier = "terraform-seed-snapshot"
  # db_instance_identifier = "terraform-seed-db"
  # most_recent            = true
  snapshot_type          = "manual"
}

If I'm using db_snapshot_identifier I get a 404, while using both db_instance_identifier and most_recent I get "Your query returned no results". At the same time I can confirm that snapshot is there using cli command aws rds describe-db-snapshots --snapshot-type manual --db-snapshot-identifier terraform-seed-snapshot.

Region: eu-south-1 (Milan)
AWS provider version: 4.52.0

[akothawala]

any update on above issue..persisting same since long.

[justinretzolk]

Hey @mt-ttmy 👋 Thank you for the detailed information. Are you able to supply debug logs and/or the output from the CLI command you mentioned (redacted as needed)?

[mt-ttmy]

Hi, I found out that the issue was related to a credential problem related to the role I was using on AWS. So, the snapshot couldn't be found since my role hadn't the right permissions. After fixing that, all worked as expected. IMHO it is a little misleading receiving an error which states that the snapshot cannot be found / search produced an empty result, instead of receiving a "permission denied" message, but well, we can agree that, at least in my case, there is no bug. Thank you for your support 👍 .

[eyal-solomon1]

@mt-ttmy can you elaborate on what was the issue and how you fixed it ?
I do get the same terraform error, while seeing the snapshot available with aws cli

I assume an admin role with Terraform so it doesn't sounds like permission issue in my case

[mt-ttmy]

I just had mismatched credentials setup on my aws cli and on my terraform script. So I don't think I can help you with your issue.