tests.system.test_session_api: test_transaction_execute_update_dml_returning failed #929
Description
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: 4990728
buildURL: Build Status, Sponge
status: failed
Test output
args = (session: "projects/precise-truck-742/instances/google-cloud-1681362231247/databases/test_sessions_1681362343647/sessi..., \'wylma@example.com\') RETURNING contact_id, first_name, last_name, email"
params {
}
seqno: 2
request_options {
}
,)
kwargs = {'metadata': [('google-cloud-resource-prefix', 'projects/precise-truck-742/instances/google-cloud-1681362231247/databa...pj4SDwnGT7q1XRIAQ'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.54.0rc1 gax/2.11.0 gccl/3.31.0')], 'timeout': 30.0}
@functools.wraps(callable_)
def error_remapped_callable(*args, **kwargs):
try:
return callable_(*args, **kwargs)
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:72:
self = <grpc._channel._UnaryUnaryMultiCallable object at 0x7f8d0455a3a0>
request = session: "projects/precise-truck-742/instances/google-cloud-1681362231247/databases/test_sessions_1681362343647/sessio...', 'wylma@example.com') RETURNING contact_id, first_name, last_name, email"
params {
}
seqno: 2
request_options {
}
timeout = 30.0
metadata = [('google-cloud-resource-prefix', 'projects/precise-truck-742/instances/google-cloud-1681362231247/databases/test_sess...kUoGBIYiA_MO1Rw9aYpj4SDwnGT7q1XRIAQ'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.54.0rc1 gax/2.11.0 gccl/3.31.0')]
credentials = None, wait_for_ready = None, compression = None
def __call__(self,
request: Any,
timeout: Optional[float] = None,
metadata: Optional[MetadataType] = None,
credentials: Optional[grpc.CallCredentials] = None,
wait_for_ready: Optional[bool] = None,
compression: Optional[grpc.Compression] = None) -> Any:
state, call, = self._blocking(request, timeout, metadata, credentials,
wait_for_ready, compression)
return _end_unary_response_blocking(state, call, False, None)
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:1030:
state = <grpc._channel._RPCState object at 0x7f8d044d2850>
call = <grpc._cython.cygrpc.SegregatedCall object at 0x7f8d044d3a00>
with_call = False, deadline = None
def _end_unary_response_blocking(
state: _RPCState, call: cygrpc.SegregatedCall, with_call: bool,
deadline: Optional[float]
) -> Union[ResponseType, Tuple[ResponseType, grpc.Call]]:
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) # pytype: disable=not-instantiable
E grpc._channel._InactiveRpcError: <_InactiveRpcError of RPC that terminated with:
E status = StatusCode.ABORTED
E details = "Transaction was aborted."
E debug_error_string = "UNKNOWN:Error received from peer ipv4:74.125.142.95:443 {grpc_message:"Transaction was aborted.", grpc_status:10, created_time:"2023-04-13T05:06:28.881724968+00:00"}"
E >
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/grpc/_channel.py:910: _InactiveRpcError
The above exception was the direct cause of the following exception:
sessions_database = <google.cloud.spanner_v1.database.Database object at 0x7f8d044f6af0>
sessions_to_delete = [<google.cloud.spanner_v1.session.Session object at 0x7f8d044d00d0>]
database_dialect = <DatabaseDialect.POSTGRESQL: 2>
@_helpers.retry_mabye_conflict
@pytest.mark.skipif(
_helpers.USE_EMULATOR, reason="Emulator does not support DML Returning."
)
def test_transaction_execute_update_dml_returning(
sessions_database, sessions_to_delete, database_dialect
):
sd = _sample_data
session = sessions_database.session()
session.create()
sessions_to_delete.append(session)
with session.batch() as batch:
batch.delete(sd.TABLE, sd.ALL)
with session.transaction() as transaction:
for row in sd.ROW_DATA:
insert_statement = _generate_insert_returning_statement(
row, database_dialect
)
row_count = transaction.execute_update(insert_statement)
tests/system/test_session_api.py:838:
google/cloud/spanner_v1/transaction.py:355: in execute_update
response = self._execute_request(
google/cloud/spanner_v1/transaction.py:103: in _execute_request
response = method(request=request)
google/cloud/spanner_v1/services/spanner/client.py:1112: in execute_sql
response = rpc(
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/gapic_v1/method.py:113: in call
return wrapped_func(*args, **kwargs)
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:349: in retry_wrapped_func
return retry_target(
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/retry.py:191: in retry_target
return target()
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/timeout.py:120: in func_with_timeout
return func(*args, **kwargs)
args = (session: "projects/precise-truck-742/instances/google-cloud-1681362231247/databases/test_sessions_1681362343647/sessi..., 'wylma@example.com') RETURNING contact_id, first_name, last_name, email"
params {
}
seqno: 2
request_options {
}
,)
kwargs = {'metadata': [('google-cloud-resource-prefix', 'projects/precise-truck-742/instances/google-cloud-1681362231247/databa...pj4SDwnGT7q1XRIAQ'), ('x-goog-api-client', 'gl-python/3.8.13 grpc/1.54.0rc1 gax/2.11.0 gccl/3.31.0')], 'timeout': 30.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.Aborted: 409 Transaction was aborted.
.nox/prerelease_deps-3-8-database_dialect-postgresql/lib/python3.8/site-packages/google/api_core/grpc_helpers.py:74: Aborted