Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created June 15, 2020 16:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/5772e3fb9094a62129a7e57adab10411 to your computer and use it in GitHub Desktop.
Save mdcallag/5772e3fb9094a62129a7e57adab10411 to your computer and use it in GitHub Desktop.
$ python ./tpcc.py --config config.desktop --warehouses 1 --clients 1 --duration 30 --no-load mongodb
2020-06-15 09:39:01,696 [<module>:245] INFO : Initializing TPC-C benchmark using MongodbDriver
2020-06-15 09:39:31,706 [<module>:282] INFO : Final Results
2020-06-15 09:39:31,707 [<module>:283] INFO : Threads: 1
{'DELIVERY': 124, 'ORDER_STATUS': 136, 'STOCK_LEVEL': 134, 'PAYMENT': 1330, 'NEW_ORDER': 1352}
{'txn': True, 'all_in_one_txn': True, 'denorm': True, 'total_retries': 0, 'batch_writes': True, 'write_concern': 1, 'duration': 30.010456085205078, 'total': 3076, 'tpmc': 2703.0578865474668, 'causal': True, 'warehouses': 1, 'find_and_modify': True, 'read_concern': 'majority', 'read_preference': 'primary', 'aborts': 14, 'DELIVERY': {'latency': {'p99': 36.219120025634766, 'p75': 33.97512435913086, 'min': 27.55594253540039, 'p90': 34.28983688354492, 'max': 36.96393966674805, 'p95': 34.68918800354004, 'p50': 33.33902359008789}, 'total': 124}, 'threads': 1, 'date': '2020-06-15 09:39:31', 'ORDER_STATUS': {'latency': {'p99': 6.378889083862305, 'p75': 5.650043487548828, 'min': 4.20689582824707, 'p90': 5.8917999267578125, 'max': 6.479978561401367, 'p95': 6.105899810791016, 'p50': 5.383968353271484}, 'total': 136}, 'NEW_ORDER': {'latency': {'p99': 15.411138534545898, 'p75': 13.300895690917969, 'min': 7.632017135620117, 'p90': 14.168024063110352, 'max': 16.97087287902832, 'p95': 14.645099639892578, 'p50': 12.19797134399414}, 'total': 1352}, 'retry_writes': False, 'STOCK_LEVEL': {'latency': {'p99': 7.295131683349609, 'p75': 5.685091018676758, 'min': 4.332065582275391, 'p90': 5.960941314697266, 'max': 9.385108947753906, 'p95': 6.145954132080078, 'p50': 5.444049835205078}, 'total': 134}, 'PAYMENT': {'latency': {'p99': 6.672143936157227, 'p75': 5.959987640380859, 'min': 3.8690567016601562, 'p90': 6.146907806396484, 'max': 7.932901382446289, 'p95': 6.2999725341796875, 'p50': 5.710124969482422}, 'total': 1330}}
Traceback (most recent call last):
File "./tpcc.py", line 284, in <module>
logging.info(results.show(load_time, driver, args['clients']))
File "/home/mdcallag/git/py-tpcc/pytpcc/util/results.py", line 251, in show
if driver: driver.save_result(result_doc)
File "/home/mdcallag/git/py-tpcc/pytpcc/drivers/mongodbdriver.py", line 1146, in save_result
self.client.test.results.save(self.result_doc)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/collection.py", line 3137, in save
to_save, True, check_keys, manipulate, write_concern)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/collection.py", line 607, in _insert
bypass_doc_val, session)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/collection.py", line 595, in _insert_one
acknowledged, _insert_command, session)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/mongo_client.py", line 1248, in _retryable_write
return self._retry_with_session(retryable, func, s, None)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/mongo_client.py", line 1201, in _retry_with_session
return func(session, sock_info, retryable)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/collection.py", line 590, in _insert_command
retryable_write=retryable_write)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/pool.py", line 584, in command
self._raise_connection_failure(error)
File "/home/mdcallag/.local/lib/python2.7/site-packages/pymongo/pool.py", line 745, in _raise_connection_failure
raise error
bson.errors.InvalidDocument: key '$_internalSplitPipeline' must not start with '$'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment