René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Unable to write a single column to cloud spanner","articleBody":"Trying to write a single column value to cloud spanner raises an error saying mismatched number of columns and values:\r\n\r\n```python\r\ndef run_txn():\r\n    from google.cloud import spanner\r\n    spanner_client = spanner.Client()\r\n    instance_id = 'your-instance'\r\n    instance = spanner_client.instance(instance_id)\r\n    database_id = 'example-db'\r\n    database = instance.database(database_id)\r\n    def f(t):\r\n      t.insert_or_update(\r\n          table=\"Singers\",\r\n          columns=('SingerId'),\r\n          values = [[6]])\r\n    database.run_in_transaction(f)\r\n\r\nif __name__ == '__main__':\r\n    run_txn()\r\n```\r\n\r\nThis raises the error:\r\n\r\n```python\r\n/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:335: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings\r\n  SNIMissingWarning\r\n/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:133: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings\r\n  InsecurePlatformWarning\r\nTraceback (most recent call last):\r\n  File \"txn.py\", line 16, in \u003cmodule\u003e\r\n    run_txn()\r\n  File \"txn.py\", line 13, in run_txn\r\n    database.run_in_transaction(f)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/cloud/spanner/database.py\", line 379, in run_in_transaction\r\n    return session.run_in_transaction(func, *args, **kw)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/cloud/spanner/session.py\", line 311, in run_in_transaction\r\n    _delay_until_retry(exc, deadline)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/cloud/spanner/session.py\", line 309, in run_in_transaction\r\n    txn.commit()\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/cloud/spanner/transaction.py\", line 114, in commit\r\n    transaction_id=self._id, options=options)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/cloud/gapic/spanner/v1/spanner_client.py\", line 832, in commit\r\n    return self._commit(request, options)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/gax/api_callable.py\", line 428, in inner\r\n    return api_caller(api_call, this_settings, request)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/gax/api_callable.py\", line 416, in base_caller\r\n    return api_call(*args)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/gax/api_callable.py\", line 376, in inner\r\n    return a_func(*args, **kwargs)\r\n  File \"/usr/local/google/home/vikask/venvs/pythonq/local/lib/python2.7/site-packages/google/gax/retry.py\", line 127, in inner\r\n    ' classified as transient', exception)\r\ngoogle.gax.errors.RetryError: GaxError(Exception occurred in retry method that was not classified as transient, caused by \u003c_Rendezvous of RPC that terminated with (StatusCode.INVALID_ARGUMENT, Mutation has mismatched number of columns and values.)\u003e)\r\n```","author":{"url":"https://github.com/vkedia","@type":"Person","name":"vkedia"},"datePublished":"2017-05-17T19:06:07.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3435/google-cloud-python/issues/3435"}