Error in terraform apply - Database already exists for module.etl.aws_glue_catalog_Database.ml_Database

Course Q&A Data Engineering Introduction to Data Engineering
,
1

I see the same error even after redoing the work in a new lab session

Plan: 3 to add, 0 to change, 0 to destroy.

Do you want to perform these actions?
Terraform will perform the actions described above.
Only ‘yes’ will be accepted to approve.

Enter a value: yes

module.etl.aws_glue_catalog_database.ml_database: Creating…
╷
│ Error: creating Glue Catalog Database (de-c1w4-ml-db): operation error Glue: CreateDatabase, https response error StatusCode: 400, RequestID: fa3c3ec3-1a4f-4dc6-9bcd-6a87fc2ab90a, AlreadyExistsException: Database already exists.
│
│ with module.etl.aws_glue_catalog_database.ml_database,
│ on modules/etl/glue.tf line 2, in resource “aws_glue_catalog_database” “ml_database”:
│ 2: resource “aws_glue_catalog_database” “ml_database” {

1 Like
2

Hello @baricsedu24, I had a similar error in Week 2, it looks like this:

apply output
apply output839×149 28.8 KB

I suggest a lab refresh with this complete form. Just choose an option (eg. Account still in cleanup) and your lab. Thank you

1 Like
3

Thanks @Georgios for the suggestions. I completed the form and waiting for their end. Do you remember how long it takes to get an update? My assignment deadline is Dec 27, 11:59 PM.

4

Hello @baricsedu24
I am not sure exactly but it is a matter of days. Thanks for your understanding and I hope you it will resolve and complete your assignment. Cheers

1 Like
5

Generally a lab refresh can take up to 24 hours - but over weekends it can be longer. DLAI staff mostly does not work on the weekends.

1 Like
6

Not sure if my lab was refreshed. I did not get any response yet. I started the lab today, issued the following command but no lab materials are copied into my current location. Can you please let me know what is the issue?
voclabs:~/environment aws s3 cp --recursive s3://dlai-data-engineering/labs/c1w4-242829/ ./ voclabs:~/environment ls
README.md
voclabs:~/environment $ aws s3 cp --recursive s3://dlai-data-engineering/labs/c1w4-242829/ ./

7

Hello @baricsedu24, not sure if this the issue but my Vocareum uses a different file than yours:
aws s3 cp --recursive s3://dlai-data-engineering/labs/c1w4-242820/ ./
instead of:
aws s3 cp --recursive s3://dlai-data-engineering/labs/c1w4-242829/ ./
Hope this helps

8

Hi, was your problem solved? I have the same error, asked for the lab refresh…

9

@Volha.B you might get this output after terraform apply even after a lab restart. The lab refresh form should fix it and it could take couple of days until you will notified. Sorry for the inconvenience, this may cause

1 Like