ERROR: gcloud crashed (InterfaceError): Error binding parameter 4 - probably unsupported type. [130561755]

Can't Repro

Bug

More Info Required

Status Update

No update yet.

Description

co...@gmail.com

created issue #1

Apr 16, 2019 12:29PM

WARNING: This is a PUBLIC issue tracker, and as such, anybody can read the
information in the report you file. In order to help diagnose the issue,
we've included some installation information in this report. Please look
through and redact any information you consider personal or sensitive
before submitting this issue.

Issue running command [gcloud auth login].

What steps will reproduce the problem?

What is the expected output? What do you see instead?

Please provide any additional information below.

Trace:
gcloud_main.py:138
gcloud_cli.Execute()
calliope/cli.py:1011
self._HandleAllErrors(exc, command_path_string, specified_arg_names)
calliope/cli.py:1044
exceptions.HandleError(exc, command_path_string, self.__known_error_handler)
calliope/exceptions.py:524
core_exceptions.reraise(exc)
core/exceptions.py:139
six.reraise(type(exc_value), exc_value, tb)
calliope/cli.py:985
resources = calliope_command.Run(cli=self, args=args)
calliope/backend.py:795
resources = command_instance.Run(args)
surface/auth/login.py:158
c_store.Store(creds, account, scopes)
core/credentials/store.py:454
store = creds.GetCredentialStore()
core/credentials/creds.py:325
_MigrateMultistore2Sqlite()
core/credentials/creds.py:534
sqlite_store.Store(account_id, credential)
core/credentials/creds.py:302
store.put(credentials)
oauth2client/client.py:431
self.locked_put(credentials)
core/credentials/creds.py:247
id_token)
core/credentials/creds.py:194
(account_id, access_token, token_expiry, rapt_token, id_token))
core/credentials/creds.py:179
cur.Execute(*args)
core/credentials/creds.py:108
return self._cursor.execute(*args)
InterfaceError: Error binding parameter 4 - probably unsupported type.

Installation information:

Google Cloud SDK [241.0.0]

Platform: [Mac OS X, x86_64] ('Darwin', 'C02P2BENG3QD', '18.2.0', 'Darwin Kernel Version 18.2.0: Thu Dec 20 20:46:53 PST 2018; root:xnu-4903.241.1~1/RELEASE_X86_64', 'x86_64', 'i386')
Python Version: [2.7.10 (default, Aug 17 2018, 19:45:58) [GCC 4.2.1 Compatible Apple LLVM 10.0.0 (clang-1000.0.42)]]
Python Location: [/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python]
Site Packages: [Disabled]

Installation Root: [${HOME}/google-cloud-sdk]
Installed Components:
core: [2019.04.02]
gsutil: [4.38]
bq: [2.0.43]
System PATH: [/Library/Frameworks/Python.framework/Versions/3.7/bin:${HOME}/google-cloud-sdk/bin:/Library/Frameworks/Python.framework/Versions/3.7/bin:/Library/Frameworks/Python.framework/Versions/3.6/bin:/Library/Frameworks/Python.framework/Versions/3.5/bin:/Library/Frameworks/Python.framework/Versions/3.5/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Postgres.app/Contents/Versions/latest/bin]
Python PATH: [${HOME}/google-cloud-sdk/lib/third_party:${HOME}/google-cloud-sdk/lib:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload]
Cloud SDK on PATH: [False]
Kubectl on PATH: [False]

Installation Properties: [${HOME}/google-cloud-sdk/properties]
User Config Directory: [${CLOUDSDK_CONFIG}]
Active Configuration Name: [jrnl-me]
Active Configuration Path: [${CLOUDSDK_CONFIG}/configurations/config_jrnl-me]

Account: [None]
Project: [None]

Current Properties:
[core]
disable_usage_reporting: [True]

Logs Directory: [${CLOUDSDK_CONFIG}/logs]
Last Log File: [${CLOUDSDK_CONFIG}/logs/2019.04.16/07.56.41.256445.log]

git: [git version 2.20.1 (Apple Git-117)]
ssh: [OpenSSH_7.9p1, LibreSSL 2.7.3]

Comments

gs...@google.com <gs...@google.com> #2Apr 16, 2019 09:55PM

Assigned to gs...@google.com.

Duplicate of

https://issuetracker.google.com/issues/72407295

co...@gmail.com <co...@gmail.com> #3Apr 17, 2019 12:41PM

Hi, this error only affects Cloud SDK version 186. It was previously reported in

Issue 72407295

and a fix for it should be released in Cloud SDK version 187.

In the mean time, you can downgrade to Cloud SDK version 185 as a workaround by running the following command:

gcloud components update --version 185.0.0

co...@gmail.com <co...@gmail.com> #4Apr 17, 2019 12:41PM

output of gcloud info:

C02P2BENG3QD:~ matt$ gcloud info
Google Cloud SDK [242.0.0]

Platform: [Mac OS X, x86_64] ('Darwin', 'C02P2BENG3QD', '18.2.0', 'Darwin Kernel Version 18.2.0: Thu Dec 20 20:46:53 PST 2018; root:xnu-4903.241.1~1/RELEASE_X86_64', 'x86_64', 'i386')
Python Version: [2.7.10 (default, Aug 17 2018, 19:45:58) [GCC 4.2.1 Compatible Apple LLVM 10.0.0 (clang-1000.0.42)]]
Python Location: [/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python]
Site Packages: [Disabled]

Installation Root: [/Users/matt/google-cloud-sdk]
Installed Components:
core: [2019.04.12]
gsutil: [4.38]
bq: [2.0.43]
System PATH: [/Library/Frameworks/Python.framework/Versions/3.7/bin:/Users/matt/google-cloud-sdk/bin:/Library/Frameworks/Python.framework/Versions/3.7/bin:/Library/Frameworks/Python.framework/Versions/3.6/bin:/Library/Frameworks/Python.framework/Versions/3.5/bin:/Library/Frameworks/Python.framework/Versions/3.5/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Postgres.app/Contents/Versions/latest/bin]
Python PATH: [/Users/matt/google-cloud-sdk/lib/third_party:/Users/matt/google-cloud-sdk/lib:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload]
Cloud SDK on PATH: [True]
Kubectl on PATH: [False]

Installation Properties: [/Users/matt/google-cloud-sdk/properties]
User Config Directory: [/Users/matt/.config/gcloud]
Active Configuration Name: [jrnl-me]
Active Configuration Path: [/Users/matt/.config/gcloud/configurations/config_jrnl-me]

Account: [None]
Project: [None]

Current Properties:
[core]
disable_usage_reporting: [True]

Logs Directory: [/Users/matt/.config/gcloud/logs]
Last Log File: [/Users/matt/.config/gcloud/logs/2019.04.17/08.40.08.349499.log]

git: [git version 2.20.1 (Apple Git-117)]
ssh: [OpenSSH_7.9p1, LibreSSL 2.7.3]

co...@gmail.com <co...@gmail.com> #5Apr 17, 2019 12:44PM

C02P2BENG3QD:~ matt$ gcloud app deploy --verbosity=debug
DEBUG: Running [gcloud.app.deploy] with arguments: [--verbosity: "debug"]
DEBUG: Error binding parameter 4 - probably unsupported type.
Traceback (most recent call last):
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/calliope/cli.py", line 985, in Execute
resources = calliope_command.Run(cli=self, args=args)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/calliope/backend.py", line 795, in Run
resources = command_instance.Run(args)
File "/Users/matt/google-cloud-sdk/lib/surface/app/deploy.py", line 85, in Run
api_client = appengine_api_client.GetApiClientForTrack(self.ReleaseTrack())
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/api_lib/app/appengine_api_client.py", line 57, in GetApiClientForTrack
return AppengineApiClient.GetApiClient(api_version)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/api_lib/app/api/appengine_api_client_base.py", line 64, in GetApiClient
return cls(core_apis.GetClientInstance('appengine', api_version))
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/api_lib/util/apis.py", line 301, in GetClientInstance
api_name, api_version, no_http, _CheckResponse, enable_resource_quota)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/api_lib/util/apis_internal.py", line 174, in _GetClientInstance
allow_account_impersonation=allow_account_impersonation)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/http.py", line 79, in Http
allow_account_impersonation=allow_account_impersonation)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/store.py", line 295, in LoadIfEnabled
return Load(allow_account_impersonation=allow_account_impersonation)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/store.py", line 340, in Load
cred = _Load(account, scopes, prevent_refresh)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/store.py", line 399, in _Load
store = creds.GetCredentialStore()
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 329, in GetCredentialStore
_MigrateMultistore2Sqlite()
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 538, in _MigrateMultistore2Sqlite
sqlite_store.Store(account_id, credential)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 306, in Store
store.put(credentials)
File "/Users/matt/google-cloud-sdk/lib/third_party/oauth2client/client.py", line 431, in put
self.locked_put(credentials)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 251, in locked_put
id_token)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 194, in Store
(account_id, access_token, token_expiry, rapt_token, id_token))
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 179, in _Execute
cur.Execute(*args)
File "/Users/matt/google-cloud-sdk/lib/googlecloudsdk/core/credentials/creds.py", line 108, in Execute
return self._cursor.execute(*args)
InterfaceError: Error binding parameter 4 - probably unsupported type.
ERROR: gcloud crashed (InterfaceError): Error binding parameter 4 - probably unsupported type.

If you would like to report this issue, please run the following command:
gcloud feedback

To check gcloud for common problems, please run the following command:
gcloud info --run-diagnostics

Message last modified on Apr 17, 2019 12:45PM

co...@gmail.com <co...@gmail.com> #6Apr 18, 2019 04:56PM

Please help

cm...@google.com <cm...@google.com> #7Apr 19, 2019 04:02AM

Hello,
Can you please provide your app.yaml file ensuring you remove any sensitive information. Also please provide the output of the following command: gcloud info --run-diagnostics

Are you following a guide or some other documentation? You can share it with us. Alternatively, please try a quickstart for the language and Google App Engine runtime that you are using. For instance, for Google App Engine Python 3.7 Standard runtime, try[1]. Note you can choose a different version or a different language right under the Header title in that page. Do you experience the same issue? If you are using App Engine Standard, please check this quickstart for Python[2]

[1]

https://cloud.google.com/appengine/docs/standard/python3/quickstart
[2]

https://cloud.google.com/appengine/docs/flexible/python/quickstart

dh...@google.com <dh...@google.com> #8Apr 19, 2019 10:56AM

Maybe following the steps on this issue can help:

https://issuetracker.google.com/issues/129760345#comment4

gs...@google.com <gs...@google.com> Apr 27, 2019 02:42PM

Status: Won't Fix (Not Reproducible)