I run benchmarksql-4.0.8 on PostggresSQL 9.2 on SUSE Linux. Create table, create index and load test data function are ok, but benchmarksql rais following error when I run "./runBenchmark.sh props.pg"
2013-10-10 11:57:08,803 INFO - Term-00,
2013-10-10 11:57:08,804 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,805 INFO - Term-00, BenchmarkSQL v4.0
2013-10-10 11:57:08,805 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2003, Raul Barbosa
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2004-2013, Denis Lussier
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2013, Cady Motyka
2013-10-10 11:57:08,806 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,806 INFO - Term-00,
2013-10-10 11:57:08,806 INFO - Term-00, driver=org.postgresql.Driver
2013-10-10 11:57:08,806 INFO - Term-00, conn=jdbc:postgresql://localhost:5432/postgres
2013-10-10 11:57:08,806 INFO - Term-00, user=benchmarksql
2013-10-10 11:57:08,807 INFO - Term-00,
2013-10-10 11:57:08,807 INFO - Term-00, warehouses=1
2013-10-10 11:57:08,807 INFO - Term-00, terminals=1
2013-10-10 11:57:08,807 INFO - Term-00, runTxnsPerTerminal=10
2013-10-10 11:57:08,807 INFO - Term-00, limitTxnsPerMin=300
2013-10-10 11:57:08,808 INFO - Term-00,
2013-10-10 11:57:08,808 INFO - Term-00, newOrderWeight=45
2013-10-10 11:57:08,808 INFO - Term-00, paymentWeight=43
2013-10-10 11:57:08,808 INFO - Term-00, orderStatusWeight=4
2013-10-10 11:57:08,809 INFO - Term-00, deliveryWeight=4
2013-10-10 11:57:08,809 INFO - Term-00, stockLevelWeight=4
2013-10-10 11:57:08,809 INFO - Term-00,
2013-10-10 11:57:09,319 ERROR - payUpdateWhse() not found! W_ID=1
2013-10-10 11:57:09,336 ERROR - payGetWhse() not found! W_ID=1
2013-10-10 11:57:09,340 ERROR - Term-01, TERMINAL=Term-01 TYPE=PAYMENT COUNT=1
Term-01, TERMINAL=Term-01 TYPE=PAYMENT COUNT=1
2013-10-10 11:57:09,341 ERROR - org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2860)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1955)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2567)
at jTPCCTerminal.paymentTransaction(Unknown Source)
at jTPCCTerminal.executeTransaction(Unknown Source)
at jTPCCTerminal.executeTransactions(Unknown Source)
at jTPCCTerminal.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
What is wrong?
Last edit: Cady 2013-10-11
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I run benchmarksql-4.0.8 on PostggresSQL 9.2 on SUSE Linux. Create table, create index and load test data function are ok, but benchmarksql rais following error when I run "./runBenchmark.sh props.pg"
2013-10-10 11:57:08,803 INFO - Term-00,
2013-10-10 11:57:08,804 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,805 INFO - Term-00, BenchmarkSQL v4.0
2013-10-10 11:57:08,805 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2003, Raul Barbosa
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2004-2013, Denis Lussier
2013-10-10 11:57:08,805 INFO - Term-00, (c) 2013, Cady Motyka
2013-10-10 11:57:08,806 INFO - Term-00, +-------------------------------------------------------------+
2013-10-10 11:57:08,806 INFO - Term-00,
2013-10-10 11:57:08,806 INFO - Term-00, driver=org.postgresql.Driver
2013-10-10 11:57:08,806 INFO - Term-00, conn=jdbc:postgresql://localhost:5432/postgres
2013-10-10 11:57:08,806 INFO - Term-00, user=benchmarksql
2013-10-10 11:57:08,807 INFO - Term-00,
2013-10-10 11:57:08,807 INFO - Term-00, warehouses=1
2013-10-10 11:57:08,807 INFO - Term-00, terminals=1
2013-10-10 11:57:08,807 INFO - Term-00, runTxnsPerTerminal=10
2013-10-10 11:57:08,807 INFO - Term-00, limitTxnsPerMin=300
2013-10-10 11:57:08,808 INFO - Term-00,
2013-10-10 11:57:08,808 INFO - Term-00, newOrderWeight=45
2013-10-10 11:57:08,808 INFO - Term-00, paymentWeight=43
2013-10-10 11:57:08,808 INFO - Term-00, orderStatusWeight=4
2013-10-10 11:57:08,809 INFO - Term-00, deliveryWeight=4
2013-10-10 11:57:08,809 INFO - Term-00, stockLevelWeight=4
2013-10-10 11:57:08,809 INFO - Term-00,
2013-10-10 11:57:09,319 ERROR - payUpdateWhse() not found! W_ID=1
2013-10-10 11:57:09,336 ERROR - payGetWhse() not found! W_ID=1
2013-10-10 11:57:09,340 ERROR - Term-01, TERMINAL=Term-01 TYPE=PAYMENT COUNT=1
Term-01, TERMINAL=Term-01 TYPE=PAYMENT COUNT=1
2013-10-10 11:57:09,341 ERROR - org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2860)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1955)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2567)
at jTPCCTerminal.paymentTransaction(Unknown Source)
at jTPCCTerminal.executeTransaction(Unknown Source)
at jTPCCTerminal.executeTransactions(Unknown Source)
at jTPCCTerminal.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
What is wrong?
Last edit: Cady 2013-10-11
This error shows up for me when the tables exist but there is no data in them. Which command did you use to load the data?
It definitely works on all versions of Postgres from 8.4 onwards