René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"tests.system.test_database_api: test_db_run_in_transaction_then_snapshot_execute_sql failed","articleBody":"This test failed!\n\nTo configure my behavior, see [the Flaky Bot documentation](https://github.com/googleapis/repo-automation-bots/tree/main/packages/flakybot).\n\nIf I'm commenting on this issue too often, add the `flakybot: quiet` label and\nI will stop commenting.\n\n---\n\ncommit: d88b37f8333a6be9e55f47467e8f620b54388e11\nbuildURL: [Build Status](https://source.cloud.google.com/results/invocations/88e947a5-080c-42c6-87c5-93e8989f414f), [Sponge](http://sponge2/88e947a5-080c-42c6-87c5-93e8989f414f)\nstatus: failed\n\u003cdetails\u003e\u003csummary\u003eTest output\u003c/summary\u003e\u003cbr\u003e\u003cpre\u003eargs = (name: \"projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44\"\n,)\nkwargs = {'metadata': [('x-goog-request-params', 'name=projects/precise-truck-742/instances/google-cloud-1664184764519/database...ations/_auto_op_7db379a90510aa44'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.49.1 gax/2.10.1')], 'timeout': 20.0}\n\n    @functools.wraps(callable_)\n    def error_remapped_callable(*args, **kwargs):\n        try:\n\u003e           return callable_(*args, **kwargs)\n\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:72: \n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ \n\nself = \u003cgrpc._channel._UnaryUnaryMultiCallable object at 0x7f24de58cf70\u003e\nrequest = name: \"projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44\"\n\ntimeout = 20.0\nmetadata = [('x-goog-request-params', 'name=projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.49.1 gax/2.10.1')]\ncredentials = None, wait_for_ready = None, compression = None\n\n    def __call__(self,\n                 request,\n                 timeout=None,\n                 metadata=None,\n                 credentials=None,\n                 wait_for_ready=None,\n                 compression=None):\n        state, call, = self._blocking(request, timeout, metadata, credentials,\n                                      wait_for_ready, compression)\n\u003e       return _end_unary_response_blocking(state, call, False, None)\n\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:946: \n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ \n\nstate = \u003cgrpc._channel._RPCState object at 0x7f24de5958e0\u003e\ncall = \u003cgrpc._cython.cygrpc.SegregatedCall object at 0x7f24de59a540\u003e\nwith_call = False, deadline = None\n\n    def _end_unary_response_blocking(state, call, with_call, deadline):\n        if state.code is grpc.StatusCode.OK:\n            if with_call:\n                rendezvous = _MultiThreadedRendezvous(state, call, None, deadline)\n                return state.response, rendezvous\n            else:\n                return state.response\n        else:\n\u003e           raise _InactiveRpcError(state)\nE           grpc._channel._InactiveRpcError: \u003c_InactiveRpcError of RPC that terminated with:\nE           \tstatus = StatusCode.DEADLINE_EXCEEDED\nE           \tdetails = \"Deadline Exceeded\"\nE           \tdebug_error_string = \"UNKNOWN:Deadline Exceeded {created_time:\"2022-09-26T09:33:54.385301867+00:00\", grpc_status:4}\"\nE           \u003e\n\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:849: _InactiveRpcError\n\nThe above exception was the direct cause of the following exception:\n\nshared_instance = \u003cgoogle.cloud.spanner_v1.instance.Instance object at 0x7f24de56dd60\u003e\ndatabase_operation_timeout = 120\ndatabase_dialect = \u003cDatabaseDialect.POSTGRESQL: 2\u003e\n\n    @pytest.fixture(scope=\"session\")\n    def shared_database(shared_instance, database_operation_timeout, database_dialect):\n        database_name = _helpers.unique_id(\"test_database\")\n        pool = spanner_v1.BurstyPool(labels={\"testcase\": \"database_api\"})\n        if database_dialect == DatabaseDialect.POSTGRESQL:\n            database = shared_instance.database(\n                database_name,\n                pool=pool,\n                database_dialect=database_dialect,\n            )\n            operation = database.create()\n            operation.result(database_operation_timeout)  # raises on failure / timeout.\n    \n            operation = database.update_ddl(ddl_statements=_helpers.DDL_STATEMENTS)\n\u003e           operation.result(database_operation_timeout)  # raises on failure / timeout.\n\ntests/system/conftest.py:190: \n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ \n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:132: in result\n    self._blocking_poll(timeout=timeout, **kwargs)\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:110: in _blocking_poll\n    retry_(self._done_or_raise)(**kwargs)\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:283: in retry_wrapped_func\n    return retry_target(\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:190: in retry_target\n    return target()\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:88: in _done_or_raise\n    if not self.done(**kwargs):\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operation.py:170: in done\n    self._refresh_and_update(retry)\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operation.py:158: in _refresh_and_update\n    self._operation = self._refresh(retry=retry)\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operations_v1/operations_client.py:142: in get_operation\n    return self._get_operation(\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/gapic_v1/method.py:154: in __call__\n    return wrapped_func(*args, **kwargs)\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:283: in retry_wrapped_func\n    return retry_target(\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:190: in retry_target\n    return target()\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/timeout.py:210: in func_with_timeout\n    return func(*args, **kwargs)\n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ \n\nargs = (name: \"projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44\"\n,)\nkwargs = {'metadata': [('x-goog-request-params', 'name=projects/precise-truck-742/instances/google-cloud-1664184764519/database...ations/_auto_op_7db379a90510aa44'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.49.1 gax/2.10.1')], 'timeout': 20.0}\n\n    @functools.wraps(callable_)\n    def error_remapped_callable(*args, **kwargs):\n        try:\n            return callable_(*args, **kwargs)\n        except grpc.RpcError as exc:\n\u003e           raise exceptions.from_grpc_error(exc) from exc\nE           google.api_core.exceptions.DeadlineExceeded: 504 Deadline Exceeded\n\n.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:74: DeadlineExceeded\u003c/pre\u003e\u003c/details\u003e","author":{"url":"https://github.com/flaky-bot[bot]","@type":"Person","name":"flaky-bot[bot]"},"datePublished":"2022-09-26T09:38:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/818/python-spanner/issues/818"}