Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

gcp:sql/user:User Error setting disabled: Invalid address to set: []string{"disabled"} #861

Closed
dstoyanoff opened this issue Jul 25, 2022 · 5 comments
Closed

gcp:sql/user:User Error setting disabled: Invalid address to set: []string{"disabled"} #861

dstoyanoff opened this issue Jul 25, 2022 · 5 comments
Labels
kind/bug Some behavior is incorrect or out of spec resolution/duplicate This issue is a duplicate of another issue

Comments

@dstoyanoff
Copy link

dstoyanoff commented Jul 25, 2022 •
edited
Loading

What happened?

I have started getting an error on refresh, related to a gcp sql User. The error states this:

    error: Preview failed: refreshing urn:pulumi:uat::sportsbook::gcp:sql/user:User::api: 1 error occurred:
        * Error setting disabled: Invalid address to set: []string{"disabled"}

I have tried to remove the user from the stack manually and import it again, but getting the same error on import.

I can't understand what is this error related to, since there is no such property 'disabled' on the user level.

Steps to reproduce

Expected Behavior

Should work or at least show a meaningful error

Actual Behavior

Refresh/import fails. Up is ok for other resources of the stack

Versions used

    "@pulumi/gcp": "6.32.0",
    "@pulumi/kubernetes": "3.20.1",
    "@pulumi/pulumi": "3.36.0",

CLI          
Version      3.36.0
Go Version   go1.18.4
Go Compiler  gc

Plugins
NAME    VERSION
nodejs  unknown

Host     
OS       darwin
Version  13.0
Arch     arm64

This project is written in nodejs: executable='/Users/danielstoyanoff/.nvm/versions/node/v16.13.2/bin/node' version='v16.13.2'

Current Stack: uat

TYPE                                                        URN
pulumi:pulumi:Stack                                         urn:pulumi:uat::sportsbook::pulumi:pulumi:Stack::sportsbook-uat
kubernetes:helm.sh/v3:Chart                                 urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart::datadog
pulumi:providers:pulumi                                     urn:pulumi:uat::sportsbook::pulumi:providers:pulumi::default
pulumi:pulumi:StackReference                                urn:pulumi:uat::sportsbook::pulumi:pulumi:StackReference::spodio/admin/uat
pulumi:providers:gcp                                        urn:pulumi:uat::sportsbook::pulumi:providers:gcp::default_6_32_0
gcp:projects/service:Service                                urn:pulumi:uat::sportsbook::gcp:projects/service:Service::sql-admin-api
gcp:projects/service:Service                                urn:pulumi:uat::sportsbook::gcp:projects/service:Service::redis-api
gcp:projects/service:Service                                urn:pulumi:uat::sportsbook::gcp:projects/service:Service::secret-manager-api
gcp:projects/service:Service                                urn:pulumi:uat::sportsbook::gcp:projects/service:Service::service-networking-api
gcp:serviceAccount/account:Account                          urn:pulumi:uat::sportsbook::gcp:serviceAccount/account:Account::platform-service-account
gcp:projects/iAMCustomRole:IAMCustomRole                    urn:pulumi:uat::sportsbook::gcp:projects/iAMCustomRole:IAMCustomRole::platform-service-account-custom-role
gcp:projects/iAMBinding:IAMBinding                          urn:pulumi:uat::sportsbook::gcp:projects/iAMBinding:IAMBinding::developers-group-viewer-access
gcp:projects/iAMBinding:IAMBinding                          urn:pulumi:uat::sportsbook::gcp:projects/iAMBinding:IAMBinding::developers-group-browser-access
gcp:projects/service:Service                                urn:pulumi:uat::sportsbook::gcp:projects/service:Service::kubernetes-api
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::two-factor-authentication-key
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::ip-registry-key
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::coins-paid-public-key
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::coins-paid-private-key
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::gbg-id-scan-password
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::fixer-api-key
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::gbg-id-scan-username
gcp:compute/network:Network                                 urn:pulumi:uat::sportsbook::gcp:compute/network:Network::spodio-platform
gcp:serviceAccount/key:Key                                  urn:pulumi:uat::sportsbook::gcp:serviceAccount/key:Key::platform-service-account-key
gcp:projects/iAMBinding:IAMBinding                          urn:pulumi:uat::sportsbook::gcp:projects/iAMBinding:IAMBinding::platform-service-account-custom-role-iam-binding
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::ip-registry-key-iam-member
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::fixer-api-key-version
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::coins-paid-private-key-iam-member
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::gbg-id-scan-password-version
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::two-factor-authentication-key-version
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::ip-registry-key-version
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::coins-paid-private-key-version
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::two-factor-authentication-key-iam-member
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::gbg-id-scan-username-iam-member
gcp:compute/firewall:Firewall                               urn:pulumi:uat::sportsbook::gcp:compute/firewall:Firewall::spodio-platform-allow-ssh
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::fixer-api-key-iam-member
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::gbg-id-scan-password-iam-member
gcp:compute/globalAddress:GlobalAddress                     urn:pulumi:uat::sportsbook::gcp:compute/globalAddress:GlobalAddress::google-managed-services-spodio-platform
gcp:redis/instance:Instance                                 urn:pulumi:uat::sportsbook::gcp:redis/instance:Instance::platform-redis
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::coins-paid-public-key-version
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::coins-paid-public-key-iam-member
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::gbg-id-scan-username-version
gcp:compute/instance:Instance                               urn:pulumi:uat::sportsbook::gcp:compute/instance:Instance::reports-sftp
gcp:servicenetworking/connection:Connection                 urn:pulumi:uat::sportsbook::gcp:servicenetworking/connection:Connection::private-service-connection
gcp:sql/databaseInstance:DatabaseInstance                   urn:pulumi:uat::sportsbook::gcp:sql/databaseInstance:DatabaseInstance::cms
pulumi:pulumi:StackReference                                urn:pulumi:uat::sportsbook::pulumi:pulumi:StackReference::spodio/sportsbook/uat
gcp:container/cluster:Cluster                               urn:pulumi:uat::sportsbook::gcp:container/cluster:Cluster::platform
pulumi:providers:kubernetes                                 urn:pulumi:uat::sportsbook::pulumi:providers:kubernetes::gkeK8s
gcp:container/nodePool:NodePool                             urn:pulumi:uat::sportsbook::gcp:container/nodePool:NodePool::linux-node-pool
gcp:projects/iAMCustomRole:IAMCustomRole                    urn:pulumi:uat::sportsbook::gcp:projects/iAMCustomRole:IAMCustomRole::bolla-cms-service-account-custom-role
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::mailjet-api-key-bolla
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::mailjet-api-secret-bolla
gcp:compute/securityPolicy:SecurityPolicy                   urn:pulumi:uat::sportsbook::gcp:compute/securityPolicy:SecurityPolicy::bolla-access-policy
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::plivo-auth-id-bolla
gcp:storage/bucket:Bucket                                   urn:pulumi:uat::sportsbook::gcp:storage/bucket:Bucket::bolla-cms-uat
gcp:serviceAccount/account:Account                          urn:pulumi:uat::sportsbook::gcp:serviceAccount/account:Account::bolla-cms-service-account
gcp:redis/instance:Instance                                 urn:pulumi:uat::sportsbook::gcp:redis/instance:Instance::bolla-cms-redis
gcp:compute/globalAddress:GlobalAddress                     urn:pulumi:uat::sportsbook::gcp:compute/globalAddress:GlobalAddress::core-ingress-ip
gcp:compute/sSLPolicy:SSLPolicy                             urn:pulumi:uat::sportsbook::gcp:compute/sSLPolicy:SSLPolicy::platform-ssl-policy
gcp:secretmanager/secret:Secret                             urn:pulumi:uat::sportsbook::gcp:secretmanager/secret:Secret::plivo-auth-token-bolla
gcp:sql/database:Database                                   urn:pulumi:uat::sportsbook::gcp:sql/database:Database::betian-cms-28a09c5
gcp:sql/user:User                                           urn:pulumi:uat::sportsbook::gcp:sql/user:User::betian-cms-user-96b15b6
kubernetes:core/v1:Namespace                                urn:pulumi:uat::sportsbook::kubernetes:core/v1:Namespace::ops
kubernetes:core/v1:Namespace                                urn:pulumi:uat::sportsbook::kubernetes:core/v1:Namespace::bolla
kubernetes:core/v1:Namespace                                urn:pulumi:uat::sportsbook::kubernetes:core/v1:Namespace::core
gcp:container/nodePool:NodePool                             urn:pulumi:uat::sportsbook::gcp:container/nodePool:NodePool::windows-node-pool
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::mailjet-api-key-bolla-version
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::mailjet-api-secret-bolla-version
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::plivo-auth-token-bolla-version
gcp:compute/globalAddress:GlobalAddress                     urn:pulumi:uat::sportsbook::gcp:compute/globalAddress:GlobalAddress::bolla-ingress-ip
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::mailjet-api-secret-bolla-iam-member
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::plivo-auth-id-bolla-iam-member
gcp:storage/bucketIAMBinding:BucketIAMBinding               urn:pulumi:uat::sportsbook::gcp:storage/bucketIAMBinding:BucketIAMBinding::bolla-cms-uat-public-access
gcp:projects/iAMBinding:IAMBinding                          urn:pulumi:uat::sportsbook::gcp:projects/iAMBinding:IAMBinding::bolla-cms-service-account-custom-role-iam-binding
gcp:secretmanager/secretVersion:SecretVersion               urn:pulumi:uat::sportsbook::gcp:secretmanager/secretVersion:SecretVersion::plivo-auth-id-bolla-version
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::mailjet-api-key-bolla-iam-member
gcp:serviceAccount/key:Key                                  urn:pulumi:uat::sportsbook::gcp:serviceAccount/key:Key::bolla-cms-service-account-key
gcp:secretmanager/secretIamMember:SecretIamMember           urn:pulumi:uat::sportsbook::gcp:secretmanager/secretIamMember:SecretIamMember::plivo-auth-token-bolla-iam-member
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::datadog-secret
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::bolla-cms-key-store
kubernetes:cloud.google.com/v1:BackendConfig                urn:pulumi:uat::sportsbook::kubernetes:cloud.google.com/v1:BackendConfig::bolla-backend-config
kubernetes:networking.gke.io/v1:ManagedCertificate          urn:pulumi:uat::sportsbook::kubernetes:networking.gke.io/v1:ManagedCertificate::bolla-cert
kubernetes:cloud.google.com/v1:BackendConfig                urn:pulumi:uat::sportsbook::kubernetes:cloud.google.com/v1:BackendConfig::bolla-cms-backend-config
kubernetes:networking.gke.io/v1beta1:FrontendConfig         urn:pulumi:uat::sportsbook::kubernetes:networking.gke.io/v1beta1:FrontendConfig::bolla-ingress-frontend-config
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::config-service
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::key-store-rabbit-mq
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::up-bolla
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::service-account-key-file
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::rabbitmq
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::api
kubernetes:networking.gke.io/v1:ManagedCertificate          urn:pulumi:uat::sportsbook::kubernetes:networking.gke.io/v1:ManagedCertificate::core-cert
kubernetes:networking.gke.io/v1beta1:FrontendConfig         urn:pulumi:uat::sportsbook::kubernetes:networking.gke.io/v1beta1:FrontendConfig::core-ingress-frontend-config
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::softswiss
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::up-report-api
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::up-admin
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::up-lsports
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::up-betting-feed
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::bolla-cms-service-account-key-file
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::bolla
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:core/v1:Service::bolla-cms
kubernetes:apps/v1:StatefulSet                              urn:pulumi:uat::sportsbook::kubernetes:apps/v1:StatefulSet::rabbitmq
kubernetes:networking.k8s.io/v1:Ingress                     urn:pulumi:uat::sportsbook::kubernetes:networking.k8s.io/v1:Ingress::core-ingress
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:apps/v1:Deployment::bolla-cms
kubernetes:networking.k8s.io/v1:Ingress                     urn:pulumi:uat::sportsbook::kubernetes:networking.k8s.io/v1:Ingress::bolla-ingress
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:apps/v1:Deployment::bolla
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:Service::ops/datadog-cluster-agent
kubernetes:core/v1:Service                                  urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:Service::ops/datadog-cluster-agent-admission-controller
kubernetes:core/v1:ConfigMap                                urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:ConfigMap::ops/datadog-installinfo
kubernetes:rbac.authorization.k8s.io/v1:Role                urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:Role::ops/datadog-cluster-agent-main
kubernetes:core/v1:ServiceAccount                           urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:ServiceAccount::ops/datadog
kubernetes:rbac.authorization.k8s.io/v1:ClusterRoleBinding  urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:ClusterRoleBinding::datadog-cluster-agent
kubernetes:rbac.authorization.k8s.io/v1:ClusterRoleBinding  urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:ClusterRoleBinding::datadog
kubernetes:rbac.authorization.k8s.io/v1:ClusterRole         urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:ClusterRole::datadog
kubernetes:rbac.authorization.k8s.io/v1:RoleBinding         urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:RoleBinding::ops/datadog-cluster-agent-main
kubernetes:core/v1:ServiceAccount                           urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:ServiceAccount::ops/datadog-cluster-agent
kubernetes:rbac.authorization.k8s.io/v1:ClusterRole         urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:rbac.authorization.k8s.io/v1:ClusterRole::datadog-cluster-agent
kubernetes:apps/v1:DaemonSet                                urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:apps/v1:DaemonSet::ops/datadog
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:core/v1:Secret::ops/datadog-cluster-agent
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:helm.sh/v3:Chart$kubernetes:apps/v1:Deployment::ops/datadog-cluster-agent
gcp:sql/databaseInstance:DatabaseInstance                   urn:pulumi:uat::sportsbook::gcp:sql/databaseInstance:DatabaseInstance::sportsbook-uat-2019
gcp:sql/database:Database                                   urn:pulumi:uat::sportsbook::gcp:sql/database:Database::Spodio
kubernetes:core/v1:Secret                                   urn:pulumi:uat::sportsbook::kubernetes:core/v1:Secret::key-store-api
kubernetes:batch/v1:CronJob                                 urn:pulumi:uat::sportsbook::kubernetes:batch/v1:CronJob::fixer-currency-rates-cron
kubernetes:batch/v1:CronJob                                 urn:pulumi:uat::sportsbook::kubernetes:batch/v1:CronJob::coins-paid-currency-rates-cron
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:apps/v1:Deployment::config-service
kubernetes:batch/v1:CronJob                                 urn:pulumi:uat::sportsbook::kubernetes:batch/v1:CronJob::lsports-match-tracker-cron
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:apps/v1:Deployment::softswiss
kubernetes:batch/v1:CronJob                                 urn:pulumi:uat::sportsbook::kubernetes:batch/v1:CronJob::softswiss-games-update-cron
kubernetes:apps/v1:Deployment                               urn:pulumi:uat::sportsbook::kubernetes:apps/v1:Deployment::api
gcp:sql/databaseInstance:DatabaseInstance                   urn:pulumi:uat::sportsbook::gcp:sql/databaseInstance:DatabaseInstance::sportsbook-uat-2019-replica


Found no pending operations associated with uat

Backend        
Name           pulumi.com
URL            https://app.pulumi.com/spodio
User           spodio
Organizations  spodio

Pulumi locates its logs in /var/folders/39/0clft0sj4t54t6k8jbhlggcr0000gn/T/ by default
warning: Failed to get information about the Pulumi program's plugins: Could not find either /Users/danielstoyanoff/dev/spodio/sportsbook/infrastructure/yarn.lock or /Users/danielstoyanoff/dev/spodio/sportsbook/infrastructure/package-lock.json

Additional context

Here is the user object:

  const user = new sql.User(
    userUsername,
    {
      name: userUsername,
      instance: instance.name,
      password: userPassword,
    },
    {
      protect: true,
      import: `${gcpConfig.project}/${instanceName}/api`,
    }
  );

Contributing

Vote on this issue by adding a 👍 reaction.
To contribute a fix for this issue, leave a comment (and link to your pull request, if you've opened one already).
@dstoyanoff dstoyanoff added kind/bug Some behavior is incorrect or out of spec needs-triage Needs attention from the triage team labels Jul 25, 2022
@Frassle Frassle transferred this issue from pulumi/pulumi Jul 25, 2022
@Frassle
Copy link
Member

Frassle commented Jul 25, 2022

Moving to pulumi-gpc, this looks like an error in the provider read method.

@dstoyanoff
Copy link
Author

Here are my thoughts upon further investigation.

I have tried to manually call the GCP rest API to list all users. This is how the response looks like:

{
  "kind": "sql#usersList",
  "items": [
    {
      "kind": "sql#user",
      "etag": "0d38779023f5ac855a4e91a20a8d6f58dc3f86c30747622eeb57103f8039fabe",
      "name": "##MS_PolicyTsqlExecutionLogin##",
      "host": "",
      "instance": "sportsbook-uat-2019",
      "project": "spodio-340306",
      "sqlserverUserDetails": {
        "disabled": true
      }
    },
    {
      "kind": "sql#user",
      "etag": "1527c29d14243f5ec0512d1579e08f706a1f019eb56b53dee0a0fcfc286c9b48",
      "name": "sqlserver",
      "host": "",
      "instance": "sportsbook-uat-2019",
      "project": "spodio-340306",
      "sqlserverUserDetails": {
        "serverRoles": [
          "CustomerDbRootRole"
        ]
      }
    },
    {
      "kind": "sql#user",
      "etag": "6ecfbf714f4e3259ea9685045c4862a31def25a337beb6ca8bbac2b9b41110a0",
      "name": "api",
      "host": "",
      "instance": "sportsbook-uat-2019",
      "project": "spodio-340306",
      "sqlserverUserDetails": {
        "serverRoles": [
          "CustomerDbRootRole"
        ]
      }
    },
    {
      "kind": "sql#user",
      "etag": "dc9a25e69379c9f4de44f7c4504b7b96c5fd65eb6a50c8c8fd36fc3cfa165dbb",
      "name": "##MS_PolicyEventProcessingLogin##",
      "host": "",
      "instance": "sportsbook-uat-2019",
      "project": "spodio-340306",
      "sqlserverUserDetails": {
        "disabled": true
      }
    }
  ]
}

My guess is that the issues comes from the sqlserverUserDetails.disabled property. What I can see however is that there is a difference in the casing here and inside of the pulumi interface. In Google's API, the property is called sqlserverUserDetails, while in the pulumi/gcp implementation, it is called sqlServerUserDetails.

Upon further checks, it seems this was typed properly in pulumi-google-native, so I am guessing this is what's causing the problem

@dstoyanoff dstoyanoff mentioned this issue Jul 26, 2022
Closed
@viveklak
Copy link
Contributor

Marking this a duplicate of #850

@viveklak viveklak added resolution/duplicate This issue is a duplicate of another issue and removed needs-triage Needs attention from the triage team labels Jul 27, 2022
@viveklak
Copy link
Contributor

As mentioned in #850, this is unfortunately coming from the underlying terraform provider. The terraform bug is tracked there. Thanks for trying to fix this in #863 but sadly that will not fix it since the pulumi gcp provider automatically generates against the spec from the underlying terraform provider.

@iGoogIe
Copy link

iGoogIe commented Sep 23, 2022

I believe this is what we're waiting on being fixed - hashicorp/terraform-provider-google#11891

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
kind/bug Some behavior is incorrect or out of spec resolution/duplicate This issue is a duplicate of another issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@viveklak @Frassle @dstoyanoff @iGoogIe