PostgreSQL configuration variable invalid field

The configuration variable is returning an invalid field error for Postgres database configuration when passing max_locks_per_transaction but this variable is documented as supported here

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" "db" {
  name                         = "example-database"
  service                      = "databases-for-postgresql"
  plan                         = "standard"
  location                     = "us-east"

  users {
    name     = "repl"
    password = "repl12345password"
  }

  configuration                = <<CONFIGURATION
  {
    "max_locks_per_transaction": 64
  }
  CONFIGURATION
}

Debug Output

Panic Output

Expected Behavior

provider should accept max_locks_per_transaction as a valid field in configuration

Actual Behavior

│ Error: ---
│ id: terraform-23dab597
Error: [0m summary: "1 error occurred:\n\t* [ERROR] configuration contained invalid field(s):
│  [max_locks_per_transaction]\n\n"

Steps to Reproduce

terraform apply

Important Factoids

References

https://github.com/terraform-ibm-modules/terraform-ibm-icd-postgresql/pull/424

Is this the reason I'm not able to complete the creation of a PostgreSQL database with provider version 1.66?, here's the output:

│ Error: [ERROR] Error updating database configuration failed Unprocessable Entity
│ {
│     "StatusCode": 422,
│     "Headers": {
│         "Cache-Control": [
│             "no-store"
│         ],
│         "Cf-Cache-Status": [
│             "DYNAMIC"
│         ],
│         "Cf-Ray": [
│             "893e50aabd9b8da8-MIA"
│         ],
│         "Content-Security-Policy": [
│             "frame-ancestors *.bluemix.net *.compose.fastkit *.cloud.ibm.com cloud.ibm.com"
│         ],
│         "Content-Type": [
│             "application/json; charset=utf-8"
│         ],
│         "Date": [
│             "Sat, 15 Jun 2024 00:06:36 GMT"
│         ],
│         "Referrer-Policy": [
│             "strict-origin-when-cross-origin"
│         ],
│         "Server": [
│             "cloudflare"
│         ],
│         "Set-Cookie": [
│             "_compose-dashboard_session=J2ppRsTxIL7YHOAIAo4rHADd7QUBxDGMH%2FX1KzzAmexutbx8ZVeglKv7qaUmQI%2F48eN0%2BU0oRq2fzMogqP%2BkPLEzY22hASK68xvnzXm30aZtNFjwxCswKUrtN5OMhZBRA0cJAi9xykNXdCng2N2Sw0rxzgrfox858eYmgu7Ql%2BoX6Wvd1ETV8yg4dosEyZaEMIUTta%2BA0M8D1HuCYLHJrgGWi7zasX%2F3KhfLdZfN%2Fh2uosqHmHADU4P0KQDVziu%2BGj00xrl%2FaEDGJs1Jc%2BZnl83yuMCrothtCwR5cBclt%2BFyPFAbjwasKtlb9idyQnDHN2AUJcrMEI6TNLLWl8YyrDTFhGQS0aYZnavXUkHV3eOSUsl02UQQgubUwmaTs3hiZvPJtFwyV7OeNFgEKy6f4YiiIzlrTH%2BAFnD%2FrfdZVjpHuUeyfyeijtMBrnKxyBqRQsclYYEHJeMF8osH4NyAXS3aIVtZhrUNQVLEsTb9VwT7TvVd6I3kTlcu0s0b3YsyveSosdSseXP2I4muMpgsmGjhe55bNo%2BeEO%2B2lGxuBNlSdg2j5VCVWK40RvqoLqMpqANmjyB6cBQtNwmUIx0NyRVPh7qZXGqQmcXUkfOSJ3BN%2FbDLOTSPwWHt5Z7iBRx4OYXN25FmQtra5wIHaeEAUjZR4RF%2BAwL%2Bh4WcS09j9VG5TcwmWG%2BusFqlkhuEfoy38Hv2j7SeybiqC5xVUZ6%2Bj0%2BA56pd5mksaJxj5zuqwzi0jHfH1dohiF3BDtV%2BnRhch7BqXyPE6jrW3zMbneBclGQ98SonKN8ZivCGoxfpOdF3AvtJeRdZ9hmbxM9h3wjgmaJaoPFfaS5lXbgw%2FH8sG0Gdr4U1fNbJjxqmzo%2B6sdTW4Lh8eWOq%2B3CQJg4MVfiUsE58TppMBq6z3ZonJalU%2BaqbqFjiZaCJqXiXDmmpns51ZYMO2VhnUE0fa4azH22xl9Sb1A3EI3bsVmF3rWlQqg78K%2FuTT4AGRBp0dUrN%2BPjqJUtQjtuLfNK%2BUw%2B76qqOhzVefZM2U7J%2FR4XCysvMm8o%2FAcWJ771VQLLognKSaA4F7zgtvd9nnGgyDEZff8JTBBbrC98BIyVa6dTGqE5DT42P6r%2B9sLTGWcz8dhg3nlWEurycvBvVJmO5qnmnxXp8bdCapUXIQnQFk30YSmPeHJuG05N8IcVmVRcKuxStjQB0LbnWHVi2%2FG9pghW1%2BYTH1GTHiO7bYh8tjWnZybKqZBr%2BQBDSPFIIK7a4VThMOjCsY%2B5fMe3z9gjsPDtPBaqb2R%2FRCqYzkbAAF2tuHQBGfDfzdlOmbPaG3sJfTSkw3nVGmtmLUUmXVX981lTGsyLxIJMiAg46VzozIpCrZZwH8JFEFfuoW33vFaUMWWbgjaF0MggKmyzkaMH72D57u1DLIL38PvgpnRXNz1ROS2FbQM9OMHzZmlWTg9j5YjaUnUtqq8yYClEgFtMsAB93GjaH5kSKgg8Db38B%2F%2FS2wjYAAbGrJ15CGcAUWO%2Bh9VYgzh2Wn6Jgxel1jYT2sUU7M8v7YmpXuHSJSJx2GBKH3knXDrgxutHAlUDuPzQPBMtUcB1TxKnYbtgQdnWRqjMe%2FBicety5p3APNBKguASw25ifeIyTJF2OClVVtSK8uYqfjhIy9BcoIBiYG8pHvoOAVSQScz08wTLe5FC4Un7iOwBfOi1qsvVNAH38qFsadNCy%2FmO43EbCvml4DAqLoKgeL422MbUkMIP8Tw69MQLFsStXSEJiQHQtlEq5CwqVsJdVxRkrZjBkLUeTHfaQ6DlK1phEL14CkN%2BENz6LYrkC88Hm4Jih9Sah8SO4y7eim8bfjN9gl9QJ3xtsSOvEvlJtEwmVYF80RvptfZ2BgLCcOQFpN7rzOPXV1jyONNJJyYeaH8dlzcK4tleremLCcym9L%2FvnoAqTU60AsXN4zGszp9j3CrB3vca0AyxmkVO13ck765L9FkFyNvGBDwTija2Xjy7Z9qiEJ8GDPG0HH9qysudDVeJoX3X9AonvqnDQFugnlamu%2BA9uDzzqum4IxSzgLoN0w7Q1Acm8TDrqq1yAcIpNSbe5AkKIXCZoQYBGmAh59Tf6nIos1xQmwGSLXRjXj5CGolXFBNpGWxtvc%2Fo70zEBBjDavh7hd%2FJhbMrc5GOEYTM5KoOV%2BIDJNm7NINbpvM1Nz3TCn3fDVPRzA%2B5pGgGL24XcVY0QSLO2dNiRm0ZsRu2xb4pn3K7WgcXVJG2tve%2BxzallOyTJeqAEwAOCiyzL3irnBw%2FH3SiizwYxmEO7bClvc0%2B5Qwtg0noHYir3rh2nBFrdgLD6z2NnEP3kEtVk%2Bb0Y9A9T2HisOocvkuujpFmClP0JtJ5S1VbUPAQ79ugjKfUbh0WtZNzIXBeSEKTo%2Bkj%2FPFxyE0UMbjBq5c%2BDs%2FcrPmuCSbMXSRSaPlGCko4U1zaGM7xiWRUkJ3LpHu7xlEzrLSn%2F6wEfU24ar%2BSkBQ%2FnOUn3jEtpm3ihz3gOrniEKHEueQxtF15eqDnUjMUaO3Y1Ckv7IVuzr58SuHpsNkZ65%2FSp1UoJykrriaKxRKx9SVO%2FwXva9jAlzTz%2FPIqR%2BzIfvXVL8jGSPAZPkzEs19xJnuOBxnzGQm%2B56Qi7cNCt2L9EJ7hH%2FsY%2FUQ2CsSgqqicTz8tfUQMFSiqHwxQYqNel2goZvLmKIIkWMDSwNEH8FXid0Ab2wFcRZK1JXDTPEYeZGg22PowVGENCp9KOEAi3MS8%2BudWRzb875Q9Yqh03XDh9gFfX%2FvXqv6KL%2B8hGX7%2FNbmshX9RKF%2BMsUDI1xSF%2BY6OtaUBp4z%2B7Onc5rXNj0BIiQ0DsZY%2Fxg8E5hT8QVvv5OTYPErxIzjMbzXgX--fFiRPuX3mRcWJKW%2B--C4SVF1SDTXHauxFne6Wgig%3D%3D; path=/; secure; httponly; SameSite=Lax"
│         ],
│         "Strict-Transport-Security": [
│             "max-age=63072000; includeSubDomains"
│         ],
│         "X-Content-Type-Options": [
│             "nosniff"
│         ],
│         "X-Download-Options": [
│             "noopen"
│         ],
│         "X-Envoy-Upstream-Service-Time": [
│             "303"
│         ],
│         "X-Permitted-Cross-Domain-Policies": [
│             "none"
│         ],
│         "X-Request-Id": [
│             "6ba46ee2-1d7d-4a89-83b6-e20ef9f2f52e"
│         ],
│         "X-Runtime": [
│             "0.299083"
│         ],
│         "X-Xss-Protection": [
│             "0"
│         ]
│     },
│     "Result": {
│         "errors": {
│             "configuration": [
│                 "can't be blank"
│             ]
│         }
│     },
│     "RawResult": null
│ }

Database is created successfully but in the terraform state, gets tainted and next run will destroyed and recreated.

IBM-Cloud / terraform-provider-ibm