New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Almost random: InvalidRequestException (HTTP 400). Idempotent parameters do not match / Could not find results #104
Comments
Hi @magnussv, really sorry to here that you are having issues with |
Thanks @DyfanJones ! I found ankane/blazer#234 when I googled as well, so I tried to run many (new/different) queries but with the same type of result on all of them. I didn't fully understand that issue but the title said "does not allow you to run same query multiple times". :-) |
Hi @magnussv, i just want to check some details with you. Does mtcars exist in 2 schema's? For example |
Plus can you let me know how you connect to athena? I am wondering if there is a problem with the defualt schema. I.e You connect to the default, but you are querying the adhoc schema for example.
|
This looks like a possible solution: https://paws-r.github.io/docs/athena/start_query_execution.html. The parameter
Could be the issue. I will need to read some boto3, documentation in how to handle this(any suggestions welcome). In the meantime can you try caching: https://dyfanjones.github.io/noctua/articles/aws_athena_query_caching.html and let me know if this persists. (Sorry for the mountain of questions please take your time to answer them :) ) |
From investigating further it looks like there are 2 possible issues going on here.
|
Hi @magnussv can please try out the development branch "start_query_execution"
Please let me know if the error continues to persist. |
@DyfanJones thanks for your quick response. You find answers to your initial questions below.
I'm using credentials from a local ~/.aws/credentials with [
I have tried with
I will try it and come back to you! |
@DyfanJones I can confirm that this resolved the issues! I ran around 100 queries and all returned the expected result. Great! Thanks for the instant correction. :-) 👍 |
@magnussv oh brilliant. I didn't know what to do next if that failed 😆 I will merge the branch after I have tweaked the caching option to allow 100 distinct queries (thanks for point that out to me :D ) |
bug fix: pass uuid string to `ClientRequestToken` #104
noctua_1.8.1 has been submitted to the cran. |
Hello Dyfan,
Lately I had problems with
RAthena
so I turned tonoctua
instead and I noticed some peculiar, almost random, issues.Issue Description
When running the code below then I usually get
Error: InvalidRequestException (HTTP 400). Idempotent parameters do not match
or sometimesError: InvalidRequestException (HTTP 400). Could not find results
HOWEVER about 1 of 5 times I retrieve the desired result. It almost seems random. Issue occurs in both R Console and in Rstudio. As a side note: If I for example uselibrary(aws.s3); bucketlist()
then I always retrieves the desired result, so I know that I'm assuming the role correctly.Reproducible Example
Example:
Screenshot:
Traceback:
The text was updated successfully, but these errors were encountered: