_________TestSessionAPI.test_transaction_batch_update_w_syntax_error__________args= (session: "projects/precise-truck-742/instances/google-cloud-python-systest/databases/test_sessions_1561421696334/sess...hARQno60JnjCZosiqjNrh1xW69seY6xZOPqwi7sR9qy5cr-kXFHxiGpx3w"transaction_id: "AJSwhAR6DqYBotfoiNM7cVnSLV0pgvC3eEPc3g"
,)
kwargs= {'metadata': [('google-cloud-resource-prefix', 'projects/precise-truck-742/instances/google-cloud-python-systest/datab...x3w'), ('x-goog-api-client', 'gl-python/3.7.0b3 grpc/1.22.0rc1 gax/1.13.0 gapic/1.9.0 gccl/1.9.0')], 'timeout': 3599.0}
@six.wraps(callable_)deferror_remapped_callable(*args, **kwargs):
try:
>returncallable_(*args, **kwargs)
../api_core/google/api_core/grpc_helpers.py:57:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
self=<grpc._channel._UnaryUnaryMultiCallableobjectat0x7f02eb1a9c18>request=session: "projects/precise-truck-742/instances/google-cloud-python-systest/databases/test_sessions_1561421696334/sessi...SwhARQno60JnjCZosiqjNrh1xW69seY6xZOPqwi7sR9qy5cr-kXFHxiGpx3w"transaction_id: "AJSwhAR6DqYBotfoiNM7cVnSLV0pgvC3eEPc3g"timeout=3599.0metadata= [('google-cloud-resource-prefix', 'projects/precise-truck-742/instances/google-cloud-python-systest/databases/test_ses...wi7sR9qy5cr-kXFHxiGpx3w'), ('x-goog-api-client', 'gl-python/3.7.0b3 grpc/1.22.0rc1 gax/1.13.0 gapic/1.9.0 gccl/1.9.0')]
credentials=None, wait_for_ready=None, compression=Nonedef__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-7/lib/python3.7/site-packages/grpc/_channel.py:565:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
state=<grpc._channel._RPCStateobjectat0x7f02eb11cb38>call=<grpc._cython.cygrpc.SegregatedCallobjectat0x7f02eb11ad88>with_call=False, deadline=Nonedef_end_unary_response_blocking(state, call, with_call, deadline):
ifstate.codeisgrpc.StatusCode.OK:
ifwith_call:
rendezvous=_Rendezvous(state, call, None, deadline)
returnstate.response, rendezvouselse:
returnstate.responseelse:
>raise_Rendezvous(state, None, None, deadline)
Egrpc._channel._Rendezvous: <_RendezvousofRPCthatterminatedwith:
Estatus=StatusCode.ABORTEDEdetails="Transaction aborted. Database schema probably changed during transaction, retry may succeed."Edebug_error_string="{"created":"@1561421764.604780791","description":"Errorreceivedfrompeeripv4:74.125.195.95:443","file":"src/core/lib/surface/call.cc","file_line":1052,"grpc_message":"Transactionaborted. Databaseschemaprobablychangedduringtransaction, retrymaysucceed.","grpc_status":10}"E>
.nox/system-3-7/lib/python3.7/site-packages/grpc/_channel.py:467: _RendezvousTheaboveexceptionwasthedirectcauseofthefollowingexception:
self=<tests.system.test_system.TestSessionAPItestMethod=test_transaction_batch_update_w_syntax_error>deftest_transaction_batch_update_w_syntax_error(self):
retry=RetryInstanceState(_has_all_ddl)
retry(self._db.reload)()
session=self._db.session()
session.create()
self.to_delete.append(session)
withsession.batch() asbatch:
batch.delete(self.TABLE, self.ALL)
insert_statement=list(self._generate_insert_statements())[0]
update_statement= (
"UPDTAE contacts SET email = @email ""WHERE contact_id = @contact_id;",
{"contact_id": 1, "email": "phreddy@example.com"},
{"contact_id": Type(code=INT64), "email": Type(code=STRING)},
)
delete_statement= (
"DELETE contacts WHERE contact_id = @contact_id;",
{"contact_id": 1},
{"contact_id": Type(code=INT64)},
)
withsession.transaction() astransaction:
rows=list(transaction.read(self.TABLE, self.COLUMNS, self.ALL))
self.assertEqual(rows, [])
status, row_counts=transaction.batch_update(
> [insert_statement, update_statement, delete_statement]
)
tests/system/test_system.py:894:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
google/cloud/spanner_v1/transaction.py:268: in__exit__self.commit()
google/cloud/spanner_v1/transaction.py:127: incommitmetadata=metadata,
google/cloud/spanner_v1/gapic/spanner_client.py:1461: incommitrequest, retry=retry, timeout=timeout, metadata=metadata
../api_core/google/api_core/gapic_v1/method.py:143: in__call__returnwrapped_func(*args, **kwargs)
../api_core/google/api_core/retry.py:273: inretry_wrapped_funcon_error=on_error,
../api_core/google/api_core/retry.py:182: inretry_targetreturntarget()
../api_core/google/api_core/timeout.py:214: infunc_with_timeoutreturnfunc(*args, **kwargs)
../api_core/google/api_core/grpc_helpers.py:59: inerror_remapped_callablesix.raise_from(exceptions.from_grpc_error(exc), exc)
__ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
value=Nonefrom_value=<_RendezvousofRPCthatterminatedwith:
status=StatusCode.ABORTEDdetails="Transaction aborted. Database schem...ge":"Transaction aborted. Database schema probably changed during transaction, retry may succeed.","grpc_status":10}"
>> ???
Egoogle.api_core.exceptions.Aborted: 409Transactionaborted. Databaseschemaprobablychangedduringtransaction, retrymaysucceed.
<string>:3: Aborted
From this Kokoro run: