Can not run benchmarksql on PostggresSQL 9.2

Help
leo
2013-10-10
2014-03-13
  • leo

    leo - 2013-10-10

    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
  • Cady

    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?

     
  • Denis Lussier

    Denis Lussier - 2014-03-13

    It definitely works on all versions of Postgres from 8.4 onwards

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks