tests.system.test_database_api: test_db_run_in_transaction_then_snapshot_execute_sql failed

[flaky-bot]

This test failed!

To configure my behavior, see the Flaky Bot documentation.

If I'm commenting on this issue too often, add the flakybot: quiet label and
I will stop commenting.

---

commit: d88b37f
buildURL: Build Status, Sponge
status: failed

Test output

args = (name: "projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44"
,)
kwargs = {'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}
@functools.wraps(callable_)
def error_remapped_callable(*args, **kwargs):
    try:


      return callable_(*args, **kwargs)


.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:72:

self = <grpc._channel._UnaryUnaryMultiCallable object at 0x7f24de58cf70>

request = name: "projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44"
timeout = 20.0

metadata = [('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')]

credentials = None, wait_for_ready = None, compression = None
def __call__(self,
             request,
             timeout=None,
             metadata=None,
             credentials=None,
             wait_for_ready=None,
             compression=None):
    state, call, = self._blocking(request, timeout, metadata, credentials,
                                  wait_for_ready, compression)


  return _end_unary_response_blocking(state, call, False, None)


.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:946:

state = <grpc._channel._RPCState object at 0x7f24de5958e0>

call = <grpc._cython.cygrpc.SegregatedCall object at 0x7f24de59a540>

with_call = False, deadline = None
def _end_unary_response_blocking(state, call, with_call, deadline):
    if state.code is grpc.StatusCode.OK:
        if with_call:
            rendezvous = _MultiThreadedRendezvous(state, call, None, deadline)
            return state.response, rendezvous
        else:
            return state.response
    else:


      raise _InactiveRpcError(state)


E           grpc._channel._InactiveRpcError: <_InactiveRpcError of RPC that terminated with:

E           	status = StatusCode.DEADLINE_EXCEEDED

E           	details = "Deadline Exceeded"

E           	debug_error_string = "UNKNOWN:Deadline Exceeded {created_time:"2022-09-26T09:33:54.385301867+00:00", grpc_status:4}"

E           >
.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:849: _InactiveRpcError
The above exception was the direct cause of the following exception:
shared_instance = <google.cloud.spanner_v1.instance.Instance object at 0x7f24de56dd60>

database_operation_timeout = 120

database_dialect = <DatabaseDialect.POSTGRESQL: 2>
@pytest.fixture(scope="session")
def shared_database(shared_instance, database_operation_timeout, database_dialect):
    database_name = _helpers.unique_id("test_database")
    pool = spanner_v1.BurstyPool(labels={"testcase": "database_api"})
    if database_dialect == DatabaseDialect.POSTGRESQL:
        database = shared_instance.database(
            database_name,
            pool=pool,
            database_dialect=database_dialect,
        )
        operation = database.create()
        operation.result(database_operation_timeout)  # raises on failure / timeout.

        operation = database.update_ddl(ddl_statements=_helpers.DDL_STATEMENTS)


      operation.result(database_operation_timeout)  # raises on failure / timeout.


tests/system/conftest.py:190:

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:132: in result

self._blocking_poll(timeout=timeout, **kwargs)

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:110: in blocking_poll

retry(self._done_or_raise)(**kwargs)

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:283: in retry_wrapped_func

return retry_target(

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:190: in retry_target

return target()

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/future/polling.py:88: in _done_or_raise

if not self.done(**kwargs):

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operation.py:170: in done

self._refresh_and_update(retry)

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operation.py:158: in _refresh_and_update

self._operation = self._refresh(retry=retry)

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/operations_v1/operations_client.py:142: in get_operation

return self._get_operation(

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/gapic_v1/method.py:154: in call

return wrapped_func(*args, **kwargs)

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:283: in retry_wrapped_func

return retry_target(

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:190: in retry_target

return target()

.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/timeout.py:210: in func_with_timeout

return func(*args, **kwargs)

args = (name: "projects/precise-truck-742/instances/google-cloud-1664184764519/databases/test_database-1664184766645/operations/_auto_op_7db379a90510aa44"

,)

kwargs = {'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}
@functools.wraps(callable_)
def error_remapped_callable(*args, **kwargs):
    try:
        return callable_(*args, **kwargs)
    except grpc.RpcError as exc:


      raise exceptions.from_grpc_error(exc) from exc


E           google.api_core.exceptions.DeadlineExceeded: 504 Deadline Exceeded
.nox/system-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:74: DeadlineExceeded

[flaky-bot]

Test passed for commit 2a74060 (Build Status, Sponge)! Closing this issue.