PostgreSQL configuration variable invalid field

[MatthewLemmond]

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

1. terraform apply

Important Factoids

References

• feat: add missing configuration parameters and add validations for plan-time terraform-ibm-modules/terraform-ibm-icd-postgresql#424

[ramirezalfredo]

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.