./testrunner -i /tmp/atomicity.ini rerun=False,data_spec_name=initial_load_N1ql,get-cbcollect-info=True,GROUP=P0 -t N1qlTransaction.basic_ops.BasicOps.test_concurrent_txn,nodes_init=2,num_stmt_txn=10,num_collection=1,num_savepoints=2,override_savepoint=1,num_txn=3,num_commit=1,num_rollback_to_savepoint=3,num_conflict=2,GROUP=P0,bucket_spec=single_bucket.def_scope_ten_collections Test Input params: {'cluster_name': 'atomicity', 'num_stmt_txn': '10', 'num_rollback_to_savepoint': '3', 'ini': '/tmp/atomicity.ini', 'get-cbcollect-info': 'True', 'conf_file': 'conf/N1qlTransaction/concurrency.conf', 'spec': 'concurrency', 'rerun': 'False', 'num_nodes': 2, 'logs_folder': '/data/workspace/temp_atomicity_phase1/logs/testrunner-20-Oct-12_23-39-24/test_11', 'num_txn': '3', 'nodes_init': '2', 'num_collection': '1', 'num_savepoints': '2', 'GROUP': 'P0', 'num_commit': '1', 'override_savepoint': '1', 'num_conflict': '2', 'bucket_spec': 'single_bucket.def_scope_ten_collections', 'case_number': 11, 'data_spec_name': 'initial_load_N1ql'} test_concurrent_txn (N1qlTransaction.basic_ops.BasicOps) ... 2020-10-13 00:22:24,364 | test | INFO | MainThread | [basetestcase:log_setup_status:538] ========= BaseTestCase setup started for test #11 test_concurrent_txn ========= 2020-10-13 00:22:24,815 | test | INFO | MainThread | [basetestcase:log_setup_status:538] ========= BaseTestCase setup started for test #11 test_concurrent_txn ========= 2020-10-13 00:22:24,964 | test | INFO | MainThread | [basetestcase:setUp:319] Initializing cluster 2020-10-13 00:22:25,483 | test | WARNING | MainThread | [basetestcase:_initialize_nodes:582] RAM quota was defined less than 100 MB: 2020-10-13 00:22:37,211 | test | INFO | MainThread | [basetestcase:setUp:341] Couchbase Cluster: default, Nodes: 172.23.105.229, 172.23.105.230 initialized 2020-10-13 00:22:37,223 | test | INFO | MainThread | [basetestcase:log_setup_status:538] ========= BaseTestCase setup finished for test #11 test_concurrent_txn ========= 2020-10-13 00:22:37,240 | test | INFO | MainThread | [basetestcase:log_setup_status:538] ========= CollectionBase setup started for test #11 test_concurrent_txn ========= 2020-10-13 00:22:39,490 | test | INFO | pool-12-thread-3 | [table_view:display:72] Rebalance Overview +----------------+-----------------+--------------+ | Nodes | Services | Status | +----------------+-----------------+--------------+ | 172.23.105.229 | index, kv, n1ql | Cluster node | | 172.23.105.230 | None | <--- IN --- | +----------------+-----------------+--------------+ 2020-10-13 00:22:39,500 | test | INFO | pool-12-thread-3 | [task:check:320] Rebalance - status: running, progress: 0 2020-10-13 00:22:49,532 | test | INFO | pool-12-thread-3 | [task:check:320] Rebalance - status: none, progress: 100 2020-10-13 00:22:49,543 | test | INFO | pool-12-thread-3 | [task:check:377] Rebalance completed with progress: 100% in 10.0549998283 sec 2020-10-13 00:22:49,673 | test | INFO | MainThread | [bucket_ready_functions:create_buckets_using_json_data:1754] Creating required buckets from template 2020-10-13 00:22:49,780 | test | INFO | Thread-509 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection vmbKcxecKywWd_wh creation 2020-10-13 00:22:51,852 | test | INFO | Thread-511 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection GlyoI4bsyJG_jrTeu5L creation 2020-10-13 00:22:53,882 | test | INFO | Thread-511 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection HMQ1Im_ZgkI2B3Pr creation 2020-10-13 00:22:55,951 | test | INFO | Thread-514 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection 6QRwxBTIbIhw creation 2020-10-13 00:22:57,989 | test | INFO | Thread-514 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection 8SRZ0VSro2V5O3p7X56MFebdc creation 2020-10-13 00:23:00,052 | test | INFO | Thread-517 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection CfwZeE creation 2020-10-13 00:23:02,085 | test | INFO | Thread-517 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection KHC-h1Jd_OxioKimPtPF7owut9hVr creation 2020-10-13 00:23:04,151 | test | INFO | Thread-520 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection vj7VyiDFZS0Tjpmc74p creation 2020-10-13 00:23:06,193 | test | INFO | Thread-520 | [common_lib:sleep:22] Sleep 2 seconds. Reason: MB-38073: Wait after collection 05KyZ%DJLkAir_6l%dX creation 2020-10-13 00:23:08,194 | test | INFO | MainThread | [bucket_ready_functions:wait_for_collection_creation_to_complete:2215] Waiting for all collections to be created 2020-10-13 00:23:08,246 | test | INFO | MainThread | [table_view:display:72] Bucket statistics +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ | Bucket | Type | Replicas | Durability | TTL | Items | RAM Quota | RAM Used | Disk Used | +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ | xQoORgdDPhqRmgzPVVLhhWaopPt5 | couchbase | 1 | none | 0 | 0 | 5322571776 | 57981840 | 73579344 | +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ 2020-10-13 00:23:08,247 | test | INFO | MainThread | [collections_base:collection_setup:118] Creating required SDK clients for client_pool 2020-10-13 00:23:15,821 | test | INFO | MainThread | [common_lib:sleep:22] Sleep 120 seconds. Reason: MB-38497 2020-10-13 00:25:15,821 | test | INFO | MainThread | [bucket_ready_functions:perform_tasks_from_spec:4532] Performing scope/collection specific operations 2020-10-13 00:25:21,082 | test | INFO | MainThread | [table_view:display:72] Cluster statistics +----------------+-----------------+-----------------+------------+------------+------------------------+-------------------+-----------------------+ | Node | Services | CPU_utilization | Mem_total | Mem_free | Swap_mem_used | Active / Replica | Version | +----------------+-----------------+-----------------+------------+------------+------------------------+-------------------+-----------------------+ | 172.23.105.229 | index, kv, n1ql | 3.03797468354 | 4201840640 | 3392016384 | 218255360 / 3758092288 | 0 / 0 | 7.0.0-3383-enterprise | | 172.23.105.230 | kv | 2.27848101266 | 4201844736 | 3501232128 | 101187584 / 3758092288 | 0 / 0 | 7.0.0-3383-enterprise | +----------------+-----------------+-----------------+------------+------------+------------------------+-------------------+-----------------------+ 2020-10-13 00:25:22,210 | test | INFO | MainThread | [bucket_ready_functions:validate_docs_per_collections_all_buckets:4342] Validating collection stats and item counts 2020-10-13 00:25:27,948 | test | INFO | MainThread | [table_view:display:72] Bucket statistics +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ | Bucket | Type | Replicas | Durability | TTL | Items | RAM Quota | RAM Used | Disk Used | +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ | xQoORgdDPhqRmgzPVVLhhWaopPt5 | couchbase | 1 | none | 0 | 20000 | 5322571776 | 83669872 | 123303356 | +------------------------------+-----------+----------+------------+-----+-------+------------+----------+-----------+ 2020-10-13 00:25:27,950 | test | INFO | MainThread | [basetestcase:log_setup_status:538] ========= CollectionBase setup complete for test #11 test_concurrent_txn ========= 2020-10-13 00:25:31,763 | test | INFO | MainThread | [N1qlBase:get_stmt_for_threads:809] insert, delete and update 4 0 6 2020-10-13 00:25:31,776 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE PRIMARY INDEX on default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` USING GSI 2020-10-13 00:25:33,963 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.182641606s 2020-10-13 00:25:33,974 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `tl2i` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(join_mo) USING GSI 2020-10-13 00:25:37,012 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 3.032217657s 2020-10-13 00:25:37,025 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `UDxxsa1enpOcUT3u-uiaYj_1hQyr` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(citizen_of) USING GSI 2020-10-13 00:25:39,836 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.8063548s 2020-10-13 00:25:39,851 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `8UFvVUpRRKiK5` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(job_title) USING GSI 2020-10-13 00:25:42,598 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.743053142s 2020-10-13 00:25:42,611 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `IATON` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(citizen_of,job_title) USING GSI 2020-10-13 00:25:45,390 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.775029838s 2020-10-13 00:25:45,401 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `TrbYzU3xnqyz527ALaQE` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(job_title) USING GSI 2020-10-13 00:25:48,206 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.800504618s 2020-10-13 00:25:48,219 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `Bq4mrBHnMMY` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(job_title) USING GSI 2020-10-13 00:25:51,006 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.782963937s 2020-10-13 00:25:51,019 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `Ld` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(Working_country) USING GSI 2020-10-13 00:25:53,892 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.869179622s 2020-10-13 00:25:53,907 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `g1ircfB-QXIQNzXtblCJ` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(join_yr,job_title) USING GSI 2020-10-13 00:25:56,729 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.817339341s 2020-10-13 00:25:56,743 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `26pGHbblqr` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(join_mo) USING GSI 2020-10-13 00:25:59,526 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.778154448s 2020-10-13 00:25:59,546 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY CREATE INDEX `pXUDVKHMHwJl7G2g81b` ON default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`(job_title,skills) USING GSI 2020-10-13 00:26:02,377 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.826198877s 2020-10-13 00:26:02,394 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:02,398 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 1.138805ms 2020-10-13 00:26:02,433 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:02,437 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 628.466µs 2020-10-13 00:26:02,447 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:02,450 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 506.007µs 2020-10-13 00:26:02,460 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:02,464 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 585.692µs 2020-10-13 00:26:02,466 | test | INFO | Thread-559 | [N1qlBase:thread_txn:791] values are ['SAVEPOINT:a1', 'SAVEPOINT:a0', 'SAVEPOINT:a0', 'SAVEPOINT:a0', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: join_mo =1:join_month='January':join_mo"] False False False 2020-10-13 00:26:02,466 | test | INFO | Thread-558 | [N1qlBase:thread_txn:791] values are ["xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:INSERT: job_title='Support':job_title", 'xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:INSERT: join_mo=9:join_mo', 'SAVEPOINT:a1', 'SAVEPOINT:a1', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: job_title='Support':SE=True:job_title", 'SAVEPOINT:a1', 'SAVEPOINT:a0'] False True False 2020-10-13 00:26:02,466 | test | INFO | Thread-557 | [N1qlBase:thread_txn:791] values are ['SAVEPOINT:a0', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: Working_country='USA':temp_emp=True:Working_country", 'SAVEPOINT:a1', 'SAVEPOINT:a1', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: join_yr > 2016 OR job_title='Engineer':mutated=1:join_yr,job_title", 'SAVEPOINT:a0', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: job_title='Engineer' and 'Testing' in skills:QE=True:job_title,skills"] False True True 2020-10-13 00:26:02,467 | test | INFO | Thread-556 | [N1qlBase:thread_txn:791] values are ['SAVEPOINT:a1', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:INSERT: citizen_of='INDIA':citizen_of", 'SAVEPOINT:a0', 'SAVEPOINT:a1', 'SAVEPOINT:a0', "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:DELETE: ['Development'] in skills:gaming=True:job_title", "xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr:INSERT: citizen_of='USA' AND job_title='Sales':citizen_of,job_title"] True True True 2020-10-13 00:26:02,482 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,482 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,483 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,483 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE job_title='Support' LIMIT 10 RETURNING * 2020-10-13 00:26:02,486 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 507.328µs 2020-10-13 00:26:02,487 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 352.846µs 2020-10-13 00:26:02,489 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 486.576µs 2020-10-13 00:26:02,500 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE Working_country='USA' LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,502 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE citizen_of='INDIA' LIMIT 10 RETURNING * 2020-10-13 00:26:02,502 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,510 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 549.031µs 2020-10-13 00:26:02,515 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 28.140135ms 2020-10-13 00:26:02,516 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 11.46929ms 2020-10-13 00:26:02,525 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,538 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 446.909µs 2020-10-13 00:26:02,548 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT * from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,551 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT * from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,551 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,572 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 654.271µs 2020-10-13 00:26:02,581 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 8.874649ms 2020-10-13 00:26:02,584 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 9.623514ms 2020-10-13 00:26:02,588 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE join_mo =1 LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,595 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,599 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE join_mo=9 LIMIT 10 RETURNING * 2020-10-13 00:26:02,601 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 498.423µs 2020-10-13 00:26:02,614 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,618 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 399.02µs 2020-10-13 00:26:02,618 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 13.5262ms 2020-10-13 00:26:02,619 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 112.749037ms 2020-10-13 00:26:02,625 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 32.334126ms 2020-10-13 00:26:02,631 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,634 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT * from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in ['Mia Hall', 'Basha Wilson', 'Maura White', 'Jerica Damian', 'Jerica Young', 'Basha Thomas', 'Mia Green', 'Mia Sebastian', 'Maura Brown', 'Fantine Brown'] 2020-10-13 00:26:02,635 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 725.312µs 2020-10-13 00:26:02,637 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in ['test_collections-1000', 'test_collections-1008', 'test_collections-1011', 'test_collections-1013', 'test_collections-1015', 'test_collections-1020', 'test_collections-1027', 'test_collections-1032', 'test_collections-1047', 'test_collections-1048', 'test_collections-105', 'test_collections-1050', 'test_collections-1053', 'test_collections-1061', 'test_collections-1063', 'test_collections-107', 'test_collections-1073', 'test_collections-1075', 'test_collections-1076', 'test_collections-1080', 'test_collections-1084', 'test_collections-1085', 'test_collections-1086', 'test_collections-1088', 'test_collections-1097', 'test_collections-1104', 'test_collections-1106', 'test_collections-1109', 'test_collections-111', 'test_collections-1113', 'test_collections-1115', 'test_collections-1122', 'test_collections-1124', 'test_collections-1127', 'test_collections-1130', 'test_collections-1133', 'test_collections-114', 'test_collections-1142', 'test_collections-1145', 'test_collections-1151', 'test_collections-1152', 'test_collections-1153', 'test_collections-1159', 'test_collections-116', 'test_collections-1164', 'test_collections-1166', 'test_collections-1169', 'test_collections-1170', 'test_collections-1182', 'test_collections-1185', 'test_collections-1186', 'test_collections-119', 'test_collections-1195', 'test_collections-1198', 'test_collections-1205', 'test_collections-1209', 'test_collections-1216', 'test_collections-1222', 'test_collections-1225', 'test_collections-123', 'test_collections-1231', 'test_collections-1240', 'test_collections-1252', 'test_collections-1258', 'test_collections-1261', 'test_collections-1263', 'test_collections-1267', 'test_collections-1270', 'test_collections-1271', 'test_collections-1276', 'test_collections-1279', 'test_collections-128', 'test_collections-1280', 'test_collections-1287', 'test_collections-1289', 'test_collections-1290', 'test_collections-1292', 'test_collections-1294', 'test_collections-1297', 'test_collections-1299', 'test_collections-13', 'test_collections-1302', 'test_collections-131', 'test_collections-1310', 'test_collections-1312', 'test_collections-1314', 'test_collections-1322', 'test_collections-1323', 'test_collections-1330', 'test_collections-1333', 'test_collections-1339', 'test_collections-1341', 'test_collections-1344', 'test_collections-1348', 'test_collections-1350', 'test_collections-1357', 'test_collections-1359', 'test_collections-136', 'test_collections-1360', 'test_collections-1364', 'test_collections-1369', 'test_collections-1379', 'test_collections-1382', 'test_collections-1384', 'test_collections-1385', 'test_collections-1395', 'test_collections-14', 'test_collections-1402', 'test_collections-1403', 'test_collections-1405', 'test_collections-1410', 'test_collections-1416', 'test_collections-1419', 'test_collections-1426', 'test_collections-1429', 'test_collections-143', 'test_collections-1436', 'test_collections-1440', 'test_collections-1444', 'test_collections-1446', 'test_collections-1449', 'test_collections-1453', 'test_collections-1455', 'test_collections-1456', 'test_collections-146', 'test_collections-1462', 'test_collections-1465', 'test_collections-147', 'test_collections-1475', 'test_collections-1476', 'test_collections-1481', 'test_collections-1482', 'test_collections-1485', 'test_collections-1492', 'test_collections-150', 'test_collections-1500', 'test_collections-1501', 'test_collections-1503', 'test_collections-1505', 'test_collections-1507', 'test_collections-1508', 'test_collections-1509', 'test_collections-1512', 'test_collections-1514', 'test_collections-1527', 'test_collections-1530', 'test_collections-1535', 'test_collections-1539', 'test_collections-154', 'test_collections-1542', 'test_collections-1543', 'test_collections-1549', 'test_collections-155', 'test_collections-1551', 'test_collections-1552', 'test_collections-1553', 'test_collections-1561', 'test_collections-1578', 'test_collections-1588', 'test_collections-1597', 'test_collections-1598', 'test_collections-1601', 'test_collections-1604', 'test_collections-1607', 'test_collections-1612', 'test_collections-1614', 'test_collections-1619', 'test_collections-1622', 'test_collections-1623', 'test_collections-1624', 'test_collections-1627', 'test_collections-1630', 'test_collections-1631', 'test_collections-1634', 'test_collections-1636', 'test_collections-1641', 'test_collections-1643', 'test_collections-1645', 'test_collections-165', 'test_collections-1650', 'test_collections-1653', 'test_collections-1654', 'test_collections-166', 'test_collections-1660', 'test_collections-1666', 'test_collections-167', 'test_collections-1674', 'test_collections-1676', 'test_collections-1684', 'test_collections-1685', 'test_collections-1686', 'test_collections-169', 'test_collections-1693', 'test_collections-1695', 'test_collections-1696', 'test_collections-1697', 'test_collections-1699', 'test_collections-1703', 'test_collections-1710', 'test_collections-1715'] 2020-10-13 00:26:02,638 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in ['test_collections-10', 'test_collections-1027', 'test_collections-1034', 'test_collections-1037', 'test_collections-1041', 'test_collections-1048', 'test_collections-1062', 'test_collections-1065', 'test_collections-1076', 'test_collections-1087', 'test_collections-1127', 'test_collections-913', 'test_collections-208', 'test_collections-1421', 'test_collections-52', 'test_collections-1560', 'test_collections-1539', 'test_collections-1961', 'test_collections-24', 'test_collections-809', 'test_collections-1944', 'test_collections-564', 'test_collections-1599', 'test_collections-987', 'test_collections-1518', 'test_collections-1449', 'test_collections-387', 'test_collections-575', 'test_collections-1432', 'test_collections-475', 'test_collections-1667', 'test_collections-1895', 'test_collections-1165', 'test_collections-703', 'test_collections-319', 'test_collections-1646', 'test_collections-1972', 'test_collections-191', 'test_collections-934', 'test_collections-394', 'test_collections-1262', 'test_collections-1283', 'test_collections-1460', 'test_collections-1343', 'test_collections-13', 'test_collections-909', 'test_collections-1937', 'test_collections-1360', 'test_collections-678', 'test_collections-1833', 'test_collections-180', 'test_collections-464', 'test_collections-806', 'test_collections-515', 'test_collections-80', 'test_collections-1716', 'test_collections-1318', 'test_collections-1588', 'test_collections-1446', 'test_collections-657', 'test_collections-1809', 'test_collections-41', 'test_collections-653', 'test_collections-17', 'test_collections-550', 'test_collections-447', 'test_collections-920', 'test_collections-792', 'test_collections-152', 'test_collections-347', 'test_collections-408', 'test_collections-1674', 'test_collections-692', 'test_collections-1923', 'test_collections-308', 'test_collections-91', 'test_collections-1418', 'test_collections-3', 'test_collections-1553', 'test_collections-781', 'test_collections-297', 'test_collections-436', 'test_collections-269', 'test_collections-820', 'test_collections-1677', 'test_collections-1169', 'test_collections-1304', 'test_collections-681', 'test_collections-785', 'test_collections-525', 'test_collections-1176', 'test_collections-1767', 'test_collections-219', 'test_collections-1830', 'test_collections-266', 'test_collections-750', 'test_collections-906', 'test_collections-1574', 'test_collections-1933', 'test_collections-1471', 'test_collections-397', 'test_collections-1688', 'test_collections-592', 'test_collections-294', 'test_collections-1546', 'test_collections-1902', 'test_collections-771', 'test_collections-166', 'test_collections-336', 'test_collections-1215', 'test_collections-1297', 'test_collections-1660', 'test_collections-553', 'test_collections-1321', 'test_collections-1727', 'test_collections-1639', 'test_collections-1134', 'test_collections-450', 'test_collections-1293', 'test_collections-529', 'test_collections-1702', 'test_collections-1155', 'test_collections-280', 'test_collections-1805', 'test_collections-536', 'test_collections-63', 'test_collections-937', 'test_collections-1930', 'test_collections-422', 'test_collections-1190', 'test_collections-138', 'test_collections-1855', 'test_collections-1162', 'test_collections-169', 'test_collections-38', 'test_collections-425', 'test_collections-643', 'test_collections-131', 'test_collections-948', 'test_collections-1204', 'test_collections-1425', 'test_collections-1681', 'test_collections-1774', 'test_collections-1488', 'test_collections-1958', 'test_collections-1844', 'test_collections-259', 'test_collections-1983', 'test_collections-1802', 'test_collections-1411', 'test_collections-1193', 'test_collections-664', 'test_collections-1549', 'test_collections-522', 'test_collections-622', 'test_collections-778', 'test_collections-976', 'test_collections-1795', 'test_collections-1816', 'test_collections-1332', 'test_collections-899', 'test_collections-831', 'test_collections-848', 'test_collections-650', 'test_collections-720', 'test_collections-1390', 'test_collections-1290', 'test_collections-959', 'test_collections-141'] 2020-10-13 00:26:02,644 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 5.113672ms 2020-10-13 00:26:02,647 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE ['Development'] in skills LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,664 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,667 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 25.647673ms 2020-10-13 00:26:02,667 | test | INFO | Thread-557 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,668 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 726.953µs 2020-10-13 00:26:02,671 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 28.73391ms 2020-10-13 00:26:02,671 | test | INFO | Thread-559 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,671 | test | INFO | Thread-559 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'c9b16cff-7326-4ada-8fda-44d404a92d46', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:02,677 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,681 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 759.654µs 2020-10-13 00:26:02,681 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,684 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:145] RUN QUERY ROLLBACK WORK 2020-10-13 00:26:02,687 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 538.903µs 2020-10-13 00:26:02,687 | test | INFO | Thread-559 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 485.6µs 2020-10-13 00:26:02,687 | test | INFO | Thread-559 | [N1qlBase:thread_txn:797] queries executed in txn are {u'c9b16cff-7326-4ada-8fda-44d404a92d46': [{u'signature': u'json', u'requestID': u'813db618-1803-4052-8839-bdee9a810fa3', u'metrics': {u'resultCount': 0, u'executionTime': u'241.667\xb5s', u'serviceLoad': 4, u'resultSize': 0, u'elapsedTime': u'352.846\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'2e27a2d2-df59-48ae-852f-04b87824d2df', u'metrics': {u'resultCount': 0, u'executionTime': u'401.162\xb5s', u'serviceLoad': 6, u'resultSize': 0, u'elapsedTime': u'549.031\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'db8ac813-167d-4a50-81af-e450bb6399aa', u'metrics': {u'resultCount': 0, u'executionTime': u'344.987\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'446.909\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'82aff1d1-75b2-4859-b2da-4f51c8444f5d', u'metrics': {u'resultCount': 0, u'executionTime': u'502.868\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'654.271\xb5s'}, u'results': [], u'status': u'success'}, 'DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE join_mo =1 LIMIT 200 RETURNING meta().id', 'ROLLBACK WORK']} 2020-10-13 00:26:02,697 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,697 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE job_title='Support' LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,700 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 657.543µs 2020-10-13 00:26:02,704 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 3.930689ms 2020-10-13 00:26:02,710 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE join_yr > 2016 OR job_title='Engineer' LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,714 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,721 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 7.609952ms 2020-10-13 00:26:02,723 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 4.589265ms 2020-10-13 00:26:02,723 | test | INFO | Thread-558 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,733 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,733 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a1 2020-10-13 00:26:02,737 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 550.291µs 2020-10-13 00:26:02,740 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 3.854928ms 2020-10-13 00:26:02,740 | test | INFO | Thread-557 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,747 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,750 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SAVEPOINT a0 2020-10-13 00:26:02,752 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 579.196µs 2020-10-13 00:26:02,752 | test | INFO | Thread-558 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'8a529aed-7f5c-4246-9016-8b66ac617c0b', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:02,755 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 513.797µs 2020-10-13 00:26:02,763 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY ROLLBACK TO SAVEPOINT a1 2020-10-13 00:26:02,766 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE job_title='Engineer' and 'Testing' in skills LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,767 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 708.275µs 2020-10-13 00:26:02,769 | test | INFO | Thread-558 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'8a529aed-7f5c-4246-9016-8b66ac617c0b', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:02,776 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 6.960478ms 2020-10-13 00:26:02,780 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:145] RUN QUERY ROLLBACK WORK 2020-10-13 00:26:02,786 | test | INFO | Thread-558 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 803.944µs 2020-10-13 00:26:02,786 | test | INFO | Thread-558 | [N1qlBase:thread_txn:797] queries executed in txn are {u'8a529aed-7f5c-4246-9016-8b66ac617c0b': ["INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE job_title='Support' LIMIT 10 RETURNING *", 'INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE join_mo=9 LIMIT 10 RETURNING *', {u'signature': u'json', u'requestID': u'45cedce1-71dc-4bc3-a36e-392fab4b68d5', u'metrics': {u'resultCount': 0, u'executionTime': u'600.94\xb5s', u'serviceLoad': 4, u'resultSize': 0, u'elapsedTime': u'726.953\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'4e0eed83-b201-4c91-b866-5b2dc0ae2c04', u'metrics': {u'resultCount': 0, u'executionTime': u'389.797\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'538.903\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE job_title='Support' LIMIT 200 RETURNING meta().id", {u'signature': u'json', u'requestID': u'ef406278-ea87-4ddd-8e64-c2d1e2b724d4', u'metrics': {u'resultCount': 0, u'executionTime': u'419.27\xb5s', u'serviceLoad': 4, u'resultSize': 0, u'elapsedTime': u'550.291\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'76f7516e-9b6b-46cf-af4d-e9a88ed957e4', u'metrics': {u'resultCount': 0, u'executionTime': u'436.432\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'579.196\xb5s'}, u'results': [], u'status': u'success'}, 'ROLLBACK TO SAVEPOINT a1', 'ROLLBACK WORK']} 2020-10-13 00:26:02,786 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,796 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 5.358083ms 2020-10-13 00:26:02,796 | test | INFO | Thread-557 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,808 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:02,812 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 696.27µs 2020-10-13 00:26:02,823 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE Working_country='USA' LIMIT 200 RETURNING meta().id 2020-10-13 00:26:02,861 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 31.94599ms 2020-10-13 00:26:02,872 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in ['test_collections-1000', 'test_collections-1008', 'test_collections-1011', 'test_collections-1013', 'test_collections-1015', 'test_collections-1020', 'test_collections-1027', 'test_collections-1032', 'test_collections-1047', 'test_collections-1048', 'test_collections-105', 'test_collections-1050', 'test_collections-1053', 'test_collections-1061', 'test_collections-1063', 'test_collections-107', 'test_collections-1073', 'test_collections-1075', 'test_collections-1076', 'test_collections-1080', 'test_collections-1084', 'test_collections-1085', 'test_collections-1086', 'test_collections-1088', 'test_collections-1097', 'test_collections-1104', 'test_collections-1106', 'test_collections-1109', 'test_collections-111', 'test_collections-1113', 'test_collections-1115', 'test_collections-1122', 'test_collections-1124', 'test_collections-1127', 'test_collections-1130', 'test_collections-1133', 'test_collections-114', 'test_collections-1142', 'test_collections-1145', 'test_collections-1151', 'test_collections-1152', 'test_collections-1153', 'test_collections-1159', 'test_collections-116', 'test_collections-1164', 'test_collections-1166', 'test_collections-1169', 'test_collections-1170', 'test_collections-1182', 'test_collections-1185', 'test_collections-1186', 'test_collections-119', 'test_collections-1195', 'test_collections-1198', 'test_collections-1205', 'test_collections-1209', 'test_collections-1216', 'test_collections-1222', 'test_collections-1225', 'test_collections-123', 'test_collections-1231', 'test_collections-1240', 'test_collections-1252', 'test_collections-1258', 'test_collections-1261', 'test_collections-1263', 'test_collections-1267', 'test_collections-1270', 'test_collections-1271', 'test_collections-1276', 'test_collections-1279', 'test_collections-128', 'test_collections-1280', 'test_collections-1287', 'test_collections-1289', 'test_collections-1290', 'test_collections-1292', 'test_collections-1294', 'test_collections-1297', 'test_collections-1299', 'test_collections-13', 'test_collections-1302', 'test_collections-131', 'test_collections-1310', 'test_collections-1312', 'test_collections-1314', 'test_collections-1322', 'test_collections-1323', 'test_collections-1330', 'test_collections-1333', 'test_collections-1339', 'test_collections-1341', 'test_collections-1344', 'test_collections-1348', 'test_collections-1350', 'test_collections-1357', 'test_collections-1359', 'test_collections-136', 'test_collections-1360', 'test_collections-1364', 'test_collections-1369', 'test_collections-1379', 'test_collections-1382', 'test_collections-1384', 'test_collections-1385', 'test_collections-1395', 'test_collections-14', 'test_collections-1402', 'test_collections-1403', 'test_collections-1405', 'test_collections-1410', 'test_collections-1416', 'test_collections-1419', 'test_collections-1426', 'test_collections-1429', 'test_collections-143', 'test_collections-1436', 'test_collections-1440', 'test_collections-1444', 'test_collections-1446', 'test_collections-1449', 'test_collections-1453', 'test_collections-1455', 'test_collections-1456', 'test_collections-146', 'test_collections-1462', 'test_collections-1465', 'test_collections-147', 'test_collections-1475', 'test_collections-1476', 'test_collections-1481', 'test_collections-1482', 'test_collections-1485', 'test_collections-1492', 'test_collections-150', 'test_collections-1500', 'test_collections-1501', 'test_collections-1503', 'test_collections-1505', 'test_collections-1507', 'test_collections-1508', 'test_collections-1509', 'test_collections-1512', 'test_collections-1514', 'test_collections-1527', 'test_collections-1530', 'test_collections-1535', 'test_collections-1539', 'test_collections-154', 'test_collections-1542', 'test_collections-1543', 'test_collections-1549', 'test_collections-155', 'test_collections-1551', 'test_collections-1552', 'test_collections-1553', 'test_collections-1561', 'test_collections-1578', 'test_collections-1588', 'test_collections-1597', 'test_collections-1598', 'test_collections-1601', 'test_collections-1604', 'test_collections-1607', 'test_collections-1612', 'test_collections-1614', 'test_collections-1619', 'test_collections-1622', 'test_collections-1623', 'test_collections-1624', 'test_collections-1627', 'test_collections-1630', 'test_collections-1631', 'test_collections-1634', 'test_collections-1636', 'test_collections-1641', 'test_collections-1643', 'test_collections-1645', 'test_collections-165', 'test_collections-1650', 'test_collections-1653', 'test_collections-1654', 'test_collections-166', 'test_collections-1660', 'test_collections-1666', 'test_collections-167', 'test_collections-1674', 'test_collections-1676', 'test_collections-1684', 'test_collections-1685', 'test_collections-1686', 'test_collections-169', 'test_collections-1693', 'test_collections-1695', 'test_collections-1696', 'test_collections-1697', 'test_collections-1699', 'test_collections-1703', 'test_collections-1710', 'test_collections-1715'] 2020-10-13 00:26:02,891 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 240.421643ms 2020-10-13 00:26:02,901 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT META().id,* from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:02,907 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 28.665008ms 2020-10-13 00:26:02,907 | test | INFO | Thread-557 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,907 | test | INFO | Thread-557 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'3559c11b-5db7-4cad-80c3-bd832e7bf7a8', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:02,908 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 2.805538ms 2020-10-13 00:26:02,908 | test | INFO | Thread-556 | [N1qlBase:validate_delete_results:423] delete result is [] 2020-10-13 00:26:02,917 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY COMMIT WORK 2020-10-13 00:26:02,921 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE citizen_of='USA' AND job_title='Sales' LIMIT 10 RETURNING * 2020-10-13 00:26:02,957 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 31.426703ms 2020-10-13 00:26:02,966 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY SELECT * from default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE META().id in [] 2020-10-13 00:26:03,013 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 43.926319ms 2020-10-13 00:26:03,023 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY BEGIN WORK 2020-10-13 00:26:03,029 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 621.283µs 2020-10-13 00:26:03,039 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:145] RUN QUERY DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE ['Development'] in skills LIMIT 200 RETURNING meta().id 2020-10-13 00:26:03,203 | test | ERROR | Thread-556 | [rest_client:_http_request:747] POST http://172.23.105.229:8093/query?txid=291197f8-d9ac-423a-a20a-ede497ba4fd4&scan_consistency=REQUEST_PLUS&statement=DELETE+FROM+default%3A%60xQoORgdDPhqRmgzPVVLhhWaopPt5%60.%60ghlJeTlN%60.%60KHC-h1Jd_OxioKimPtPF7owut9hVr%60+WHERE++%5B%27Development%27%5D+in+skills+LIMIT+200+RETURNING+meta%28%29.id body: headers: {'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n'} error: 500 reason: unknown { "requestID": "076e6ac4-9235-49c6-91a2-f09f57907d7f", "signature": {"id":"json"}, "results": [ ], "errors": [{"code":5000,"msg":"txFetch - cause: transaction operation failed | previous operation failed"}], "status": "errors", "metrics": {"elapsedTime": "157.364592ms","executionTime": "157.233604ms","resultCount": 0,"resultSize": 0,"serviceLoad": 3,"errorCount": 1} } auth: Administrator:password 2020-10-13 00:26:03,204 | test | INFO | Thread-556 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 157.364592ms 2020-10-13 00:26:03,206 | test | INFO | Thread-556 | [N1qlBase:full_execute_query:619] txn failed with unexpected errors {u'signature': {u'id': u'json'}, u'requestID': u'076e6ac4-9235-49c6-91a2-f09f57907d7f', u'metrics': {u'resultCount': 0, u'executionTime': u'157.233604ms', u'serviceLoad': 3, u'resultSize': 0, u'errorCount': 1, u'elapsedTime': u'157.364592ms'}, u'results': [], u'errors': [{u'msg': u'txFetch - cause: transaction operation failed | previous operation failed', u'code': 5000}], u'status': u'errors'} 2020-10-13 00:26:03,207 | test | INFO | Thread-556 | [N1qlBase:thread_txn:797] queries executed in txn are {u'8768088c-9574-4852-a6e7-75c106d18af2': [{u'signature': u'json', u'requestID': u'a80cb78c-3604-4a23-9782-dcb36873ac68', u'metrics': {u'resultCount': 0, u'executionTime': u'395.607\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'507.328\xb5s'}, u'results': [], u'status': u'success'}, "INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE citizen_of='INDIA' LIMIT 10 RETURNING *", {u'signature': u'json', u'requestID': u'7677bfd6-6a22-4942-8a0d-03e6d42016ea', u'metrics': {u'resultCount': 0, u'executionTime': u'394.895\xb5s', u'serviceLoad': 4, u'resultSize': 0, u'elapsedTime': u'498.423\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'31cbaa3e-9ee9-4748-8884-edbd12107b53', u'metrics': {u'resultCount': 0, u'executionTime': u'290.535\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'399.02\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'128e3a8e-37f4-4476-81ad-c45a8e5a5ab5', u'metrics': {u'resultCount': 0, u'executionTime': u'536.339\xb5s', u'serviceLoad': 1, u'resultSize': 0, u'elapsedTime': u'725.312\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE ['Development'] in skills LIMIT 200 RETURNING meta().id", "INSERT INTO default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` (KEY k1, value t) SELECT DISTINCT t.name AS k1,t FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` t WHERE citizen_of='USA' AND job_title='Sales' LIMIT 10 RETURNING *"]} 2020-10-13 00:26:03,295 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 372.827792ms 2020-10-13 00:26:03,296 | test | INFO | Thread-557 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'7f8eaf40-53d0-47b7-a6cb-450915a909f1', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:03,306 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY ROLLBACK TO SAVEPOINT a1 2020-10-13 00:26:03,312 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 543.48µs 2020-10-13 00:26:03,312 | test | INFO | Thread-557 | [N1qlBase:end_txn:102] commit work for txn {'txid': u'7f8eaf40-53d0-47b7-a6cb-450915a909f1', 'scan_consistency': 'REQUEST_PLUS'} 2020-10-13 00:26:03,323 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:145] RUN QUERY ROLLBACK WORK 2020-10-13 00:26:03,328 | test | INFO | Thread-557 | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 605.697µs 2020-10-13 00:26:03,329 | test | INFO | Thread-557 | [N1qlBase:thread_txn:797] queries executed in txn are {u'7f8eaf40-53d0-47b7-a6cb-450915a909f1': [{u'signature': u'json', u'requestID': u'f2da6fc1-dd92-4478-b745-bd580fdc9ae3', u'metrics': {u'resultCount': 0, u'executionTime': u'347.16\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'486.576\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE Working_country='USA' LIMIT 200 RETURNING meta().id", {u'signature': u'json', u'requestID': u'971e3a15-626e-46b3-86f9-7495b08c69f7', u'metrics': {u'resultCount': 0, u'executionTime': u'561.892\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'759.654\xb5s'}, u'results': [], u'status': u'success'}, {u'signature': u'json', u'requestID': u'99dd525b-5cc6-4ebd-b501-d92d7d9cb40c', u'metrics': {u'resultCount': 0, u'executionTime': u'511.85\xb5s', u'serviceLoad': 4, u'resultSize': 0, u'elapsedTime': u'657.543\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE join_yr > 2016 OR job_title='Engineer' LIMIT 200 RETURNING meta().id", {u'signature': u'json', u'requestID': u'27e4ed0e-ba1a-4627-b8fd-d31d066b992a', u'metrics': {u'resultCount': 0, u'executionTime': u'397.69\xb5s', u'serviceLoad': 3, u'resultSize': 0, u'elapsedTime': u'513.797\xb5s'}, u'results': [], u'status': u'success'}, "DELETE FROM default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr` WHERE job_title='Engineer' and 'Testing' in skills LIMIT 200 RETURNING meta().id", 'ROLLBACK TO SAVEPOINT a1', 'ROLLBACK WORK']} 2020-10-13 00:26:03,329 | test | INFO | MainThread | [N1qlBase:get_stmt_for_threads:844] txn failed with unexpected errors {u'signature': {u'id': u'json'}, u'requestID': u'076e6ac4-9235-49c6-91a2-f09f57907d7f', u'metrics': {u'resultCount': 0, u'executionTime': u'157.233604ms', u'serviceLoad': 3, u'resultSize': 0, u'errorCount': 1, u'elapsedTime': u'157.364592ms'}, u'results': [], u'errors': [{u'msg': u'txFetch - cause: transaction operation failed | previous operation failed', u'code': 5000}], u'status': u'errors'} 2020-10-13 00:26:03,331 | test | INFO | MainThread | [basic_ops:test_concurrent_txn:48] result is [[{}, []], [{}, []], [{'last': {'xQoORgdDPhqRmgzPVVLhhWaopPt5.ghlJeTlN.KHC-h1Jd_OxioKimPtPF7owut9hVr': {'DELETE': ['test_collections-1000', 'test_collections-1008', 'test_collections-1011', 'test_collections-1013', 'test_collections-1015', 'test_collections-1020', 'test_collections-1027', 'test_collections-1032', 'test_collections-1047', 'test_collections-1048', 'test_collections-105', 'test_collections-1050', 'test_collections-1053', 'test_collections-1061', 'test_collections-1063', 'test_collections-107', 'test_collections-1073', 'test_collections-1075', 'test_collections-1076', 'test_collections-1080', 'test_collections-1084', 'test_collections-1085', 'test_collections-1086', 'test_collections-1088', 'test_collections-1097', 'test_collections-1104', 'test_collections-1106', 'test_collections-1109', 'test_collections-111', 'test_collections-1113', 'test_collections-1115', 'test_collections-1122', 'test_collections-1124', 'test_collections-1127', 'test_collections-1130', 'test_collections-1133', 'test_collections-114', 'test_collections-1142', 'test_collections-1145', 'test_collections-1151', 'test_collections-1152', 'test_collections-1153', 'test_collections-1159', 'test_collections-116', 'test_collections-1164', 'test_collections-1166', 'test_collections-1169', 'test_collections-1170', 'test_collections-1182', 'test_collections-1185', 'test_collections-1186', 'test_collections-119', 'test_collections-1195', 'test_collections-1198', 'test_collections-1205', 'test_collections-1209', 'test_collections-1216', 'test_collections-1222', 'test_collections-1225', 'test_collections-123', 'test_collections-1231', 'test_collections-1240', 'test_collections-1252', 'test_collections-1258', 'test_collections-1261', 'test_collections-1263', 'test_collections-1267', 'test_collections-1270', 'test_collections-1271', 'test_collections-1276', 'test_collections-1279', 'test_collections-128', 'test_collections-1280', 'test_collections-1287', 'test_collections-1289', 'test_collections-1290', 'test_collections-1292', 'test_collections-1294', 'test_collections-1297', 'test_collections-1299', 'test_collections-13', 'test_collections-1302', 'test_collections-131', 'test_collections-1310', 'test_collections-1312', 'test_collections-1314', 'test_collections-1322', 'test_collections-1323', 'test_collections-1330', 'test_collections-1333', 'test_collections-1339', 'test_collections-1341', 'test_collections-1344', 'test_collections-1348', 'test_collections-1350', 'test_collections-1357', 'test_collections-1359', 'test_collections-136', 'test_collections-1360', 'test_collections-1364', 'test_collections-1369', 'test_collections-1379', 'test_collections-1382', 'test_collections-1384', 'test_collections-1385', 'test_collections-1395', 'test_collections-14', 'test_collections-1402', 'test_collections-1403', 'test_collections-1405', 'test_collections-1410', 'test_collections-1416', 'test_collections-1419', 'test_collections-1426', 'test_collections-1429', 'test_collections-143', 'test_collections-1436', 'test_collections-1440', 'test_collections-1444', 'test_collections-1446', 'test_collections-1449', 'test_collections-1453', 'test_collections-1455', 'test_collections-1456', 'test_collections-146', 'test_collections-1462', 'test_collections-1465', 'test_collections-147', 'test_collections-1475', 'test_collections-1476', 'test_collections-1481', 'test_collections-1482', 'test_collections-1485', 'test_collections-1492', 'test_collections-150', 'test_collections-1500', 'test_collections-1501', 'test_collections-1503', 'test_collections-1505', 'test_collections-1507', 'test_collections-1508', 'test_collections-1509', 'test_collections-1512', 'test_collections-1514', 'test_collections-1527', 'test_collections-1530', 'test_collections-1535', 'test_collections-1539', 'test_collections-154', 'test_collections-1542', 'test_collections-1543', 'test_collections-1549', 'test_collections-155', 'test_collections-1551', 'test_collections-1552', 'test_collections-1553', 'test_collections-1561', 'test_collections-1578', 'test_collections-1588', 'test_collections-1597', 'test_collections-1598', 'test_collections-1601', 'test_collections-1604', 'test_collections-1607', 'test_collections-1612', 'test_collections-1614', 'test_collections-1619', 'test_collections-1622', 'test_collections-1623', 'test_collections-1624', 'test_collections-1627', 'test_collections-1630', 'test_collections-1631', 'test_collections-1634', 'test_collections-1636', 'test_collections-1641', 'test_collections-1643', 'test_collections-1645', 'test_collections-165', 'test_collections-1650', 'test_collections-1653', 'test_collections-1654', 'test_collections-166', 'test_collections-1660', 'test_collections-1666', 'test_collections-167', 'test_collections-1674', 'test_collections-1676', 'test_collections-1684', 'test_collections-1685', 'test_collections-1686', 'test_collections-169', 'test_collections-1693', 'test_collections-1695', 'test_collections-1696', 'test_collections-1697', 'test_collections-1699', 'test_collections-1703', 'test_collections-1710', 'test_collections-1715'], 'INSERT': {}, 'UPDATE': {}}}}, ['last']]] 2020-10-13 00:26:03,631 | test | INFO | MainThread | [N1qlBase:validate_keys:686] Expected keys: 1800, Actual: 2000, Deleted: 200 FAIL 2020-10-13 00:26:03,644 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`tl2i` USING GSI 2020-10-13 00:26:03,674 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 27.101611ms 2020-10-13 00:26:03,684 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`UDxxsa1enpOcUT3u-uiaYj_1hQyr` USING GSI 2020-10-13 00:26:03,721 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 34.225709ms 2020-10-13 00:26:03,734 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`8UFvVUpRRKiK5` USING GSI 2020-10-13 00:26:03,773 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 35.535153ms 2020-10-13 00:26:03,785 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`IATON` USING GSI 2020-10-13 00:26:03,831 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 42.392979ms 2020-10-13 00:26:03,841 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`TrbYzU3xnqyz527ALaQE` USING GSI 2020-10-13 00:26:03,875 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 23.565024ms 2020-10-13 00:26:03,885 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`Bq4mrBHnMMY` USING GSI 2020-10-13 00:26:03,924 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 35.501412ms 2020-10-13 00:26:03,934 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`Ld` USING GSI 2020-10-13 00:26:03,967 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 29.620223ms 2020-10-13 00:26:03,977 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`g1ircfB-QXIQNzXtblCJ` USING GSI 2020-10-13 00:26:04,007 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 27.211939ms 2020-10-13 00:26:04,019 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`26pGHbblqr` USING GSI 2020-10-13 00:26:04,059 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 36.313693ms 2020-10-13 00:26:04,069 | test | INFO | MainThread | [N1qlBase:run_cbq_query:145] RUN QUERY DROP INDEX default:`xQoORgdDPhqRmgzPVVLhhWaopPt5`.`ghlJeTlN`.`KHC-h1Jd_OxioKimPtPF7owut9hVr`.`pXUDVKHMHwJl7G2g81b` USING GSI 2020-10-13 00:26:04,115 | test | INFO | MainThread | [N1qlBase:run_cbq_query:201] TOTAL ELAPSED TIME: 42.232948ms 2020-10-13 00:26:04,723 | test | INFO | MainThread | [collections_base:tearDown:86] Bucket: xQoORgdDPhqRmgzPVVLhhWaopPt5, Resident ratio(DGM): 100% 2020-10-13 00:26:07,453 | test | INFO | MainThread | [basetestcase:check_coredump_exist:704] 172.23.105.229 : SSH Successful 2020-10-13 00:26:07,453 | test | INFO | MainThread | [basetestcase:check_coredump_exist:705] 172.23.105.229 : Looking for crash dump files 2020-10-13 00:26:07,470 | test | INFO | MainThread | [basetestcase:check_coredump_exist:724] 172.23.105.229 : No crash files found 2020-10-13 00:26:07,470 | test | INFO | MainThread | [basetestcase:check_coredump_exist:726] 172.23.105.229 : Looking for CRITICAL messages in log 2020-10-13 00:26:08,885 | test | INFO | MainThread | [basetestcase:check_coredump_exist:704] 172.23.105.230 : SSH Successful 2020-10-13 00:26:08,885 | test | INFO | MainThread | [basetestcase:check_coredump_exist:705] 172.23.105.230 : Looking for crash dump files 2020-10-13 00:26:08,904 | test | INFO | MainThread | [basetestcase:check_coredump_exist:724] 172.23.105.230 : No crash files found 2020-10-13 00:26:08,904 | test | INFO | MainThread | [basetestcase:check_coredump_exist:726] 172.23.105.230 : Looking for CRITICAL messages in log 2020-10-13 00:26:09,684 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:605] Running cbcollect on node 172.23.105.229 2020-10-13 00:26:09,707 | test | INFO | MainThread | [rest_client:_http_request:728] {'date': 'Tue, 13 Oct 2020 07:26:09 GMT', 'content-length': '2', 'server': 'Couchbase Server', 'expires': 'Thu, 01 Jan 1970 00:00:00 GMT', 'x-frame-options': 'DENY', 'x-permitted-cross-domain-policies': 'none', 'pragma': 'no-cache', 'x-content-type-options': 'nosniff', 'x-xss-protection': '1; mode=block', 'connection': 'close', 'content-type': 'application/json', 'cache-control': 'no-cache,no-store,must-revalidate', 'status': '200'} 2020-10-13 00:26:09,709 | test | INFO | MainThread | [rest_client:_http_request:729] [] 2020-10-13 00:26:19,716 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:609] 172.23.105.229 - cbcollect status: True 2020-10-13 00:26:19,717 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:612] Polling active_tasks to check cbcollect status 2020-10-13 00:29:10,076 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:629] Copying cbcollect ZIP file to Client 2020-10-13 00:29:10,956 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:638] 172.23.105.229 node cb collect zip coped on client : True 2020-10-13 00:29:10,977 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:605] Running cbcollect on node 172.23.105.230 2020-10-13 00:29:11,003 | test | INFO | MainThread | [rest_client:_http_request:728] {'date': 'Tue, 13 Oct 2020 07:29:10 GMT', 'content-length': '2', 'server': 'Couchbase Server', 'expires': 'Thu, 01 Jan 1970 00:00:00 GMT', 'x-frame-options': 'DENY', 'x-permitted-cross-domain-policies': 'none', 'pragma': 'no-cache', 'x-content-type-options': 'nosniff', 'x-xss-protection': '1; mode=block', 'connection': 'close', 'content-type': 'application/json', 'cache-control': 'no-cache,no-store,must-revalidate', 'status': '200'} 2020-10-13 00:29:11,003 | test | INFO | MainThread | [rest_client:_http_request:729] [] 2020-10-13 00:29:21,010 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:609] 172.23.105.230 - cbcollect status: True 2020-10-13 00:29:21,010 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:612] Polling active_tasks to check cbcollect status 2020-10-13 00:31:31,243 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:629] Copying cbcollect ZIP file to Client 2020-10-13 00:31:32,005 | test | INFO | MainThread | [basetestcase:fetch_cb_collect_logs:638] 172.23.105.230 node cb collect zip coped on client : True 2020-10-13 00:31:32,023 | test | CRITICAL | MainThread | [basetestcase:tearDownEverything:490] Skipping get_trace !! 2020-10-13 00:31:44,704 | test | INFO | MainThread | [rest_client:monitorRebalance:1433] Rebalance done. Taken 11.0579998493 seconds to complete 2020-10-13 00:31:44,713 | test | INFO | MainThread | [common_lib:sleep:22] Sleep 5 seconds. Reason: Wait after rebalance complete During the test, Remote Connections: 294, Disconnections: 261 SDK Connections: 330, Disconnections: 330 ====================================================================== FAIL: test_concurrent_txn (N1qlTransaction.basic_ops.BasicOps) ---------------------------------------------------------------------- Traceback (most recent call last): File "pytests/N1qlTransaction/basic_ops.py", line 51, in test_concurrent_txn self.fail("One of the thread failed with unexpected errors") AssertionError: One of the thread failed with unexpected errors ----------------------------------------------------------------------