@ yafeishi hello, want to ask you a question:


About benchmarksql test use Postgres benchmarksql version 5.0, perform the last step $./runBenchmark. Sh props. Pg, you said "because of the code itself, as soon as my side to perform error,", I want to ask is the code itself has problem can't use it, how to solve?


I ran always appear this kind of error: in the process of


[gpadmin @ GZNS - waimai - do - gpdb451 run] $./runBenchmark. Sh props. Pg
21:21:59, 258 [main] INFO jTPCC: Term - 00,
21:21:59, 261 [main] INFO jTPCC: Term - 00, + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - +
21:21:59, 261 [main] INFO jTPCC: Term - 00, BenchmarkSQL v5.0
21:21:59, 261 [main] INFO jTPCC: Term - 00, + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - +
21:21:59, 262 [main] INFO jTPCC: Term - 00, (c) 2003, Raul Barbosa
21:21:59, 262 [main] INFO jTPCC: Term - 00, (c) 2004-2016, Denis Lussier
21:21:59, 264 [main] INFO jTPCC: Term - 00, (c) 2016, Jan Wieck
21:21:59, 264 [main] INFO jTPCC: Term - 00, + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - +
21:21:59, 264 [main] INFO jTPCC: Term - 00,
21:21:59, 264 [main] INFO jTPCC: Term - 00, db=postgres
21:21:59, 264 [main] INFO jTPCC: Term - 00, driver=org. Postgresql. Driver
21:21:59, 264 [main] INFO jTPCC: Term - 00, conn=JDBC: postgresql://10.19.147.136:2345/TPCC
21:21:59, 264 [main] INFO jTPCC: Term - 00, user=tpch_user
21:21:59, 265 [main] INFO jTPCC: Term - 00,
21:21:59, 265 [main] INFO jTPCC: Term - 00, warehouses=30
21:21:59, 265 [main] INFO jTPCC: Term - 00, terminals=20
21:21:59, 266 [main] INFO jTPCC: Term - 00, runMins=10
21:21:59, 267 [main] INFO jTPCC: Term - 00, limitTxnsPerMin=0
21:21:59, 267 [main] INFO jTPCC: Term - 00, terminalWarehouseFixed=true
21:21:59, 267 [main] INFO jTPCC: Term - 00,
21:21:59, 267 [main] INFO jTPCC: Term - 00, newOrderWeight=45
21:21:59, 267 [main] INFO jTPCC: Term - 00, paymentWeight=43
21:21:59, 267 [main] INFO jTPCC: Term - 00, orderStatusWeight=4
21:21:59, 267 [main] INFO jTPCC: Term - 00, deliveryWeight=4
21:21:59, 267 [main] INFO jTPCC: Term - 00, stockLevelWeight=4
21:21:59, 267 [main] INFO jTPCC: Term - 00,
21:21:59, 268 [main] INFO jTPCC: Term - 00, resultDirectory=my_result_ tY - tH td_ tm - % % % % % % tm tS
21:21:59, 268 [main] INFO jTPCC: Term - 00, osCollectorScript=./misc/os_collector_linux. Py
21:21:59, 268 [main] INFO jTPCC: Term - 00,
21:21:59, 283 [main] INFO jTPCC: Term - 00, copied props. The pg to my_result_2016-10-25 _212159/run. The properties
21:21:59, 283 [main] INFO jTPCC: Term - 00, created my_result_2016-10 to 25 _212159/data/runInfo CSV for runID 7
21:21:59, 283 [main] INFO jTPCC: Term - 00, writing per transaction results to my_result_2016-10 to 25 _212159/data/result. The CSV
21:21:59, 284 [main] INFO jTPCC: Term - 00, osCollectorScript=./misc/os_collector_linux. Py
21:21:59, 284 [main] INFO jTPCC: Term - 00, osCollectorInterval=1
21:21:59, 284 [main] INFO jTPCC: Term - 00, osCollectorSSHAddr=null
21:21:59, 284 [main] INFO jTPCC: Term - 00, osCollectorDevices=net_eth0 blk_sda
21:21:59, 348 [main] INFO jTPCC: Term - 00,
Traceback (the most recent call last) :
The File "& lt; Stdin>" , line 299, in & lt; module>
The File "& lt; Stdin>" , line 62, in the main
The File "& lt; Stdin>" , line 166, in initSystemUsage
Exception: CPU line in/proc/stat too short
358 [21:21:59, Thread - 0] ERROR OSCollector $CollectData: OSCollector, unexpected EOF while reading the from external helper process
21:22:00, 289 [main] INFO jTPCC: Term - 00, C value for C_LAST during load: 144
21:22:00, 289 [main] INFO jTPCC: Term - 00, C value for C_LAST this run: 47
21:22:00, 289 [main] INFO jTPCC: Term - 00, 21:22:34, 103/Thread - 5 ERROR jTP
CCTData: Unexpected SQLException NEW_ORDERage: in 322 MB or 1928 MB 21:22:34, 103/Thread - 5 ERROR jTPCCTData: ERROR: deadlock detected
Detail: the Process of 9102 waits for RowExclusiveLock on base of 1159908 of the database, 1159744; Blocked by the process 9120.
Process 9120 waits for ExclusiveLock on base of 1159934 of the database, 1159744; Blocked by the process 9102.
Org. Postgresql. Util. PSQLException: ERROR: deadlock detected
Detail: the Process of 9102 waits for RowExclusiveLock on base of 1159908 of the database, 1159744; Blocked by the process 9120.
Process 9120 waits for ExclusiveLock on base of 1159934 of the database, 1159744; Blocked by the process 9102.
The at org. Postgresql. Core. The v3. QueryExecutorImpl. ReceiveErrorResponse (QueryExecutorImpl. Java: 2198)
The at org. Postgresql. Core. The v3. QueryExecutorImpl. ProcessResults (QueryExecutorImpl. Java: 1927)
The at org. Postgresql. Core. The v3. QueryExecutorImpl. Execute (QueryExecutorImpl. Java: 255)
The at org. Postgresql. Jdbc2. AbstractJdbc2Statement. Execute (AbstractJdbc2Statement. Java: 561)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull