ibm_database conflicts with admin_pass and remote_leader_id

[shemau]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform CLI and Terraform IBM Provider Version

Affected Resource(s)

• ibm_database

Terraform Configuration Files

Please include all Terraform configurations required to reproduce the bug. Bug reports without a functional reproduction may be closed without investigation.

resource "ibm_database" "postgresql_db" {
  ... all the regular stuff
  remote_leader_id  = var.remote_leader_crn
  adminpassword     = var.admin_pass

Where both the variables are valid and not null.

Debug Output

│ Error: [ERROR] UpdateUser (admin) failed Not Found
│ {
│     "StatusCode": 404,
│     "Headers": {
│         "Cache-Control": [
│             "no-store"
│         ],
│         "Cf-Cache-Status": [
│             "DYNAMIC"
│         ],
│         "Cf-Ray": [
│             "92e175956be860e3-LHR"
│         ],
│         "Content-Security-Policy": [
│             "frame-ancestors *.bluemix.net *.compose.fastkit *.cloud.ibm.com cloud.ibm.com"
│         ],
│         "Content-Type": [
│             "application/json; charset=utf-8"
│         ],
│         "Date": [
│             "Thu, 10 Apr 2025 10:11:20 GMT"
│         ],
│         "Referrer-Policy": [
│             "strict-origin-when-cross-origin"
│         ],
│         "Server": [
│             "cloudflare"
│         ],
│         "Strict-Transport-Security": [
│             "max-age=63072000; includeSubDomains"
│         ],
│         "X-Content-Type-Options": [
│             "nosniff"
│         ],
│         "X-Download-Options": [
│             "noopen"
│         ],
│         "X-Envoy-Upstream-Service-Time": [
│             "1946"
│         ],
│         "X-Permitted-Cross-Domain-Policies": [
│             "none"
│         ],
│         "X-Request-Id": [
│             "35c1b172-18b0-4a59-bf5d-42cd1da707a1"
│         ],
│         "X-Runtime": [
│             "1.940561"
│         ],
│         "X-Xss-Protection": [
│             "0"
│         ]
│     },
│     "Result": {
│         "errors": {
│             "errors": "not_found",
│             "hint": "You may need to URL-encode any included CRN(s), see https://cloud.ibm.com/apidocs/cloud-databases-api/cloud-databases-api-v5#deployment-ids-and-crns for details"
│         }
│     },
│     "RawResult": null
│ }
│ 
│ 
│   with module.postgresql_db.ibm_database.postgresql_db,
│   on ../../main.tf line 180, in resource "ibm_database" "postgresql_db":
│  180: resource "ibm_database" "postgresql_db" {

Note: There is nothing wrong with the CRN.
Note: To minimise scope, the location of the replica is the same as the location of the original instance and the same as the region on the IBM provider block.

Panic Output

Expected Behavior

The admin password should have been set.

Actual Behavior

The error was generated, after the instance had been created, but before the configuration was complete.

Steps to Reproduce

1. terraform apply

Important Factoids

References

• #0000