Skip to content

tests.system.test_database_api: test_db_run_in_transaction_then_snapshot_execute_sql failed #818

Closed
@flaky-bot

Description

@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

Metadata

Metadata

Assignees

Labels

api: spannerIssues related to the googleapis/python-spanner API.flakybot: issueAn issue filed by the Flaky Bot. Should not be added manually.priority: p1Important issue which blocks shipping the next release. Will be fixed prior to next release.type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions