Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Home

Denis Lussier

This is the personal project of Denis Lussier. This project is created automatically during user registration as an easy place to store personal data that doesn't need its own project such as cloned repositories.


  • leo
    leo
    2013-10-10

    Can not run benchmarksql on PostggresSQL 9.2
    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?

     
  • Denis Lussier
    Denis Lussier
    2013-10-11

    Cady,

    Can u please look into this.

    --Luss

    On Thu, Oct 10, 2013 at 1:26 AM, leo leozhou@users.sf.net wrote:

    Can not run benchmarksql on PostggresSQL 9.2
    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?

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/u/lussman/wiki/Home/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/subscriptions/