can not update beanstalk as it keeps looking for a deleted database

Hi There,

I understand that you recently added a database on RDS. In that process, you also added a database to the EC2 instance (or at least a database in the Beanstalk itself). you then deleted this database, but for some reason it keeps trying to use it and complains about it, meaning that you can not update any details in your configuration.

Please note that Deletion protection is enabled for you when you use the AWS Management Console to create a production DB instance. However, Amazon RDS enforces deletion protection when you use the console, the CLI, or the API to delete a DB instance.

In order to successfully and correctly delete an RDS instance from beanstalk you need to first decouple this RDS DB instance from beanstalk. You can decouple your database from an Elastic Beanstalk environment without affecting the health of the environment, please follow the document here. [1]

You can choose to create a snapshot of the database and then terminate it, retain the database operational as a standalone database external to Elastic Beanstalk, or permanently delete the database. The Database deletion policy setting determines this result.

I suggest that in your case, you decouple all databases attached to beanstalk using The Database deletion policy setting. Choose delete for the rds you plan to delete and choose retain for the one you need to keep. Then clean up your beanstalk so you can create a new one that you can then attach the necessary resources to.[2]

I hope this information is helpful to you.

=================References===================

[1] Decoupling an RDS DB instance using the console: https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/using-features.managing.db.html#using-features.decoupling.db

[2] Clean up: https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/GettingStarted.Cleanup.html

Please note that I personally value your feedback, please accept and thumbs up this answer if you find it helpful.