Replace Terraform DynamoDB state locking with native state locking

[dms1981]

User Story

As a Modernisation Platform Engineer
I want to implement Terraform native state locking
So that I don't need to use DynamoDB for state locking

Value / Purpose

In Terraform 1.10.* Hashicorp will implement native state locking that is not reliant on DynamoDB tables.

The present use of DynamoDB for state locking introduces friction for our customers when stale state locks persist and require removal. Further to this we have to assume a role in the MP account in order to access the DynamoDB table.

By using native state locking we can reduce the amount of friction customers get by needing us to remove stale state locks, and we can simplify both our terraform configuration and our guidance on running local plans by removing the steps needed to assume a role in the main MP account during terraform init

Useful Contacts

No response

Additional Information

No response

Definition of Done

• Terraform native state locking tested
• Modernisation Platform terraform updated to use native state locking
• Modernisation Platform Environments terraform updated to use native state locking
• Confirm all statefiles using state locking (Enable state locking for remaining TF backends in the MP repo #8789 )
• Old configuration for state locking removed
• Documentation updated

[SimonPPledger]

Believe this is now available

[dms1981]

Prior issues on state locking for reference:

• Implement terraform state locking in S3 backends #2467
• State locking is not happening for the tf state of environments. #5534