Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
on build 7.0.0-3383:
test case:
./testrunner -i /tmp/atomicity.ini rerun=False,data_spec_name=initial_load_N1ql,get-cbcollect-info=False,GROUP=P0 -t N1qlTransaction.basic_ops.BasicOps.test_concurrent_txn,nodes_init=2,num_stmt_txn=10,num_collection=1,num_savepoints=2,num_txn=3,num_commit=3,num_rollback_to_savepoint=3,GROUP=P0,bucket_spec=single_bucket.def_scope_ten_collections
one of thread fails with "document not found " error. The queries executed on the thread are as follows:
SAVEPOINT a1;
SAVEPOINT a0;
INSERT INTO default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` t WHERE join_mo=9 LIMIT 10 RETURNING *;
DELETE FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` WHERE ['Development'] in skills LIMIT 200 RETURNING meta().id;
DELETE FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` WHERE join_mo =1 LIMIT 200 RETURNING meta().id;
ROLLBACK TO SAVEPOINT a1;
COMMIT WORK
Here we are rolling back to first statement but the commit fails with "document not found" error.
This issue is very difficult to reproduce. I tried reproducing through cbq also ran the test in loop both did not help. Test did not collect cbcollect logs. attached the test logs.
I will update the jira in case if this issue is hit again.
error:
2020-10-14 00:35:57,079 | test | INFO | Thread-201 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'47db7c00-a6d7-466f-8835-3c2137874ea9', 'scan_consistency': 'REQUEST_PLUS'}
|
2020-10-14 00:35:57,091 | test | INFO | Thread-201 | [N1qlBase:run_cbq_query:145] RUN QUERY COMMIT WORK
|
2020-10-14 00:35:57,197 | test | INFO | Thread-199 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 437.392184ms
|
2020-10-14 00:35:57,197 | test | INFO | Thread-199 | [N1qlBase:thread_txn:797] queries executed in txn are {u'fcf20ba2-54df-45ab-aede-429dde04db8d': ["DELETE FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` WHERE Working_country='USA' LIMIT 200 RETURNING meta().id", {u'signature': u'json', u'requestID': u'3dfb7c9e-0b02-4e89-84fd-178eac107a05', u'metrics': {u'resultCount': 0, u'executionTime': u'274.258\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'368.215\xb5s'}, u'results': [], u'status': u'success'}, "INSERT INTO default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` t WHERE citizen_of='INDIA' LIMIT 10 RETURNING *", {u'signature': u'json', u'requestID': u'90845e5d-fe0f-4d93-8d75-df67995b0739', u'metrics': {u'resultCount': 0, u'executionTime': u'349.667\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'443.755\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`boXC0MfdMbL0U-42-484000`.`_default`.`EQMB-42-485000` WHERE join_yr > 2016 OR job_title='Engineer' LIMIT 200 RETURNING meta().id", 'ROLLBACK TO SAVEPOINT a1', 'COMMIT WORK']}
|
2020-10-14 00:35:57,200 | test | INFO | Thread-201 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 104.580092ms
|
2020-10-14 00:35:57,200 | test | INFO | Thread-201 | [N1qlBase:run_cbq_query:215] txn failed with error {u'signature': u'json', u'requestID': u'f089ff0f-87b9-4857-a460-1f0daea870a3', u'metrics': {u'resultCount': 0, u'executionTime': u'104.471625ms', u'serviceLoad': 1, u'resultSize': 0, u'errorCount': 1, u'elapsedTime': u'104.580092ms'}, u'results': [], u'errors': [{u'msg': u'Commit Transaction statement error: transaction operation failed | document not found | {"status_code":1,"bucket":"boXC0MfdMbL0U-42-484000","scope":"_default","collection":"EQMB-42-485000","collection_id":10,"error_name":"KEY_ENOENT","error_description":"Not Found","opaque":184,"last_dispatched_to":"172.23.105.229:11210","last_dispatched_from":"172.23.105.229:37858","last_connection_id":"ba4f4c21fec4d29d/e7c8b18a6fe9c1d1"}', u'code': 17007}], u'status': u'errors'}
|