0
回答
benchmarksql 测试Postgres
注册华为云得mate10,2.9折抢先购!>>>   


@yafeishi 你好,想跟你请教个问题:

关于benchmarksql 测试Postgres使用 BenchmarkSQL 5.0 版本,执行最后一步$./runBenchmark.sh props.pg的时候,你说的“由于代码本身的原因,我这边一执行就报错。”,我想问的是代码本身就有问题不能用吗,怎么解决?

我跑的过程中总是出现这种错误:

[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-%tm-%td_%tH%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.pg to my_result_2016-10-25_212159/run.properties
21:21:59,283 [main] INFO   jTPCC : Term-00, created my_result_2016-10-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-25_212159/data/result.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 (most recent call last):
  File "<stdin>", line 299, in <module>
  File "<stdin>", line 62, in main
  File "<stdin>", line 166, in initSystemUsage
Exception: cpu line in /proc/stat too short
21:21:59,358 [Thread-0] ERROR  OSCollector$CollectData : OSCollector, unexpected EOF while reading 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 in NEW_ORDERage: 322MB / 1928MB                                           21:22:34,103 [Thread-5] ERROR  jTPCCTData : ERROR: deadlock detected
  Detail: Process 9102 waits for RowExclusiveLock on relation 1159908 of database 1159744; blocked by process 9120.
Process 9120 waits for ExclusiveLock on relation 1159934 of database 1159744; blocked by process 9102.
org.postgresql.util.PSQLException: ERROR: deadlock detected
  Detail: Process 9102 waits for RowExclusiveLock on relation 1159908 of database 1159744; blocked by process 9120.
Process 9120 waits for ExclusiveLock on relation 1159934 of database 1159744; blocked by process 9102.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at jTPCCTData.executeNewOrder(jTPCCTData.java:417)
at jTPCCTData.execute(jTPCCTData.java:95)
at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:261)
at jTPCCTerminal.run(jTPCCTerminal.java:88)
at java.lang.Thread.run(Thread.java:745)                                                                                                                                     21:22:43,8
26 [Thread-18] ERROR  jTPCCTData : Unexpected SQLException in DELIVERY_BG: 322MB / 1928MB                   21:22:43,826 [Thread-18] ERROR  jTPCCTData : ERROR: deadlock detected
  Detail: Process 9215 waits for ExclusiveLock on relation 1159934 of database 1159744; blocked by process 9126.
Process 9126 waits for RowExclusiveLock on relation 1159908 of database 1159744; blocked by process 9215.
org.postgresql.util.PSQLException: ERROR: deadlock detected
  Detail: Process 9215 waits for ExclusiveLock on relation 1159934 of database 1159744; blocked by process 9126.
Process 9126 waits for RowExclusiveLock on relation 1159908 of database 1159744; blocked by process 9215.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
at jTPCCTData.executeDeliveryBG(jTPCCTData.java:1659)
at jTPCCTData.execute(jTPCCTData.java:115)
at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:237)
at jTPCCTerminal.run(jTPCCTerminal.java:88)
at java.lang.Thread.run(Thread.java:745)                             

举报
yy3368
发帖于1年前 0回/229阅
顶部