ErrorCode: INTERNAL_ERROR_SERVICE

Question

I receive this error when I try to run a query by athena-express library.

[ErrorCode: INTERNAL_ERROR_SERVICE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this query. We apologize for the inconvenience.

`Query: DROP SCHEMA IF EXISTS name_schema CASCADE`

Run time: 	0 sec	Data scanned: 0 MB

Till yesterday I didn't see any errors!

Answer

Hi, I found the problem related to my error. I don't know why but when I changed my query in "CREATE SCHEMA XY" I received an error related to some missing permissions. So, the problem was related to the missing permissions but I don't know why I didn't receive this error message when I tried with the query "DROP SCHEMA XY".

Anyway, the problem was resolved!

Answer

Hello,

Can you please share the Athena failed query ID and AWS region for us to troubleshoot further ? You can find Athena query ID in query history [1]

REFERENCES:

[1] https://docs.aws.amazon.com/athena/latest/ug/querying.html#queries-viewing-history

ErrorCode: INTERNAL_ERROR_SERVICE

Relevant content